APPS.INV_COPY_ORGANIZATION_REPORT dependencies on BOM_ALTERNATE_DESIGNATORS

Line 997: Init_Vars('BOM_ALTERNATE_DESIGNATORS');

993: -----------------------------------*/
994: IF g_copy_boms = 'Y'
995: OR g_copy_routings = 'Y'
996: THEN
997: Init_Vars('BOM_ALTERNATE_DESIGNATORS');
998: g_entity_names := Get_Err_Bom_Alt_Desig;
999: Put_Report_Data;
1000: END IF;
1001:

Line 1484: -- DESCRIPTION : Validate bom alternate designators created for new org

1480:
1481: --=============================================================================
1482: -- FUNCTION NAME : Get_Err_Bom_Alt_Desig
1483: -- PRE-CONDITIONS: None.
1484: -- DESCRIPTION : Validate bom alternate designators created for new org
1485: -- against those in model org.
1486: -- PARAMETERS : None.
1487: -- EXCEPTIONS : None.
1488: --

Line 1505: FROM BOM_ALTERNATE_DESIGNATORS bad1

1501: , p_organization_id NUMBER
1502: )
1503: IS
1504: SELECT bad1.ALTERNATE_DESIGNATOR_CODE
1505: FROM BOM_ALTERNATE_DESIGNATORS bad1
1506: WHERE bad1.ORGANIZATION_ID=g_model_org_id
1507: AND NOT EXISTS
1508: ( SELECT bad2.ALTERNATE_DESIGNATOR_CODE
1509: FROM BOM_ALTERNATE_DESIGNATORS bad2

Line 1509: FROM BOM_ALTERNATE_DESIGNATORS bad2

1505: FROM BOM_ALTERNATE_DESIGNATORS bad1
1506: WHERE bad1.ORGANIZATION_ID=g_model_org_id
1507: AND NOT EXISTS
1508: ( SELECT bad2.ALTERNATE_DESIGNATOR_CODE
1509: FROM BOM_ALTERNATE_DESIGNATORS bad2
1510: WHERE bad2.ORGANIZATION_ID=g_organization_id
1511: AND bad2.ALTERNATE_DESIGNATOR_CODE=bad1.ALTERNATE_DESIGNATOR_CODE
1512: );
1513:

Line 1517: FROM BOM_ALTERNATE_DESIGNATORS bad

1513:
1514: CURSOR l_cnt_csr ( p_org_id NUMBER )
1515: IS
1516: SELECT COUNT(bad.ALTERNATE_DESIGNATOR_CODE)
1517: FROM BOM_ALTERNATE_DESIGNATORS bad
1518: WHERE bad.ORGANIZATION_ID = p_org_id;
1519:
1520: BEGIN
1521: