APPS.BOMPXINQ dependencies on INV_ORGHIERARCHY_PVT

Line 642: t_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;

638: bom_export_tab OUT NOCOPY bomexporttabtype,
639: Err_Msg OUT NOCOPY VARCHAR2,
640: Error_Code OUT NOCOPY NUMBER )
641: IS
642: t_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;
643: l_Org_hierarchy_name VARCHAR2(30);
644: l_assembly_item_id NUMBER;
645: l_organization_id NUMBER;
646: l_cst_type_id NUMBER;

Line 751: WHERE INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_ACCESS(Org_hierarchy_name)='Y'

747: if (Org_hierarchy_name is not null)
748: then
749: SELECT count (*) into l_org_count from
750: per_organization_structures
751: WHERE INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_ACCESS(Org_hierarchy_name)='Y'
752: AND name = Org_hierarchy_name;
753:
754: if (l_org_count <1 ) then
755: RAISE no_hierarchy;

Line 778: if (INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LEVEL_ACCESS(Org_hierarchy_name,

774: THEN
775: --dbms_output.put_line('Org Hierarachy is null ' );
776: t_org_code_list(1) := l_organization_id;
777: ELSE
778: if (INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LEVEL_ACCESS(Org_hierarchy_name,
779: l_organization_id)= 'Y') THEN
780: INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LIST (Org_hierarchy_name,
781: l_organization_id ,t_org_code_list);
782: else

Line 780: INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LIST (Org_hierarchy_name,

776: t_org_code_list(1) := l_organization_id;
777: ELSE
778: if (INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LEVEL_ACCESS(Org_hierarchy_name,
779: l_organization_id)= 'Y') THEN
780: INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LIST (Org_hierarchy_name,
781: l_organization_id ,t_org_code_list);
782: else
783: RAISE no_level_access;
784: end if;