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 max(intf_lines.line_num) AS max_line_num

Line 289: DELETE FROM po_session_gt

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

Line 477: l_key po_session_gt.key%TYPE;

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

Line 503: INSERT INTO po_session_gt(key, num1)

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

Line 515: INSERT INTO po_session_gt(key, num1)

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

Line 526: INSERT INTO po_session_gt(key, num1)

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

Line 542: DELETE FROM po_session_gt

538: AND intf_lines.line_num = p_line_num_tbl(i);
539:
540: d_position := 30;
541:
542: DELETE FROM po_session_gt
543: WHERE key = l_key
544: RETURNING num1 BULK COLLECT INTO l_index_tbl;
545:
546: FOR i IN 1..l_index_tbl.COUNT

Line 605: l_key po_session_gt.key%TYPE;

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

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

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

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

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

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

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

Line 725: DELETE FROM po_session_gt

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

Line 905: l_key po_session_gt.key%TYPE;

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

Line 931: INSERT INTO po_session_gt(key, num1)

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

Line 948: INSERT INTO po_session_gt(key, num1)

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

Line 968: DELETE FROM po_session_gt

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

Line 1031: l_key po_session_gt.key%TYPE;

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

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

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

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

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

Line 1120: DELETE FROM po_session_gt

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

Line 1311: l_key po_session_gt.key%TYPE;

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

Line 1339: INSERT INTO po_session_gt(key, num1)

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

Line 1354: INSERT INTO po_session_gt(key, num1)

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

Line 1373: DELETE FROM po_session_gt

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

Line 1444: l_key po_session_gt.key%TYPE;

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

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

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

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

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

Line 1495: DELETE FROM po_session_gt

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

Line 1679: l_key po_session_gt.key%TYPE;

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

Line 1713: INSERT INTO po_session_gt(key, num1)

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

Line 1726: INSERT INTO po_session_gt(key, num1)

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

Line 1736: DELETE FROM po_session_gt

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