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.BOM_ALTERNATE_DESIGNATORS_PKG dependencies on BOM_ALTERNATE_DESIGNATORS_TL

Line 398: DELETE FROM BOM_ALTERNATE_DESIGNATORS_TL

394: IF p_from_struct_alt_page = 'N' THEN
395: DELETE FROM BOM_ALTERNATE_DESIGNATORS
396: WHERE ALTERNATE_DESIGNATOR_CODE = p_alt_desig_code;
397:
398: DELETE FROM BOM_ALTERNATE_DESIGNATORS_TL
399: WHERE ALTERNATE_DESIGNATOR_CODE = p_alt_desig_code;
400:
401: ELSE
402: UPDATE BOM_ALTERNATE_DESIGNATORS SET structure_type_id =

Line 457: DELETE FROM BOM_ALTERNATE_DESIGNATORS_TL

453: DELETE FROM BOM_ALTERNATE_DESIGNATORS
454: WHERE ALTERNATE_DESIGNATOR_CODE = p_alt_desig_code
455: AND ORGANIZATION_ID = p_organization_id;
456:
457: DELETE FROM BOM_ALTERNATE_DESIGNATORS_TL
458: WHERE ALTERNATE_DESIGNATOR_CODE = p_alt_desig_code
459: and ORGANIZATION_ID = p_organization_id;
460:
461: commit;

Line 542: DELETE FROM BOM_ALTERNATE_DESIGNATORS_TL T

