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_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_TBL_NUMBER

Line 60: p_po_line_id_tbl IN PO_TBL_NUMBER,

56:
57: PROCEDURE reset_cat_attributes
58: (
59: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
60: p_po_line_id_tbl IN PO_TBL_NUMBER,
61: p_draft_id_tbl IN PO_TBL_NUMBER
62: );
63: --------------------------------------------------------------------------
64: ---------------------- PUBLIC PROCEDURES ---------------------------------

Line 61: p_draft_id_tbl IN PO_TBL_NUMBER

57: PROCEDURE reset_cat_attributes
58: (
59: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
60: p_po_line_id_tbl IN PO_TBL_NUMBER,
61: p_draft_id_tbl IN PO_TBL_NUMBER
62: );
63: --------------------------------------------------------------------------
64: ---------------------- PUBLIC PROCEDURES ---------------------------------
65: --------------------------------------------------------------------------

Line 309: l_po_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

305: -- 2. store position of each row indexed by po_line_id
306: l_line_ref_tbl DBMS_SQL.NUMBER_TABLE;
307:
308: -- table to save distinct po_line_ids within the batch
309: l_po_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
310: l_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
311: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
312: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
313:

Line 310: l_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

306: l_line_ref_tbl DBMS_SQL.NUMBER_TABLE;
307:
308: -- table to save distinct po_line_ids within the batch
309: l_po_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
310: l_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
311: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
312: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
313:
314: -- tables containing existing values for updatable attrs

Line 316: l_unit_price_tbl PO_TBL_NUMBER;

312: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
313:
314: -- tables containing existing values for updatable attrs
315: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
316: l_unit_price_tbl PO_TBL_NUMBER;
317: l_item_desc_tbl PO_TBL_VARCHAR2000;
318: l_expiration_date_tbl PO_TBL_DATE;
319: l_retroactive_date_tbl PO_TBL_DATE;
320: l_price_break_lookup_code_tbl PO_TBL_VARCHAR30;

Line 321: l_base_unit_price_tbl PO_TBL_NUMBER;

317: l_item_desc_tbl PO_TBL_VARCHAR2000;
318: l_expiration_date_tbl PO_TBL_DATE;
319: l_retroactive_date_tbl PO_TBL_DATE;
320: l_price_break_lookup_code_tbl PO_TBL_VARCHAR30;
321: l_base_unit_price_tbl PO_TBL_NUMBER;
322: l_attribute14_tbl PO_TBL_VARCHAR2000;
323: l_amount_tbl PO_TBL_NUMBER;
324: l_price_limit_tbl PO_TBL_NUMBER;
325: l_negotiated_flag_tbl PO_TBL_VARCHAR1;

Line 323: l_amount_tbl PO_TBL_NUMBER;

319: l_retroactive_date_tbl PO_TBL_DATE;
320: l_price_break_lookup_code_tbl PO_TBL_VARCHAR30;
321: l_base_unit_price_tbl PO_TBL_NUMBER;
322: l_attribute14_tbl PO_TBL_VARCHAR2000;
323: l_amount_tbl PO_TBL_NUMBER;
324: l_price_limit_tbl PO_TBL_NUMBER;
325: l_negotiated_flag_tbl PO_TBL_VARCHAR1;
326: l_category_id_tbl PO_TBL_NUMBER;
327: l_ip_category_id_tbl PO_TBL_NUMBER;

Line 324: l_price_limit_tbl PO_TBL_NUMBER;

320: l_price_break_lookup_code_tbl PO_TBL_VARCHAR30;
321: l_base_unit_price_tbl PO_TBL_NUMBER;
322: l_attribute14_tbl PO_TBL_VARCHAR2000;
323: l_amount_tbl PO_TBL_NUMBER;
324: l_price_limit_tbl PO_TBL_NUMBER;
325: l_negotiated_flag_tbl PO_TBL_VARCHAR1;
326: l_category_id_tbl PO_TBL_NUMBER;
327: l_ip_category_id_tbl PO_TBL_NUMBER;
328: l_orig_intf_line_id_tbl PO_TBL_NUMBER; -- bug5149827

Line 326: l_category_id_tbl PO_TBL_NUMBER;

