DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on INV_ORGHIERARCHY_PVT

Line 1750: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;

1746: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
1747: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
1748: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
1749:
1750: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;
1751: l_org_hierarchy_level_id NUMBER;
1752: l_org_code VARCHAR2(3);
1753: l_org_id NUMBER;
1754: l_change_type_code VARCHAR2(80);

Line 1941: INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LIST(p_org_hierarchy_name,

1937: INTO l_org_hierarchy_level_id
1938: FROM org_organization_definitions
1939: WHERE organization_name = p_org_hierarchy_level;*/
1940:
1941: INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LIST(p_org_hierarchy_name,
1942: l_org_hierarchy_level_id,l_org_code_list);
1943:
1944:
1945: IF (l_org_code_list.COUNT = 0) THEN

Line 5732: , x_organizations_list OUT NOCOPY INV_OrgHierarchy_PVT.OrgID_tbl_type

5728: p_change_notice IN VARCHAR2
5729: , p_organization_id IN NUMBER
5730: , p_hierarchy_name IN VARCHAR2
5731: , p_local_organization_id IN NUMBER
5732: , x_organizations_list OUT NOCOPY INV_OrgHierarchy_PVT.OrgID_tbl_type
5733: , x_return_status OUT NOCOPY VARCHAR2
5734: ) IS
5735:
5736: CURSOR c_local_orgs IS

Line 5772: Inv_OrgHierarchy_Pvt.Org_Hierarchy_List(p_hierarchy_name, p_organization_id, x_organizations_list);

5768: x_organizations_list(2) := p_local_organization_id;
5769: ELSIF p_hierarchy_name IS NOT NULL
5770: THEN
5771: -- Fetch the list of organizations from hierarchy if specified
5772: Inv_OrgHierarchy_Pvt.Org_Hierarchy_List(p_hierarchy_name, p_organization_id, x_organizations_list);
5773: ELSE
5774: -- from eng_change_local_organizations for TTM
5775: -- The following APIs fetch the list of all organizations for which the user has access
5776: -- by responsibility and by business group.

Line 5836: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;

5832: ) IS
5833:
5834: l_plm_or_erp_flag VARCHAR2(3);
5835: l_org_hierarchy_level_id NUMBER;
5836: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;
5837:
5838: CURSOR c_organization_details IS
5839: SELECT MP.organization_id
5840: FROM HR_ORGANIZATION_UNITS HOU

Line 5955: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;

5951: ) IS
5952:
5953: l_org_hierarchy_level_id NUMBER;
5954: l_change_notice eng_engineering_changes.change_notice%TYPE;
5955: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;
5956:
5957: CURSOR c_change_details IS
5958: SELECT change_notice, organization_id
5959: FROM eng_engineering_changes