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.GR_MULTILINGUAL_NAME_TL_PKG dependencies on GR_MULTILINGUAL_NAME_TL

Line 1: PACKAGE BODY GR_MULTILINGUAL_NAME_TL_PKG AS

1: PACKAGE BODY GR_MULTILINGUAL_NAME_TL_PKG AS
2: /*$Header: GRHIMLTB.pls 115.10 2002/10/28 16:53:36 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 141: INSERT INTO gr_multilingual_name_tl

137: IF FND_API.To_Boolean(l_key_exists) THEN
138: RAISE Item_Exists_Error;
139: END IF;
140:
141: INSERT INTO gr_multilingual_name_tl
142: (item_code,
143: language,
144: label_code,
145: source_lang,

Line 437: UPDATE gr_multilingual_name_tl

433:
434: IF l_return_status <> 'S' THEN
435: RAISE Foreign_Key_Error;
436: ELSE
437: UPDATE gr_multilingual_name_tl
438: SET item_code = p_item_code,
439: language = p_language,
440: label_code = p_label_code,
441: source_lang = p_source_lang,

Line 649: FROM gr_multilingual_name_tl mln

645: mln.creation_date,
646: mln.last_updated_by,
647: mln.last_update_date,
648: mln.last_update_login
649: FROM gr_multilingual_name_tl mln
650: WHERE mln.item_code = p_item_code
651: AND mln.label_code = p_label_code
652: AND mln.language = l_language;
653: MLNameDesc c_get_descs%ROWTYPE;

Line 675: delete from GR_MULTILINGUAL_NAME_TL T

671: l_msg_token := p_item_code || ' ' || p_label_code || ' ' || p_language;
672:
673: /* Remove translations with no base row */
674:
675: delete from GR_MULTILINGUAL_NAME_TL T
676: where not exists
677: (select NULL
678: from GR_ITEM_GENERAL B,
679: GR_LABELS_B L

Line 686: update gr_multilingual_name_tl t set (

682: );
683:
684: /* Redefault translations from the source language */
685:
686: update gr_multilingual_name_tl t set (
687: name_description ) =
688: ( select
689: B.NAME_DESCRIPTION
690: from GR_MULTILINGUAL_NAME_TL B

Line 690: from GR_MULTILINGUAL_NAME_TL B

686: update gr_multilingual_name_tl t set (
687: name_description ) =
688: ( select
689: B.NAME_DESCRIPTION
690: from GR_MULTILINGUAL_NAME_TL B
691: where B.ITEM_CODE = T.ITEM_CODE
692: and B.LABEL_CODE = T.LABEL_CODE
693: and B.LANGUAGE = T.SOURCE_LANG)
694: where (

Line 702: from GR_MULTILINGUAL_NAME_TL SUBB, GR_MULTILINGUAL_NAME_TL SUBT

698: ) in (select
699: SUBT.ITEM_CODE,
700: SUBT.LABEL_CODE,
701: SUBT.LANGUAGE
702: from GR_MULTILINGUAL_NAME_TL SUBB, GR_MULTILINGUAL_NAME_TL SUBT
703: where SUBB.ITEM_CODE = SUBT.ITEM_CODE
704: AND SUBB.LABEL_CODE = SUBT.LABEL_CODE
705: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
706: and (SUBB.NAME_DESCRIPTION <> SUBT.NAME_DESCRIPTION

Line 777: INSERT INTO gr_multilingual_name_tl

773: OPEN c_get_descs;
774: FETCH c_get_descs INTO MLNameDesc;
775: IF c_get_descs%NOTFOUND THEN
776: CLOSE c_get_descs;
777: INSERT INTO gr_multilingual_name_tl
778: (item_code,
779: language,
780: label_code,
781: source_lang,

Line 979: FROM gr_multilingual_name_tl

975:
976: CURSOR c_lock_mlname_tl
977: IS
978: SELECT *
979: FROM gr_multilingual_name_tl
980: WHERE rowid = p_rowid
981: FOR UPDATE NOWAIT;
982: LockMLNameRcd c_lock_mlname_tl%ROWTYPE;
983:

Line 1182: DELETE FROM gr_multilingual_name_tl

1178: IF l_return_status <> 'S' THEN
1179: RAISE Check_Integrity_Error;
1180: END IF;
1181:
1182: DELETE FROM gr_multilingual_name_tl
1183: WHERE rowid = p_rowid;
1184:
1185: /* Check the commit flag and if set, then commit the work. */
1186:

Line 1287: DELETE FROM gr_multilingual_name_tl

1283: RAISE Null_Delete_Option_Error;
1284: ELSE
1285: l_msg_token := p_item_code;
1286:
1287: DELETE FROM gr_multilingual_name_tl
1288: WHERE item_code = p_item_code;
1289: END IF;
1290: ELSIF p_delete_option = 'L' THEN
1291: IF p_label_code IS NULL THEN

Line 1297: DELETE FROM gr_multilingual_name_tl

1293: RAISE Null_Delete_Option_Error;
1294: ELSE
1295: l_msg_token := p_label_code;
1296:
1297: DELETE FROM gr_multilingual_name_tl
1298: WHERE label_code = p_label_code;
1299: END IF;
1300: ELSIF p_delete_option = 'B' THEN
1301: IF p_item_code IS NULL OR

Line 1308: DELETE FROM gr_multilingual_name_tl

1304: RAISE Null_Delete_Option_Error;
1305: ELSE
1306: l_msg_token := p_item_code || ' ' || p_label_code;
1307:
1308: DELETE FROM gr_multilingual_name_tl
1309: WHERE item_code = p_item_code
1310: AND label_code = p_label_code;
1311: END IF;
1312: END IF;

Line 1662: FROM gr_multilingual_name_tl mln

1658:
1659: CURSOR c_get_mlname_tl_rowid
1660: IS
1661: SELECT mln.rowid
1662: FROM gr_multilingual_name_tl mln
1663: WHERE mln.item_code = p_item_code
1664: AND mln.label_code = p_label_code
1665: AND mln.language = p_language;
1666: MLNameTLRecord c_get_mlname_tl_rowid%ROWTYPE;

Line 1709: delete from GR_MULTILINGUAL_NAME_TL T

1705:
1706: procedure NEW_LANGUAGE
1707: is
1708: begin
1709: delete from GR_MULTILINGUAL_NAME_TL T
1710: where not exists
1711: (select NULL
1712: from GR_ITEM_GENERAL B
1713: where B.ITEM_CODE = T.ITEM_CODE

Line 1716: update GR_MULTILINGUAL_NAME_TL T set (

1712: from GR_ITEM_GENERAL B
1713: where B.ITEM_CODE = T.ITEM_CODE
1714: );
1715:
1716: update GR_MULTILINGUAL_NAME_TL T set (
1717: NAME_DESCRIPTION
1718: ) = (select
1719: B.NAME_DESCRIPTION
1720: from GR_MULTILINGUAL_NAME_TL B

Line 1720: from GR_MULTILINGUAL_NAME_TL B

1716: update GR_MULTILINGUAL_NAME_TL T set (
1717: NAME_DESCRIPTION
1718: ) = (select
1719: B.NAME_DESCRIPTION
1720: from GR_MULTILINGUAL_NAME_TL B
1721: where B.ITEM_CODE = T.ITEM_CODE
1722: and B.LABEL_CODE = T.LABEL_CODE
1723: and B.LANGUAGE = T.SOURCE_LANG)
1724: where (

Line 1730: from GR_MULTILINGUAL_NAME_TL SUBB, GR_MULTILINGUAL_NAME_TL SUBT

1726: T.LANGUAGE
1727: ) in (select
1728: SUBT.ITEM_CODE,
1729: SUBT.LANGUAGE
1730: from GR_MULTILINGUAL_NAME_TL SUBB, GR_MULTILINGUAL_NAME_TL SUBT
1731: where SUBB.ITEM_CODE = SUBT.ITEM_CODE
1732: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1733: and (SUBB.NAME_DESCRIPTION <> SUBT.NAME_DESCRIPTION
1734: ));

Line 1736: insert into GR_MULTILINGUAL_NAME_TL (

1732: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1733: and (SUBB.NAME_DESCRIPTION <> SUBT.NAME_DESCRIPTION
1734: ));
1735:
1736: insert into GR_MULTILINGUAL_NAME_TL (
1737: ITEM_CODE,
1738: LABEL_CODE,
1739: NAME_DESCRIPTION,
1740: ATTRIBUTE_CATEGORY,

Line 1820: from GR_MULTILINGUAL_NAME_TL B, FND_LANGUAGES L

1816: B.LAST_UPDATE_DATE,
1817: B.LAST_UPDATE_LOGIN,
1818: L.LANGUAGE_CODE,
1819: B.SOURCE_LANG
1820: from GR_MULTILINGUAL_NAME_TL B, FND_LANGUAGES L
1821: where L.INSTALLED_FLAG in ('I', 'B')
1822: and B.LANGUAGE = userenv('LANG')
1823: and not exists
1824: (select NULL

Line 1825: from GR_MULTILINGUAL_NAME_TL T

1821: where L.INSTALLED_FLAG in ('I', 'B')
1822: and B.LANGUAGE = userenv('LANG')
1823: and not exists
1824: (select NULL
1825: from GR_MULTILINGUAL_NAME_TL T
1826: where T.ITEM_CODE = B.ITEM_CODE
1827: and T.LABEL_CODE = B.LABEL_CODE
1828: and T.LANGUAGE = L.LANGUAGE_CODE);
1829: end NEW_LANGUAGE;

Line 1831: END GR_MULTILINGUAL_NAME_TL_PKG;

1827: and T.LABEL_CODE = B.LABEL_CODE
1828: and T.LANGUAGE = L.LANGUAGE_CODE);
1829: end NEW_LANGUAGE;
1830:
1831: END GR_MULTILINGUAL_NAME_TL_PKG;