APPS.PO_PDOI_ERR_UTL dependencies on PO_SESSION_GT

Line 640: INSERT INTO po_session_gt

636:
637: d_position := 20;
638:
639: FORALL i IN 1..p_table_id_tbl.COUNT
640: INSERT INTO po_session_gt
641: ( key, index_num1, num1 )
642: VALUES
643: (l_key, l_seq(i), p_table_id_tbl(i));
644:

Line 654: FROM po_session_gt PSG,

650:
651: SELECT PHI.interface_header_id
652: BULK COLLECT
653: INTO x_intf_header_id_tbl
654: FROM po_session_gt PSG,
655: po_headers_interface PHI
656: WHERE PSG.key = l_key AND
657: PSG.num1 = PHI.interface_header_id
658: ORDER BY PSG.index_num1;

Line 669: FROM po_session_gt PSG,

665: PLI.interface_line_id
666: BULK COLLECT
667: INTO x_intf_header_id_tbl,
668: x_intf_line_id_tbl
669: FROM po_session_gt PSG,
670: po_lines_interface PLI
671: WHERE PSG.key = l_key
672: AND PSG.num1 = PLI.interface_line_id
673: ORDER BY PSG.index_num1;

Line 686: FROM po_session_gt PSG,

682: BULK COLLECT
683: INTO x_intf_header_id_tbl,
684: x_intf_line_id_tbl,
685: x_intf_line_loc_id_tbl
686: FROM po_session_gt PSG,
687: po_line_locations_interface PLLI
688: WHERE PSG.key = l_key
689: AND PSG.num1 = PLLI.interface_line_location_id
690: ORDER BY PSG.index_num1;

Line 705: FROM po_session_gt PSG,

701: INTO x_intf_header_id_tbl,
702: x_intf_line_id_tbl,
703: x_intf_line_loc_id_tbl,
704: x_intf_dist_id_tbl
705: FROM po_session_gt PSG,
706: po_distributions_interface PDI
707: WHERE PSG.key = l_key
708: AND PSG.num1 = PDI.interface_distribution_id
709: ORDER BY PSG.index_num1;

Line 724: FROM po_session_gt PSG,

720: INTO x_intf_header_id_tbl,
721: x_intf_line_id_tbl,
722: x_intf_line_loc_id_tbl,
723: x_intf_price_diff_id_tbl
724: FROM po_session_gt PSG,
725: po_price_diff_interface PPDI
726: WHERE PSG.key = l_key
727: AND PSG.num1 = PPDI.price_diff_interface_id
728: ORDER BY PSG.index_num1;