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 DBMS_SQL

Line 59: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

55: );
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: --------------------------------------------------------------------------

Line 298: l_update_item_queue DBMS_SQL.NUMBER_TABLE;

294: l_uom_different VARCHAR2(1);
295: l_exceed_tolerance VARCHAR2(1);
296:
297: -- variable used to bulk update description in item master
298: l_update_item_queue DBMS_SQL.NUMBER_TABLE;
299:
300: -- hashtable used in two places:
301: -- 1. remove duplicate po_line_ids in p_lines
302: -- 2. store position of each row indexed by po_line_id

Line 303: l_line_ref_tbl DBMS_SQL.NUMBER_TABLE;

299:
300: -- hashtable used in two places:
301: -- 1. remove duplicate po_line_ids in p_lines
302: -- 2. store position of each row indexed by po_line_id
303: l_line_ref_tbl DBMS_SQL.NUMBER_TABLE;
304:
305: -- table to save distinct po_line_ids within the batch
306: l_po_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
307: l_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 336: l_num_tbl DBMS_SQL.NUMBER_TABLE;

332: -- variables to hold result from temp table
333: l_index_tbl PO_TBL_NUMBER;
334:
335: -- ordered num list
336: l_num_tbl DBMS_SQL.NUMBER_TABLE;
337:
338: -- variables used in UOM processing
339: l_precision FND_CURRENCIES.precision%TYPE;
340: l_precision_tbl PO_PDOI_TYPES.varchar_index_tbl_type;

Line 344: l_update_loc_queue DBMS_SQL.NUMBER_TABLE;

340: l_precision_tbl PO_PDOI_TYPES.varchar_index_tbl_type;
341: l_uom_rate NUMBER;
342:
343: -- location lines that need to be updated
344: l_update_loc_queue DBMS_SQL.NUMBER_TABLE;
345: l_change_loc_id_tbl PO_TBL_NUMBER;
346:
347: -- lines for which uom warning needs to be given
348: l_uom_warning_queue DBMS_SQL.NUMBER_TABLE;

Line 348: l_uom_warning_queue DBMS_SQL.NUMBER_TABLE;

344: l_update_loc_queue DBMS_SQL.NUMBER_TABLE;
345: l_change_loc_id_tbl PO_TBL_NUMBER;
346:
347: -- lines for which uom warning needs to be given
348: l_uom_warning_queue DBMS_SQL.NUMBER_TABLE;
349: l_price_limit_queue DBMS_SQL.NUMBER_TABLE;
350:
351: -- index of the po line for which description is changed;
352: -- we may need to update po_attribute_values_tlp_draft table

Line 349: l_price_limit_queue DBMS_SQL.NUMBER_TABLE;

345: l_change_loc_id_tbl PO_TBL_NUMBER;
346:
347: -- lines for which uom warning needs to be given
348: l_uom_warning_queue DBMS_SQL.NUMBER_TABLE;
349: l_price_limit_queue DBMS_SQL.NUMBER_TABLE;
350:
351: -- index of the po line for which description is changed;
352: -- we may need to update po_attribute_values_tlp_draft table
353: l_update_desc_queue DBMS_SQL.NUMBER_TABLE;

Line 353: l_update_desc_queue DBMS_SQL.NUMBER_TABLE;

349: l_price_limit_queue DBMS_SQL.NUMBER_TABLE;
350:
351: -- index of the po line for which description is changed;
352: -- we may need to update po_attribute_values_tlp_draft table
353: l_update_desc_queue DBMS_SQL.NUMBER_TABLE;
354: l_sync_attr_tlp_id_tbl PO_TBL_NUMBER;
355:
356: -- lines for which we need to null out the cat based attribute values
357: l_ip_cat_id_updated_queue DBMS_SQL.NUMBER_TABLE;

Line 357: l_ip_cat_id_updated_queue DBMS_SQL.NUMBER_TABLE;

353: l_update_desc_queue DBMS_SQL.NUMBER_TABLE;
354: l_sync_attr_tlp_id_tbl PO_TBL_NUMBER;
355:
356: -- lines for which we need to null out the cat based attribute values
357: l_ip_cat_id_updated_queue DBMS_SQL.NUMBER_TABLE;
358:
359: -- variables to hold results from INV's API call
360: l_inventory_item_id NUMBER;
361: l_organization_id NUMBER;

Line 1524: p_processing_row_tbl IN DBMS_SQL.NUMBER_TABLE,

1520: --End of Comments
1521: ------------------------------------------------------------------------
1522: PROCEDURE merge_attr_values
1523: (
1524: p_processing_row_tbl IN DBMS_SQL.NUMBER_TABLE,
1525: p_sync_attr_id_tbl IN PO_TBL_NUMBER,
1526: p_sync_draft_id_tbl IN PO_TBL_NUMBER,
1527: p_attr_values IN PO_PDOI_TYPES.attr_values_rec_type
1528: ) IS

Line 1642: p_processing_row_tbl IN DBMS_SQL.NUMBER_TABLE,

1638: --End of Comments
1639: ------------------------------------------------------------------------
1640: PROCEDURE merge_attr_values_tlp
1641: (
1642: p_processing_row_tbl IN DBMS_SQL.NUMBER_TABLE,
1643: p_sync_attr_tlp_id_tbl IN PO_TBL_NUMBER,
1644: p_sync_draft_id_tbl IN PO_TBL_NUMBER,
1645: p_attr_values_tlp IN PO_PDOI_TYPES.attr_values_tlp_rec_type
1646: ) IS

Line 5320: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

5316: --End of Comments
5317: ------------------------------------------------------------------------
5318: PROCEDURE reset_cat_attributes
5319: (
5320: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5321: p_po_line_id_tbl IN PO_TBL_NUMBER,
5322: p_draft_id_tbl IN PO_TBL_NUMBER
5323: ) IS
5324: