APPS.INV_COPY_ORGANIZATION_REPORT dependencies on BOM_DEPARTMENT_CLASSES

Line 968: Init_Vars('BOM_DEPARTMENT_CLASSES');

964: Init_Vars('CST_RESOURCE_OVERHEAD');
965: g_entity_names := Get_Err_Cst_Res_Ovhds;
966: Put_Report_Data;
967:
968: Init_Vars('BOM_DEPARTMENT_CLASSES');
969: g_entity_names := Get_Err_Bom_Dept_Classes;
970: Put_Report_Data;
971:
972: Init_Vars('STANDARD_OPERATIONS');

Line 1398: -- DESCRIPTION : Validate bom department classes created for new org against

1394:
1395: --=============================================================================
1396: -- FUNCTION NAME : Get_Err_Bom_Dept_Classes
1397: -- PRE-CONDITIONS: None.
1398: -- DESCRIPTION : Validate bom department classes created for new org against
1399: -- those in model org.
1400: -- PARAMETERS :
1401: -- EXCEPTIONS : None.
1402: --

Line 1419: FROM BOM_DEPARTMENT_CLASSES bdc1

1415: , p_organization_id NUMBER
1416: )
1417: IS
1418: SELECT bdc1.DEPARTMENT_CLASS_CODE
1419: FROM BOM_DEPARTMENT_CLASSES bdc1
1420: WHERE bdc1.ORGANIZATION_ID = p_model_org_id
1421: AND NOT EXISTS
1422: ( SELECT 'x'
1423: FROM BOM_DEPARTMENT_CLASSES bdc2

Line 1423: FROM BOM_DEPARTMENT_CLASSES bdc2

1419: FROM BOM_DEPARTMENT_CLASSES bdc1
1420: WHERE bdc1.ORGANIZATION_ID = p_model_org_id
1421: AND NOT EXISTS
1422: ( SELECT 'x'
1423: FROM BOM_DEPARTMENT_CLASSES bdc2
1424: WHERE bdc2.ORGANIZATION_ID = p_organization_id
1425: AND bdc2.DEPARTMENT_CLASS_CODE = bdc1.DEPARTMENT_CLASS_CODE
1426: );
1427:

Line 1431: FROM BOM_DEPARTMENT_CLASSES ent

1427:
1428: CURSOR l_cnt_csr ( p_org_id NUMBER )
1429: IS
1430: SELECT COUNT(ent.DEPARTMENT_CLASS_CODE)
1431: FROM BOM_DEPARTMENT_CLASSES ent
1432: WHERE ent.ORGANIZATION_ID = p_org_id;
1433:
1434: BEGIN
1435: