[Home] [Help]
APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_NOTIFICATIONS
Line 1945: DELETE FROM PO_NOTIFICATIONS pon
1941: END IF;
1942:
1943: d_progress := 10;
1944:
1945: DELETE FROM PO_NOTIFICATIONS pon
1946: WHERE pon.object_type_lookup_code = DECODE(p_document_type,
1947: 'PO', p_document_subtype,
1948: 'PA', p_document_subtype,
1949: p_document_type)
Line 1959: INSERT INTO PO_NOTIFICATIONS(
1955: THEN
1956:
1957: d_progress := 20;
1958:
1959: INSERT INTO PO_NOTIFICATIONS(
1960: employee_id
1961: , object_type_lookup_code
1962: , object_id
1963: , last_update_date