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_LINE_LOC_PROCESS_PVT dependencies on PO_SESSION_GT

Line 12: p_key IN po_session_gt.key%TYPE,

8: ---------------------- PRIVATE PROCEDURES PROTOTYPE ----------------------
9: --------------------------------------------------------------------------
10: PROCEDURE derive_line_loc_id
11: (
12: p_key IN po_session_gt.key%TYPE,
13: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
14: p_po_line_id_tbl IN PO_TBL_NUMBER,
15: p_shipment_num_tbl IN PO_TBL_NUMBER,
16: x_line_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 21: p_key IN po_session_gt.key%TYPE,

17: );
18:
19: PROCEDURE derive_ship_to_org_id
20: (
21: p_key IN po_session_gt.key%TYPE,
22: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
23: p_ship_to_org_code_tbl IN PO_TBL_VARCHAR5,
24: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
25: );

Line 29: p_key IN po_session_gt.key%TYPE,

25: );
26:
27: PROCEDURE derive_receiving_routing_id
28: (
29: p_key IN po_session_gt.key%TYPE,
30: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
31: p_receiving_routing_tbl IN PO_TBL_VARCHAR30,
32: x_receiving_routing_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
33: );

Line 37: p_key IN po_session_gt.key%TYPE,

33: );
34:
35: PROCEDURE derive_tax_name
36: (
37: p_key IN po_session_gt.key%TYPE,
38: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
39: p_tax_code_id_tbl IN PO_TBL_NUMBER,
40: x_tax_name_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
41: );

Line 45: p_key IN po_session_gt.key%TYPE,

41: );
42:
43: PROCEDURE default_locs_for_spo
44: (
45: p_key IN po_session_gt.key%TYPE,
46: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
47: x_line_locs IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
48: );
49:

Line 52: p_key IN po_session_gt.key%TYPE,

48: );
49:
50: PROCEDURE default_locs_for_blanket
51: (
52: p_key IN po_session_gt.key%TYPE,
53: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
54: x_line_locs IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
55: );
56:

Line 59: p_key IN po_session_gt.key%TYPE,

55: );
56:
57: PROCEDURE default_locs_for_quotation
58: (
59: p_key IN po_session_gt.key%TYPE,
60: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
61: x_line_locs IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
62: );
63:

Line 66: p_key IN po_session_gt.key%TYPE,

62: );
63:
64: PROCEDURE default_inspect_required_flag
65: (
66: p_key IN po_session_gt.key%TYPE,
67: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
68: p_item_id_tbl IN PO_TBL_NUMBER,
69: x_inspection_required_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
70: );

Line 74: p_key IN po_session_gt.key%TYPE,

70: );
71:
72: PROCEDURE default_ship_to_org_id
73: (
74: p_key IN po_session_gt.key%TYPE,
75: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
76: p_ship_to_loc_id_tbl IN PO_TBL_NUMBER,
77: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
78: );

Line 82: p_key IN po_session_gt.key%TYPE,

