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_MAIN_HEADINGS_TL_PKG dependencies on GR_MAIN_HEADINGS_TL

Line 1: PACKAGE BODY GR_MAIN_HEADINGS_TL_PKG AS

1: PACKAGE BODY GR_MAIN_HEADINGS_TL_PKG AS
2: /*$Header: GRHIMHTB.pls 115.7 2002/10/28 16:47:11 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 76: INSERT INTO gr_main_headings_tl

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

Line 243: UPDATE gr_main_headings_tl

239:
240: IF l_return_status <> 'S' THEN
241: RAISE Foreign_Key_Error;
242: ELSE
243: UPDATE gr_main_headings_tl
244: SET main_heading_code = p_main_heading_code,
245: language = p_language,
246: main_heading_description = p_main_heading_description,
247: source_lang = p_source_lang,

Line 330: L_BASE_DESC GR_MAIN_HEADINGS_TL.main_heading_description%TYPE;

326:
327: L_RETURN_STATUS VARCHAR2(1) := 'S';
328: L_MSG_DATA VARCHAR2(2000);
329: L_MSG_TOKEN VARCHAR2(100);
330: L_BASE_DESC GR_MAIN_HEADINGS_TL.main_heading_description%TYPE;
331: L_LANGUAGE VARCHAR2(4);
332: L_CREATION_DATE DATE;
333: L_LAST_UPDATE_DATE DATE;
334: /*

Line 356: FROM gr_main_headings_tl mht

352: mht.creation_date,
353: mht.last_updated_by,
354: mht.last_update_date,
355: mht.last_update_login
356: FROM gr_main_headings_tl mht
357: WHERE mht.main_heading_code = p_main_heading_code
358: AND mht.language = l_language;
359: MainHdgRecord c_get_main_heading%ROWTYPE;
360:

Line 381: delete from GR_MAIN_HEADINGS_TL T

377: l_msg_token := p_main_heading_code || ' ' || p_language;
378:
379: /* Remove translations with no base row */
380:
381: delete from GR_MAIN_HEADINGS_TL T
382: where not exists
383: (select NULL
384: from GR_MAIN_HEADINGS_B B
385: where B.MAIN_HEADING_CODE = T.MAIN_HEADING_CODE

Line 390: update gr_main_headings_tl t set (

386: );
387:
388: /* Redefault translations from the source language */
389:
390: update gr_main_headings_tl t set (
391: main_heading_description ) =
392: ( select
393: B.MAIN_HEADING_DESCRIPTION
394: from GR_MAIN_HEADINGS_TL B

Line 394: from GR_MAIN_HEADINGS_TL B

390: update gr_main_headings_tl t set (
391: main_heading_description ) =
392: ( select
393: B.MAIN_HEADING_DESCRIPTION
394: from GR_MAIN_HEADINGS_TL B
395: where B.MAIN_HEADING_CODE = T.MAIN_HEADING_CODE
396: and B.LANGUAGE = T.SOURCE_LANG)
397: where (
398: T.MAIN_HEADING_CODE,

Line 403: from GR_MAIN_HEADINGS_TL SUBB, GR_MAIN_HEADINGS_TL SUBT

399: T.LANGUAGE
400: ) in (select
401: SUBT.MAIN_HEADING_CODE,
402: SUBT.LANGUAGE
403: from GR_MAIN_HEADINGS_TL SUBB, GR_MAIN_HEADINGS_TL SUBT
404: where SUBB.MAIN_HEADING_CODE = SUBT.MAIN_HEADING_CODE
405: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
406: and (SUBB.MAIN_HEADING_DESCRIPTION <> SUBT.MAIN_HEADING_DESCRIPTION
407: or (SUBB.MAIN_HEADING_DESCRIPTION is null and SUBT.MAIN_HEADING_DESCRIPTION is not null)

Line 445: INSERT INTO gr_main_headings_tl

441: OPEN c_get_main_heading;
442: FETCH c_get_main_heading INTO MainHdgRecord;
443: IF c_get_main_heading%NOTFOUND THEN
444: CLOSE c_get_main_heading;
445: INSERT INTO gr_main_headings_tl
446: (main_heading_code,
447: language,
448: main_heading_description,
449: source_lang,

Line 552: FROM gr_main_headings_tl

548:
549: CURSOR c_lock_main_hdgs_tl
550: IS
551: SELECT *
552: FROM gr_main_headings_tl
553: WHERE rowid = p_rowid
554: FOR UPDATE NOWAIT;
555: LockMainHdgRcd c_lock_main_hdgs_tl%ROWTYPE;
556:

Line 691: DELETE FROM gr_main_headings_tl

687: IF l_return_status <> 'S' THEN
688: RAISE Check_Integrity_Error;
689: END IF;
690:
691: DELETE FROM gr_main_headings_tl
692: WHERE rowid = p_rowid;
693:
694: /* Check the commit flag and if set, then commit the work. */
695:

Line 776: DELETE FROM gr_main_headings_tl

772: x_oracle_error := 0;
773: x_msg_data := NULL;
774: l_msg_token := p_main_heading_code;
775:
776: DELETE FROM gr_main_headings_tl
777: WHERE main_heading_code = p_main_heading_code;
778:
779: IF FND_API.To_Boolean(p_commit) THEN
780: COMMIT WORK;

Line 1009: FROM gr_main_headings_tl mht

1005:
1006: CURSOR c_get_main_hdgs_tl_rowid
1007: IS
1008: SELECT mht.rowid
1009: FROM gr_main_headings_tl mht
1010: WHERE mht.main_heading_code = p_main_heading_code
1011: AND mht.language = p_language;
1012: HeadingTLRecord c_get_main_hdgs_tl_rowid%ROWTYPE;
1013:

Line 1051: UPDATE GR_MAIN_HEADINGS_TL SET

1047: ,X_MAIN_HEADING_DESCRIPTION IN VARCHAR2
1048: ,X_SOURCE_LANG IN VARCHAR2
1049: ) IS
1050: BEGIN
1051: UPDATE GR_MAIN_HEADINGS_TL SET
1052: MAIN_HEADING_DESCRIPTION = X_MAIN_HEADING_DESCRIPTION,
1053: SOURCE_LANG = USERENV('LANG'),
1054: LAST_UPDATE_DATE = sysdate,
1055: LAST_UPDATED_BY = 0,

Line 1070: FROM GR_MAIN_HEADINGS_TL

1066: ,X_SOURCE_LANG IN VARCHAR2
1067: ) IS
1068: CURSOR Cur_rowid IS
1069: SELECT rowid
1070: FROM GR_MAIN_HEADINGS_TL
1071: WHERE (MAIN_HEADING_CODE = X_MAIN_HEADING_CODE)
1072: AND (LANGUAGE = X_LANGUAGE);
1073: l_user_id NUMBER DEFAULT 1;
1074: l_row_id VARCHAR2(64);

Line 1082: GR_MAIN_HEADINGS_TL_PKG.UPDATE_ROW(

1078: BEGIN
1079: OPEN Cur_rowid;
1080: FETCH Cur_rowid INTO l_row_id;
1081: IF Cur_rowid%FOUND THEN
1082: GR_MAIN_HEADINGS_TL_PKG.UPDATE_ROW(
1083: P_COMMIT => 'T'
1084: ,P_CALLED_BY_FORM => 'F'
1085: ,P_ROWID => l_row_id
1086: ,P_MAIN_HEADING_CODE => X_MAIN_HEADING_CODE

Line 1099: GR_MAIN_HEADINGS_TL_PKG.INSERT_ROW(

1095: ,X_RETURN_STATUS => l_return_status
1096: ,X_ORACLE_ERROR => l_oracle_error
1097: ,X_MSG_DATA => l_msg_data);
1098: ELSE
1099: GR_MAIN_HEADINGS_TL_PKG.INSERT_ROW(
1100: P_COMMIT => 'T'
1101: ,P_CALLED_BY_FORM => 'F'
1102: ,P_MAIN_HEADING_CODE => X_MAIN_HEADING_CODE
1103: ,P_LANGUAGE => X_LANGUAGE

Line 1130: delete from GR_MAIN_HEADINGS_TL T

1126:
1127: procedure NEW_LANGUAGE
1128: is
1129: begin
1130: delete from GR_MAIN_HEADINGS_TL T
1131: where not exists
1132: (select NULL
1133: from GR_MAIN_HEADINGS_B B
1134: where B.MAIN_HEADING_CODE = T.MAIN_HEADING_CODE

Line 1137: update GR_MAIN_HEADINGS_TL T set (

1133: from GR_MAIN_HEADINGS_B B
1134: where B.MAIN_HEADING_CODE = T.MAIN_HEADING_CODE
1135: );
1136:
1137: update GR_MAIN_HEADINGS_TL T set (
1138: MAIN_HEADING_DESCRIPTION
1139: ) = (select
1140: B.MAIN_HEADING_DESCRIPTION
1141: from GR_MAIN_HEADINGS_TL B

Line 1141: from GR_MAIN_HEADINGS_TL B

1137: update GR_MAIN_HEADINGS_TL T set (
1138: MAIN_HEADING_DESCRIPTION
1139: ) = (select
1140: B.MAIN_HEADING_DESCRIPTION
1141: from GR_MAIN_HEADINGS_TL B
1142: where B.MAIN_HEADING_CODE = T.MAIN_HEADING_CODE
1143: and B.LANGUAGE = T.SOURCE_LANG)
1144: where (
1145: T.MAIN_HEADING_CODE,

Line 1150: from GR_MAIN_HEADINGS_TL SUBB, GR_MAIN_HEADINGS_TL SUBT

1146: T.LANGUAGE
1147: ) in (select
1148: SUBT.MAIN_HEADING_CODE,
1149: SUBT.LANGUAGE
1150: from GR_MAIN_HEADINGS_TL SUBB, GR_MAIN_HEADINGS_TL SUBT
1151: where SUBB.MAIN_HEADING_CODE = SUBT.MAIN_HEADING_CODE
1152: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1153: and (SUBB.MAIN_HEADING_DESCRIPTION <> SUBT.MAIN_HEADING_DESCRIPTION
1154: ));

Line 1156: insert into GR_MAIN_HEADINGS_TL (

1152: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1153: and (SUBB.MAIN_HEADING_DESCRIPTION <> SUBT.MAIN_HEADING_DESCRIPTION
1154: ));
1155:
1156: insert into GR_MAIN_HEADINGS_TL (
1157: CREATION_DATE,
1158: LAST_UPDATED_BY,
1159: LAST_UPDATE_DATE,
1160: LAST_UPDATE_LOGIN,

Line 1176: from GR_MAIN_HEADINGS_TL B, FND_LANGUAGES L

1172: B.MAIN_HEADING_DESCRIPTION,
1173: B.CREATED_BY,
1174: L.LANGUAGE_CODE,
1175: B.SOURCE_LANG
1176: from GR_MAIN_HEADINGS_TL B, FND_LANGUAGES L
1177: where L.INSTALLED_FLAG in ('I', 'B')
1178: and B.LANGUAGE = userenv('LANG')
1179: and not exists
1180: (select NULL

Line 1181: from GR_MAIN_HEADINGS_TL T

1177: where L.INSTALLED_FLAG in ('I', 'B')
1178: and B.LANGUAGE = userenv('LANG')
1179: and not exists
1180: (select NULL
1181: from GR_MAIN_HEADINGS_TL T
1182: where T.MAIN_HEADING_CODE = B.MAIN_HEADING_CODE
1183: and T.LANGUAGE = L.LANGUAGE_CODE);
1184:
1185: end NEW_LANGUAGE;

Line 1187: END GR_MAIN_HEADINGS_TL_PKG;

1183: and T.LANGUAGE = L.LANGUAGE_CODE);
1184:
1185: end NEW_LANGUAGE;
1186:
1187: END GR_MAIN_HEADINGS_TL_PKG;