APPS.PO_PDOI_ERR_UTL dependencies on PO_SESSION_GT

Line 625: INSERT INTO po_session_gt

621:
622: d_position := 20;
623:
624: FORALL i IN 1..p_table_id_tbl.COUNT
625: INSERT INTO po_session_gt
626: ( key, index_num1, num1 )
627: VALUES
628: (l_key, l_seq(i), p_table_id_tbl(i));
629:

Line 639: FROM po_session_gt PSG,

635:
636: SELECT PHI.interface_header_id
637: BULK COLLECT
638: INTO x_intf_header_id_tbl
639: FROM po_session_gt PSG,
640: po_headers_interface PHI
641: WHERE PSG.key = l_key AND
642: PSG.num1 = PHI.interface_header_id
643: ORDER BY PSG.index_num1;

Line 654: FROM po_session_gt PSG,

650: PLI.interface_line_id
651: BULK COLLECT
652: INTO x_intf_header_id_tbl,
653: x_intf_line_id_tbl
654: FROM po_session_gt PSG,
655: po_lines_interface PLI
656: WHERE PSG.key = l_key
657: AND PSG.num1 = PLI.interface_line_id
658: ORDER BY PSG.index_num1;

Line 671: FROM po_session_gt PSG,

667: BULK COLLECT
668: INTO x_intf_header_id_tbl,
669: x_intf_line_id_tbl,
670: x_intf_line_loc_id_tbl
671: FROM po_session_gt PSG,
672: po_line_locations_interface PLLI
673: WHERE PSG.key = l_key
674: AND PSG.num1 = PLLI.interface_line_location_id
675: ORDER BY PSG.index_num1;

Line 690: FROM po_session_gt PSG,

686: INTO x_intf_header_id_tbl,
687: x_intf_line_id_tbl,
688: x_intf_line_loc_id_tbl,
689: x_intf_dist_id_tbl
690: FROM po_session_gt PSG,
691: po_distributions_interface PDI
692: WHERE PSG.key = l_key
693: AND PSG.num1 = PDI.interface_distribution_id
694: ORDER BY PSG.index_num1;

Line 709: FROM po_session_gt PSG,

705: INTO x_intf_header_id_tbl,
706: x_intf_line_id_tbl,
707: x_intf_line_loc_id_tbl,
708: x_intf_price_diff_id_tbl
709: FROM po_session_gt PSG,
710: po_price_diff_interface PPDI
711: WHERE PSG.key = l_key
712: AND PSG.num1 = PPDI.price_diff_interface_id
713: ORDER BY PSG.index_num1;