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 301: l_update_item_queue DBMS_SQL.NUMBER_TABLE;

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

Line 306: l_line_ref_tbl DBMS_SQL.NUMBER_TABLE;

302:
303: -- hashtable used in two places:
304: -- 1. remove duplicate po_line_ids in p_lines
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();

Line 344: l_num_tbl DBMS_SQL.NUMBER_TABLE;

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:
346: -- variables used in UOM processing
347: l_precision FND_CURRENCIES.precision%TYPE;
348: l_precision_tbl PO_PDOI_TYPES.varchar_index_tbl_type;

Line 352: l_update_loc_queue DBMS_SQL.NUMBER_TABLE;

348: l_precision_tbl PO_PDOI_TYPES.varchar_index_tbl_type;
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;

Line 356: l_uom_warning_queue DBMS_SQL.NUMBER_TABLE;

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;
358:
359: -- index of the po line for which description is changed;
360: -- we may need to update po_attribute_values_tlp_draft table

Line 357: l_price_limit_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;
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;

Line 361: l_update_desc_queue DBMS_SQL.NUMBER_TABLE;

357: l_price_limit_queue DBMS_SQL.NUMBER_TABLE;
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

Line 366: l_ip_cat_id_updated_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:
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; --

Line 1718: p_processing_row_tbl IN DBMS_SQL.NUMBER_TABLE,

1714: --End of Comments
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

Line 1836: p_processing_row_tbl IN DBMS_SQL.NUMBER_TABLE,

1832: --End of Comments
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

Line 5660: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

5656: --End of Comments
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: