APPS.BOMPXINQ dependencies on INV_ORGHIERARCHY_PVT

Line 686: t_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;

682: bom_export_tab OUT NOCOPY bomexporttabtype,
683: Err_Msg OUT NOCOPY VARCHAR2,
684: Error_Code OUT NOCOPY NUMBER )
685: IS
686: t_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;
687: l_Org_hierarchy_name VARCHAR2(30);
688: l_assembly_item_id NUMBER;
689: l_organization_id NUMBER;
690: l_cst_type_id NUMBER;

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

791: if (Org_hierarchy_name is not null)
792: then
793: SELECT count (*) into l_org_count from
794: per_organization_structures
795: WHERE INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_ACCESS(Org_hierarchy_name)='Y'
796: AND name = Org_hierarchy_name;
797:
798: if (l_org_count <1 ) then
799: RAISE no_hierarchy;

Line 822: if (INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LEVEL_ACCESS(Org_hierarchy_name,

818: THEN
819: --dbms_output.put_line('Org Hierarachy is null ' );
820: t_org_code_list(1) := l_organization_id;
821: ELSE
822: if (INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LEVEL_ACCESS(Org_hierarchy_name,
823: l_organization_id)= 'Y') THEN
824: INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LIST (Org_hierarchy_name,
825: l_organization_id ,t_org_code_list);
826: else

Line 824: INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LIST (Org_hierarchy_name,

820: t_org_code_list(1) := l_organization_id;
821: ELSE
822: if (INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LEVEL_ACCESS(Org_hierarchy_name,
823: l_organization_id)= 'Y') THEN
824: INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LIST (Org_hierarchy_name,
825: l_organization_id ,t_org_code_list);
826: else
827: RAISE no_level_access;
828: end if;