322: l_attribute14_tbl PO_TBL_VARCHAR2000;
323: l_amount_tbl PO_TBL_NUMBER;
324: l_price_limit_tbl PO_TBL_NUMBER;
325: l_negotiated_flag_tbl PO_TBL_VARCHAR1;
326: l_category_id_tbl PO_TBL_NUMBER;
327: l_ip_category_id_tbl PO_TBL_NUMBER;
328: l_orig_intf_line_id_tbl PO_TBL_NUMBER; -- bug5149827
329: -- Bug 13506679
330: l_un_number_id_tbl PO_TBL_NUMBER;

Line 327: l_ip_category_id_tbl PO_TBL_NUMBER;

323: l_amount_tbl PO_TBL_NUMBER;
324: l_price_limit_tbl PO_TBL_NUMBER;
325: l_negotiated_flag_tbl PO_TBL_VARCHAR1;
326: l_category_id_tbl PO_TBL_NUMBER;
327: l_ip_category_id_tbl PO_TBL_NUMBER;
328: l_orig_intf_line_id_tbl PO_TBL_NUMBER; -- bug5149827
329: -- Bug 13506679
330: l_un_number_id_tbl PO_TBL_NUMBER;
331: l_hazard_class_id_tbl PO_TBL_NUMBER;

Line 328: l_orig_intf_line_id_tbl PO_TBL_NUMBER; -- bug5149827

324: l_price_limit_tbl PO_TBL_NUMBER;
325: l_negotiated_flag_tbl PO_TBL_VARCHAR1;
326: l_category_id_tbl PO_TBL_NUMBER;
327: l_ip_category_id_tbl PO_TBL_NUMBER;
328: l_orig_intf_line_id_tbl PO_TBL_NUMBER; -- bug5149827
329: -- Bug 13506679
330: l_un_number_id_tbl PO_TBL_NUMBER;
331: l_hazard_class_id_tbl PO_TBL_NUMBER;
332: -- Bug 13506679

Line 330: l_un_number_id_tbl PO_TBL_NUMBER;

326: l_category_id_tbl PO_TBL_NUMBER;
327: l_ip_category_id_tbl PO_TBL_NUMBER;
328: l_orig_intf_line_id_tbl PO_TBL_NUMBER; -- bug5149827
329: -- Bug 13506679
330: l_un_number_id_tbl PO_TBL_NUMBER;
331: l_hazard_class_id_tbl PO_TBL_NUMBER;
332: -- Bug 13506679
333:
334: -- need the item_id value in processing even thought

Line 331: l_hazard_class_id_tbl PO_TBL_NUMBER;

327: l_ip_category_id_tbl PO_TBL_NUMBER;
328: l_orig_intf_line_id_tbl PO_TBL_NUMBER; -- bug5149827
329: -- Bug 13506679
330: l_un_number_id_tbl PO_TBL_NUMBER;
331: l_hazard_class_id_tbl PO_TBL_NUMBER;
332: -- Bug 13506679
333:
334: -- need the item_id value in processing even thought
335: -- it is not updatable

Line 336: l_item_id_tbl PO_TBL_NUMBER;

332: -- Bug 13506679
333:
334: -- need the item_id value in processing even thought
335: -- it is not updatable
336: l_item_id_tbl PO_TBL_NUMBER;
337: -- values read from item table
338: l_allow_desc_update_tbl PO_TBL_VARCHAR1;
339:
340: -- variables to hold result from temp table

Line 341: l_index_tbl PO_TBL_NUMBER;

337: -- values read from item table
338: l_allow_desc_update_tbl PO_TBL_VARCHAR1;
339:
340: -- variables to hold result from temp table
341: l_index_tbl PO_TBL_NUMBER;
342:
343: -- ordered num list
344: l_num_tbl DBMS_SQL.NUMBER_TABLE;
345:

Line 353: l_change_loc_id_tbl PO_TBL_NUMBER;

349: l_uom_rate NUMBER;
350:
351: -- location lines that need to be updated
352: l_update_loc_queue DBMS_SQL.NUMBER_TABLE;
353: l_change_loc_id_tbl PO_TBL_NUMBER;
354:
355: -- lines for which uom warning needs to be given
356: l_uom_warning_queue DBMS_SQL.NUMBER_TABLE;
357: l_price_limit_queue DBMS_SQL.NUMBER_TABLE;

Line 362: l_sync_attr_tlp_id_tbl PO_TBL_NUMBER;

358:
359: -- index of the po line for which description is changed;
360: -- we may need to update po_attribute_values_tlp_draft table
361: l_update_desc_queue DBMS_SQL.NUMBER_TABLE;
362: l_sync_attr_tlp_id_tbl PO_TBL_NUMBER;
363: l_sync_attr_id_tbl PO_TBL_NUMBER; --
364:
365: -- lines for which we need to null out the cat based attribute values
366: l_ip_cat_id_updated_queue DBMS_SQL.NUMBER_TABLE;

