APPS.PO_DOCS_INTERFACE_PURGE dependencies on PO_PDOI_CONSTANTS

Line 70: AND ((process_code = PO_PDOI_CONSTANTS.g_process_code_ACCEPTED and X_accepted_flag = 'Y')

66: FROM po_headers_interface
67: WHERE (batch_id = X_selected_batch_id
68: OR X_selected_batch_id IS NULL )
69:
70: AND ((process_code = PO_PDOI_CONSTANTS.g_process_code_ACCEPTED and X_accepted_flag = 'Y')
71: OR (process_code = PO_PDOI_CONSTANTS.g_process_code_REJECTED and X_rejected_flag = 'Y')
72: OR (process_code = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS AND p_po_header_id IS NOT NULL))
73:
74: AND (org_id = l_org_id

Line 71: OR (process_code = PO_PDOI_CONSTANTS.g_process_code_REJECTED and X_rejected_flag = 'Y')

67: WHERE (batch_id = X_selected_batch_id
68: OR X_selected_batch_id IS NULL )
69:
70: AND ((process_code = PO_PDOI_CONSTANTS.g_process_code_ACCEPTED and X_accepted_flag = 'Y')
71: OR (process_code = PO_PDOI_CONSTANTS.g_process_code_REJECTED and X_rejected_flag = 'Y')
72: OR (process_code = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS AND p_po_header_id IS NOT NULL))
73:
74: AND (org_id = l_org_id
75: OR l_org_id is NULL)

Line 72: OR (process_code = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS AND p_po_header_id IS NOT NULL))

68: OR X_selected_batch_id IS NULL )
69:
70: AND ((process_code = PO_PDOI_CONSTANTS.g_process_code_ACCEPTED and X_accepted_flag = 'Y')
71: OR (process_code = PO_PDOI_CONSTANTS.g_process_code_REJECTED and X_rejected_flag = 'Y')
72: OR (process_code = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS AND p_po_header_id IS NOT NULL))
73:
74: AND (org_id = l_org_id
75: OR l_org_id is NULL)
76:

Line 225: IF (p_process_code_tbl(i) = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS) THEN

221:
222: FOR i IN 1..p_process_code_tbl.COUNT LOOP
223: d_position := 20;
224:
225: IF (p_process_code_tbl(i) = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS) THEN
226: -- if user wants to purge the intf record that is still in process, make
227: -- sure that the drafts are removed and locks are released, if the
228: -- record is no longer being touched.
229: