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_SUB_HEADINGS_TL_PKG dependencies on GR_SUB_HEADINGS_TL

Line 1: PACKAGE BODY GR_SUB_HEADINGS_TL_PKG AS

1: PACKAGE BODY GR_SUB_HEADINGS_TL_PKG AS
2: /*$Header: GRHISHTB.pls 115.5 2002/10/25 18:00:40 gkelly ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 76: INSERT INTO gr_sub_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_sub_headings_tl
77: (sub_heading_code,
78: language,
79: sub_heading_desc,
80: source_lang,

Line 243: UPDATE gr_sub_headings_tl

239:
240: IF l_return_status <> 'S' THEN
241: RAISE Foreign_Key_Error;
242: ELSE
243: UPDATE gr_sub_headings_tl
244: SET sub_heading_code = p_sub_heading_code,
245: language = p_language,
246: sub_heading_desc = p_sub_heading_desc,
247: source_lang = p_source_lang,

Line 330: L_BASE_DESC GR_SUB_HEADINGS_TL.sub_heading_desc%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_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
331: L_LANGUAGE VARCHAR2(4);
332: L_CREATION_DATE DATE;
333: L_LAST_UPDATE_DATE DATE;
334: /*

Line 356: FROM gr_sub_headings_tl sht

352: sht.creation_date,
353: sht.last_updated_by,
354: sht.last_update_date,
355: sht.last_update_login
356: FROM gr_sub_headings_tl sht
357: WHERE sht.sub_heading_code = p_sub_heading_code
358: AND sht.language = l_language;
359: SubHdgRecord c_get_sub_heading%ROWTYPE;
360:

Line 381: delete from GR_SUB_HEADINGS_TL T

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

Line 390: update gr_sub_headings_tl t set (

386: );
387:
388: /* Redefault translations from the source language */
389:
390: update gr_sub_headings_tl t set (
391: sub_heading_desc ) =
392: ( select
393: B.SUB_HEADING_DESC
394: from GR_SUB_HEADINGS_TL B

Line 394: from GR_SUB_HEADINGS_TL B

390: update gr_sub_headings_tl t set (
391: sub_heading_desc ) =
392: ( select
393: B.SUB_HEADING_DESC
394: from GR_SUB_HEADINGS_TL B
395: where B.SUB_HEADING_CODE = T.SUB_HEADING_CODE
396: and B.LANGUAGE = T.SOURCE_LANG)
397: where (
398: T.SUB_HEADING_CODE,

Line 403: from GR_SUB_HEADINGS_TL SUBB, GR_SUB_HEADINGS_TL SUBT

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

Line 445: INSERT INTO gr_sub_headings_tl

441: OPEN c_get_sub_heading;
442: FETCH c_get_sub_heading INTO SubHdgRecord;
443: IF c_get_sub_heading%NOTFOUND THEN
444: CLOSE c_get_sub_heading;
445: INSERT INTO gr_sub_headings_tl
446: (sub_heading_code,
447: language,
448: sub_heading_desc,
449: source_lang,

Line 551: FROM gr_sub_headings_tl

547:
548: CURSOR c_lock_sub_hdgs_tl
549: IS
550: SELECT *
551: FROM gr_sub_headings_tl
552: WHERE rowid = p_rowid
553: FOR UPDATE NOWAIT;
554: LockSubHdgRcd c_lock_sub_hdgs_tl%ROWTYPE;
555:

Line 690: DELETE FROM gr_sub_headings_tl

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

Line 775: DELETE FROM gr_sub_headings_tl

771: x_oracle_error := 0;
772: x_msg_data := NULL;
773: l_msg_token := p_sub_heading_code;
774:
775: DELETE FROM gr_sub_headings_tl
776: WHERE sub_heading_code = p_sub_heading_code;
777:
778: IF FND_API.To_Boolean(p_commit) THEN
779: COMMIT WORK;

Line 1008: FROM gr_sub_headings_tl sht

1004:
1005: CURSOR c_get_sub_hdgs_tl_rowid
1006: IS
1007: SELECT sht.rowid
1008: FROM gr_sub_headings_tl sht
1009: WHERE sht.sub_heading_code = p_sub_heading_code
1010: AND sht.language = p_language;
1011: HeadingTLRecord c_get_sub_hdgs_tl_rowid%ROWTYPE;
1012:

Line 1054: delete from GR_SUB_HEADINGS_TL T

1050:
1051: procedure NEW_LANGUAGE
1052: is
1053: begin
1054: delete from GR_SUB_HEADINGS_TL T
1055: where not exists
1056: (select NULL
1057: from GR_SUB_HEADINGS_B B
1058: where B.SUB_HEADING_CODE = T.SUB_HEADING_CODE

Line 1061: update GR_SUB_HEADINGS_TL T set (

1057: from GR_SUB_HEADINGS_B B
1058: where B.SUB_HEADING_CODE = T.SUB_HEADING_CODE
1059: );
1060:
1061: update GR_SUB_HEADINGS_TL T set (
1062: SUB_HEADING_DESC
1063: ) = (select
1064: B.SUB_HEADING_DESC
1065: from GR_SUB_HEADINGS_TL B

Line 1065: from GR_SUB_HEADINGS_TL B

1061: update GR_SUB_HEADINGS_TL T set (
1062: SUB_HEADING_DESC
1063: ) = (select
1064: B.SUB_HEADING_DESC
1065: from GR_SUB_HEADINGS_TL B
1066: where B.SUB_HEADING_CODE = T.SUB_HEADING_CODE
1067: and B.LANGUAGE = T.SOURCE_LANG)
1068: where (
1069: T.SUB_HEADING_CODE,

Line 1074: from GR_SUB_HEADINGS_TL SUBB, GR_SUB_HEADINGS_TL SUBT

1070: T.LANGUAGE
1071: ) in (select
1072: SUBT.SUB_HEADING_CODE,
1073: SUBT.LANGUAGE
1074: from GR_SUB_HEADINGS_TL SUBB, GR_SUB_HEADINGS_TL SUBT
1075: where SUBB.SUB_HEADING_CODE = SUBT.SUB_HEADING_CODE
1076: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1077: and (SUBB.SUB_HEADING_DESC <> SUBT.SUB_HEADING_DESC
1078: ));

Line 1080: insert into GR_SUB_HEADINGS_TL (

1076: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1077: and (SUBB.SUB_HEADING_DESC <> SUBT.SUB_HEADING_DESC
1078: ));
1079:
1080: insert into GR_SUB_HEADINGS_TL (
1081: SUB_HEADING_CODE,
1082: SUB_HEADING_DESC,
1083: CREATED_BY,
1084: CREATION_DATE,

Line 1100: from GR_SUB_HEADINGS_TL B, FND_LANGUAGES L

1096: B.LAST_UPDATED_BY,
1097: B.LAST_UPDATE_LOGIN,
1098: L.LANGUAGE_CODE,
1099: B.SOURCE_LANG
1100: from GR_SUB_HEADINGS_TL B, FND_LANGUAGES L
1101: where L.INSTALLED_FLAG in ('I', 'B')
1102: and B.LANGUAGE = userenv('LANG')
1103: and not exists
1104: (select NULL

Line 1105: from GR_SUB_HEADINGS_TL T

1101: where L.INSTALLED_FLAG in ('I', 'B')
1102: and B.LANGUAGE = userenv('LANG')
1103: and not exists
1104: (select NULL
1105: from GR_SUB_HEADINGS_TL T
1106: where T.SUB_HEADING_CODE = B.SUB_HEADING_CODE
1107: and T.LANGUAGE = L.LANGUAGE_CODE);
1108:
1109: end NEW_LANGUAGE;

Line 1111: END GR_SUB_HEADINGS_TL_PKG;

1107: and T.LANGUAGE = L.LANGUAGE_CODE);
1108:
1109: end NEW_LANGUAGE;
1110:
1111: END GR_SUB_HEADINGS_TL_PKG;