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_EXPOSURE_TYPES_TL_PKG dependencies on GR_EXPOSURE_TYPES_TL

Line 1: PACKAGE BODY GR_EXPOSURE_TYPES_TL_PKG AS

1: PACKAGE BODY GR_EXPOSURE_TYPES_TL_PKG AS
2: /*$Header: GRHIETTB.pls 115.11 2002/10/29 20:47:52 mgrosser ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 75: INSERT INTO gr_exposure_types_tl

71: IF FND_API.To_Boolean(l_key_exists) THEN
72: RAISE Item_Exists_Error;
73: END IF;
74:
75: INSERT INTO gr_exposure_types_tl
76: (exposure_type_code,
77: language,
78: source_lang,
79: exposure_type_desc,

Line 242: UPDATE gr_exposure_types_tl

238:
239: IF l_return_status <> 'S' THEN
240: RAISE Foreign_Key_Error;
241: ELSE
242: UPDATE gr_exposure_types_tl
243: SET exposure_type_code = p_exposure_type_code,
244: language = p_language,
245: source_lang = p_source_lang,
246: exposure_type_desc = p_exposure_type_desc,

Line 355: FROM gr_exposure_types_tl ett

351: ett.creation_date,
352: ett.last_updated_by,
353: ett.last_update_date,
354: ett.last_update_login
355: FROM gr_exposure_types_tl ett
356: WHERE ett.exposure_type_code = p_exposure_type_code
357: AND ett.language = l_language;
358: TypeDesc c_get_descs%ROWTYPE;
359:

Line 379: delete from GR_EXPOSURE_TYPES_TL T

375: l_msg_token := p_exposure_type_code || ' ' || p_language;
376:
377: /* Remove translations with no base row */
378:
379: delete from GR_EXPOSURE_TYPES_TL T
380: where not exists
381: (select NULL
382: from GR_EXPOSURE_TYPES_B B
383: where B.EXPOSURE_TYPE_CODE = T.EXPOSURE_TYPE_CODE

Line 388: update gr_exposure_types_tl t set (

384: );
385:
386: /* Redefault translations from the source language */
387:
388: update gr_exposure_types_tl t set (
389: exposure_type_desc ) =
390: ( select
391: B.EXPOSURE_TYPE_DESC
392: from GR_EXPOSURE_TYPES_TL B

Line 392: from GR_EXPOSURE_TYPES_TL B

388: update gr_exposure_types_tl t set (
389: exposure_type_desc ) =
390: ( select
391: B.EXPOSURE_TYPE_DESC
392: from GR_EXPOSURE_TYPES_TL B
393: where B.EXPOSURE_TYPE_CODE = T.EXPOSURE_TYPE_CODE
394: and B.LANGUAGE = T.SOURCE_LANG)
395: where (
396: T.EXPOSURE_TYPE_CODE,

Line 401: from GR_EXPOSURE_TYPES_TL SUBB, GR_EXPOSURE_TYPES_TL SUBT

397: T.LANGUAGE
398: ) in (select
399: SUBT.EXPOSURE_TYPE_CODE,
400: SUBT.LANGUAGE
401: from GR_EXPOSURE_TYPES_TL SUBB, GR_EXPOSURE_TYPES_TL SUBT
402: where SUBB.EXPOSURE_TYPE_CODE = SUBT.EXPOSURE_TYPE_CODE
403: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
404: and (SUBB.EXPOSURE_TYPE_DESC <> SUBT.EXPOSURE_TYPE_DESC
405: or (SUBB.EXPOSURE_TYPE_DESC is null and SUBT.EXPOSURE_TYPE_DESC is not null)

Line 443: INSERT INTO gr_exposure_types_tl

439: OPEN c_get_descs;
440: FETCH c_get_descs INTO TypeDesc;
441: IF c_get_descs%NOTFOUND THEN
442: CLOSE c_get_descs;
443: INSERT INTO gr_exposure_types_tl
444: (exposure_type_code,
445: language,
446: exposure_type_desc,
447: source_lang,

Line 549: FROM gr_exposure_types_tl

545:
546: CURSOR c_lock_types_tl
547: IS
548: SELECT last_update_date
549: FROM gr_exposure_types_tl
550: WHERE rowid = p_rowid
551: FOR UPDATE NOWAIT;
552: LockTypeRcd c_lock_types_tl%ROWTYPE;
553: BEGIN

Line 699: DELETE FROM gr_exposure_types_tl

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

Line 783: DELETE FROM gr_exposure_types_tl

779: x_oracle_error := 0;
780: x_msg_data := NULL;
781: l_msg_token := p_exposure_type_code;
782:
783: DELETE FROM gr_exposure_types_tl
784: WHERE exposure_type_code = p_exposure_type_code;
785:
786: IF FND_API.To_Boolean(p_commit) THEN
787: COMMIT WORK;

Line 1013: FROM gr_exposure_types_tl ett

1009:
1010: CURSOR c_get_types_tl_rowid
1011: IS
1012: SELECT ett.rowid
1013: FROM gr_exposure_types_tl ett
1014: WHERE ett.exposure_type_code = p_exposure_type_code
1015: AND ett.language = p_language;
1016: TypeTLRecord c_get_types_tl_rowid%ROWTYPE;
1017:

Line 1055: UPDATE GR_EXPOSURE_TYPES_TL SET

1051: ,X_EXPOSURE_TYPE_DESC IN VARCHAR2
1052: ,X_SOURCE_LANG IN VARCHAR2
1053: ) IS
1054: BEGIN
1055: UPDATE GR_EXPOSURE_TYPES_TL SET
1056: EXPOSURE_TYPE_DESC = X_EXPOSURE_TYPE_DESC,
1057: SOURCE_LANG = USERENV('LANG'),
1058: LAST_UPDATE_DATE = sysdate,
1059: LAST_UPDATED_BY = 0,

Line 1074: FROM GR_EXPOSURE_TYPES_TL

1070: ,X_SOURCE_LANG IN VARCHAR2
1071: ) IS
1072: CURSOR Cur_rowid IS
1073: SELECT rowid
1074: FROM GR_EXPOSURE_TYPES_TL
1075: WHERE (EXPOSURE_TYPE_CODE = X_EXPOSURE_TYPE_CODE)
1076: AND (LANGUAGE = X_LANGUAGE);
1077: l_user_id NUMBER DEFAULT 1;
1078: l_row_id VARCHAR2(64);

Line 1086: GR_EXPOSURE_TYPES_TL_PKG.UPDATE_ROW(

1082: BEGIN
1083: OPEN Cur_rowid;
1084: FETCH Cur_rowid INTO l_row_id;
1085: IF Cur_rowid%FOUND THEN
1086: GR_EXPOSURE_TYPES_TL_PKG.UPDATE_ROW(
1087: P_COMMIT => 'T'
1088: ,P_CALLED_BY_FORM => 'F'
1089: ,P_ROWID => l_row_id
1090: ,P_EXPOSURE_TYPE_CODE => X_EXPOSURE_TYPE_CODE

Line 1103: GR_EXPOSURE_TYPES_TL_PKG.INSERT_ROW(

1099: ,X_RETURN_STATUS => l_return_status
1100: ,X_ORACLE_ERROR => l_oracle_error
1101: ,X_MSG_DATA => l_msg_data);
1102: ELSE
1103: GR_EXPOSURE_TYPES_TL_PKG.INSERT_ROW(
1104: P_COMMIT => 'T'
1105: ,P_CALLED_BY_FORM => 'F'
1106: ,P_EXPOSURE_TYPE_CODE => X_EXPOSURE_TYPE_CODE
1107: ,P_LANGUAGE => X_LANGUAGE

Line 1131: delete from GR_EXPOSURE_TYPES_TL T

1127: */
1128: procedure NEW_LANGUAGE
1129: is
1130: begin
1131: delete from GR_EXPOSURE_TYPES_TL T
1132: where not exists
1133: (select NULL
1134: from GR_EXPOSURE_TYPES_B B
1135: where B.EXPOSURE_TYPE_CODE = T.EXPOSURE_TYPE_CODE

Line 1138: update GR_EXPOSURE_TYPES_TL T set (

1134: from GR_EXPOSURE_TYPES_B B
1135: where B.EXPOSURE_TYPE_CODE = T.EXPOSURE_TYPE_CODE
1136: );
1137:
1138: update GR_EXPOSURE_TYPES_TL T set (
1139: EXPOSURE_TYPE_DESC
1140: ) = (select
1141: B.EXPOSURE_TYPE_DESC
1142: from GR_EXPOSURE_TYPES_TL B

Line 1142: from GR_EXPOSURE_TYPES_TL B

1138: update GR_EXPOSURE_TYPES_TL T set (
1139: EXPOSURE_TYPE_DESC
1140: ) = (select
1141: B.EXPOSURE_TYPE_DESC
1142: from GR_EXPOSURE_TYPES_TL B
1143: where B.EXPOSURE_TYPE_CODE = T.EXPOSURE_TYPE_CODE
1144: and B.LANGUAGE = T.SOURCE_LANG)
1145: where (
1146: T.EXPOSURE_TYPE_CODE,

Line 1151: from GR_EXPOSURE_TYPES_TL SUBB, GR_EXPOSURE_TYPES_TL SUBT

1147: T.LANGUAGE
1148: ) in (select
1149: SUBT.EXPOSURE_TYPE_CODE,
1150: SUBT.LANGUAGE
1151: from GR_EXPOSURE_TYPES_TL SUBB, GR_EXPOSURE_TYPES_TL SUBT
1152: where SUBB.EXPOSURE_TYPE_CODE = SUBT.EXPOSURE_TYPE_CODE
1153: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1154: and (SUBB.EXPOSURE_TYPE_DESC <> SUBT.EXPOSURE_TYPE_DESC
1155: ));

Line 1157: insert into GR_EXPOSURE_TYPES_TL (

1153: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1154: and (SUBB.EXPOSURE_TYPE_DESC <> SUBT.EXPOSURE_TYPE_DESC
1155: ));
1156:
1157: insert into GR_EXPOSURE_TYPES_TL (
1158: EXPOSURE_TYPE_CODE,
1159: EXPOSURE_TYPE_DESC,
1160: CREATED_BY,
1161: CREATION_DATE,

Line 1177: from GR_EXPOSURE_TYPES_TL B, FND_LANGUAGES L

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

Line 1182: from GR_EXPOSURE_TYPES_TL T

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

Line 1189: END GR_EXPOSURE_TYPES_TL_PKG;

1185:
1186: end NEW_LANGUAGE;
1187:
1188:
1189: END GR_EXPOSURE_TYPES_TL_PKG;