538:
539: PROCEDURE ADD_LANGUAGE
540: IS
541: BEGIN
542: DELETE FROM BOM_ALTERNATE_DESIGNATORS_TL T
543: WHERE not exists
544: (SELECT NULL
545: FROM BOM_ALTERNATE_DESIGNATORS B
546: WHERE B.ALTERNATE_DESIGNATOR_CODE = T.ALTERNATE_DESIGNATOR_CODE

Line 550: UPDATE BOM_ALTERNATE_DESIGNATORS_TL T SET (

546: WHERE B.ALTERNATE_DESIGNATOR_CODE = T.ALTERNATE_DESIGNATOR_CODE
547: and B.ORGANIZATION_ID = T.ORGANIZATION_ID
548: );
549:
550: UPDATE BOM_ALTERNATE_DESIGNATORS_TL T SET (
551: DISPLAY_NAME,
552: DESCRIPTION
553: ) = (SELECT
554: B.DISPLAY_NAME,

Line 556: FROM BOM_ALTERNATE_DESIGNATORS_TL B

552: DESCRIPTION
553: ) = (SELECT
554: B.DISPLAY_NAME,
555: B.DESCRIPTION
556: FROM BOM_ALTERNATE_DESIGNATORS_TL B
557: WHERE B.ALTERNATE_DESIGNATOR_CODE = T.ALTERNATE_DESIGNATOR_CODE
558: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
559: AND B.LANGUAGE = T.SOURCE_LANG)
560: WHERE (

Line 568: FROM BOM_ALTERNATE_DESIGNATORS_TL SUBB, BOM_ALTERNATE_DESIGNATORS_TL SUBT

564: ) IN (SELECT
565: SUBT.ALTERNATE_DESIGNATOR_CODE,
566: SUBT.ORGANIZATION_ID,
567: SUBT.LANGUAGE
568: FROM BOM_ALTERNATE_DESIGNATORS_TL SUBB, BOM_ALTERNATE_DESIGNATORS_TL SUBT
569: WHERE SUBB.ALTERNATE_DESIGNATOR_CODE = SUBT.ALTERNATE_DESIGNATOR_CODE
570: AND SUBB.ORGANIZATION_ID = SUBT.ORGANIZATION_ID
571: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
572: AND (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME

Line 580: INSERT INTO BOM_ALTERNATE_DESIGNATORS_TL (

576: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
577: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
578: ));
579:
580: INSERT INTO BOM_ALTERNATE_DESIGNATORS_TL (
581: ALTERNATE_DESIGNATOR_CODE,
582: ORGANIZATION_ID,
583: DISPLAY_NAME,
584: DESCRIPTION,

Line 604: FROM BOM_ALTERNATE_DESIGNATORS_TL B, FND_LANGUAGES L

600: B.CREATED_BY,
601: B.LAST_UPDATE_LOGIN,
602: L.LANGUAGE_CODE,
603: B.SOURCE_LANG
604: FROM BOM_ALTERNATE_DESIGNATORS_TL B, FND_LANGUAGES L
605: WHERE L.INSTALLED_FLAG IN ('I', 'B')
606: AND B.LANGUAGE = USERENV('LANG')
607: AND NOT EXISTS
608: (SELECT NULL

Line 609: FROM BOM_ALTERNATE_DESIGNATORS_TL T

605: WHERE L.INSTALLED_FLAG IN ('I', 'B')
606: AND B.LANGUAGE = USERENV('LANG')
607: AND NOT EXISTS
608: (SELECT NULL
609: FROM BOM_ALTERNATE_DESIGNATORS_TL T
610: WHERE T.ALTERNATE_DESIGNATOR_CODE = B.ALTERNATE_DESIGNATOR_CODE
611: AND T.ORGANIZATION_ID = B.ORGANIZATION_ID
612: AND T.LANGUAGE = L.LANGUAGE_CODE);
613:

Line 823: insert into BOM_ALTERNATE_DESIGNATORS_TL (

819: ,p_alt_desig_rec.IS_PREFERRED
820: );
821:
822: --- Added for MLS enabling of Bom_Alternate_Designators table
823: insert into BOM_ALTERNATE_DESIGNATORS_TL (
824: ALTERNATE_DESIGNATOR_CODE,
825: ORGANIZATION_ID,
826: DISPLAY_NAME,
827: DESCRIPTION,

Line 851: from BOM_ALTERNATE_DESIGNATORS_TL T

847: from FND_LANGUAGES L
848: where L.INSTALLED_FLAG in ('I', 'B')
849: and not exists
850: (select NULL
851: from BOM_ALTERNATE_DESIGNATORS_TL T
852: where T.ALTERNATE_DESIGNATOR_CODE = p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE
853: and T.ORGANIZATION_ID = p_alt_desig_rec.ORGANIZATION_ID
854: and T.LANGUAGE = L.LANGUAGE_CODE);
855: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1025: UPDATE BOM_ALTERNATE_DESIGNATORS_TL

1021: WHERE
1022: ALTERNATE_DESIGNATOR_CODE = p_alt_desig_rec.alt_desig_code_old
1023: AND ORGANIZATION_ID = p_alt_desig_rec.ORGANIZATION_ID;
1024:
1025: UPDATE BOM_ALTERNATE_DESIGNATORS_TL
1026: SET
1027: ALTERNATE_DESIGNATOR_CODE = p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE,
1028: DESCRIPTION = p_alt_desig_rec.DESCRIPTION,
1029: DISPLAY_NAME = p_alt_desig_rec.DISPLAY_NAME,

Line 1072: UPDATE BOM_ALTERNATE_DESIGNATORS_TL

1068: WHERE
1069: ALTERNATE_DESIGNATOR_CODE = p_alt_desig_rec.alt_desig_code_old -- 4054618
1070: AND ORGANIZATION_ID = p_alt_desig_rec.ORGANIZATION_ID;
1071:
1072: UPDATE BOM_ALTERNATE_DESIGNATORS_TL
1073: SET
1074: ALTERNATE_DESIGNATOR_CODE = p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE,
1075: DESCRIPTION = p_alt_desig_rec.description,
1076: DISPLAY_NAME = p_alt_desig_rec.display_name,

Line 1179: from BOM_ALTERNATE_DESIGNATORS_TL

1175: cursor c1 is select
1176: -- DISPLAY_NAME,
1177: DESCRIPTION,
1178: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
1179: from BOM_ALTERNATE_DESIGNATORS_TL
1180: where ALTERNATE_DESIGNATOR_CODE = P_ALTERNATE_DESIGNATOR_CODE
1181: and ORGANIZATION_ID = P_ORGANIZATION_ID
1182: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
1183: for update of ALTERNATE_DESIGNATOR_CODE nowait;

Line 1281: l_display_name bom_alternate_designators_tl.display_name%TYPE;

1277: is_preferred
1278: FROM bom_alternate_designators_vl badv
1279: WHERE badv.alternate_designator_code = cp_alt_desig_code
1280: AND badv.organization_id = cp_org_id;
1281: l_display_name bom_alternate_designators_tl.display_name%TYPE;
1282: l_description bom_alternate_designators_tl.description%TYPE;
1283: l_disable_date bom_alternate_designators.disable_date%TYPE;
1284: l_structure_type_id bom_alternate_designators.structure_type_id%TYPE;
1285: l_is_preferred bom_alternate_designators.is_preferred%TYPE;

Line 1282: l_description bom_alternate_designators_tl.description%TYPE;

1278: FROM bom_alternate_designators_vl badv
1279: WHERE badv.alternate_designator_code = cp_alt_desig_code
1280: AND badv.organization_id = cp_org_id;
1281: l_display_name bom_alternate_designators_tl.display_name%TYPE;
1282: l_description bom_alternate_designators_tl.description%TYPE;
1283: l_disable_date bom_alternate_designators.disable_date%TYPE;
1284: l_structure_type_id bom_alternate_designators.structure_type_id%TYPE;
1285: l_is_preferred bom_alternate_designators.is_preferred%TYPE;
1286: x_return_status VARCHAR2(1);

Line 1556: UPDATE BOM_ALTERNATE_DESIGNATORS_TL

1552: )
1553: AND (ORGANIZATION_ID = p_organization_id
1554: or (organization_id is null and p_organization_id is null));
1555:
1556: UPDATE BOM_ALTERNATE_DESIGNATORS_TL
1557: SET
1558: DESCRIPTION = NVL(p_description, DESCRIPTION),
1559: DISPLAY_NAME = NVL(p_display_name, DISPLAY_NAME),
1560: LAST_UPDATE_DATE = p_last_update_date,

Line 1651: INSERT INTO BOM_ALTERNATE_DESIGNATORS_TL

1647: ,p_program_update_date
1648: ,p_is_preferred
1649: );
1650:
1651: INSERT INTO BOM_ALTERNATE_DESIGNATORS_TL
1652: (
1653: ALTERNATE_DESIGNATOR_CODE,
1654: ORGANIZATION_ID,
1655: DISPLAY_NAME,

Line 1684: FROM BOM_ALTERNATE_DESIGNATORS_TL T

1680: L.INSTALLED_FLAG IN ('I', 'B')
1681: AND NOT EXISTS
1682: (
1683: SELECT NULL
1684: FROM BOM_ALTERNATE_DESIGNATORS_TL T
1685: WHERE
1686: (
1687: (
1688: p_alternate_designator_code IS NULL

Line 1732: BOM_ALTERNATE_DESIGNATORS_TL badtl

1728: badtl.LAST_UPDATED_BY, badtl.LAST_UPDATE_DATE
1729: INTO
1730: db_luby, db_ludate
1731: FROM
1732: BOM_ALTERNATE_DESIGNATORS_TL badtl
1733: WHERE
1734: badtl.LANGUAGE = userenv('LANG')
1735: AND
1736: (

Line 1752: UPDATE BOM_ALTERNATE_DESIGNATORS_TL

1748: -- Test for customization and version
1749: IF ( FND_LOAD_UTIL.UPLOAD_TEST(p_last_updated_by, p_last_update_date, db_luby, db_ludate, p_custom_mode) )
1750: THEN
1751: -- Update translations for this language
1752: UPDATE BOM_ALTERNATE_DESIGNATORS_TL
1753: SET
1754: DISPLAY_NAME = NVL(p_display_name, DISPLAY_NAME),
1755: DESCRIPTION = NVL(p_description, DESCRIPTION),
1756: LAST_UPDATE_DATE = p_last_update_date,