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_GENERIC_ML_NAME_TL_PKG dependencies on GR_GENERIC_ML_NAME_TL

Line 1: PACKAGE BODY GR_GENERIC_ML_NAME_TL_PKG AS

1: PACKAGE BODY GR_GENERIC_ML_NAME_TL_PKG AS
2: /*$Header: GRHIGITB.pls 120.0 2005/05/26 14:24:42 appldev noship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 143: INSERT INTO gr_generic_ml_name_tl

139: IF FND_API.To_Boolean(l_key_exists) THEN
140: RAISE Item_Exists_Error;
141: END IF;
142:
143: INSERT INTO gr_generic_ml_name_tl
144: (item_code,
145: item_no,
146: language,
147: label_code,

Line 443: UPDATE gr_generic_ml_name_tl

439:
440: IF l_return_status <> 'S' THEN
441: RAISE Foreign_Key_Error;
442: ELSE
443: UPDATE gr_generic_ml_name_tl
444: SET item_code = p_item_code,
445: item_no = p_item_no,
446: language = p_language,
447: label_code = p_label_code,

Line 656: FROM gr_generic_ml_name_tl gin

652: gin.creation_date,
653: gin.last_updated_by,
654: gin.last_update_date,
655: gin.last_update_login
656: FROM gr_generic_ml_name_tl gin
657: WHERE gin.item_code = p_item_code
658: AND gin.item_no = p_item_no
659: AND gin.language = l_language;
660: GenericDesc c_get_descs%ROWTYPE;

Line 682: delete from GR_GENERIC_ML_NAME_TL T

678: l_msg_token := p_item_code || ' ' || p_item_no || ' ' || p_language;
679:
680: /* Remove translations with no base row */
681:
682: delete from GR_GENERIC_ML_NAME_TL T
683: where not exists
684: (select NULL
685: from GR_GENERIC_ITEMS_B B
686: where B.ITEM_CODE = T.ITEM_CODE

Line 692: update gr_generic_ml_name_tl t set (

688: );
689:
690: /* Redefault translations from the source language */
691:
692: update gr_generic_ml_name_tl t set (
693: name_description ) =
694: ( select
695: B.NAME_DESCRIPTION
696: from GR_GENERIC_ML_NAME_TL B

Line 696: from GR_GENERIC_ML_NAME_TL B

692: update gr_generic_ml_name_tl t set (
693: name_description ) =
694: ( select
695: B.NAME_DESCRIPTION
696: from GR_GENERIC_ML_NAME_TL B
697: where B.ITEM_CODE = T.ITEM_CODE
698: and B.ITEM_NO = T.ITEM_NO
699: and B.LANGUAGE = T.SOURCE_LANG)
700: where (

Line 708: from GR_GENERIC_ML_NAME_TL SUBB, GR_GENERIC_ML_NAME_TL SUBT

704: ) in (select
705: SUBT.ITEM_CODE,
706: SUBT.ITEM_NO,
707: SUBT.LANGUAGE
708: from GR_GENERIC_ML_NAME_TL SUBB, GR_GENERIC_ML_NAME_TL SUBT
709: where SUBB.ITEM_CODE = SUBT.ITEM_CODE
710: and SUBB.ITEM_NO = SUBB.ITEM_NO
711: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
712: and (SUBB.NAME_DESCRIPTION <> SUBT.NAME_DESCRIPTION

Line 783: INSERT INTO gr_generic_ml_name_tl

779: OPEN c_get_descs;
780: FETCH c_get_descs INTO GenericDesc;
781: IF c_get_descs%NOTFOUND THEN
782: CLOSE c_get_descs;
783: INSERT INTO gr_generic_ml_name_tl
784: (item_code,
785: item_no,
786: language,
787: label_code,

Line 987: FROM gr_generic_ml_name_tl

983:
984: CURSOR c_lock_generics_tl
985: IS
986: SELECT last_update_date
987: FROM gr_generic_ml_name_tl
988: WHERE rowid = p_rowid
989: FOR UPDATE NOWAIT;
990: LockGenericRcd c_lock_generics_tl%ROWTYPE;
991:

Line 1205: DELETE FROM gr_generic_ml_name_tl

1201: IF l_return_status <> 'S' THEN
1202: RAISE Check_Integrity_Error;
1203: END IF;
1204:
1205: DELETE FROM gr_generic_ml_name_tl
1206: WHERE rowid = p_rowid;
1207:
1208: /* Check the commit flag and if set, then commit the work. */
1209:

Line 1310: DELETE FROM gr_generic_ml_name_tl

1306: RAISE Null_Delete_Option_Error;
1307: ELSE
1308: l_msg_token := p_item_code;
1309:
1310: DELETE FROM gr_generic_ml_name_tl
1311: WHERE item_code = p_item_code;
1312: END IF;
1313: ELSIF p_delete_option = 'I' THEN
1314: IF p_item_no IS NULL THEN

Line 1320: DELETE FROM gr_generic_ml_name_tl

1316: RAISE Null_Delete_Option_Error;
1317: ELSE
1318: l_msg_token := p_item_no;
1319:
1320: DELETE FROM gr_generic_ml_name_tl
1321: WHERE item_no = p_item_no;
1322: END IF;
1323: ELSIF p_delete_option = 'B' THEN
1324: IF p_item_code IS NULL OR

Line 1331: DELETE FROM gr_generic_ml_name_tl

1327: RAISE Null_Delete_Option_Error;
1328: ELSE
1329: l_msg_token := p_item_code || ' ' || p_item_no;
1330:
1331: DELETE FROM gr_generic_ml_name_tl
1332: WHERE item_code = p_item_code
1333: AND item_no = p_item_no;
1334: END IF;
1335: END IF;

Line 1709: FROM gr_generic_ml_name_tl gin

1705:
1706: CURSOR c_get_generic_tl_rowid
1707: IS
1708: SELECT gin.rowid
1709: FROM gr_generic_ml_name_tl gin
1710: WHERE gin.item_code = p_item_code
1711: AND gin.item_no = p_item_no
1712: AND gin.language = p_language;
1713: GenericTLRecord c_get_generic_tl_rowid%ROWTYPE;

Line 1759: delete from GR_GENERIC_ML_NAME_TL T

1755: */
1756: procedure NEW_LANGUAGE
1757: is
1758: begin
1759: delete from GR_GENERIC_ML_NAME_TL T
1760: where not exists
1761: (select NULL
1762: from GR_GENERIC_ITEMS_B B
1763: where B.ITEM_CODE = T.ITEM_CODE

Line 1767: update GR_GENERIC_ML_NAME_TL T set (

1763: where B.ITEM_CODE = T.ITEM_CODE
1764: and B.ITEM_NO = T.ITEM_NO
1765: );
1766:
1767: update GR_GENERIC_ML_NAME_TL T set (
1768: NAME_DESCRIPTION
1769: ) = (select
1770: B.NAME_DESCRIPTION
1771: from GR_GENERIC_ML_NAME_TL B

Line 1771: from GR_GENERIC_ML_NAME_TL B

1767: update GR_GENERIC_ML_NAME_TL T set (
1768: NAME_DESCRIPTION
1769: ) = (select
1770: B.NAME_DESCRIPTION
1771: from GR_GENERIC_ML_NAME_TL B
1772: where B.ITEM_CODE = T.ITEM_CODE
1773: and B.ITEM_NO = T.ITEM_NO
1774: and B.LANGUAGE = T.SOURCE_LANG)
1775: where (

Line 1783: from GR_GENERIC_ML_NAME_TL SUBB, GR_GENERIC_ML_NAME_TL SUBT

1779: ) in (select
1780: SUBT.ITEM_CODE,
1781: SUBT.ITEM_NO,
1782: SUBT.LANGUAGE
1783: from GR_GENERIC_ML_NAME_TL SUBB, GR_GENERIC_ML_NAME_TL SUBT
1784: where SUBB.ITEM_CODE = SUBT.ITEM_CODE
1785: and SUBB.ITEM_NO = SUBT.ITEM_NO
1786: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1787: and (SUBB.NAME_DESCRIPTION <> SUBT.NAME_DESCRIPTION

Line 1790: insert into GR_GENERIC_ML_NAME_TL (

1786: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1787: and (SUBB.NAME_DESCRIPTION <> SUBT.NAME_DESCRIPTION
1788: ));
1789:
1790: insert into GR_GENERIC_ML_NAME_TL (
1791: ATTRIBUTE10,
1792: ATTRIBUTE11,
1793: ATTRIBUTE12,
1794: ATTRIBUTE13,

Line 1876: from GR_GENERIC_ML_NAME_TL B, FND_LANGUAGES L

1872: B.ATTRIBUTE8,
1873: B.ATTRIBUTE9,
1874: L.LANGUAGE_CODE,
1875: B.SOURCE_LANG
1876: from GR_GENERIC_ML_NAME_TL B, FND_LANGUAGES L
1877: where L.INSTALLED_FLAG in ('I', 'B')
1878: and B.LANGUAGE = userenv('LANG')
1879: and not exists
1880: (select NULL

Line 1881: from GR_GENERIC_ML_NAME_TL T

1877: where L.INSTALLED_FLAG in ('I', 'B')
1878: and B.LANGUAGE = userenv('LANG')
1879: and not exists
1880: (select NULL
1881: from GR_GENERIC_ML_NAME_TL T
1882: where T.ITEM_CODE = B.ITEM_CODE
1883: and T.ITEM_NO = B.ITEM_NO
1884: and T.LANGUAGE = L.LANGUAGE_CODE);
1885:

Line 1888: END GR_GENERIC_ML_NAME_TL_PKG;

1884: and T.LANGUAGE = L.LANGUAGE_CODE);
1885:
1886: end NEW_LANGUAGE;
1887:
1888: END GR_GENERIC_ML_NAME_TL_PKG;