DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on INV_ORGHIERARCHY_PVT

Line 1768: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;

1764: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
1765: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
1766: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
1767:
1768: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;
1769: l_org_hierarchy_level_id NUMBER;
1770: l_org_code VARCHAR2(3);
1771: l_org_id NUMBER;
1772: l_change_type_code VARCHAR2(80);

Line 1960: INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LIST(p_org_hierarchy_name,

1956: INTO l_org_hierarchy_level_id
1957: FROM org_organization_definitions
1958: WHERE organization_name = p_org_hierarchy_level;*/
1959:
1960: INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LIST(p_org_hierarchy_name,
1961: l_org_hierarchy_level_id,l_org_code_list);
1962:
1963:
1964: IF (l_org_code_list.COUNT = 0) THEN

Line 6205: , x_organizations_list OUT NOCOPY INV_OrgHierarchy_PVT.OrgID_tbl_type

6201: p_change_notice IN VARCHAR2
6202: , p_organization_id IN NUMBER
6203: , p_hierarchy_name IN VARCHAR2
6204: , p_local_organization_id IN NUMBER
6205: , x_organizations_list OUT NOCOPY INV_OrgHierarchy_PVT.OrgID_tbl_type
6206: , x_return_status OUT NOCOPY VARCHAR2
6207: ) IS
6208:
6209: CURSOR c_local_orgs IS

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

6241: x_organizations_list(2) := p_local_organization_id;
6242: ELSIF p_hierarchy_name IS NOT NULL
6243: THEN
6244: -- Fetch the list of organizations from hierarchy if specified
6245: Inv_OrgHierarchy_Pvt.Org_Hierarchy_List(p_hierarchy_name, p_organization_id, x_organizations_list);
6246: ELSE
6247: -- from eng_change_local_organizations for TTM
6248: -- The following APIs fetch the list of all organizations for which the user has access
6249: -- by responsibility and by business group.

Line 6309: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;

6305: ) IS
6306:
6307: l_plm_or_erp_flag VARCHAR2(3);
6308: l_org_hierarchy_level_id NUMBER;
6309: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;
6310:
6311: CURSOR c_organization_details IS
6312: SELECT MP.organization_id
6313: FROM HR_ORGANIZATION_UNITS HOU

Line 6428: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;

6424: ) IS
6425:
6426: l_org_hierarchy_level_id NUMBER;
6427: l_change_notice eng_engineering_changes.change_notice%TYPE;
6428: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;
6429:
6430: CURSOR c_change_details IS
6431: SELECT change_notice, organization_id
6432: FROM eng_engineering_changes