eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_COPY_ORGANIZATION_REPORT dependencies on BOM_DEPARTMENTS

Line 948: Init_Vars('BOM_DEPARTMENTS');

944: ---- Routings -------
945: -----------------------------------*/
946: IF g_copy_routings = 'Y'
947: THEN
948: Init_Vars('BOM_DEPARTMENTS');
949: g_entity_names := Get_Err_Bom_Departments;
950: Put_Report_Data;
951:
952: Init_Vars('BOM_DEPARTMENT_RESOURCES');

Line 949: g_entity_names := Get_Err_Bom_Departments;

945: -----------------------------------*/
946: IF g_copy_routings = 'Y'
947: THEN
948: Init_Vars('BOM_DEPARTMENTS');
949: g_entity_names := Get_Err_Bom_Departments;
950: Put_Report_Data;
951:
952: Init_Vars('BOM_DEPARTMENT_RESOURCES');
953: g_entity_names := Get_Err_Bom_Dept_Res;

Line 1311: -- FUNCTION NAME : Get_Err_Bom_Departments

1307: RAISE;
1308:
1309: END Get_Err_Bom_Resources;
1310: --=============================================================================
1311: -- FUNCTION NAME : Get_Err_Bom_Departments
1312: -- PRE-CONDITIONS: None.
1313: -- DESCRIPTION : Validate bom departments created for new org against
1314: -- those in model org.
1315: -- PARAMETERS : None.

Line 1313: -- DESCRIPTION : Validate bom departments created for new org against

1309: END Get_Err_Bom_Resources;
1310: --=============================================================================
1311: -- FUNCTION NAME : Get_Err_Bom_Departments
1312: -- PRE-CONDITIONS: None.
1313: -- DESCRIPTION : Validate bom departments created for new org against
1314: -- those in model org.
1315: -- PARAMETERS : None.
1316: -- EXCEPTIONS : None.
1317: --

Line 1319: FUNCTION Get_Err_Bom_Departments RETURN Char_Array

1315: -- PARAMETERS : None.
1316: -- EXCEPTIONS : None.
1317: --
1318: --=============================================================================
1319: FUNCTION Get_Err_Bom_Departments RETURN Char_Array
1320: IS
1321: l_api_name VARCHAR2(100):= ' Get_Err_Bom_Departments ';
1322: l_model_org_count NUMBER;
1323: l_new_org_count NUMBER;

Line 1321: l_api_name VARCHAR2(100):= ' Get_Err_Bom_Departments ';

1317: --
1318: --=============================================================================
1319: FUNCTION Get_Err_Bom_Departments RETURN Char_Array
1320: IS
1321: l_api_name VARCHAR2(100):= ' Get_Err_Bom_Departments ';
1322: l_model_org_count NUMBER;
1323: l_new_org_count NUMBER;
1324: l_entity_names Char_Array := Char_Array();
1325: l_entity_arr_idx NUMBER := 1;

Line 1334: FROM BOM_DEPARTMENTS bd1

