APPS.PO_REQ_LINES_SV dependencies on PO_SESSION_GT

Line 1801: INSERT INTO po_session_gt(

1797: WHERE requisition_line_id = l_infofd_group_line_ids(i);
1798:
1799: -- Enter Priced Clin of Info funded slins into GT table, for sending all reqs in structure back to pool
1800: FORALL i IN 1..l_infofd_group_line_ids.Count
1801: INSERT INTO po_session_gt(
1802: index_char1,
1803: index_num1, -- ReqLineId
1804: index_num2, -- ReqHeadreId
1805: num1, --GroupLineId

Line 1835: INSERT INTO po_session_gt(

1831: -- We will indert all Clins(Auticreated and SoftLinked) and Priced Slins(SoftLinked using Link Requisitions action)
1832: -- for inserting into the GT table,
1833: -- which is used in update_reqs_in_pool_flag for fetching all the IDs of that ClinSlin structure
1834: FORALL i IN 1..l_unlinked_reqLine_ids.Count
1835: INSERT INTO po_session_gt(
1836: index_char1,
1837: index_num1, -- ReqLineId
1838: index_num2, -- ReqHeadreId
1839: num1, --GroupLineId

Line 1983: INSERT INTO po_session_gt gt3 (index_char1, index_num1, index_num2, num1, num2, num3, num10)

1979: -- iterations and make sure it wont go in infinite loop.
1980:
1981: WHILE 1=1
1982: LOOP
1983: INSERT INTO po_session_gt gt3 (index_char1, index_num1, index_num2, num1, num2, num3, num10)
1984:
1985: SELECT 'UNLINKED_REQUISITIONS', r.requisition_line_id, r.requisition_header_id, r.group_line_id, r.clm_base_line_num, r.linked_po_count, num10
1986: FROM po_requisition_lines_all r,
1987: po_session_gt gt

Line 1987: po_session_gt gt

1983: INSERT INTO po_session_gt gt3 (index_char1, index_num1, index_num2, num1, num2, num3, num10)
1984:
1985: SELECT 'UNLINKED_REQUISITIONS', r.requisition_line_id, r.requisition_header_id, r.group_line_id, r.clm_base_line_num, r.linked_po_count, num10
1986: FROM po_requisition_lines_all r,
1987: po_session_gt gt
1988: WHERE
1989: r.requisition_header_id = gt.index_num2
1990: AND gt.index_char1 = 'UNLINKED_REQUISITIONS'
1991: AND ( r.requisition_line_id = gt.index_num1

Line 2001: AND NOT EXISTS (SELECT 1 FROM po_session_gt gt2

1997: OR r.requisition_line_id = gt.num2
1998: OR r.group_line_id = gt.num2
1999: OR r.clm_base_line_num = gt.num2
2000: )
2001: AND NOT EXISTS (SELECT 1 FROM po_session_gt gt2
2002: WHERE gt2.index_num1 = r.requisition_line_id
2003: AND r.requisition_header_id = gt2.index_num2
2004: AND gt2.index_char1 = 'UNLINKED_REQUISITIONS'
2005: AND gt2.num10 = gt.num10

Line 2028: FROM po_session_gt ogt

2024: BULK COLLECT INTO
2025: l_eligible_reqLine_ids,
2026: l_eligible_reqHeader_ids
2027:
2028: FROM po_session_gt ogt
2029: WHERE index_char1 = 'UNLINKED_REQUISITIONS'
2030: AND num10 IN (SELECT num10 FROM po_session_gt igt
2031: WHERE igt.index_char1 = 'UNLINKED_REQUISITIONS'
2032: GROUP BY num10 HAVING sum(Nvl(num3,0)) <= 0

Line 2030: AND num10 IN (SELECT num10 FROM po_session_gt igt

2026: l_eligible_reqHeader_ids
2027:
2028: FROM po_session_gt ogt
2029: WHERE index_char1 = 'UNLINKED_REQUISITIONS'
2030: AND num10 IN (SELECT num10 FROM po_session_gt igt
2031: WHERE igt.index_char1 = 'UNLINKED_REQUISITIONS'
2032: GROUP BY num10 HAVING sum(Nvl(num3,0)) <= 0
2033: ) ;
2034:

Line 2052: DELETE po_session_gt WHERE index_char1 = 'UNLINKED_REQUISITIONS';

2048: update_par_draft_line_status(p_reqLine_ids => l_eligible_reqLine_ids,
2049: p_reqHeader_ids => l_eligible_reqHeader_ids );
2050:
2051: -- Refresh the GT table once this method end.
2052: DELETE po_session_gt WHERE index_char1 = 'UNLINKED_REQUISITIONS';
2053:
2054: EXCEPTION WHEN OTHERS THEN
2055:
2056: x_progress := 100;

Line 2061: DELETE po_session_gt WHERE index_char1 = 'UNLINKED_REQUISITIONS';

2057: PO_MESSAGE_S.add_exc_msg
2058: ( p_pkg_name => 'PO_REQ_LINES_SV',
2059: p_procedure_name => 'update_reqs_in_pool_flag' || '.' || x_progress
2060: );
2061: DELETE po_session_gt WHERE index_char1 = 'UNLINKED_REQUISITIONS';
2062:
2063: END update_reqs_in_pool_flag ;
2064:
2065: END po_req_lines_sv;