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_ITEM_GROUPS_TL_PKG dependencies on GR_ITEM_GROUPS_TL

Line 1: PACKAGE BODY GR_ITEM_GROUPS_TL_PKG AS

1: PACKAGE BODY GR_ITEM_GROUPS_TL_PKG AS
2: /*$Header: GRHIIGTB.pls 115.10 2002/10/25 20:56:35 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 76: INSERT INTO gr_item_groups_tl

72: IF FND_API.To_Boolean(l_key_exists) THEN
73: RAISE Item_Exists_Error;
74: END IF;
75:
76: INSERT INTO gr_item_groups_tl
77: (item_group_code,
78: language,
79: source_lang,
80: description,

Line 243: UPDATE gr_item_groups_tl

239:
240: IF l_return_status <> 'S' THEN
241: RAISE Foreign_Key_Error;
242: ELSE
243: UPDATE gr_item_groups_tl
244: SET item_group_code = p_item_group_code,
245: language = p_language,
246: source_lang = p_source_lang,
247: description = p_description,

Line 358: FROM gr_item_groups_tl igt

354: igt.creation_date,
355: igt.last_updated_by,
356: igt.last_update_date,
357: igt.last_update_login
358: FROM gr_item_groups_tl igt
359: WHERE igt.item_group_code = p_item_group_code
360: AND igt.language = l_language;
361: GroupDesc c_get_descs%ROWTYPE;
362:

Line 383: delete from GR_ITEM_GROUPS_TL T

379: l_msg_token := p_item_group_code || ' ' || p_language;
380:
381: /* Remove translations with no base row */
382:
383: delete from GR_ITEM_GROUPS_TL T
384: where not exists
385: (select NULL
386: from GR_ITEM_GROUPS_B B
387: where B.ITEM_GROUP_CODE = T.ITEM_GROUP_CODE

Line 392: update gr_item_groups_tl t set (

388: );
389:
390: /* Redefault translations from the source language */
391:
392: update gr_item_groups_tl t set (
393: description ) =
394: ( select
395: B.DESCRIPTION
396: from GR_ITEM_GROUPS_TL B

Line 396: from GR_ITEM_GROUPS_TL B

392: update gr_item_groups_tl t set (
393: description ) =
394: ( select
395: B.DESCRIPTION
396: from GR_ITEM_GROUPS_TL B
397: where B.ITEM_GROUP_CODE = T.ITEM_GROUP_CODE
398: and B.LANGUAGE = T.SOURCE_LANG)
399: where (
400: T.ITEM_GROUP_CODE,

Line 405: from GR_ITEM_GROUPS_TL SUBB, GR_ITEM_GROUPS_TL SUBT

401: T.LANGUAGE
402: ) in (select
403: SUBT.ITEM_GROUP_CODE,
404: SUBT.LANGUAGE
405: from GR_ITEM_GROUPS_TL SUBB, GR_ITEM_GROUPS_TL SUBT
406: where SUBB.ITEM_GROUP_CODE = SUBT.ITEM_GROUP_CODE
407: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
408: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
409: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 447: INSERT INTO gr_item_groups_tl

443: OPEN c_get_descs;
444: FETCH c_get_descs INTO GroupDesc;
445: IF c_get_descs%NOTFOUND THEN
446: CLOSE c_get_descs;
447: INSERT INTO gr_item_groups_tl
448: (item_group_code,
449: language,
450: source_lang,
451: description,

Line 553: FROM gr_item_groups_tl

549:
550: CURSOR c_lock_groups_tl
551: IS
552: SELECT *
553: FROM gr_item_groups_tl
554: WHERE rowid = p_rowid
555: FOR UPDATE NOWAIT;
556: LockGroupRcd c_lock_groups_tl%ROWTYPE;
557:

Line 700: DELETE FROM gr_item_groups_tl

696: IF l_return_status <> 'S' THEN
697: RAISE Check_Integrity_Error;
698: END IF;
699:
700: DELETE FROM gr_item_groups_tl
701: WHERE rowid = p_rowid;
702:
703: /* Check the commit flag and if set, then commit the work. */
704:

Line 786: DELETE FROM gr_item_groups_tl

782: x_oracle_error := 0;
783: x_msg_data := NULL;
784: l_msg_token := p_item_group_code;
785:
786: DELETE FROM gr_item_groups_tl
787: WHERE item_group_code = p_item_group_code;
788:
789: IF FND_API.To_Boolean(p_commit) THEN
790: COMMIT WORK;

Line 1019: FROM gr_item_groups_tl igt

1015:
1016: CURSOR c_get_groups_tl_rowid
1017: IS
1018: SELECT igt.rowid
1019: FROM gr_item_groups_tl igt
1020: WHERE igt.item_group_code = p_item_group_code
1021: AND igt.language = p_language;
1022: GroupTLRecord c_get_groups_tl_rowid%ROWTYPE;
1023:

Line 1065: delete from GR_ITEM_GROUPS_TL T

1061:
1062: procedure NEW_LANGUAGE
1063: is
1064: begin
1065: delete from GR_ITEM_GROUPS_TL T
1066: where not exists
1067: (select NULL
1068: from GR_ITEM_GROUPS_B B
1069: where B.ITEM_GROUP_CODE = T.ITEM_GROUP_CODE

Line 1072: update GR_ITEM_GROUPS_TL T set (

1068: from GR_ITEM_GROUPS_B B
1069: where B.ITEM_GROUP_CODE = T.ITEM_GROUP_CODE
1070: );
1071:
1072: update GR_ITEM_GROUPS_TL T set (
1073: DESCRIPTION
1074: ) = (select
1075: B.DESCRIPTION
1076: from GR_ITEM_GROUPS_TL B

Line 1076: from GR_ITEM_GROUPS_TL B

1072: update GR_ITEM_GROUPS_TL T set (
1073: DESCRIPTION
1074: ) = (select
1075: B.DESCRIPTION
1076: from GR_ITEM_GROUPS_TL B
1077: where B.ITEM_GROUP_CODE = T.ITEM_GROUP_CODE
1078: and B.LANGUAGE = T.SOURCE_LANG)
1079: where (
1080: T.ITEM_GROUP_CODE,

Line 1085: from GR_ITEM_GROUPS_TL SUBB, GR_ITEM_GROUPS_TL SUBT

1081: T.LANGUAGE
1082: ) in (select
1083: SUBT.ITEM_GROUP_CODE,
1084: SUBT.LANGUAGE
1085: from GR_ITEM_GROUPS_TL SUBB, GR_ITEM_GROUPS_TL SUBT
1086: where SUBB.ITEM_GROUP_CODE = SUBT.ITEM_GROUP_CODE
1087: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1088: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
1089: ));

Line 1091: insert into GR_ITEM_GROUPS_TL (

1087: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1088: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
1089: ));
1090:
1091: insert into GR_ITEM_GROUPS_TL (
1092: ITEM_GROUP_CODE,
1093: DESCRIPTION,
1094: CREATED_BY,
1095: CREATION_DATE,

Line 1111: from GR_ITEM_GROUPS_TL B, FND_LANGUAGES L

1107: B.LAST_UPDATE_DATE,
1108: B.LAST_UPDATE_LOGIN,
1109: L.LANGUAGE_CODE,
1110: B.SOURCE_LANG
1111: from GR_ITEM_GROUPS_TL B, FND_LANGUAGES L
1112: where L.INSTALLED_FLAG in ('I', 'B')
1113: and B.LANGUAGE = userenv('LANG')
1114: and not exists
1115: (select NULL

Line 1116: from GR_ITEM_GROUPS_TL T

1112: where L.INSTALLED_FLAG in ('I', 'B')
1113: and B.LANGUAGE = userenv('LANG')
1114: and not exists
1115: (select NULL
1116: from GR_ITEM_GROUPS_TL T
1117: where T.ITEM_GROUP_CODE = B.ITEM_GROUP_CODE
1118: and T.LANGUAGE = L.LANGUAGE_CODE);
1119:
1120: end NEW_LANGUAGE;

Line 1122: END GR_ITEM_GROUPS_TL_PKG;

1118: and T.LANGUAGE = L.LANGUAGE_CODE);
1119:
1120: end NEW_LANGUAGE;
1121:
1122: END GR_ITEM_GROUPS_TL_PKG;