1330: , p_organization_id NUMBER
1331: )
1332: IS
1333: SELECT bd1.DEPARTMENT_CODE
1334: FROM BOM_DEPARTMENTS bd1
1335: WHERE bd1.ORGANIZATION_ID = p_model_org_id
1336: AND NOT EXISTS ( SELECT 'x'
1337: FROM BOM_DEPARTMENTS bd2
1338: WHERE bd2.ORGANIZATION_ID=p_organization_id

Line 1337: FROM BOM_DEPARTMENTS bd2

1333: SELECT bd1.DEPARTMENT_CODE
1334: FROM BOM_DEPARTMENTS bd1
1335: WHERE bd1.ORGANIZATION_ID = p_model_org_id
1336: AND NOT EXISTS ( SELECT 'x'
1337: FROM BOM_DEPARTMENTS bd2
1338: WHERE bd2.ORGANIZATION_ID=p_organization_id
1339: AND bd2.DEPARTMENT_CODE=bd1.DEPARTMENT_CODE
1340: );
1341:

Line 1345: FROM BOM_DEPARTMENTS bd

1341:
1342: CURSOR l_cnt_csr ( p_org_id NUMBER )
1343: IS
1344: SELECT COUNT(bd.DEPARTMENT_CODE)
1345: FROM BOM_DEPARTMENTS bd
1346: WHERE bd.ORGANIZATION_ID = p_org_id;
1347:
1348: BEGIN
1349:

Line 1354: , '> Get_Err_Bom_Departments'

1350: IF G_DEBUG = 'Y' THEN
1351: FND_MSG_PUB.ADD_EXC_MSG
1352: ( G_PKG_NAME
1353: , l_api_name
1354: , '> Get_Err_Bom_Departments'
1355: );
1356: END IF;
1357:
1358: OPEN l_cnt_csr ( g_model_org_id );

Line 1393: END Get_Err_Bom_Departments;

1389: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1390: FND_MSG_PUB.Add;
1391: RAISE;
1392:
1393: END Get_Err_Bom_Departments;
1394:
1395: --=============================================================================
1396: -- FUNCTION NAME : Get_Err_Bom_Dept_Classes
1397: -- PRE-CONDITIONS: None.

Line 3537: , BOM_DEPARTMENTS bd

3533: )
3534: IS
3535: SELECT bd.DEPARTMENT_CODE, br.RESOURCE_CODE
3536: FROM BOM_DEPARTMENT_RESOURCES ent
3537: , BOM_DEPARTMENTS bd
3538: , BOM_RESOURCES br
3539: WHERE br.RESOURCE_ID = ent.RESOURCE_ID
3540: AND ent.RESOURCE_ID IN ( SELECT br.RESOURCE_ID
3541: FROM BOM_RESOURCES br

Line 3546: FROM BOM_DEPARTMENTS bd

3542: WHERE br.ORGANIZATION_ID=p_model_org_id
3543: )
3544: AND bd.DEPARTMENT_ID = ent.DEPARTMENT_ID
3545: AND ent.DEPARTMENT_ID IN ( SELECT bd.DEPARTMENT_ID
3546: FROM BOM_DEPARTMENTS bd
3547: WHERE bd.ORGANIZATION_ID=p_model_org_id
3548: )
3549: MINUS
3550: SELECT bd.DEPARTMENT_CODE, br.RESOURCE_CODE

Line 3552: , BOM_DEPARTMENTS bd

3548: )
3549: MINUS
3550: SELECT bd.DEPARTMENT_CODE, br.RESOURCE_CODE
3551: FROM BOM_DEPARTMENT_RESOURCES ent
3552: , BOM_DEPARTMENTS bd
3553: , BOM_RESOURCES br
3554: WHERE br.RESOURCE_ID = ent.RESOURCE_ID
3555: AND ent.RESOURCE_ID IN ( SELECT br.RESOURCE_ID
3556: FROM BOM_RESOURCES br

Line 3561: FROM BOM_DEPARTMENTS bd

3557: WHERE br.ORGANIZATION_ID=p_organization_id
3558: )
3559: AND bd.DEPARTMENT_ID = ent.DEPARTMENT_ID
3560: AND ent.DEPARTMENT_ID IN ( SELECT bd.DEPARTMENT_ID
3561: FROM BOM_DEPARTMENTS bd
3562: WHERE bd.ORGANIZATION_ID=p_organization_id
3563: );
3564:
3565: CURSOR l_cursor_cnt ( p_org_id NUMBER )

Line 3578: FROM BOM_DEPARTMENTS bd

3574: )
3575: AND ent.DEPARTMENT_ID IN
3576: (
3577: SELECT bd.DEPARTMENT_ID
3578: FROM BOM_DEPARTMENTS bd
3579: WHERE bd.ORGANIZATION_ID=p_org_id
3580: );
3581:
3582: BEGIN