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_COVER_LETTERS_TL_PKG dependencies on GR_COVER_LETTERS_TL

Line 1: PACKAGE BODY GR_COVER_LETTERS_TL_PKG AS

1: PACKAGE BODY GR_COVER_LETTERS_TL_PKG AS
2: /*$Header: GRHICLTB.pls 115.8 2002/10/24 22:13:12 mgrosser ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 78: INSERT INTO gr_cover_letters_tl

74: IF FND_API.To_Boolean(l_key_exists) THEN
75: RAISE Item_Exists_Error;
76: END IF;
77:
78: INSERT INTO gr_cover_letters_tl
79: (cover_letter_id,
80: description,
81: text,
82: language,

Line 250: UPDATE gr_cover_letters_tl

246:
247: IF l_return_status <> 'S' THEN
248: RAISE Foreign_Key_Error;
249: ELSE
250: UPDATE gr_cover_letters_tl
251: SET cover_letter_id = p_cover_letter_id,
252: description = p_description,
253: text = p_text,
254: language = p_language,

Line 339: L_BASE_DESC GR_COVER_LETTERS_TL.description%TYPE;

335:
336: L_RETURN_STATUS VARCHAR2(1) := 'S';
337: L_MSG_DATA VARCHAR2(2000);
338: L_MSG_TOKEN VARCHAR2(100);
339: L_BASE_DESC GR_COVER_LETTERS_TL.description%TYPE;
340: L_BASE_TEXT GR_COVER_LETTERS_TL.text%TYPE;
341: L_LANGUAGE VARCHAR2(4);
342: L_CREATION_DATE DATE;
343: L_LAST_UPDATE_DATE DATE;

Line 340: L_BASE_TEXT GR_COVER_LETTERS_TL.text%TYPE;

336: L_RETURN_STATUS VARCHAR2(1) := 'S';
337: L_MSG_DATA VARCHAR2(2000);
338: L_MSG_TOKEN VARCHAR2(100);
339: L_BASE_DESC GR_COVER_LETTERS_TL.description%TYPE;
340: L_BASE_TEXT GR_COVER_LETTERS_TL.text%TYPE;
341: L_LANGUAGE VARCHAR2(4);
342: L_CREATION_DATE DATE;
343: L_LAST_UPDATE_DATE DATE;
344: /*

Line 367: FROM gr_cover_letters_tl clt

363: clt.creation_date,
364: clt.last_updated_by,
365: clt.last_update_date,
366: clt.last_update_login
367: FROM gr_cover_letters_tl clt
368: WHERE clt.cover_letter_id = p_cover_letter_id
369: AND clt.language = l_language;
370: CoverLetter c_get_cover_letter%ROWTYPE;
371:

Line 392: delete from GR_COVER_LETTERS_TL T

388: l_msg_token := p_cover_letter_id || ' ' || p_language;
389:
390: /* Remove translations with no base row */
391:
392: delete from GR_COVER_LETTERS_TL T
393: where not exists
394: (select NULL
395: from GR_COVER_LETTERS_B B
396: where B.COVER_LETTER_ID = T.COVER_LETTER_ID

Line 401: update gr_cover_letters_tl t set (

397: );
398:
399: /* Redefault translations from the source language */
400:
401: update gr_cover_letters_tl t set (
402: description,
403: text ) =
404: ( select
405: B.DESCRIPTION,

Line 407: from GR_COVER_LETTERS_TL B

403: text ) =
404: ( select
405: B.DESCRIPTION,
406: B.TEXT
407: from GR_COVER_LETTERS_TL B
408: where B.COVER_LETTER_ID = T.COVER_LETTER_ID
409: and B.LANGUAGE = T.SOURCE_LANG)
410: where (
411: T.COVER_LETTER_ID,

Line 416: from GR_COVER_LETTERS_TL SUBB, GR_COVER_LETTERS_TL SUBT

412: T.LANGUAGE
413: ) in (select
414: SUBT.COVER_LETTER_ID,
415: SUBT.LANGUAGE
416: from GR_COVER_LETTERS_TL SUBB, GR_COVER_LETTERS_TL SUBT
417: where SUBB.COVER_LETTER_ID = SUBT.COVER_LETTER_ID
418: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
419: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
420: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 462: INSERT INTO gr_cover_letters_tl

458: OPEN c_get_cover_letter;
459: FETCH c_get_cover_letter INTO CoverLetter;
460: IF c_get_cover_letter%NOTFOUND THEN
461: CLOSE c_get_cover_letter;
462: INSERT INTO gr_cover_letters_tl
463: (cover_letter_id,
464: description,
465: text,
466: language,

Line 572: FROM gr_cover_letters_tl

568:
569: CURSOR c_lock_letters_tl
570: IS
571: SELECT *
572: FROM gr_cover_letters_tl
573: WHERE rowid = p_rowid
574: FOR UPDATE NOWAIT;
575: LockLetterRcd c_lock_letters_tl%ROWTYPE;
576:

Line 714: DELETE FROM gr_cover_letters_tl

710: IF l_return_status <> 'S' THEN
711: RAISE Check_Integrity_Error;
712: END IF;
713:
714: DELETE FROM gr_cover_letters_tl
715: WHERE rowid = p_rowid;
716:
717: /* Check the commit flag and if set, then commit the work. */
718:

Line 799: DELETE FROM gr_cover_letters_tl

795: x_oracle_error := 0;
796: x_msg_data := NULL;
797: l_msg_token := p_cover_letter_id;
798:
799: DELETE FROM gr_cover_letters_tl
800: WHERE cover_letter_id = p_cover_letter_id;
801:
802: IF FND_API.To_Boolean(p_commit) THEN
803: COMMIT WORK;

Line 1037: FROM gr_cover_letters_tl clt

1033:
1034: CURSOR c_get_letters_tl_rowid
1035: IS
1036: SELECT clt.rowid
1037: FROM gr_cover_letters_tl clt
1038: WHERE clt.cover_letter_id = p_cover_letter_id
1039: AND clt.language = p_language;
1040: LetterTLRecord c_get_letters_tl_rowid%ROWTYPE;
1041:

Line 1080: UPDATE GR_COVER_LETTERS_TL SET

1076: ,X_LANGUAGE IN VARCHAR2
1077: ,X_SOURCE_LANG IN VARCHAR2
1078: ) IS
1079: BEGIN
1080: UPDATE GR_COVER_LETTERS_TL SET
1081: DESCRIPTION = X_DESCRIPTION,
1082: SOURCE_LANG = USERENV('LANG'),
1083: LAST_UPDATE_DATE = sysdate,
1084: LAST_UPDATED_BY = 0,

Line 1100: FROM GR_COVER_LETTERS_TL

1096: ,X_SOURCE_LANG IN VARCHAR2
1097: ) IS
1098: CURSOR Cur_rowid IS
1099: SELECT rowid
1100: FROM GR_COVER_LETTERS_TL
1101: WHERE (COVER_LETTER_ID = X_COVER_LETTER_ID)
1102: AND (LANGUAGE = X_LANGUAGE);
1103: l_user_id NUMBER DEFAULT 1;
1104: l_row_id VARCHAR2(64);

Line 1112: GR_COVER_LETTERS_TL_PKG.UPDATE_ROW(

1108: BEGIN
1109: OPEN Cur_rowid;
1110: FETCH Cur_rowid INTO l_row_id;
1111: IF Cur_rowid%FOUND THEN
1112: GR_COVER_LETTERS_TL_PKG.UPDATE_ROW(
1113: P_COMMIT => 'T'
1114: ,P_CALLED_BY_FORM => 'F'
1115: ,P_ROWID => l_row_id
1116: ,P_COVER_LETTER_ID => X_COVER_LETTER_ID

Line 1130: GR_COVER_LETTERS_TL_PKG.INSERT_ROW(

1126: ,X_RETURN_STATUS => l_return_status
1127: ,X_ORACLE_ERROR => l_oracle_error
1128: ,X_MSG_DATA => l_msg_data);
1129: ELSE
1130: GR_COVER_LETTERS_TL_PKG.INSERT_ROW(
1131: P_COMMIT => 'T'
1132: ,P_CALLED_BY_FORM => 'F'
1133: ,P_COVER_LETTER_ID => X_COVER_LETTER_ID
1134: ,P_DESCRIPTION => X_DESCRIPTION

Line 1159: delete from GR_COVER_LETTERS_TL T

1155: */
1156: procedure NEW_LANGUAGE
1157: is
1158: begin
1159: delete from GR_COVER_LETTERS_TL T
1160: where not exists
1161: (select NULL
1162: from GR_COVER_LETTERS_B B
1163: where B.COVER_LETTER_ID = T.COVER_LETTER_ID

Line 1166: update GR_COVER_LETTERS_TL T set (

1162: from GR_COVER_LETTERS_B B
1163: where B.COVER_LETTER_ID = T.COVER_LETTER_ID
1164: );
1165:
1166: update GR_COVER_LETTERS_TL T set (
1167: DESCRIPTION,
1168: TEXT
1169: ) = (select
1170: B.DESCRIPTION,

Line 1172: from GR_COVER_LETTERS_TL B

1168: TEXT
1169: ) = (select
1170: B.DESCRIPTION,
1171: B.TEXT
1172: from GR_COVER_LETTERS_TL B
1173: where B.COVER_LETTER_ID = T.COVER_LETTER_ID
1174: and B.LANGUAGE = T.SOURCE_LANG)
1175: where (
1176: T.COVER_LETTER_ID,

Line 1181: from GR_COVER_LETTERS_TL SUBB, GR_COVER_LETTERS_TL SUBT

1177: T.LANGUAGE
1178: ) in (select
1179: SUBT.COVER_LETTER_ID,
1180: SUBT.LANGUAGE
1181: from GR_COVER_LETTERS_TL SUBB, GR_COVER_LETTERS_TL SUBT
1182: where SUBB.COVER_LETTER_ID = SUBT.COVER_LETTER_ID
1183: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1184: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
1185: or SUBB.TEXT <> SUBT.TEXT

Line 1190: insert into GR_COVER_LETTERS_TL (

1186: or (SUBB.TEXT is null and SUBT.TEXT is not null)
1187: or (SUBB.TEXT is not null and SUBT.TEXT is null)
1188: ));
1189:
1190: insert into GR_COVER_LETTERS_TL (
1191: COVER_LETTER_ID,
1192: DESCRIPTION,
1193: TEXT,
1194: CREATED_BY,

Line 1212: from GR_COVER_LETTERS_TL B, FND_LANGUAGES L

1208: B.LAST_UPDATED_BY,
1209: B.LAST_UPDATE_LOGIN,
1210: L.LANGUAGE_CODE,
1211: B.SOURCE_LANG
1212: from GR_COVER_LETTERS_TL B, FND_LANGUAGES L
1213: where L.INSTALLED_FLAG in ('I', 'B')
1214: and B.LANGUAGE = userenv('LANG')
1215: and not exists
1216: (select NULL

Line 1217: from GR_COVER_LETTERS_TL T

1213: where L.INSTALLED_FLAG in ('I', 'B')
1214: and B.LANGUAGE = userenv('LANG')
1215: and not exists
1216: (select NULL
1217: from GR_COVER_LETTERS_TL T
1218: where T.COVER_LETTER_ID = B.COVER_LETTER_ID
1219: and T.LANGUAGE = L.LANGUAGE_CODE);
1220:
1221: end NEW_LANGUAGE;

Line 1225: END GR_COVER_LETTERS_TL_PKG;

1221: end NEW_LANGUAGE;
1222:
1223:
1224:
1225: END GR_COVER_LETTERS_TL_PKG;