78: );
79:
80: PROCEDURE default_close_tolerances
81: (
82: p_key IN po_session_gt.key%TYPE,
83: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
84: p_item_id_tbl IN PO_TBL_NUMBER,
85: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
86: p_line_type_id_tbl IN PO_TBL_NUMBER,

Line 93: p_key IN po_session_gt.key%TYPE,

89: );
90:
91: PROCEDURE default_invoice_match_options
92: (
93: p_key IN po_session_gt.key%TYPE,
94: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
95: p_vendor_id_tbl IN PO_TBL_NUMBER,
96: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
97: x_match_option_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

Line 102: p_key IN po_session_gt.key%TYPE,

98: );
99:
100: PROCEDURE default_accrue_on_receipt_flag
101: (
102: p_key IN po_session_gt.key%TYPE,
103: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
104: p_item_id_tbl IN PO_TBL_NUMBER,
105: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
106: p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1,

Line 119: p_key IN po_session_gt.key%TYPE,

115: );
116:
117: PROCEDURE default_secondary_unit_of_meas
118: (
119: p_key IN po_session_gt.key%TYPE,
120: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
121: p_item_id_tbl IN PO_TBL_NUMBER,
122: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
123: x_secondary_unit_of_meas_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

Line 492: l_key po_session_gt.key%TYPE;

488: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
489: d_position NUMBER;
490:
491: -- key of temp table used to identify the derived result
492: l_key po_session_gt.key%TYPE;
493:
494: -- table used to save the index of the each row
495: l_index_tbl DBMS_SQL.NUMBER_TABLE;
496: BEGIN

Line 774: l_key po_session_gt.key%TYPE;

770: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
771: d_position NUMBER;
772:
773: -- key of temp table used to identify the derived result
774: l_key po_session_gt.key%TYPE;
775:
776: -- table used to save the index of the each row
777: l_index_tbl DBMS_SQL.NUMBER_TABLE;
778: BEGIN

Line 1181: -- key value used to identify rows in po_session_gt table

1177: d_api_name CONSTANT VARCHAR2(30) := 'delete_exist_price_breaks';
1178: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1179: d_position NUMBER;
1180:
1181: -- key value used to identify rows in po_session_gt table
1182: l_key po_session_gt.key%TYPE;
1183:
1184: -- variables to hold results from po_session_gt table
1185: l_line_loc_id_tbl PO_TBL_NUMBER;

Line 1182: l_key po_session_gt.key%TYPE;

1178: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1179: d_position NUMBER;
1180:
1181: -- key value used to identify rows in po_session_gt table
1182: l_key po_session_gt.key%TYPE;
1183:
1184: -- variables to hold results from po_session_gt table
1185: l_line_loc_id_tbl PO_TBL_NUMBER;
1186: l_draft_id_tbl PO_TBL_NUMBER;

Line 1184: -- variables to hold results from po_session_gt table

1180:
1181: -- key value used to identify rows in po_session_gt table
1182: l_key po_session_gt.key%TYPE;
1183:
1184: -- variables to hold results from po_session_gt table
1185: l_line_loc_id_tbl PO_TBL_NUMBER;
1186: l_draft_id_tbl PO_TBL_NUMBER;
1187:
1188: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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

1196:
1197: l_key := PO_CORE_S.get_session_gt_nextval;
1198:
1199: FORALL i IN 1..p_po_line_id_tbl.COUNT
1200: INSERT INTO po_session_gt(key, num1, num2)
1201: SELECT l_key,
1202: line_location_id,
1203: p_draft_id_tbl(i)
1204: FROM po_line_locations_all

Line 1209: DELETE FROM po_session_gt

1205: WHERE po_line_id = p_po_line_id_tbl(i);
1206:
1207: d_position := 10;
1208:
1209: DELETE FROM po_session_gt
1210: WHERE key = l_key
1211: RETURNING num1, num2 BULK COLLECT INTO l_line_loc_id_tbl, l_draft_id_tbl;
1212:
1213: d_position := 20;

Line 1271: p_key IN po_session_gt.key%TYPE,

1267: --End of Comments
1268: ------------------------------------------------------------------------
1269: PROCEDURE derive_line_loc_id
1270: (
1271: p_key IN po_session_gt.key%TYPE,
1272: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1273: p_po_line_id_tbl IN PO_TBL_NUMBER,
1274: p_shipment_num_tbl IN PO_TBL_NUMBER,
1275: x_line_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

1292: END IF;
1293:
1294: -- run query to extract line_location_id
1295: FORALL i IN 1..p_index_tbl.COUNT
1296: INSERT INTO po_session_gt(key, num1, num2)
1297: SELECT p_key,
1298: p_index_tbl(i),
1299: line_location_id
1300: FROM po_line_locations

Line 1310: DELETE FROM po_session_gt

1306:
1307: d_position := 10;
1308:
1309: -- read result from temp table, and delete the records from temp table
1310: DELETE FROM po_session_gt
1311: WHERE key = p_key
1312: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
1313:
1314: d_position := 20;

Line 1364: p_key IN po_session_gt.key%TYPE,

1360: --End of Comments
1361: ------------------------------------------------------------------------
1362: PROCEDURE derive_ship_to_org_id
1363: (
1364: p_key IN po_session_gt.key%TYPE,
1365: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1366: p_ship_to_org_code_tbl IN PO_TBL_VARCHAR5,
1367: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
1368: ) IS

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

1383: END IF;
1384:
1385: -- execute query to extract org_id from org_code
1386: FORALL i IN 1.. p_index_tbl.COUNT
1387: INSERT INTO po_session_gt(key, num1, num2)
1388: SELECT p_key,
1389: p_index_tbl(i),
1390: organization_id
1391: FROM org_organization_definitions

Line 1401: DELETE FROM po_session_gt

1397:
1398: d_position := 10;
1399:
1400: -- read result from temp table, and delete the records from temp table
1401: DELETE FROM po_session_gt
1402: WHERE key = p_key
1403: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
1404:
1405: d_position := 20;

Line 1455: p_key IN po_session_gt.key%TYPE,

1451: --End of Comments
1452: ------------------------------------------------------------------------
1453: PROCEDURE derive_receiving_routing_id
1454: (
1455: p_key IN po_session_gt.key%TYPE,
1456: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1457: p_receiving_routing_tbl IN PO_TBL_VARCHAR30,
1458: x_receiving_routing_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
1459: ) IS

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

1476: END IF;
1477:
1478: -- execute query to extract routing_id from receiving_routings
1479: FORALL i IN 1..p_index_tbl.COUNT
1480: INSERT INTO po_session_gt(key, num1, num2)
1481: SELECT p_key,
1482: p_index_tbl(i),
1483: routing_header_id
1484: FROM rcv_routing_headers

Line 1492: DELETE FROM po_session_gt

1488:
1489: d_position := 10;
1490:
1491: -- read result from temp table, and delete the records from temp table
1492: DELETE FROM po_session_gt
1493: WHERE key = p_key
1494: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
1495:
1496: d_position := 20;

Line 1546: p_key IN po_session_gt.key%TYPE,

1542: --End of Comments
1543: ------------------------------------------------------------------------
1544: PROCEDURE derive_tax_name
1545: (
1546: p_key IN po_session_gt.key%TYPE,
1547: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1548: p_tax_code_id_tbl IN PO_TBL_NUMBER,
1549: x_tax_name_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
1550: ) IS

Line 1571: INSERT INTO po_session_gt(key, num1, char1)

1567: END IF;
1568:
1569: -- execute query to extract tax_name from tax_code_id
1570: FORALL i IN 1..p_index_tbl.COUNT
1571: INSERT INTO po_session_gt(key, num1, char1)
1572: SELECT p_key,
1573: p_index_tbl(i),
1574: tax_classification_code
1575: FROM zx_id_tcc_mapping

Line 1586: DELETE FROM po_session_gt

1582:
1583: d_position := 10;
1584:
1585: -- read result from temp table, and delete the records from temp table
1586: DELETE FROM po_session_gt
1587: WHERE key = p_key
1588: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
1589:
1590: d_position := 20;

Line 1698: p_key IN po_session_gt.key%TYPE,

1694: --End of Comments
1695: ------------------------------------------------------------------------
1696: PROCEDURE default_locs_for_spo
1697: (
1698: p_key IN po_session_gt.key%TYPE,
1699: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1700: x_line_locs IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
1701: ) IS
1702:

Line 2000: p_key IN po_session_gt.key%TYPE,

1996: --End of Comments
1997: ------------------------------------------------------------------------
1998: PROCEDURE default_locs_for_blanket
1999: (
2000: p_key IN po_session_gt.key%TYPE,
2001: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2002: x_line_locs IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
2003: ) IS
2004:

Line 2129: p_key IN po_session_gt.key%TYPE,

2125: --End of Comments
2126: ------------------------------------------------------------------------
2127: PROCEDURE default_locs_for_quotation
2128: (
2129: p_key IN po_session_gt.key%TYPE,
2130: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2131: x_line_locs IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
2132: ) IS
2133:

Line 2329: p_key IN po_session_gt.key%TYPE,

2325: --End of Comments
2326: ------------------------------------------------------------------------
2327: PROCEDURE default_inspect_required_flag
2328: (
2329: p_key IN po_session_gt.key%TYPE,
2330: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2331: p_item_id_tbl IN PO_TBL_NUMBER,
2332: x_inspection_required_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
2333: ) IS

Line 2351: INSERT INTO po_session_gt(key, num1, char1)

2347: END IF;
2348:
2349: -- retrieve the default value from database
2350: FORALL i IN 1..p_index_tbl.COUNT
2351: INSERT INTO po_session_gt(key, num1, char1)
2352: SELECT p_key,
2353: p_index_tbl(i),
2354: inspection_required_flag
2355: FROM mtl_system_items

Line 2364: DELETE FROM po_session_gt

2360:
2361: d_position := 10;
2362:
2363: -- get result from temp table
2364: DELETE FROM po_session_gt
2365: WHERE key = p_key
2366: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2367:
2368: d_position := 20;

Line 2419: p_key IN po_session_gt.key%TYPE,

2415: --End of Comments
2416: ------------------------------------------------------------------------
2417: PROCEDURE default_ship_to_org_id
2418: (
2419: p_key IN po_session_gt.key%TYPE,
2420: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2421: p_ship_to_loc_id_tbl IN PO_TBL_NUMBER,
2422: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2423: ) IS

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

2437: END IF;
2438:
2439: -- default ship_to_organization_id from ship_to_location_id
2440: FORALL i IN 1..p_index_tbl.COUNT
2441: INSERT INTO po_session_gt(key, num1, num2)
2442: SELECT p_key,
2443: p_index_tbl(i),
2444: inventory_organization_id
2445: FROM hr_locations_v

Line 2454: DELETE FROM po_session_gt

2450:
2451: d_position := 10;
2452:
2453: -- get result from temp table
2454: DELETE FROM po_session_gt
2455: WHERE key = p_key
2456: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2457:
2458: d_position := 20;

Line 2521: p_key IN po_session_gt.key%TYPE,

2517: --End of Comments
2518: ------------------------------------------------------------------------
2519: PROCEDURE default_close_tolerances
2520: (
2521: p_key IN po_session_gt.key%TYPE,
2522: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2523: p_item_id_tbl IN PO_TBL_NUMBER,
2524: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
2525: p_line_type_id_tbl IN PO_TBL_NUMBER,

Line 2550: INSERT INTO po_session_gt(key, num1, num2, num3)

2546: END IF;
2547:
2548: -- first, default from item_id and ship_to_organization_id
2549: FORALL i IN 1..p_index_tbl.COUNT
2550: INSERT INTO po_session_gt(key, num1, num2, num3)
2551: SELECT p_key,
2552: p_index_tbl(i),
2553: invoice_close_tolerance,
2554: receive_close_tolerance

Line 2564: DELETE FROM po_session_gt

2560: AND organization_id = p_ship_to_org_id_tbl(i);
2561:
2562: d_position := 10;
2563:
2564: DELETE FROM po_session_gt
2565: WHERE key = p_key
2566: RETURNING num1, num2, num3 BULK COLLECT INTO
2567: l_index_tbl, l_invoice_tolerance_tbl, l_receive_tolerance_tbl;
2568:

Line 2595: INSERT INTO po_session_gt(key, num1, num2, num3)

2591: d_position := 30;
2592:
2593: -- Second, default from item_id and default inventory org id
2594: FORALL i IN 1..p_index_tbl.COUNT
2595: INSERT INTO po_session_gt(key, num1, num2, num3)
2596: SELECT p_key,
2597: p_index_tbl(i),
2598: invoice_close_tolerance,
2599: receive_close_tolerance

Line 2609: DELETE FROM po_session_gt

2605: AND organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;
2606:
2607: d_position := 40;
2608:
2609: DELETE FROM po_session_gt
2610: WHERE key = p_key
2611: RETURNING num1, num2, num3 BULK COLLECT INTO
2612: l_index_tbl, l_invoice_tolerance_tbl, l_receive_tolerance_tbl;
2613:

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

2636: d_position := 60;
2637:
2638: -- Third, default receive_close_tolerance from line_type_id
2639: FORALL i IN 1..p_index_tbl.COUNT
2640: INSERT INTO po_session_gt(key, num1, num2)
2641: SELECT p_key,
2642: p_index_tbl(i),
2643: receipt_close
2644: FROM po_line_types_v

Line 2651: DELETE FROM po_session_gt

2647: AND line_type_id = p_line_type_id_tbl(i);
2648:
2649: d_position := 70;
2650:
2651: DELETE FROM po_session_gt
2652: WHERE key = p_key
2653: RETURNING num1, num2 BULK COLLECT INTO
2654: l_index_tbl, l_receive_tolerance_tbl;
2655:

Line 2732: p_key IN po_session_gt.key%TYPE,

2728: --End of Comments
2729: ------------------------------------------------------------------------
2730: PROCEDURE default_invoice_match_options
2731: (
2732: p_key IN po_session_gt.key%TYPE,
2733: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2734: p_vendor_id_tbl IN PO_TBL_NUMBER,
2735: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
2736: x_match_option_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

Line 2755: INSERT INTO po_session_gt(key, num1, char1)

2751: END IF;
2752:
2753: -- first, get default value from vendor_site
2754: FORALL i IN 1..p_index_tbl.COUNT
2755: INSERT INTO po_session_gt(key, num1, char1)
2756: SELECT p_key,
2757: p_index_tbl(i),
2758: match_option
2759: FROM po_vendor_sites

Line 2766: DELETE FROM po_session_gt

2762: AND vendor_site_id = p_vendor_site_id_tbl(i);
2763:
2764: d_position := 10;
2765:
2766: DELETE FROM po_session_gt
2767: WHERE key = p_key
2768: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2769:
2770: FOR i IN 1..l_index_tbl.COUNT

Line 2784: INSERT INTO po_session_gt(key, num1, char1)

2780: d_position := 20;
2781:
2782: -- next, default value from vendor, same as vendor_site
2783: FORALL i IN 1..p_index_tbl.COUNT
2784: INSERT INTO po_session_gt(key, num1, char1)
2785: SELECT p_key,
2786: p_index_tbl(i),
2787: match_option
2788: FROM po_vendors

Line 2795: DELETE FROM po_session_gt

2791: AND vendor_id = p_vendor_id_tbl(i);
2792:
2793: d_position := 30;
2794:
2795: DELETE FROM po_session_gt
2796: WHERE key = p_key
2797: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2798:
2799: FOR i IN 1..l_index_tbl.COUNT

Line 2863: p_key IN po_session_gt.key%TYPE,

2859: --End of Comments
2860: ------------------------------------------------------------------------
2861: PROCEDURE default_accrue_on_receipt_flag
2862: (
2863: p_key IN po_session_gt.key%TYPE,
2864: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2865: p_item_id_tbl IN PO_TBL_NUMBER,
2866: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
2867: p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1,

Line 2892: INSERT INTO po_session_gt(key, num1, char1, char2)

2888:
2889: -- get default values from item
2890: -- first, default from item_id and ship_to_organization_id
2891: FORALL i IN 1..p_index_tbl.COUNT
2892: INSERT INTO po_session_gt(key, num1, char1, char2)
2893: SELECT p_key,
2894: p_index_tbl(i),
2895: outside_operation_flag,
2896: nvl(stock_enabled_flag,'N')

Line 2905: DELETE FROM po_session_gt

2901: AND organization_id = p_ship_to_org_id_tbl(i);
2902:
2903: d_position := 10;
2904:
2905: DELETE FROM po_session_gt
2906: WHERE key = p_key
2907: RETURNING num1, char1, char2 BULK COLLECT INTO
2908: l_index_tbl, l_outside_op_flag_tbl, l_stock_enabled_flag_tbl;
2909:

Line 3002: p_key IN po_session_gt.key%TYPE,

2998: --End of Comments
2999: ------------------------------------------------------------------------
3000: PROCEDURE default_secondary_unit_of_meas
3001: (
3002: p_key IN po_session_gt.key%TYPE,
3003: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3004: p_item_id_tbl IN PO_TBL_NUMBER,
3005: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
3006: x_secondary_unit_of_meas_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

Line 3026: INSERT INTO po_session_gt(key, num1, char1)

3022: END IF;
3023:
3024: -- retrieve the default value from database
3025: FORALL i IN 1..p_index_tbl.COUNT
3026: INSERT INTO po_session_gt(key, num1, char1)
3027: SELECT p_key,
3028: p_index_tbl(i),
3029: uom.unit_of_measure
3030: FROM mtl_system_items item,

Line 3043: DELETE FROM po_session_gt

3039:
3040: d_position := 10;
3041:
3042: -- get result from temp table
3043: DELETE FROM po_session_gt
3044: WHERE key = p_key
3045: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
3046:
3047: d_position := 20;