APPS.POR_APPROVAL_LIST dependencies on PO_APPROVAL_LIST_LINES

Line 142: from (select approver_id from po_approval_list_lines

138:
139: ELSE
140: begin
141: select approver_id into l_first_approver_id
142: from (select approver_id from po_approval_list_lines
143: where approval_list_header_id=l_approval_list_header_id
144: and approver_type in ('SYSTEM', 'FORWARD')
145: order by sequence_num asc)
146: where rownum=1;

Line 892: -- po_approval_list_lines for p_existing_requisition_id and

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
896: -- so that the sequence number is always starting from 1,2,3...

Line 931: FROM po_approval_list_lines

927: approver_type,
928: status,
929: response_date,
930: comments
931: FROM po_approval_list_lines
932: WHERE approval_list_header_id = p_approval_list_header_id
933: order by approval_list_line_id;
934:
935: begin

Line 954: DELETE FROM po_approval_list_lines

950: WHERE document_id = p_existing_requisition_id
951: AND document_type = 'REQUISITION'
952: AND latest_revision = 'Y';
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

Line 969: FROM po_approval_list_lines

965: l_progress := '002:'||l_old_approval_list_header_id ||';'|| l_old_current_sequence_num;
966:
967: SELECT COUNT(1)
968: into l_new_current_sequence_num
969: FROM po_approval_list_lines
970: WHERE sequence_num <= l_old_current_sequence_num and
971: approval_list_header_id = l_old_approval_list_header_id;
972:
973: l_progress := '003:'|| l_new_current_sequence_num;

Line 1018: INSERT INTO po_approval_list_lines (

1014:
1015: BEGIN
1016: FOR approver_rec IN old_approver_c(l_old_approval_list_header_id) LOOP
1017: l_sequence_number := l_sequence_number +1;
1018: INSERT INTO po_approval_list_lines (
1019: approval_list_header_id,
1020: approval_list_line_id,
1021: next_element_id,
1022: approver_id,

Line 1040: po_approval_list_lines_s.nextval,

1036: last_update_login,
1037: last_updated_by,
1038: last_update_date)
1039: VALUES ( l_new_approval_list_header_id,
1040: po_approval_list_lines_s.nextval,
1041: null,
1042: approver_rec.approver_id,
1043: l_sequence_number,
1044: approver_rec.notification_id,

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'