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_AUTHS_TL_PKG dependencies on GR_EXPOSURE_AUTHS_TL

Line 1: PACKAGE BODY GR_EXPOSURE_AUTHS_TL_PKG AS

1: PACKAGE BODY GR_EXPOSURE_AUTHS_TL_PKG AS
2: /*$Header: GRHIEATB.pls 115.12 2002/10/29 20:45:25 mgrosser ship $*/
3:
4: PROCEDURE Insert_Row
5: (p_commit IN VARCHAR2,

Line 77: INSERT INTO gr_exposure_auths_tl

73: IF FND_API.To_Boolean(l_key_exists) THEN
74: RAISE Item_Exists_Error;
75: END IF;
76:
77: INSERT INTO gr_exposure_auths_tl
78: (exposure_authority_code,
79: language,
80: source_lang,
81: exposure_authority_desc,

Line 243: UPDATE gr_exposure_auths_tl

239:
240: IF l_return_status <> 'S' THEN
241: RAISE Foreign_Key_Error;
242: ELSE
243: UPDATE gr_exposure_auths_tl
244: SET exposure_authority_code = p_exposure_authority_code,
245: language = p_language,
246: source_lang = p_source_lang,
247: exposure_authority_desc = p_exposure_authority_desc,

Line 358: FROM gr_exposure_auths_tl eat

354: eat.creation_date,
355: eat.last_updated_by,
356: eat.last_update_date,
357: eat.last_update_login
358: FROM gr_exposure_auths_tl eat
359: WHERE eat.exposure_authority_code = p_exposure_authority_code
360: AND eat.language = l_language;
361: AuthDesc c_get_descs%ROWTYPE;
362:

Line 383: delete from GR_EXPOSURE_AUTHS_TL T

379: l_msg_token := p_exposure_authority_code || ' ' || p_language;
380:
381: /* Remove translations with no base row */
382:
383: delete from GR_EXPOSURE_AUTHS_TL T
384: where not exists
385: (select NULL
386: from GR_EXPOSURE_AUTHS_B B
387: where B.EXPOSURE_AUTHORITY_CODE = T.EXPOSURE_AUTHORITY_CODE

Line 392: update gr_exposure_auths_tl t set (

388: );
389:
390: /* Redefault translations from the source language */
391:
392: update gr_exposure_auths_tl t set (
393: exposure_authority_desc ) =
394: ( select
395: B.EXPOSURE_AUTHORITY_DESC
396: from GR_EXPOSURE_AUTHS_TL B

Line 396: from GR_EXPOSURE_AUTHS_TL B

392: update gr_exposure_auths_tl t set (
393: exposure_authority_desc ) =
394: ( select
395: B.EXPOSURE_AUTHORITY_DESC
396: from GR_EXPOSURE_AUTHS_TL B
397: where B.EXPOSURE_AUTHORITY_CODE = T.EXPOSURE_AUTHORITY_CODE
398: and B.LANGUAGE = T.SOURCE_LANG)
399: where (
400: T.EXPOSURE_AUTHORITY_CODE,

Line 405: from GR_EXPOSURE_AUTHS_TL SUBB, GR_EXPOSURE_AUTHS_TL SUBT

401: T.LANGUAGE
402: ) in (select
403: SUBT.EXPOSURE_AUTHORITY_CODE,
404: SUBT.LANGUAGE
405: from GR_EXPOSURE_AUTHS_TL SUBB, GR_EXPOSURE_AUTHS_TL SUBT
406: where SUBB.EXPOSURE_AUTHORITY_CODE = SUBT.EXPOSURE_AUTHORITY_CODE
407: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
408: and (SUBB.EXPOSURE_AUTHORITY_DESC <> SUBT.EXPOSURE_AUTHORITY_DESC
409: or (SUBB.EXPOSURE_AUTHORITY_DESC is null and SUBT.EXPOSURE_AUTHORITY_DESC is not null)

Line 448: INSERT INTO gr_exposure_auths_tl

444: OPEN c_get_descs;
445: FETCH c_get_descs INTO AuthDesc;
446: IF c_get_descs%NOTFOUND THEN
447: CLOSE c_get_descs;
448: INSERT INTO gr_exposure_auths_tl
449: (exposure_authority_code,
450: language,
451: exposure_authority_desc,
452: source_lang,

Line 554: FROM gr_exposure_auths_tl

550:
551: CURSOR c_lock_auths_tl
552: IS
553: SELECT last_update_date
554: FROM gr_exposure_auths_tl
555: WHERE rowid = p_rowid
556: FOR UPDATE NOWAIT;
557: LockAuthRcd c_lock_auths_tl%ROWTYPE;
558: BEGIN

Line 704: DELETE FROM gr_exposure_auths_tl

700: IF l_return_status <> 'S' THEN
701: RAISE Check_Integrity_Error;
702: END IF;
703:
704: DELETE FROM gr_exposure_auths_tl
705: WHERE rowid = p_rowid;
706:
707: /* Check the commit flag and if set, then commit the work. */
708:

Line 790: DELETE FROM gr_exposure_auths_tl

786: x_oracle_error := 0;
787: x_msg_data := NULL;
788: l_msg_token := p_exposure_authority_code;
789:
790: DELETE FROM gr_exposure_auths_tl
791: WHERE exposure_authority_code = p_exposure_authority_code;
792:
793: IF FND_API.To_Boolean(p_commit) THEN
794: COMMIT WORK;

Line 1023: FROM gr_exposure_auths_tl eat

1019:
1020: CURSOR c_get_auths_tl_rowid
1021: IS
1022: SELECT eat.rowid
1023: FROM gr_exposure_auths_tl eat
1024: WHERE eat.exposure_authority_code = p_exposure_authority_code
1025: AND eat.language = p_language;
1026: AuthTLRecord c_get_auths_tl_rowid%ROWTYPE;
1027:

Line 1065: UPDATE GR_EXPOSURE_AUTHS_TL SET

1061: ,X_EXPOSURE_AUTHORITY_DESC IN VARCHAR2
1062: ,X_SOURCE_LANG IN VARCHAR2
1063: ) IS
1064: BEGIN
1065: UPDATE GR_EXPOSURE_AUTHS_TL SET
1066: EXPOSURE_AUTHORITY_DESC = X_EXPOSURE_AUTHORITY_DESC,
1067: SOURCE_LANG = USERENV('LANG'),
1068: LAST_UPDATE_DATE = sysdate,
1069: LAST_UPDATED_BY = 0,

Line 1084: FROM GR_EXPOSURE_AUTHS_TL

1080: ,X_SOURCE_LANG IN VARCHAR2
1081: ) IS
1082: CURSOR Cur_rowid IS
1083: SELECT rowid
1084: FROM GR_EXPOSURE_AUTHS_TL
1085: WHERE (EXPOSURE_AUTHORITY_CODE = X_EXPOSURE_AUTHORITY_CODE)
1086: AND (LANGUAGE = X_LANGUAGE);
1087: l_user_id NUMBER DEFAULT 1;
1088: l_row_id VARCHAR2(64);

Line 1096: GR_EXPOSURE_AUTHS_TL_PKG.UPDATE_ROW(

1092: BEGIN
1093: OPEN Cur_rowid;
1094: FETCH Cur_rowid INTO l_row_id;
1095: IF Cur_rowid%FOUND THEN
1096: GR_EXPOSURE_AUTHS_TL_PKG.UPDATE_ROW(
1097: P_COMMIT => 'T'
1098: ,P_CALLED_BY_FORM => 'F'
1099: ,P_ROWID => l_row_id
1100: ,P_EXPOSURE_AUTHORITY_CODE => X_EXPOSURE_AUTHORITY_CODE

Line 1113: GR_EXPOSURE_AUTHS_TL_PKG.INSERT_ROW(

1109: ,X_RETURN_STATUS => l_return_status
1110: ,X_ORACLE_ERROR => l_oracle_error
1111: ,X_MSG_DATA => l_msg_data);
1112: ELSE
1113: GR_EXPOSURE_AUTHS_TL_PKG.INSERT_ROW(
1114: P_COMMIT => 'T'
1115: ,P_CALLED_BY_FORM => 'F'
1116: ,P_EXPOSURE_AUTHORITY_CODE => X_EXPOSURE_AUTHORITY_CODE
1117: ,P_LANGUAGE => X_LANGUAGE

Line 1141: delete from GR_EXPOSURE_AUTHS_TL T

1137: */
1138: procedure NEW_LANGUAGE
1139: is
1140: begin
1141: delete from GR_EXPOSURE_AUTHS_TL T
1142: where not exists
1143: (select NULL
1144: from GR_EXPOSURE_AUTHS_B B
1145: where B.EXPOSURE_AUTHORITY_CODE = T.EXPOSURE_AUTHORITY_CODE

Line 1148: update GR_EXPOSURE_AUTHS_TL T set (

1144: from GR_EXPOSURE_AUTHS_B B
1145: where B.EXPOSURE_AUTHORITY_CODE = T.EXPOSURE_AUTHORITY_CODE
1146: );
1147:
1148: update GR_EXPOSURE_AUTHS_TL T set (
1149: EXPOSURE_AUTHORITY_DESC
1150: ) = (select
1151: B.EXPOSURE_AUTHORITY_DESC
1152: from GR_EXPOSURE_AUTHS_TL B

Line 1152: from GR_EXPOSURE_AUTHS_TL B

1148: update GR_EXPOSURE_AUTHS_TL T set (
1149: EXPOSURE_AUTHORITY_DESC
1150: ) = (select
1151: B.EXPOSURE_AUTHORITY_DESC
1152: from GR_EXPOSURE_AUTHS_TL B
1153: where B.EXPOSURE_AUTHORITY_CODE = T.EXPOSURE_AUTHORITY_CODE
1154: and B.LANGUAGE = T.SOURCE_LANG)
1155: where (
1156: T.EXPOSURE_AUTHORITY_CODE,

Line 1161: from GR_EXPOSURE_AUTHS_TL SUBB, GR_EXPOSURE_AUTHS_TL SUBT

1157: T.LANGUAGE
1158: ) in (select
1159: SUBT.EXPOSURE_AUTHORITY_CODE,
1160: SUBT.LANGUAGE
1161: from GR_EXPOSURE_AUTHS_TL SUBB, GR_EXPOSURE_AUTHS_TL SUBT
1162: where SUBB.EXPOSURE_AUTHORITY_CODE = SUBT.EXPOSURE_AUTHORITY_CODE
1163: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1164: and (SUBB.EXPOSURE_AUTHORITY_DESC <> SUBT.EXPOSURE_AUTHORITY_DESC
1165: ));

Line 1167: insert into GR_EXPOSURE_AUTHS_TL (

1163: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1164: and (SUBB.EXPOSURE_AUTHORITY_DESC <> SUBT.EXPOSURE_AUTHORITY_DESC
1165: ));
1166:
1167: insert into GR_EXPOSURE_AUTHS_TL (
1168: EXPOSURE_AUTHORITY_CODE,
1169: EXPOSURE_AUTHORITY_DESC,
1170: CREATED_BY,
1171: CREATION_DATE,

Line 1187: from GR_EXPOSURE_AUTHS_TL B, FND_LANGUAGES L

1183: B.LAST_UPDATE_DATE,
1184: B.LAST_UPDATE_LOGIN,
1185: L.LANGUAGE_CODE,
1186: B.SOURCE_LANG
1187: from GR_EXPOSURE_AUTHS_TL B, FND_LANGUAGES L
1188: where L.INSTALLED_FLAG in ('I', 'B')
1189: and B.LANGUAGE = userenv('LANG')
1190: and not exists
1191: (select NULL

Line 1192: from GR_EXPOSURE_AUTHS_TL T

1188: where L.INSTALLED_FLAG in ('I', 'B')
1189: and B.LANGUAGE = userenv('LANG')
1190: and not exists
1191: (select NULL
1192: from GR_EXPOSURE_AUTHS_TL T
1193: where T.EXPOSURE_AUTHORITY_CODE = B.EXPOSURE_AUTHORITY_CODE
1194: and T.LANGUAGE = L.LANGUAGE_CODE);
1195: end NEW_LANGUAGE;
1196:

Line 1198: END GR_EXPOSURE_AUTHS_TL_PKG;

1194: and T.LANGUAGE = L.LANGUAGE_CODE);
1195: end NEW_LANGUAGE;
1196:
1197:
1198: END GR_EXPOSURE_AUTHS_TL_PKG;