12:
13: X_progress VARCHAR2(3) := NULL;
14:
15: BEGIN
16: DELETE FROM po_notification_controls
17: WHERE po_header_id = X_po_header_id;
18:
19: X_deleted := TRUE;
20: return(X_deleted);
45:
46: X_progress := '010';
47: SELECT COUNT(1)
48: INTO X_amt_base_notif_cntl_row
49: FROM po_notification_controls
50: WHERE po_header_id = X_po_header_id
51: AND notification_condition_code <> 'EXPIRATION';
52:
53: IF X_amt_base_notif_cntl_row > 0 THEN
77:
78: X_progress varchar2(3) := '000';
79: cursor c1 is
80: SELECT 'date based notification controls exist'
81: FROM po_notification_controls
82: WHERE po_header_id = X_po_header_id
83: AND notification_condition_code = 'EXPIRATION';
84:
85: Recinfo c1%rowtype;