DBA Data[Home] [Help]

APPS.BOMPCMBM dependencies on INV_ORGHIERARCHY_PVT

Line 133: t_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;

129: common_org_to IN NUMBER DEFAULT NULL,
130: common_item_to IN NUMBER DEFAULT NULL
131: , enable_attrs_update IN VARCHAR2
132: ) IS
133: t_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;
134: l_org_name VARCHAR2(60) ;
135: common_item_from_name VARCHAR2(200) ;
136: common_item_to_name VARCHAR2(200) ;
137: common_org_to_code VARCHAR2(4) ;

Line 262: INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LIST(org_hierarchy,current_org_id,t_org_code_list) ;

258: SELECT organization_name
259: INTO l_org_name
260: FROM org_organization_definitions
261: WHERE organization_id = current_org_id;
262: INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LIST(org_hierarchy,current_org_id,t_org_code_list) ;
263: ELSIF ( scope = 3 ) THEN
264: starting_org_counter := 1 ;
265: -- bug:4931463 Modified below cursor query to reduce shared memory
266: for C1 in (