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 308: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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();
308: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
309: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
310:
311: -- tables containing existing values for updatable attrs
312: l_unit_of_measure_tbl PO_TBL_VARCHAR30;

Line 309: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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();
308: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
309: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
310:
311: -- tables containing existing values for updatable attrs
312: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
313: l_unit_price_tbl PO_TBL_NUMBER;

Line 322: l_negotiated_flag_tbl PO_TBL_VARCHAR1;

318: l_base_unit_price_tbl PO_TBL_NUMBER;
319: l_attribute14_tbl PO_TBL_VARCHAR2000;
320: l_amount_tbl PO_TBL_NUMBER;
321: l_price_limit_tbl PO_TBL_NUMBER;
322: l_negotiated_flag_tbl PO_TBL_VARCHAR1;
323: l_category_id_tbl PO_TBL_NUMBER;
324: l_ip_category_id_tbl PO_TBL_NUMBER;
325: l_orig_intf_line_id_tbl PO_TBL_NUMBER; -- bug5149827
326: -- need the item_id value in processing even thought

Line 330: l_allow_desc_update_tbl PO_TBL_VARCHAR1;

326: -- need the item_id value in processing even thought
327: -- it is not updatable
328: l_item_id_tbl PO_TBL_NUMBER;
329: -- values read from item table
330: l_allow_desc_update_tbl PO_TBL_VARCHAR1;
331:
332: -- variables to hold result from temp table
333: l_index_tbl PO_TBL_NUMBER;
334:

Line 1314: l_delete_flag_tbl PO_TBL_VARCHAR1;

1310: l_key po_session_gt.key%TYPE;
1311:
1312: l_change_loc_id_tbl PO_TBL_NUMBER;
1313: l_draft_id_tbl PO_TBL_NUMBER;
1314: l_delete_flag_tbl PO_TBL_VARCHAR1;
1315: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1316: BEGIN
1317: d_position := 0;
1318:

Line 1315: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

1311:
1312: l_change_loc_id_tbl PO_TBL_NUMBER;
1313: l_draft_id_tbl PO_TBL_NUMBER;
1314: l_delete_flag_tbl PO_TBL_VARCHAR1;
1315: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1316: BEGIN
1317: d_position := 0;
1318:
1319: IF (PO_LOG.d_proc) THEN

Line 1538: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

1534: l_key po_session_gt.key%TYPE;
1535:
1536: -- variables used to sync attr values rows from txn table
1537: -- to draft table
1538: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1539: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1540: BEGIN
1541: d_position := 0;
1542:

Line 1539: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

1535:
1536: -- variables used to sync attr values rows from txn table
1537: -- to draft table
1538: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1539: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1540: BEGIN
1541: d_position := 0;
1542:
1543: IF (PO_LOG.d_proc) THEN

Line 1656: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

1652: l_key po_session_gt.key%TYPE;
1653:
1654: -- variables used to sync attr values rows from txn table
1655: -- to draft table
1656: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1657: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1658: BEGIN
1659: d_position := 0;
1660:

Line 1657: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

1653:
1654: -- variables used to sync attr values rows from txn table
1655: -- to draft table
1656: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1657: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1658: BEGIN
1659: d_position := 0;
1660:
1661: IF (PO_LOG.d_proc) THEN

Line 5334: l_delete_flag_tbl PO_TBL_VARCHAR1;

5330:
5331: l_sync_attr_values_id_tbl PO_TBL_NUMBER;
5332: l_sync_attr_values_tlp_id_tbl PO_TBL_NUMBER;
5333: l_draft_id_tbl PO_TBL_NUMBER;
5334: l_delete_flag_tbl PO_TBL_VARCHAR1;
5335: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
5336: BEGIN
5337: d_position := 0;
5338:

Line 5335: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

5331: l_sync_attr_values_id_tbl PO_TBL_NUMBER;
5332: l_sync_attr_values_tlp_id_tbl PO_TBL_NUMBER;
5333: l_draft_id_tbl PO_TBL_NUMBER;
5334: l_delete_flag_tbl PO_TBL_VARCHAR1;
5335: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
5336: BEGIN
5337: d_position := 0;
5338:
5339: IF (PO_LOG.d_proc) THEN