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 524: l_key po_session_gt.key%TYPE;

520: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
521: d_position NUMBER;
522:
523: -- key of temp table used to identify the derived result
524: l_key po_session_gt.key%TYPE;
525:
526: -- table used to save the index of the each row
527: l_index_tbl DBMS_SQL.NUMBER_TABLE;
528:

Line 872: l_key po_session_gt.key%TYPE;

868: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
869: d_position NUMBER;
870:
871: -- key of temp table used to identify the derived result
872: l_key po_session_gt.key%TYPE;
873:
874: -- table used to save the index of the each row
875: l_index_tbl DBMS_SQL.NUMBER_TABLE;
876: BEGIN

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

1286: d_api_name CONSTANT VARCHAR2(30) := 'delete_exist_price_breaks';
1287: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1288: d_position NUMBER;
1289:
1290: -- key value used to identify rows in po_session_gt table
1291: l_key po_session_gt.key%TYPE;
1292:
1293: -- variables to hold results from po_session_gt table
1294: l_line_loc_id_tbl PO_TBL_NUMBER;

Line 1291: l_key po_session_gt.key%TYPE;

1287: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1288: d_position NUMBER;
1289:
1290: -- key value used to identify rows in po_session_gt table
1291: l_key po_session_gt.key%TYPE;
1292:
1293: -- variables to hold results from po_session_gt table
1294: l_line_loc_id_tbl PO_TBL_NUMBER;
1295: l_draft_id_tbl PO_TBL_NUMBER;

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

1289:
1290: -- key value used to identify rows in po_session_gt table
1291: l_key po_session_gt.key%TYPE;
1292:
1293: -- variables to hold results from po_session_gt table
1294: l_line_loc_id_tbl PO_TBL_NUMBER;
1295: l_draft_id_tbl PO_TBL_NUMBER;
1296:
1297: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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

1305:
1306: l_key := PO_CORE_S.get_session_gt_nextval;
1307:
1308: FORALL i IN 1..p_po_line_id_tbl.COUNT
1309: INSERT INTO po_session_gt(key, num1, num2)
1310: SELECT l_key,
1311: line_location_id,
1312: p_draft_id_tbl(i)
1313: FROM po_line_locations_all

Line 1318: DELETE FROM po_session_gt

1314: WHERE po_line_id = p_po_line_id_tbl(i);
1315:
1316: d_position := 10;
1317:
1318: DELETE FROM po_session_gt
1319: WHERE key = l_key
1320: RETURNING num1, num2 BULK COLLECT INTO l_line_loc_id_tbl, l_draft_id_tbl;
1321:
1322: d_position := 20;

Line 1380: p_key IN po_session_gt.key%TYPE,

1376: --End of Comments
1377: ------------------------------------------------------------------------
1378: PROCEDURE derive_line_loc_id
1379: (
1380: p_key IN po_session_gt.key%TYPE,
1381: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1382: p_po_line_id_tbl IN PO_TBL_NUMBER,
1383: p_shipment_num_tbl IN PO_TBL_NUMBER,
1384: x_line_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

1401: END IF;
1402:
1403: -- run query to extract line_location_id
1404: FORALL i IN 1..p_index_tbl.COUNT
1405: INSERT INTO po_session_gt(key, num1, num2)
1406: SELECT p_key,
1407: p_index_tbl(i),
1408: line_location_id
1409: FROM po_line_locations

Line 1419: DELETE FROM po_session_gt

1415:
1416: d_position := 10;
1417:
1418: -- read result from temp table, and delete the records from temp table
1419: DELETE FROM po_session_gt
1420: WHERE key = p_key
1421: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
1422:
1423: d_position := 20;

Line 1473: p_key IN po_session_gt.key%TYPE,

1469: --End of Comments
1470: ------------------------------------------------------------------------
1471: PROCEDURE derive_ship_to_org_id
1472: (
1473: p_key IN po_session_gt.key%TYPE,
1474: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1475: p_ship_to_org_code_tbl IN PO_TBL_VARCHAR5,
1476: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
1477: ) IS

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

1492: END IF;
1493:
1494: -- execute query to extract org_id from org_code
1495: FORALL i IN 1.. p_index_tbl.COUNT
1496: INSERT INTO po_session_gt(key, num1, num2)
1497: SELECT p_key,
1498: p_index_tbl(i),
1499: organization_id
1500: FROM org_organization_definitions

Line 1510: DELETE FROM po_session_gt

1506:
1507: d_position := 10;
1508:
1509: -- read result from temp table, and delete the records from temp table
1510: DELETE FROM po_session_gt
1511: WHERE key = p_key
1512: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
1513:
1514: d_position := 20;

Line 1564: p_key IN po_session_gt.key%TYPE,

1560: --End of Comments
1561: ------------------------------------------------------------------------
1562: PROCEDURE derive_receiving_routing_id
1563: (
1564: p_key IN po_session_gt.key%TYPE,
1565: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1566: p_receiving_routing_tbl IN PO_TBL_VARCHAR30,
1567: x_receiving_routing_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
1568: ) IS

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

1585: END IF;
1586:
1587: -- execute query to extract routing_id from receiving_routings
1588: FORALL i IN 1..p_index_tbl.COUNT
1589: INSERT INTO po_session_gt(key, num1, num2)
1590: SELECT p_key,
1591: p_index_tbl(i),
1592: routing_header_id
1593: FROM rcv_routing_headers

Line 1601: DELETE FROM po_session_gt

1597:
1598: d_position := 10;
1599:
1600: -- read result from temp table, and delete the records from temp table
1601: DELETE FROM po_session_gt
1602: WHERE key = p_key
1603: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
1604:
1605: d_position := 20;

Line 1655: p_key IN po_session_gt.key%TYPE,

1651: --End of Comments
1652: ------------------------------------------------------------------------
1653: PROCEDURE derive_tax_name
1654: (
1655: p_key IN po_session_gt.key%TYPE,
1656: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1657: p_tax_code_id_tbl IN PO_TBL_NUMBER,
1658: x_tax_name_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
1659: ) IS

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

1676: END IF;
1677:
1678: -- execute query to extract tax_name from tax_code_id
1679: FORALL i IN 1..p_index_tbl.COUNT
1680: INSERT INTO po_session_gt(key, num1, char1)
1681: SELECT p_key,
1682: p_index_tbl(i),
1683: tax_classification_code
1684: FROM zx_id_tcc_mapping

Line 1695: DELETE FROM po_session_gt

1691:
1692: d_position := 10;
1693:
1694: -- read result from temp table, and delete the records from temp table
1695: DELETE FROM po_session_gt
1696: WHERE key = p_key
1697: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
1698:
1699: d_position := 20;

Line 1807: p_key IN po_session_gt.key%TYPE,

1803: --End of Comments
1804: ------------------------------------------------------------------------
1805: PROCEDURE default_locs_for_spo
1806: (
1807: p_key IN po_session_gt.key%TYPE,
1808: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1809: x_line_locs IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
1810: ) IS
1811:

Line 2144: p_key IN po_session_gt.key%TYPE,

2140: --End of Comments
2141: ------------------------------------------------------------------------
2142: PROCEDURE default_locs_for_blanket
2143: (
2144: p_key IN po_session_gt.key%TYPE,
2145: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2146: x_line_locs IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
2147: ) IS
2148:

Line 2282: p_key IN po_session_gt.key%TYPE,

2278: --End of Comments
2279: ------------------------------------------------------------------------
2280: PROCEDURE default_locs_for_quotation
2281: (
2282: p_key IN po_session_gt.key%TYPE,
2283: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2284: x_line_locs IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
2285: ) IS
2286:

Line 2520: p_key IN po_session_gt.key%TYPE,

2516: --End of Comments
2517: ------------------------------------------------------------------------
2518: PROCEDURE default_inspect_required_flag
2519: (
2520: p_key IN po_session_gt.key%TYPE,
2521: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2522: p_item_id_tbl IN PO_TBL_NUMBER,
2523: x_inspection_required_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
2524: ) IS

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

2538: END IF;
2539:
2540: -- retrieve the default value from database
2541: FORALL i IN 1..p_index_tbl.COUNT
2542: INSERT INTO po_session_gt(key, num1, char1)
2543: SELECT p_key,
2544: p_index_tbl(i),
2545: inspection_required_flag
2546: FROM mtl_system_items

Line 2555: DELETE FROM po_session_gt

2551:
2552: d_position := 10;
2553:
2554: -- get result from temp table
2555: DELETE FROM po_session_gt
2556: WHERE key = p_key
2557: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2558:
2559: d_position := 20;

Line 2610: p_key IN po_session_gt.key%TYPE,

2606: --End of Comments
2607: ------------------------------------------------------------------------
2608: PROCEDURE default_ship_to_org_id
2609: (
2610: p_key IN po_session_gt.key%TYPE,
2611: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2612: p_ship_to_loc_id_tbl IN PO_TBL_NUMBER,
2613: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2614: ) IS

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

2628: END IF;
2629:
2630: -- default ship_to_organization_id from ship_to_location_id
2631: FORALL i IN 1..p_index_tbl.COUNT
2632: INSERT INTO po_session_gt(key, num1, num2)
2633: SELECT p_key,
2634: p_index_tbl(i),
2635: inventory_organization_id
2636: FROM hr_locations_v

Line 2645: DELETE FROM po_session_gt

2641:
2642: d_position := 10;
2643:
2644: -- get result from temp table
2645: DELETE FROM po_session_gt
2646: WHERE key = p_key
2647: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2648:
2649: d_position := 20;

Line 2712: p_key IN po_session_gt.key%TYPE,

2708: --End of Comments
2709: ------------------------------------------------------------------------
2710: PROCEDURE default_close_tolerances
2711: (
2712: p_key IN po_session_gt.key%TYPE,
2713: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2714: p_item_id_tbl IN PO_TBL_NUMBER,
2715: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
2716: p_line_type_id_tbl IN PO_TBL_NUMBER,

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

2737: END IF;
2738:
2739: -- first, default from item_id and ship_to_organization_id
2740: FORALL i IN 1..p_index_tbl.COUNT
2741: INSERT INTO po_session_gt(key, num1, num2, num3)
2742: SELECT p_key,
2743: p_index_tbl(i),
2744: invoice_close_tolerance,
2745: receive_close_tolerance

Line 2755: DELETE FROM po_session_gt

2751: AND organization_id = p_ship_to_org_id_tbl(i);
2752:
2753: d_position := 10;
2754:
2755: DELETE FROM po_session_gt
2756: WHERE key = p_key
2757: RETURNING num1, num2, num3 BULK COLLECT INTO
2758: l_index_tbl, l_invoice_tolerance_tbl, l_receive_tolerance_tbl;
2759:

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

2782: d_position := 30;
2783:
2784: -- Second, default from item_id and default inventory org id
2785: FORALL i IN 1..p_index_tbl.COUNT
2786: INSERT INTO po_session_gt(key, num1, num2, num3)
2787: SELECT p_key,
2788: p_index_tbl(i),
2789: invoice_close_tolerance,
2790: receive_close_tolerance

Line 2800: DELETE FROM po_session_gt

2796: AND organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;
2797:
2798: d_position := 40;
2799:
2800: DELETE FROM po_session_gt
2801: WHERE key = p_key
2802: RETURNING num1, num2, num3 BULK COLLECT INTO
2803: l_index_tbl, l_invoice_tolerance_tbl, l_receive_tolerance_tbl;
2804:

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

2827: d_position := 60;
2828:
2829: -- Third, default receive_close_tolerance from line_type_id
2830: FORALL i IN 1..p_index_tbl.COUNT
2831: INSERT INTO po_session_gt(key, num1, num2)
2832: SELECT p_key,
2833: p_index_tbl(i),
2834: receipt_close
2835: FROM po_line_types_v

Line 2842: DELETE FROM po_session_gt

2838: AND line_type_id = p_line_type_id_tbl(i);
2839:
2840: d_position := 70;
2841:
2842: DELETE FROM po_session_gt
2843: WHERE key = p_key
2844: RETURNING num1, num2 BULK COLLECT INTO
2845: l_index_tbl, l_receive_tolerance_tbl;
2846:

Line 2923: p_key IN po_session_gt.key%TYPE,

2919: --End of Comments
2920: ------------------------------------------------------------------------
2921: PROCEDURE default_invoice_match_options
2922: (
2923: p_key IN po_session_gt.key%TYPE,
2924: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2925: p_vendor_id_tbl IN PO_TBL_NUMBER,
2926: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
2927: x_match_option_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

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

2942: END IF;
2943:
2944: -- first, get default value from vendor_site
2945: FORALL i IN 1..p_index_tbl.COUNT
2946: INSERT INTO po_session_gt(key, num1, char1)
2947: SELECT p_key,
2948: p_index_tbl(i),
2949: match_option
2950: FROM po_vendor_sites

Line 2957: DELETE FROM po_session_gt

2953: AND vendor_site_id = p_vendor_site_id_tbl(i);
2954:
2955: d_position := 10;
2956:
2957: DELETE FROM po_session_gt
2958: WHERE key = p_key
2959: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2960:
2961: FOR i IN 1..l_index_tbl.COUNT

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

2971: d_position := 20;
2972:
2973: -- next, default value from vendor, same as vendor_site
2974: FORALL i IN 1..p_index_tbl.COUNT
2975: INSERT INTO po_session_gt(key, num1, char1)
2976: SELECT p_key,
2977: p_index_tbl(i),
2978: match_option
2979: FROM po_vendors

Line 2986: DELETE FROM po_session_gt

2982: AND vendor_id = p_vendor_id_tbl(i);
2983:
2984: d_position := 30;
2985:
2986: DELETE FROM po_session_gt
2987: WHERE key = p_key
2988: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2989:
2990: FOR i IN 1..l_index_tbl.COUNT

Line 3054: p_key IN po_session_gt.key%TYPE,

3050: --End of Comments
3051: ------------------------------------------------------------------------
3052: PROCEDURE default_accrue_on_receipt_flag
3053: (
3054: p_key IN po_session_gt.key%TYPE,
3055: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3056: p_item_id_tbl IN PO_TBL_NUMBER,
3057: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
3058: p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1,

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

3079:
3080: -- get default values from item
3081: -- first, default from item_id and ship_to_organization_id
3082: FORALL i IN 1..p_index_tbl.COUNT
3083: INSERT INTO po_session_gt(key, num1, char1, char2)
3084: SELECT p_key,
3085: p_index_tbl(i),
3086: outside_operation_flag,
3087: nvl(stock_enabled_flag,'N')

Line 3096: DELETE FROM po_session_gt

3092: AND organization_id = p_ship_to_org_id_tbl(i);
3093:
3094: d_position := 10;
3095:
3096: DELETE FROM po_session_gt
3097: WHERE key = p_key
3098: RETURNING num1, char1, char2 BULK COLLECT INTO
3099: l_index_tbl, l_outside_op_flag_tbl, l_stock_enabled_flag_tbl;
3100:

Line 3220: p_key IN po_session_gt.key%TYPE,

3216: --End of Comments
3217: ------------------------------------------------------------------------
3218: PROCEDURE default_secondary_unit_of_meas
3219: (
3220: p_key IN po_session_gt.key%TYPE,
3221: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3222: p_item_id_tbl IN PO_TBL_NUMBER,
3223: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
3224: x_secondary_unit_of_meas_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

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

3240: END IF;
3241:
3242: -- retrieve the default value from database
3243: FORALL i IN 1..p_index_tbl.COUNT
3244: INSERT INTO po_session_gt(key, num1, char1)
3245: SELECT p_key,
3246: p_index_tbl(i),
3247: uom.unit_of_measure
3248: FROM mtl_system_items item,

Line 3261: DELETE FROM po_session_gt

3257:
3258: d_position := 10;
3259:
3260: -- get result from temp table
3261: DELETE FROM po_session_gt
3262: WHERE key = p_key
3263: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
3264:
3265: d_position := 20;