Line 363: l_sync_attr_id_tbl PO_TBL_NUMBER; --

359: -- index of the po line for which description is changed;
360: -- we may need to update po_attribute_values_tlp_draft table
361: l_update_desc_queue DBMS_SQL.NUMBER_TABLE;
362: l_sync_attr_tlp_id_tbl PO_TBL_NUMBER;
363: l_sync_attr_id_tbl PO_TBL_NUMBER; --
364:
365: -- lines for which we need to null out the cat based attribute values
366: l_ip_cat_id_updated_queue DBMS_SQL.NUMBER_TABLE;
367:

Line 369: l_modified_ip_cat_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER(); --

365: -- lines for which we need to null out the cat based attribute values
366: l_ip_cat_id_updated_queue DBMS_SQL.NUMBER_TABLE;
367:
368: -- table of modified ip_category_id. The index for this table is record number
369: l_modified_ip_cat_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER(); --
370: l_modified_ip_cat_id_tbl_tmp PO_TBL_NUMBER; --
371:
372: -- variables to hold results from INV's API call
373: l_inventory_item_id NUMBER;

Line 370: l_modified_ip_cat_id_tbl_tmp PO_TBL_NUMBER; --

366: l_ip_cat_id_updated_queue DBMS_SQL.NUMBER_TABLE;
367:
368: -- table of modified ip_category_id. The index for this table is record number
369: l_modified_ip_cat_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER(); --
370: l_modified_ip_cat_id_tbl_tmp PO_TBL_NUMBER; --
371:
372: -- variables to hold results from INV's API call
373: l_inventory_item_id NUMBER;
374: l_organization_id NUMBER;

Line 1506: l_change_loc_id_tbl PO_TBL_NUMBER;

1502: d_position NUMBER;
1503:
1504: l_key po_session_gt.key%TYPE;
1505:
1506: l_change_loc_id_tbl PO_TBL_NUMBER;
1507: l_draft_id_tbl PO_TBL_NUMBER;
1508: l_delete_flag_tbl PO_TBL_VARCHAR1;
1509: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1510: BEGIN

Line 1507: l_draft_id_tbl PO_TBL_NUMBER;

1503:
1504: l_key po_session_gt.key%TYPE;
1505:
1506: l_change_loc_id_tbl PO_TBL_NUMBER;
1507: l_draft_id_tbl PO_TBL_NUMBER;
1508: l_delete_flag_tbl PO_TBL_VARCHAR1;
1509: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1510: BEGIN
1511: d_position := 0;

Line 1719: p_sync_attr_id_tbl IN PO_TBL_NUMBER,

1715: ------------------------------------------------------------------------
1716: PROCEDURE merge_attr_values
1717: (
1718: p_processing_row_tbl IN DBMS_SQL.NUMBER_TABLE,
1719: p_sync_attr_id_tbl IN PO_TBL_NUMBER,
1720: p_sync_draft_id_tbl IN PO_TBL_NUMBER,
1721: p_attr_values IN PO_PDOI_TYPES.attr_values_rec_type
1722: ) IS
1723:

Line 1720: p_sync_draft_id_tbl IN PO_TBL_NUMBER,

1716: PROCEDURE merge_attr_values
1717: (
1718: p_processing_row_tbl IN DBMS_SQL.NUMBER_TABLE,
1719: p_sync_attr_id_tbl IN PO_TBL_NUMBER,
1720: p_sync_draft_id_tbl IN PO_TBL_NUMBER,
1721: p_attr_values IN PO_PDOI_TYPES.attr_values_rec_type
1722: ) IS
1723:
1724: d_api_name CONSTANT VARCHAR2(30) := 'merge_attr_values';

Line 1837: p_sync_attr_tlp_id_tbl IN PO_TBL_NUMBER,

1833: ------------------------------------------------------------------------
1834: PROCEDURE merge_attr_values_tlp
1835: (
1836: p_processing_row_tbl IN DBMS_SQL.NUMBER_TABLE,
1837: p_sync_attr_tlp_id_tbl IN PO_TBL_NUMBER,
1838: p_sync_draft_id_tbl IN PO_TBL_NUMBER,
1839: p_attr_values_tlp IN PO_PDOI_TYPES.attr_values_tlp_rec_type
1840: ) IS
1841:

