eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_PDOI_MAINPROC_UTL_PVT dependencies on PO_SESSION_GT

Line 197: l_key po_session_gt.key%TYPE;

193: d_api_name CONSTANT VARCHAR2(30) := 'calculate_max_line_num';
194: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
195: d_position NUMBER;
196:
197: l_key po_session_gt.key%TYPE;
198: l_po_header_id_tbl PO_TBL_NUMBER;
199: l_max_line_num_tbl PO_TBL_NUMBER;
200:
201: l_processing_row_tbl DBMS_SQL.number_table;

Line 245: INSERT INTO po_session_gt(key, num1, num2)

241: l_key := PO_CORE_S.get_session_gt_nextval;
242:
243: -- search in txn table
244: FORALL i IN INDICES OF l_processing_row_tbl
245: INSERT INTO po_session_gt(key, num1, num2)
246: SELECT l_key,
247: p_po_header_id_tbl(i),
248: v.max_line_num
249: FROM (SELECT max(line_num) AS max_line_num

Line 258: INSERT INTO po_session_gt(key, num1, num2)

254: d_position := 20;
255:
256: -- search in draft table
257: FORALL i IN INDICES OF l_processing_row_tbl
258: INSERT INTO po_session_gt(key, num1, num2)
259: SELECT l_key,
260: p_po_header_id_tbl(i),
261: v.max_line_num
262: FROM (SELECT max(line_num) AS max_line_num

Line 272: INSERT INTO po_session_gt(key, num1, num2)

268: d_position := 30;
269:
270: -- search interface table
271: FORALL i IN INDICES OF l_processing_row_tbl
272: INSERT INTO po_session_gt(key, num1, num2)
273: SELECT l_key,
274: p_po_header_id_tbl(i),
275: v.max_line_num
276: FROM (SELECT /*+ INDEX(intf_headers PO_HEADERS_INTERFACE_N5) */ -- Added as 9799280 fix

Line 291: DELETE FROM po_session_gt

287:
288: d_position := 40;
289:
290: -- set max_line_num in cache
291: DELETE FROM po_session_gt
292: WHERE key = l_key
293: RETURNING num1, num2 BULK COLLECT INTO l_po_header_id_tbl, l_max_line_num_tbl;
294:
295: IF (PO_LOG.d_stmt) THEN

Line 479: l_key po_session_gt.key%TYPE;

475: d_position NUMBER;
476:
477: l_index_tbl DBMS_SQL.number_table;
478:
479: l_key po_session_gt.key%TYPE;
480: BEGIN
481: d_position := 0;
482:
483: IF (PO_LOG.d_proc) THEN

Line 505: INSERT INTO po_session_gt(key, num1)

501: );
502:
503: -- check draft table
504: FORALL i IN 1..l_index_tbl.COUNT
505: INSERT INTO po_session_gt(key, num1)
506: SELECT l_key,
507: l_index_tbl(i)
508: FROM po_lines_draft_all
509: WHERE po_header_id = p_po_header_id_tbl(i)

Line 517: INSERT INTO po_session_gt(key, num1)

513: d_position := 10;
514:
515: -- check txn table
516: FORALL i IN 1..l_index_tbl.COUNT
517: INSERT INTO po_session_gt(key, num1)
518: SELECT l_key,
519: l_index_tbl(i)
520: FROM po_lines_all
521: WHERE po_header_id = p_po_header_id_tbl(i)

Line 528: INSERT INTO po_session_gt(key, num1)

524: d_position := 20;
525:
526: -- check interface table records which is before current records
527: FORALL i IN 1..l_index_tbl.COUNT
528: INSERT INTO po_session_gt(key, num1)
529: SELECT l_key,
530: l_index_tbl(i)
531: FROM po_lines_interface intf_lines,
532: po_headers_interface intf_headers

Line 545: DELETE FROM po_session_gt

541: AND intf_headers.po_header_id IS NOT NULL AND p_po_header_id_tbl(i) IS NOT NULL; -- Added as 9799280 fix to handle & avoid NULL cases.
542:
543: d_position := 30;
544:
545: DELETE FROM po_session_gt
546: WHERE key = l_key
547: RETURNING num1 BULK COLLECT INTO l_index_tbl;
548:
549: FOR i IN 1..l_index_tbl.COUNT

Line 608: l_key po_session_gt.key%TYPE;

604: d_api_name CONSTANT VARCHAR2(30) := 'calculate_max_shipment_num';
605: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
606: d_position NUMBER;
607:
608: l_key po_session_gt.key%TYPE;
609: l_po_line_id_tbl PO_TBL_NUMBER;
610: l_max_shipment_num_tbl PO_TBL_NUMBER;
611:
612: l_processing_row_tbl DBMS_SQL.number_table;

Line 667: INSERT INTO po_session_gt(key, num1, num2)

663: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
664: d_position := 10;
665:
666: FORALL i IN INDICES OF l_processing_row_tbl
667: INSERT INTO po_session_gt(key, num1, num2)
668: SELECT l_key,
669: p_po_line_id_tbl(i),
670: v.max_shipment_num
671: FROM (SELECT max(shipment_num) AS max_shipment_num

Line 686: INSERT INTO po_session_gt(key, num1, num2)

682: -- not be counted here
683:
684: -- search in draft table
685: FORALL i IN INDICES OF l_processing_row_tbl
686: INSERT INTO po_session_gt(key, num1, num2)
687: SELECT l_key,
688: p_po_line_id_tbl(i),
689: v.max_shipment_num
690: FROM (SELECT max(shipment_num) AS max_shipment_num

Line 707: INSERT INTO po_session_gt(key, num1, num2)

703: This fix is done as the CBO was starting from the po_line_locations_interface index.*/
704:
705: -- search interface table
706: FORALL i IN INDICES OF l_processing_row_tbl
707: INSERT INTO po_session_gt(key, num1, num2)
708: SELECT l_key,
709: p_po_line_id_tbl(i),
710: v.max_shipment_num
711: FROM (SELECT /*+ INDEX(intf_lines PO_LINES_INTERFACE_N8) */

Line 728: DELETE FROM po_session_gt

724:
725: d_position := 40;
726:
727: -- set max_shipment_num in cache
728: DELETE FROM po_session_gt
729: WHERE key = l_key
730: RETURNING num1, num2 BULK COLLECT INTO l_po_line_id_tbl, l_max_shipment_num_tbl;
731:
732: FOR i IN 1..l_po_line_id_tbl.COUNT

Line 908: l_key po_session_gt.key%TYPE;

904: d_position NUMBER;
905:
906: l_index_tbl DBMS_SQL.number_table;
907:
908: l_key po_session_gt.key%TYPE;
909: BEGIN
910: d_position := 0;
911:
912: IF (PO_LOG.d_proc) THEN

Line 934: INSERT INTO po_session_gt(key, num1)

930: );
931:
932: -- check draft table
933: FORALL i IN 1..l_index_tbl.COUNT
934: INSERT INTO po_session_gt(key, num1)
935: SELECT l_key,
936: l_index_tbl(i)
937: FROM po_line_locations_draft_all
938: WHERE po_line_id = p_po_line_id_tbl(i)

Line 951: INSERT INTO po_session_gt(key, num1)

947: Ideally search should start from po_lines_interface.*/
948:
949: -- check interface table records which is before current records
950: FORALL i IN 1..l_index_tbl.COUNT
951: INSERT INTO po_session_gt(key, num1)
952: SELECT l_key,
953: l_index_tbl(i)
954: FROM po_line_locations_interface intf_locs,
955: po_lines_interface intf_lines,

Line 971: DELETE FROM po_session_gt

967: AND intf_lines.po_line_id IS NOT NULL AND p_po_line_id_tbl(i) IS NOT NULL;
968:
969: d_position := 20;
970:
971: DELETE FROM po_session_gt
972: WHERE key = l_key
973: RETURNING num1 BULK COLLECT INTO l_index_tbl;
974:
975: FOR i IN 1..l_index_tbl.COUNT

Line 1034: l_key po_session_gt.key%TYPE;

1030: d_api_name CONSTANT VARCHAR2(30) := 'calculate_max_dist_num';
1031: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1032: d_position NUMBER;
1033:
1034: l_key po_session_gt.key%TYPE;
1035: l_line_loc_id_tbl PO_TBL_NUMBER;
1036: l_max_dist_num_tbl PO_TBL_NUMBER;
1037:
1038: l_processing_row_tbl DBMS_SQL.number_table;

Line 1082: INSERT INTO po_session_gt(key, num1, num2)

1078: d_position := 10;
1079:
1080: -- search in draft table
1081: FORALL i IN INDICES OF l_processing_row_tbl
1082: INSERT INTO po_session_gt(key, num1, num2)
1083: SELECT l_key,
1084: p_line_loc_id_tbl(i),
1085: v.max_dist_num
1086: FROM (SELECT max(distribution_num) AS max_dist_num

Line 1102: INSERT INTO po_session_gt(key, num1, num2)

1098: -- Adding the Leading Hint as per Apps Performance Team Suggestion
1099:
1100: -- search interface table
1101: FORALL i IN INDICES OF l_processing_row_tbl
1102: INSERT INTO po_session_gt(key, num1, num2)
1103: SELECT l_key,
1104: p_line_loc_id_tbl(i),
1105: v.max_dist_num
1106: FROM (SELECT /*+ leading(intf_locs) INDEX(intf_locs PO_LINE_LOCATIONS_INTERFACE_N4) */

Line 1123: DELETE FROM po_session_gt

1119:
1120: d_position := 30;
1121:
1122: -- set max_distribution_num in cache
1123: DELETE FROM po_session_gt
1124: WHERE key = l_key
1125: RETURNING num1, num2 BULK COLLECT INTO l_line_loc_id_tbl, l_max_dist_num_tbl;
1126:
1127: FOR i IN 1..l_line_loc_id_tbl.COUNT

Line 1314: l_key po_session_gt.key%TYPE;

1310: d_api_name CONSTANT VARCHAR2(30) := 'check_dist_num_unique';
1311: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1312: d_position NUMBER;
1313:
1314: l_key po_session_gt.key%TYPE;
1315:
1316: l_index_tbl DBMS_SQL.NUMBER_TABLE;
1317: BEGIN
1318: d_position := 0;

Line 1342: INSERT INTO po_session_gt(key, num1)

1338: );
1339:
1340: -- check draft table
1341: FORALL i IN 1..l_index_tbl.COUNT
1342: INSERT INTO po_session_gt(key, num1)
1343: SELECT l_key,
1344: l_index_tbl(i)
1345: FROM po_distributions_draft_all
1346: WHERE line_location_id = p_line_loc_id_tbl(i)

Line 1357: INSERT INTO po_session_gt(key, num1)

1353: -- Adding the Leading Hint as per Apps Performance Team Suggestion
1354:
1355: -- check interface table records which is before current records
1356: FORALL i IN 1..l_index_tbl.COUNT
1357: INSERT INTO po_session_gt(key, num1)
1358: SELECT /*+ LEADING(intf_locs) */ l_key,
1359: l_index_tbl(i)
1360: FROM po_distributions_interface intf_dists,
1361: po_line_locations_interface intf_locs,

Line 1376: DELETE FROM po_session_gt

1372: AND intf_dists.distribution_num = p_dist_num_tbl(i);
1373:
1374: d_position := 20;
1375:
1376: DELETE FROM po_session_gt
1377: WHERE key = l_key
1378: RETURNING num1 BULK COLLECT INTO l_index_tbl;
1379:
1380: FOR i IN 1..l_index_tbl.COUNT

Line 1447: l_key po_session_gt.key%TYPE;

1443: d_api_name CONSTANT VARCHAR2(30) := 'calculate_max_price_diff_num';
1444: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1445: d_position NUMBER;
1446:
1447: l_key po_session_gt.key%TYPE;
1448: l_entity_type_tbl PO_TBL_VARCHAR30;
1449: l_entity_id_tbl PO_TBL_NUMBER;
1450: l_max_price_diff_num_tbl PO_TBL_NUMBER;
1451:

Line 1468: INSERT INTO po_session_gt(key, char1, num1, num2)

1464: d_position := 10;
1465:
1466: -- first, search in draft table for max price diff num
1467: FORALL i IN 1..p_entity_id_tbl.COUNT
1468: INSERT INTO po_session_gt(key, char1, num1, num2)
1469: SELECT l_key,
1470: p_entity_type_tbl(i),
1471: p_entity_id_tbl(i),
1472: v.max_price_diff_num

Line 1484: INSERT INTO po_session_gt(key, char1, num1, num2)

1480: d_position := 20;
1481:
1482: -- second, search in txn table for max price diff num
1483: FORALL i IN 1..p_entity_id_tbl.COUNT
1484: INSERT INTO po_session_gt(key, char1, num1, num2)
1485: SELECT l_key,
1486: p_entity_type_tbl(i),
1487: p_entity_id_tbl(i),
1488: v.max_price_diff_num

Line 1498: DELETE FROM po_session_gt

1494:
1495: d_position := 30;
1496:
1497: -- set max price diff num in cache
1498: DELETE FROM po_session_gt
1499: WHERE key = l_key
1500: RETURNING char1, num1, num2 BULK COLLECT INTO
1501: l_entity_type_tbl, l_entity_id_tbl, l_max_price_diff_num_tbl;
1502:

Line 1682: l_key po_session_gt.key%TYPE;

1678: d_api_name CONSTANT VARCHAR2(30) := 'check_price_diff_num_unique';
1679: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1680: d_position NUMBER;
1681:
1682: l_key po_session_gt.key%TYPE;
1683:
1684: l_index_tbl DBMS_SQL.NUMBER_TABLE;
1685:
1686: TYPE two_dimension_table_type IS TABLE OF DBMS_SQL.VARCHAR2_TABLE INDEX BY PLS_INTEGER;

Line 1716: INSERT INTO po_session_gt(key, num1)

1712: );
1713:
1714: -- first, check draft table to see whether the provided price diff nums exist
1715: FORALL i IN 1..l_index_tbl.COUNT
1716: INSERT INTO po_session_gt(key, num1)
1717: SELECT l_key,
1718: l_index_tbl(i)
1719: FROM po_price_diff_draft
1720: WHERE entity_type = p_entity_type_tbl(i)

Line 1729: INSERT INTO po_session_gt(key, num1)

1725: d_position := 10;
1726:
1727: -- second, check txn table to see whether the provided price diff nums exist
1728: FORALL i IN 1..l_index_tbl.COUNT
1729: INSERT INTO po_session_gt(key, num1)
1730: SELECT l_key,
1731: l_index_tbl(i)
1732: FROM po_price_differentials
1733: WHERE entity_type = p_entity_type_tbl(i)

Line 1739: DELETE FROM po_session_gt

1735: AND price_differential_num = p_price_diff_num_tbl(i);
1736:
1737: d_position := 20;
1738:
1739: DELETE FROM po_session_gt
1740: WHERE key = l_key
1741: RETURNING num1 BULK COLLECT INTO l_index_tbl;
1742:
1743: d_position := 30;