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

Line 1: PACKAGE BODY BOM_ALTERNATE_DESIGNATORS_PKG as

1: PACKAGE BODY BOM_ALTERNATE_DESIGNATORS_PKG as
2: /* $Header: bompbadb.pls 120.6 2007/03/29 05:41:21 dikrishn ship $ */
3: ------------------------------------
4: -- Global Variables and Constants --
5: ------------------------------------

Line 7: g_pkg_name CONSTANT VARCHAR2(30) := 'BOM_ALTERNATE_DESIGNATORS_PKG';

3: ------------------------------------
4: -- Global Variables and Constants --
5: ------------------------------------
6:
7: g_pkg_name CONSTANT VARCHAR2(30) := 'BOM_ALTERNATE_DESIGNATORS_PKG';
8: g_current_user_id NUMBER := FND_GLOBAL.User_Id;
9: g_current_login_id NUMBER := FND_GLOBAL.Login_Id;
10:
11: TYPE Bom_Alt_Desig_Rec IS RECORD

Line 12: ( -- Columns from Bom_Alternate_Designators table

8: g_current_user_id NUMBER := FND_GLOBAL.User_Id;
9: g_current_login_id NUMBER := FND_GLOBAL.Login_Id;
10:
11: TYPE Bom_Alt_Desig_Rec IS RECORD
12: ( -- Columns from Bom_Alternate_Designators table
13: Alternate_Designator_Code VARCHAR2(10)
14: , Organization_id NUMBER
15: , LAST_UPDATE_DATE DATE
16: , LAST_UPDATED_BY NUMBER

Line 128: (SELECT 1 FROM BOM_ALTERNATE_DESIGNATORS

124: X_Alternate_Designator_Code VARCHAR2) IS
125: DUMMY NUMBER;
126: BEGIN
127: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
128: (SELECT 1 FROM BOM_ALTERNATE_DESIGNATORS
129: WHERE Organization_Id = X_Organization_Id
130: AND Alternate_Designator_Code = X_Alternate_Designator_Code
131: );
132:

Line 395: DELETE FROM BOM_ALTERNATE_DESIGNATORS

391:
392: IF NOT Check_References(NULL, p_alt_desig_code) THEN
393: -- Added for Bug Fix : 3045566
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;

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 402: UPDATE BOM_ALTERNATE_DESIGNATORS SET structure_type_id =

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 =
403: (SELECT structure_type_id
404: FROM bom_structure_types_b
405: WHERE parent_structure_type_id IS NULL)
406: WHERE ALTERNATE_DESIGNATOR_CODE = p_alt_desig_code ;

Line 453: DELETE FROM BOM_ALTERNATE_DESIGNATORS

449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451:
452: IF NOT Check_References(p_organization_id, p_alt_desig_code) THEN
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

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 500: UPDATE BOM_ALTERNATE_DESIGNATORS

496: l_api_name, G_PKG_NAME) THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499:
500: UPDATE BOM_ALTERNATE_DESIGNATORS
501: SET structure_type_id = p_structure_type_id
502: WHERE alternate_designator_code = p_alternate_designator_code;
503: -- AND organization_id = p_organization_id;
504: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 545: FROM BOM_ALTERNATE_DESIGNATORS B

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
547: and B.ORGANIZATION_ID = T.ORGANIZATION_ID
548: );
549:

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 745: update bom_alternate_designators

741: old_preferred_name := Get_Preferred_Name(p_alt_desig_rec.structure_type_id, p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE);
742: if(p_alt_desig_rec.is_preferred = 'Y' and
743: old_preferred_name <> p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE)
744: then
745: update bom_alternate_designators
746: set is_preferred ='N'
747: where
748: alternate_designator_code =old_preferred_name;
749: end if;

Line 753: INSERT INTO BOM_ALTERNATE_DESIGNATORS

