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_DOCUMENT_CODES_TL_PKG dependencies on GR_DOCUMENT_CODES

Line 1: PACKAGE BODY GR_DOCUMENT_CODES_TL_PKG AS

1: PACKAGE BODY GR_DOCUMENT_CODES_TL_PKG AS
2: /*$Header: GRHIDCTB.pls 115.11 2002/10/28 19:11:41 mgrosser noship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 76: INSERT INTO gr_document_codes_tl

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

Line 238: UPDATE gr_document_codes_tl

234:
235: IF l_return_status <> 'S' THEN
236: RAISE Foreign_Key_Error;
237: ELSE
238: UPDATE gr_document_codes_tl
239: SET document_code = p_document_code,
240: language = p_language,
241: description = p_description,
242: source_lang = p_source_lang,

Line 352: FROM gr_document_codes_tl eit

348: eit.creation_date,
349: eit.last_updated_by,
350: eit.last_update_date,
351: eit.last_update_login
352: FROM gr_document_codes_tl eit
353: WHERE eit.document_code = p_document_code
354: AND eit.language = l_language;
355: TypeDesc c_get_descs%ROWTYPE;
356:

Line 376: delete from GR_DOCUMENT_CODES_TL T

372: l_msg_token := p_document_code || ' ' || p_language;
373:
374: /* Remove translations with no base row */
375:
376: delete from GR_DOCUMENT_CODES_TL T
377: where not exists
378: (select NULL
379: from GR_DOCUMENT_CODES B
380: where B.DOCUMENT_CODE = T.DOCUMENT_CODE

Line 379: from GR_DOCUMENT_CODES B

375:
376: delete from GR_DOCUMENT_CODES_TL T
377: where not exists
378: (select NULL
379: from GR_DOCUMENT_CODES B
380: where B.DOCUMENT_CODE = T.DOCUMENT_CODE
381: );
382:
383: /* Redefault translations from the source language */

Line 386: Changed the inner query from GR_DOCUMENT_CODES to GR_DOCUMENT_CODES_TL.

382:
383: /* Redefault translations from the source language */
384:
385: /* 15-Aug-2001 Mercy Thomas 1926634
386: Changed the inner query from GR_DOCUMENT_CODES to GR_DOCUMENT_CODES_TL.
387: Added the condition B.LANGUAGE = T.SOURCE_LANG
388: And changed the column from DOCUMENT_DESCRIPTION to DESCRIPTION */
389:
390: update gr_document_codes_tl t set (

Line 390: update gr_document_codes_tl t set (

386: Changed the inner query from GR_DOCUMENT_CODES to GR_DOCUMENT_CODES_TL.
387: Added the condition B.LANGUAGE = T.SOURCE_LANG
388: And changed the column from DOCUMENT_DESCRIPTION to DESCRIPTION */
389:
390: update gr_document_codes_tl t set (
391: description ) =
392: ( select
393: B.DESCRIPTION
394: from GR_DOCUMENT_CODES_TL B

Line 394: from GR_DOCUMENT_CODES_TL B

390: update gr_document_codes_tl t set (
391: description ) =
392: ( select
393: B.DESCRIPTION
394: from GR_DOCUMENT_CODES_TL B
395: where B.DOCUMENT_CODE = T.DOCUMENT_CODE
396: and B.LANGUAGE = T.SOURCE_LANG)
397: where (
398: T.DOCUMENT_CODE,

Line 403: from GR_DOCUMENT_CODES_TL SUBB, GR_DOCUMENT_CODES_TL SUBT

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

Line 445: INSERT INTO gr_document_codes_tl

441: OPEN c_get_descs;
442: FETCH c_get_descs INTO TypeDesc;
443: IF c_get_descs%NOTFOUND THEN
444: CLOSE c_get_descs;
445: INSERT INTO gr_document_codes_tl
446: (document_code,
447: language,
448: description,
449: source_lang,

Line 552: FROM gr_document_codes_tl

548:
549: CURSOR c_lock_ein_number
550: IS
551: SELECT last_update_date
552: FROM gr_document_codes_tl
553: WHERE rowid = p_rowid
554: FOR UPDATE NOWAIT;
555: LockEinRcd c_lock_ein_number%ROWTYPE;
556: BEGIN

Line 683: DELETE FROM gr_document_codes_tl

679: IF l_return_status <> 'S' THEN
680: RAISE Check_Integrity_Error;
681: END IF;
682:
683: DELETE FROM gr_document_codes_tl
684: WHERE rowid = p_rowid;
685:
686: /* Check the commit flag and if set, then commit the work. */
687:

Line 768: DELETE FROM gr_document_codes_tl

764: x_oracle_error := 0;
765: x_msg_data := NULL;
766: l_msg_token := p_document_code;
767:
768: DELETE FROM gr_document_codes_tl
769: WHERE document_code = p_document_code;
770:
771: IF FND_API.To_Boolean(p_commit) THEN
772: COMMIT WORK;

Line 989: FROM gr_document_codes_tl ein

985:
986: CURSOR c_get_ein_rowid
987: IS
988: SELECT ein.rowid
989: FROM gr_document_codes_tl ein
990: WHERE ein.document_code = p_document_code
991: AND ein.language = p_language;
992: EinRecord c_get_ein_rowid%ROWTYPE;
993:

Line 1029: UPDATE GR_DOCUMENT_CODES_TL SET

1025: ,X_DESCRIPTION IN VARCHAR2
1026: ,X_SOURCE_LANG IN VARCHAR2
1027: ) IS
1028: BEGIN
1029: UPDATE GR_DOCUMENT_CODES_TL SET
1030: DESCRIPTION = X_DESCRIPTION,
1031: SOURCE_LANG = USERENV('LANG'),
1032: LAST_UPDATE_DATE = sysdate,
1033: LAST_UPDATED_BY = 0,

Line 1048: FROM GR_DOCUMENT_CODES_TL

1044: ,X_SOURCE_LANG IN VARCHAR2
1045: ) IS
1046: CURSOR Cur_rowid IS
1047: SELECT rowid
1048: FROM GR_DOCUMENT_CODES_TL
1049: WHERE (DOCUMENT_CODE = X_DOCUMENT_CODE)
1050: AND (LANGUAGE = X_LANGUAGE);
1051: l_user_id NUMBER DEFAULT 1;
1052: l_row_id VARCHAR2(64);

Line 1060: GR_DOCUMENT_CODES_TL_PKG.UPDATE_ROW(

1056: BEGIN
1057: OPEN Cur_rowid;
1058: FETCH Cur_rowid INTO l_row_id;
1059: IF Cur_rowid%FOUND THEN
1060: GR_DOCUMENT_CODES_TL_PKG.UPDATE_ROW(
1061: P_COMMIT => 'T'
1062: ,P_CALLED_BY_FORM => 'F'
1063: ,P_ROWID => l_row_id
1064: ,P_DOCUMENT_CODE => X_DOCUMENT_CODE

Line 1077: GR_DOCUMENT_CODES_TL_PKG.INSERT_ROW(

1073: ,X_RETURN_STATUS => l_return_status
1074: ,X_ORACLE_ERROR => l_oracle_error
1075: ,X_MSG_DATA => l_msg_data);
1076: ELSE
1077: GR_DOCUMENT_CODES_TL_PKG.INSERT_ROW(
1078: P_COMMIT => 'T'
1079: ,P_CALLED_BY_FORM => 'F'
1080: ,P_DOCUMENT_CODE => X_DOCUMENT_CODE
1081: ,P_LANGUAGE => X_LANGUAGE

Line 1108: delete from GR_DOCUMENT_CODES_TL T

1104:
1105: procedure NEW_LANGUAGE
1106: is
1107: begin
1108: delete from GR_DOCUMENT_CODES_TL T
1109: where not exists
1110: (select NULL
1111: from GR_DOCUMENT_CODES B
1112: where B.DOCUMENT_CODE = T.DOCUMENT_CODE

Line 1111: from GR_DOCUMENT_CODES B

1107: begin
1108: delete from GR_DOCUMENT_CODES_TL T
1109: where not exists
1110: (select NULL
1111: from GR_DOCUMENT_CODES B
1112: where B.DOCUMENT_CODE = T.DOCUMENT_CODE
1113: );
1114:
1115: update GR_DOCUMENT_CODES_TL T set (

Line 1115: update GR_DOCUMENT_CODES_TL T set (

1111: from GR_DOCUMENT_CODES B
1112: where B.DOCUMENT_CODE = T.DOCUMENT_CODE
1113: );
1114:
1115: update GR_DOCUMENT_CODES_TL T set (
1116: DESCRIPTION
1117: ) = (select
1118: B.DESCRIPTION
1119: from GR_DOCUMENT_CODES_TL B

Line 1119: from GR_DOCUMENT_CODES_TL B

1115: update GR_DOCUMENT_CODES_TL T set (
1116: DESCRIPTION
1117: ) = (select
1118: B.DESCRIPTION
1119: from GR_DOCUMENT_CODES_TL B
1120: where B.DOCUMENT_CODE = T.DOCUMENT_CODE
1121: and B.LANGUAGE = T.SOURCE_LANG)
1122: where (
1123: T.DOCUMENT_CODE,

Line 1128: from GR_DOCUMENT_CODES_TL SUBB, GR_DOCUMENT_CODES_TL SUBT

1124: T.LANGUAGE
1125: ) in (select
1126: SUBT.DOCUMENT_CODE,
1127: SUBT.LANGUAGE
1128: from GR_DOCUMENT_CODES_TL SUBB, GR_DOCUMENT_CODES_TL SUBT
1129: where SUBB.DOCUMENT_CODE = SUBT.DOCUMENT_CODE
1130: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1131: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
1132: ));

Line 1134: insert into GR_DOCUMENT_CODES_TL (

1130: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1131: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
1132: ));
1133:
1134: insert into GR_DOCUMENT_CODES_TL (
1135: DOCUMENT_CODE,
1136: DESCRIPTION,
1137: CREATED_BY,
1138: CREATION_DATE,

Line 1154: from GR_DOCUMENT_CODES_TL B, FND_LANGUAGES L

1150: B.LAST_UPDATE_DATE,
1151: B.LAST_UPDATE_LOGIN,
1152: L.LANGUAGE_CODE,
1153: B.SOURCE_LANG
1154: from GR_DOCUMENT_CODES_TL B, FND_LANGUAGES L
1155: where L.INSTALLED_FLAG in ('I', 'B')
1156: and B.LANGUAGE = userenv('LANG')
1157: and not exists
1158: (select NULL

Line 1159: from GR_DOCUMENT_CODES_TL T

1155: where L.INSTALLED_FLAG in ('I', 'B')
1156: and B.LANGUAGE = userenv('LANG')
1157: and not exists
1158: (select NULL
1159: from GR_DOCUMENT_CODES_TL T
1160: where T.DOCUMENT_CODE = B.DOCUMENT_CODE
1161: and T.LANGUAGE = L.LANGUAGE_CODE);
1162:
1163: end NEW_LANGUAGE;

Line 1165: END GR_DOCUMENT_CODES_TL_PKG;

1161: and T.LANGUAGE = L.LANGUAGE_CODE);
1162:
1163: end NEW_LANGUAGE;
1164:
1165: END GR_DOCUMENT_CODES_TL_PKG;