DBA Data[Home] [Help]

APPS.PO_PDOI_ITEM_PROCESS_PVT dependencies on PO_TBL_VARCHAR1

Line 747: l_exist_in_ship_to_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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

Line 748: l_exist_in_master_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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

Line 749: l_exist_in_inv_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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

Line 989: l_column_name_tbl PO_TBL_VARCHAR100;

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