DBA Data[Home] [Help]

APPS.PO_PDOI_ITEM_PROCESS_PVT dependencies on PO_TBL_VARCHAR1

Line 746: l_exist_in_ship_to_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

742: l_org_id_tbl PO_TBL_NUMBER;
743: l_item_id_tbl PO_TBL_NUMBER;
744:
745: -- flag to indicate whether item exists in some orgs
746: l_exist_in_ship_to_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
747: l_exist_in_master_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
748: l_exist_in_inv_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
749:
750: -- hashtable on item number

Line 747: l_exist_in_master_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

743: l_item_id_tbl PO_TBL_NUMBER;
744:
745: -- flag to indicate whether item exists in some orgs
746: l_exist_in_ship_to_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
747: l_exist_in_master_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
748: l_exist_in_inv_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
749:
750: -- hashtable on item number
751: TYPE item_ref_type IS TABLE OF NUMBER INDEX BY VARCHAR2(1000);

Line 748: l_exist_in_inv_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

744:
745: -- flag to indicate whether item exists in some orgs
746: l_exist_in_ship_to_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
747: l_exist_in_master_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
748: l_exist_in_inv_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
749:
750: -- hashtable on item number
751: TYPE item_ref_type IS TABLE OF NUMBER INDEX BY VARCHAR2(1000);
752: l_item_ref_tbl item_ref_type;

Line 988: l_column_name_tbl PO_TBL_VARCHAR100;

984: -- rows that return errors when creating items
985: l_error_index_tbl DBMS_SQL.NUMBER_TABLE;
986: l_table_name_tbl PO_TBL_VARCHAR30;
987: l_message_name_tbl PO_TBL_VARCHAR30;
988: l_column_name_tbl PO_TBL_VARCHAR100;
989: BEGIN
990: d_position := 0;
991:
992: IF (PO_LOG.d_proc) THEN