PL/SQL Script

[leng2leng]

i need pl/sql script to hold the lot when
-if there is a violation of 20 month of lot from the lot delivery date, lot will prolos and hold.
-if there is a violation of 4month of lot from the lot delivery date, lot will prolos and hold.

[r035198x]

i need pl/sql script to hold the lot when
-if there is a violation of 20 month of lot from the lot delivery date, lot will prolos and hold.
-if there is a violation of 4month of lot from the lot delivery date, lot will prolos and hold.

What have you done so far?

[debasisdas]

Please pass on few more details aboutthe program / problem.

Post with the code that you have tried and table structure.