749: end if;
750:
751:
752: IF NOT Check_Unique(p_alt_desig_rec.ORGANIZATION_ID, p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE) THEN
753: INSERT INTO BOM_ALTERNATE_DESIGNATORS
754: (
755: ALTERNATE_DESIGNATOR_CODE
756: ,ORGANIZATION_ID
757: ,DESCRIPTION

Line 822: --- Added for MLS enabling of Bom_Alternate_Designators table

818: ,p_alt_desig_rec.PROGRAM_UPDATE_DATE
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,

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 986: UPDATE bom_alternate_designators

982: old_preferred_name := Get_Preferred_Name(p_alt_desig_rec.structure_type_id, p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE);
983: IF(p_alt_desig_rec.is_preferred = 'Y' AND
984: old_preferred_name <> p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE)
985: THEN
986: UPDATE bom_alternate_designators
987: SET is_preferred ='N'
988: WHERE
989: structure_type_id = p_alt_desig_rec.structure_type_id
990: AND is_preferred ='Y';

Line 994: UPDATE BOM_ALTERNATE_DESIGNATORS

990: AND is_preferred ='Y';
991: END IF;
992:
993: IF( p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE = p_alt_desig_rec.Alt_Desig_Code_Old ) THEN
994: UPDATE BOM_ALTERNATE_DESIGNATORS
995: SET
996: ALTERNATE_DESIGNATOR_CODE = p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE,
997: DESCRIPTION = p_alt_desig_rec.DESCRIPTION,
998: DISABLE_DATE = p_alt_desig_rec.DISABLE_DATE,

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 1042: UPDATE BOM_ALTERNATE_DESIGNATORS

1038:
1039: x_return_status := FND_API.G_RET_STS_SUCCESS;
1040: ELSIF( p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE <> p_alt_desig_rec.alt_desig_code_old ) THEN
1041: IF NOT Check_Unique(p_alt_desig_rec.ORGANIZATION_ID, p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE) THEN
1042: UPDATE BOM_ALTERNATE_DESIGNATORS
1043: SET
1044: ALTERNATE_DESIGNATOR_CODE = p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE,
1045: DESCRIPTION = p_alt_desig_rec.description,
1046: DISABLE_DATE = p_alt_desig_rec.disable_date,

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 1169: from BOM_ALTERNATE_DESIGNATORS

1165: ATTRIBUTE13,
1166: ATTRIBUTE14,
1167: ATTRIBUTE15,
1168: REQUEST_ID
1169: from BOM_ALTERNATE_DESIGNATORS
1170: where ALTERNATE_DESIGNATOR_CODE = P_ALTERNATE_DESIGNATOR_CODE
1171: and ORGANIZATION_ID = P_ORGANIZATION_ID
1172: for update of ALTERNATE_DESIGNATOR_CODE nowait;
1173: recinfo c%rowtype;

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 1258: select distinct alternate_designator_code from bom_alternate_designators

1254: Function Get_Preferred_Name ( structure_type_id Number, alt_des_code varchar2) return VARCHAR2
1255: is
1256: return_value varchar2(10);
1257: cursor get_preferred (p_structure_type_id Number,p_alt_code varchar2) is
1258: select distinct alternate_designator_code from bom_alternate_designators
1259: where is_preferred ='Y'
1260: and structure_type_id = p_structure_type_id
1261: and alternate_designator_code <> p_alt_code;
1262: begin

Line 1278: FROM bom_alternate_designators_vl badv

1274: description,
1275: NULL disable_date,
1276: structure_type_id,
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;

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 1283: l_disable_date bom_alternate_designators.disable_date%TYPE;

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);
1287: x_errorcode NUMBER;

Line 1284: l_structure_type_id bom_alternate_designators.structure_type_id%TYPE;

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);
1287: x_errorcode NUMBER;
1288: x_msg_count NUMBER;

Line 1285: l_is_preferred bom_alternate_designators.is_preferred%TYPE;

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);
1287: x_errorcode NUMBER;
1288: x_msg_count NUMBER;
1289: x_msg_data VARCHAR2(4000);

Line 1482: BOM_ALTERNATE_DESIGNATORS bad

1478: bad.LAST_UPDATED_BY, bad.LAST_UPDATE_DATE
1479: INTO
1480: db_luby, db_ludate
1481: FROM
1482: BOM_ALTERNATE_DESIGNATORS bad
1483: WHERE
1484: (
1485: (
1486: p_alternate_designator_code IS NULL

Line 1507: UPDATE BOM_ALTERNATE_DESIGNATORS

1503: THEN
1504: old_preferred_name := Get_Preferred_Name(p_structure_type_id, p_alternate_designator_code);
1505: IF(old_preferred_name <> p_alternate_designator_code)
1506: THEN
1507: UPDATE BOM_ALTERNATE_DESIGNATORS
1508: SET is_preferred ='N'
1509: WHERE alternate_designator_code = old_preferred_name;
1510: END IF;
1511: END IF;

Line 1515: UPDATE BOM_ALTERNATE_DESIGNATORS

1511: END IF;
1512:
1513: -- Update existing row
1514: -- Since update_row is not taking care of NULL alternate designator, updating row directly.
1515: UPDATE BOM_ALTERNATE_DESIGNATORS
1516: SET
1517: DESCRIPTION = NVL(p_description, DESCRIPTION),
1518: DISABLE_DATE = p_disable_date,
1519: STRUCTURE_TYPE_ID = p_structure_type_id,

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 1582: INSERT INTO BOM_ALTERNATE_DESIGNATORS

1578: EXCEPTION
1579: WHEN NO_DATA_FOUND THEN
1580: -- Record doesn't exist - insert in all cases
1581: -- Since insert_row is not taking care of NULL alternate designator, inserting row directly.
1582: INSERT INTO BOM_ALTERNATE_DESIGNATORS
1583: (
1584: ALTERNATE_DESIGNATOR_CODE
1585: ,ORGANIZATION_ID
1586: ,DESCRIPTION

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 1705: UPDATE BOM_ALTERNATE_DESIGNATORS

1701: THEN
1702: old_preferred_name := Get_Preferred_Name(p_structure_type_id, p_alternate_designator_code);
1703: IF(old_preferred_name <> p_alternate_designator_code)
1704: THEN
1705: UPDATE BOM_ALTERNATE_DESIGNATORS
1706: SET is_preferred ='N'
1707: WHERE alternate_designator_code = old_preferred_name;
1708: END IF;
1709: END IF;

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,

Line 1783: END BOM_ALTERNATE_DESIGNATORS_PKG;

1779: -- Do not insert missing translations, skip this row
1780: NULL;
1781: END TRANSLATE_ROW;
1782:
1783: END BOM_ALTERNATE_DESIGNATORS_PKG;