[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