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_VARCHAR1

Line 311: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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
315: l_unit_of_measure_tbl PO_TBL_VARCHAR30;

Line 312: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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
315: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
316: l_unit_price_tbl PO_TBL_NUMBER;

Line 325: l_negotiated_flag_tbl PO_TBL_VARCHAR1;

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
329: -- Bug 13506679

Line 338: l_allow_desc_update_tbl PO_TBL_VARCHAR1;

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
341: l_index_tbl PO_TBL_NUMBER;
342:

Line 1508: l_delete_flag_tbl PO_TBL_VARCHAR1;

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;
1512:

Line 1509: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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;
1512:
1513: IF (PO_LOG.d_proc) THEN

Line 1732: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

1728: l_key po_session_gt.key%TYPE;
1729:
1730: -- variables used to sync attr values rows from txn table
1731: -- to draft table
1732: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1733: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1734: BEGIN
1735: d_position := 0;
1736:

Line 1733: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

1729:
1730: -- variables used to sync attr values rows from txn table
1731: -- to draft table
1732: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1733: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1734: BEGIN
1735: d_position := 0;
1736:
1737: IF (PO_LOG.d_proc) THEN

Line 1850: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

1846: l_key po_session_gt.key%TYPE;
1847:
1848: -- variables used to sync attr values rows from txn table
1849: -- to draft table
1850: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1851: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1852: BEGIN
1853: d_position := 0;
1854:

Line 1851: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

1847:
1848: -- variables used to sync attr values rows from txn table
1849: -- to draft table
1850: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1851: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1852: BEGIN
1853: d_position := 0;
1854:
1855: IF (PO_LOG.d_proc) THEN

Line 5674: l_delete_flag_tbl PO_TBL_VARCHAR1;

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;
5678:

Line 5675: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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;
5678:
5679: IF (PO_LOG.d_proc) THEN