Line 1838: p_sync_draft_id_tbl IN PO_TBL_NUMBER,

1834: PROCEDURE merge_attr_values_tlp
1835: (
1836: p_processing_row_tbl IN DBMS_SQL.NUMBER_TABLE,
1837: p_sync_attr_tlp_id_tbl IN PO_TBL_NUMBER,
1838: p_sync_draft_id_tbl IN PO_TBL_NUMBER,
1839: p_attr_values_tlp IN PO_PDOI_TYPES.attr_values_tlp_rec_type
1840: ) IS
1841:
1842: d_api_name CONSTANT VARCHAR2(30) := 'merge_attr_values_tlp';

Line 1961: l_valid_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1957: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_headers_draft_all';
1958: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1959: d_position NUMBER;
1960:
1961: l_valid_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1962: l_count NUMBER;
1963: BEGIN
1964: d_position := 0;
1965:

Line 2506: l_valid_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

2502: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2503: d_position NUMBER;
2504:
2505: -- variables used to print debug message
2506: l_valid_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
2507: l_count NUMBER := 0;
2508: BEGIN
2509: d_position := 0;
2510:

Line 2782: l_valid_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

2778: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2779: d_position NUMBER;
2780:
2781: -- variables used to print debug message
2782: l_valid_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
2783: l_count NUMBER := 0;
2784: BEGIN
2785: d_position := 0;
2786:

Line 3130: l_valid_intf_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

3126: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3127: d_position NUMBER;
3128:
3129: -- variables used to print debug message
3130: l_valid_intf_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3131: l_count NUMBER := 0;
3132: BEGIN
3133: d_position := 0;
3134:

Line 3424: l_valid_intf_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

3420: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3421: d_position NUMBER;
3422:
3423: -- variables used to print debug message
3424: l_valid_intf_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3425: l_count NUMBER := 0;
3426: BEGIN
3427: d_position := 0;
3428:

Line 5661: p_po_line_id_tbl IN PO_TBL_NUMBER,

5657: ------------------------------------------------------------------------
5658: PROCEDURE reset_cat_attributes
5659: (
5660: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5661: p_po_line_id_tbl IN PO_TBL_NUMBER,
5662: p_draft_id_tbl IN PO_TBL_NUMBER
5663: ) IS
5664:
5665: d_api_name CONSTANT VARCHAR2(30) := 'reset_cat_attributes';

Line 5662: p_draft_id_tbl IN PO_TBL_NUMBER

5658: PROCEDURE reset_cat_attributes
5659: (
5660: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5661: p_po_line_id_tbl IN PO_TBL_NUMBER,
5662: p_draft_id_tbl IN PO_TBL_NUMBER
5663: ) IS
5664:
5665: d_api_name CONSTANT VARCHAR2(30) := 'reset_cat_attributes';
5666: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5671: l_sync_attr_values_id_tbl PO_TBL_NUMBER;

5667: d_position NUMBER;
5668:
5669: l_key po_session_gt.key%TYPE;
5670:
5671: l_sync_attr_values_id_tbl PO_TBL_NUMBER;
5672: l_sync_attr_values_tlp_id_tbl PO_TBL_NUMBER;
5673: l_draft_id_tbl PO_TBL_NUMBER;
5674: l_delete_flag_tbl PO_TBL_VARCHAR1;
5675: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

Line 5672: l_sync_attr_values_tlp_id_tbl PO_TBL_NUMBER;

5668:
5669: l_key po_session_gt.key%TYPE;
5670:
5671: l_sync_attr_values_id_tbl PO_TBL_NUMBER;
5672: l_sync_attr_values_tlp_id_tbl PO_TBL_NUMBER;
5673: l_draft_id_tbl PO_TBL_NUMBER;
5674: l_delete_flag_tbl PO_TBL_VARCHAR1;
5675: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
5676: BEGIN

Line 5673: l_draft_id_tbl PO_TBL_NUMBER;

5669: l_key po_session_gt.key%TYPE;
5670:
5671: l_sync_attr_values_id_tbl PO_TBL_NUMBER;
5672: l_sync_attr_values_tlp_id_tbl PO_TBL_NUMBER;
5673: l_draft_id_tbl PO_TBL_NUMBER;
5674: l_delete_flag_tbl PO_TBL_VARCHAR1;
5675: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
5676: BEGIN
5677: d_position := 0;