DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_NOTIFICATIONS

Line 2249: DELETE FROM PO_NOTIFICATIONS pon

2245: END IF;
2246:
2247: d_progress := 10;
2248:
2249: DELETE FROM PO_NOTIFICATIONS pon
2250: WHERE pon.object_type_lookup_code = DECODE(p_document_type,
2251: 'PO', p_document_subtype,
2252: 'PA', p_document_subtype,
2253: p_document_type)

Line 2263: INSERT INTO PO_NOTIFICATIONS(

2259: THEN
2260:
2261: d_progress := 20;
2262:
2263: INSERT INTO PO_NOTIFICATIONS(
2264: employee_id
2265: , object_type_lookup_code
2266: , object_id
2267: , last_update_date