APPS.POR_APPROVAL_LIST dependencies on PO_APPROVAL_LIST_LINES

Line 847: -- po_approval_list_lines for p_existing_requisition_id and

843: --------------------------------------------------------------------------------
844: --Start of Comments
845: --Function:
846: -- Find the latest records in po_approval_list_headers and
847: -- po_approval_list_lines for p_existing_requisition_id and
848: -- copy into p_new_requisition_id
849: -- the attributes are not duplicated as they are currently not used in iP approval list
850: -- note, the approval list is re-sequenced if necessary
851: -- so that the sequence number is always starting from 1,2,3...

Line 886: FROM po_approval_list_lines

882: approver_type,
883: status,
884: response_date,
885: comments
886: FROM po_approval_list_lines
887: WHERE approval_list_header_id = p_approval_list_header_id
888: order by approval_list_line_id;
889:
890: begin

Line 909: DELETE FROM po_approval_list_lines

905: WHERE document_id = p_existing_requisition_id
906: AND document_type = 'REQUISITION'
907: AND latest_revision = 'Y';
908:
909: DELETE FROM po_approval_list_lines
910: WHERE approval_list_header_id in
911: (select approval_list_header_id
912: FROM po_approval_list_headers
913: WHERE document_id = p_new_requisition_id

Line 924: FROM po_approval_list_lines

920: l_progress := '002:'||l_old_approval_list_header_id ||';'|| l_old_current_sequence_num;
921:
922: SELECT COUNT(1)
923: into l_new_current_sequence_num
924: FROM po_approval_list_lines
925: WHERE sequence_num <= l_old_current_sequence_num and
926: approval_list_header_id = l_old_approval_list_header_id;
927:
928: l_progress := '003:'|| l_new_current_sequence_num;

Line 973: INSERT INTO po_approval_list_lines (

969:
970: BEGIN
971: FOR approver_rec IN old_approver_c(l_old_approval_list_header_id) LOOP
972: l_sequence_number := l_sequence_number +1;
973: INSERT INTO po_approval_list_lines (
974: approval_list_header_id,
975: approval_list_line_id,
976: next_element_id,
977: approver_id,

Line 995: po_approval_list_lines_s.nextval,

991: last_update_login,
992: last_updated_by,
993: last_update_date)
994: VALUES ( l_new_approval_list_header_id,
995: po_approval_list_lines_s.nextval,
996: null,
997: approver_rec.approver_id,
998: l_sequence_number,
999: approver_rec.notification_id,

Line 1036: from po_approval_list_lines pal, po_approval_list_headers pah,

1032: l_approver_id number;
1033:
1034: cursor adhoc_approver_c IS
1035: select pal.approver_id
1036: from po_approval_list_lines pal, po_approval_list_headers pah,
1037: po_requisition_headers_all prh
1038: where pal.approval_list_header_id = pah.approval_list_header_id
1039: and pah.latest_revision = 'Y'
1040: and pal.mandatory_flag = 'N'