APPS.POR_APPROVAL_LIST dependencies on PO_APPROVAL_LIST_HEADERS

Line 652: from po_approval_list_headers

648: IF (l_return_code = po_approvallist_s1.E_SUCCESS) THEN
649: p_return_code := 1;
650:
651: select to_char(last_update_date, g_date_format_mask) into p_last_update_date
652: from po_approval_list_headers
653: where approval_list_header_id = p_approval_list_header_id;
654: ELSE
655: -- Deal with the specific error codes if needed
656: -- Handle the error stack

Line 891: -- Find the latest records in po_approval_list_headers and

887:
888: --------------------------------------------------------------------------------
889: --Start of Comments
890: --Function:
891: -- Find the latest records in po_approval_list_headers and
892: -- po_approval_list_lines for p_existing_requisition_id and
893: -- copy into p_new_requisition_id
894: -- the attributes are not duplicated as they are currently not used in iP approval list
895: -- note, the approval list is re-sequenced if necessary

Line 943: SELECT po_approval_list_headers_s.nextval

939: if (p_new_requisition_id is null or p_existing_requisition_id is null) then
940: return;
941: end if;
942:
943: SELECT po_approval_list_headers_s.nextval
944: INTO l_new_approval_list_header_id
945: FROM sys.dual;
946:
947: SELECT approval_list_header_id, current_sequence_num

Line 949: FROM po_approval_list_headers

945: FROM sys.dual;
946:
947: SELECT approval_list_header_id, current_sequence_num
948: INTO l_old_approval_list_header_id, l_old_current_sequence_num
949: FROM po_approval_list_headers
950: WHERE document_id = p_existing_requisition_id
951: AND document_type = 'REQUISITION'
952: AND latest_revision = 'Y';
953:

Line 957: FROM po_approval_list_headers

953:
954: DELETE FROM po_approval_list_lines
955: WHERE approval_list_header_id in
956: (select approval_list_header_id
957: FROM po_approval_list_headers
958: WHERE document_id = p_new_requisition_id
959: AND document_type = 'REQUISITION');
960:
961: DELETE FROM po_approval_list_headers

Line 961: DELETE FROM po_approval_list_headers

957: FROM po_approval_list_headers
958: WHERE document_id = p_new_requisition_id
959: AND document_type = 'REQUISITION');
960:
961: DELETE FROM po_approval_list_headers
962: WHERE document_id = p_new_requisition_id
963: AND document_type = 'REQUISITION';
964:
965: l_progress := '002:'||l_old_approval_list_header_id ||';'|| l_old_current_sequence_num;

Line 975: INSERT INTO po_approval_list_headers (

971: approval_list_header_id = l_old_approval_list_header_id;
972:
973: l_progress := '003:'|| l_new_current_sequence_num;
974:
975: INSERT INTO po_approval_list_headers (
976: approval_list_header_id,
977: document_id,
978: document_type,
979: document_subtype,

Line 1008: FROM po_approval_list_headers

1004: SYSDATE,
1005: fnd_global.login_id,
1006: fnd_global.user_id,
1007: SYSDATE
1008: FROM po_approval_list_headers
1009: WHERE document_id = p_existing_requisition_id
1010: AND document_type = 'REQUISITION'
1011: AND latest_revision = 'Y';
1012:

Line 1081: from po_approval_list_lines pal, po_approval_list_headers pah,

1077: l_approver_id number;
1078:
1079: cursor adhoc_approver_c IS
1080: select pal.approver_id
1081: from po_approval_list_lines pal, po_approval_list_headers pah,
1082: po_requisition_headers_all prh
1083: where pal.approval_list_header_id = pah.approval_list_header_id
1084: and pah.latest_revision = 'Y'
1085: and pal.mandatory_flag = 'N'