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_TOXIC_ROUTES_TL_PKG dependencies on GR_TOXIC_ROUTES_TL

Line 1: PACKAGE BODY GR_TOXIC_ROUTES_TL_PKG AS

1: PACKAGE BODY GR_TOXIC_ROUTES_TL_PKG AS
2: /*$Header: GRHITRTB.pls 115.11 2002/11/15 16:57:22 gkelly ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 76: INSERT INTO gr_toxic_routes_tl

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

Line 243: UPDATE gr_toxic_routes_tl

239:
240: IF l_return_status <> 'S' THEN
241: RAISE Foreign_Key_Error;
242: ELSE
243: UPDATE gr_toxic_routes_tl
244: SET toxic_route_code = p_toxic_route_code,
245: language = p_language,
246: source_lang = p_source_lang,
247: toxic_route_desc = p_toxic_route_desc,

Line 358: FROM gr_toxic_routes_tl trt

354: trt.creation_date,
355: trt.last_updated_by,
356: trt.last_update_date,
357: trt.last_update_login
358: FROM gr_toxic_routes_tl trt
359: WHERE trt.toxic_route_code = p_toxic_route_code
360: AND trt.language = l_language;
361: RouteDesc c_get_descs%ROWTYPE;
362:

Line 383: delete from GR_TOXIC_ROUTES_TL T

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

Line 392: update gr_toxic_routes_tl t set (

388: );
389:
390: /* Redefault translations from the source language */
391:
392: update gr_toxic_routes_tl t set (
393: toxic_route_desc ) =
394: ( select
395: B.TOXIC_ROUTE_DESC
396: from GR_TOXIC_ROUTES_TL B

Line 396: from GR_TOXIC_ROUTES_TL B

392: update gr_toxic_routes_tl t set (
393: toxic_route_desc ) =
394: ( select
395: B.TOXIC_ROUTE_DESC
396: from GR_TOXIC_ROUTES_TL B
397: where B.TOXIC_ROUTE_CODE = T.TOXIC_ROUTE_CODE
398: and B.LANGUAGE = T.SOURCE_LANG)
399: where (
400: T.TOXIC_ROUTE_CODE,

Line 405: from GR_TOXIC_ROUTES_TL SUBB, GR_TOXIC_ROUTES_TL SUBT

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

Line 447: INSERT INTO gr_toxic_routes_tl

443: OPEN c_get_descs;
444: FETCH c_get_descs INTO RouteDesc;
445: IF c_get_descs%NOTFOUND THEN
446: CLOSE c_get_descs;
447: INSERT INTO gr_toxic_routes_tl
448: (toxic_route_code,
449: language,
450: toxic_route_desc,
451: source_lang,

Line 553: FROM gr_toxic_routes_tl

549:
550: CURSOR c_lock_routes_tl
551: IS
552: SELECT last_update_date
553: FROM gr_toxic_routes_tl
554: WHERE rowid = p_rowid
555: FOR UPDATE NOWAIT;
556: LockRouteRcd c_lock_routes_tl%ROWTYPE;
557: BEGIN

Line 703: DELETE FROM gr_toxic_routes_tl

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

Line 788: DELETE FROM gr_toxic_routes_tl

784: x_oracle_error := 0;
785: x_msg_data := NULL;
786: l_msg_token := p_toxic_route_code;
787:
788: DELETE FROM gr_toxic_routes_tl
789: WHERE toxic_route_code = p_toxic_route_code;
790:
791: IF FND_API.To_Boolean(p_commit) THEN
792: COMMIT WORK;

Line 1021: FROM gr_toxic_routes_tl trt

1017:
1018: CURSOR c_get_routes_tl_rowid
1019: IS
1020: SELECT trt.rowid
1021: FROM gr_toxic_routes_tl trt
1022: WHERE trt.toxic_route_code = p_toxic_route_code
1023: AND trt.language = p_language;
1024: RouteTLRecord c_get_routes_tl_rowid%ROWTYPE;
1025:

Line 1063: UPDATE GR_TOXIC_ROUTES_TL SET

1059: ,X_SOURCE_LANG IN VARCHAR2
1060: ,X_TOXIC_ROUTE_DESC IN VARCHAR2
1061: ) IS
1062: BEGIN
1063: UPDATE GR_TOXIC_ROUTES_TL SET
1064: TOXIC_ROUTE_DESC = X_TOXIC_ROUTE_DESC,
1065: SOURCE_LANG = USERENV('LANG'),
1066: LAST_UPDATE_DATE = sysdate,
1067: LAST_UPDATED_BY = 0,

Line 1082: FROM GR_TOXIC_ROUTES_TL

1078: ,X_TOXIC_ROUTE_DESC IN VARCHAR2
1079: ) IS
1080: CURSOR Cur_rowid IS
1081: SELECT rowid
1082: FROM GR_TOXIC_ROUTES_TL
1083: WHERE (TOXIC_ROUTE_CODE = X_TOXIC_ROUTE_CODE)
1084: AND (LANGUAGE = X_LANGUAGE);
1085: l_user_id NUMBER DEFAULT 1;
1086: l_row_id VARCHAR2(64);

Line 1094: GR_TOXIC_ROUTES_TL_PKG.UPDATE_ROW(

1090: BEGIN
1091: OPEN Cur_rowid;
1092: FETCH Cur_rowid INTO l_row_id;
1093: IF Cur_rowid%FOUND THEN
1094: GR_TOXIC_ROUTES_TL_PKG.UPDATE_ROW(
1095: P_COMMIT => 'T'
1096: ,P_CALLED_BY_FORM => 'F'
1097: ,P_ROWID => l_row_id
1098: ,P_TOXIC_ROUTE_CODE => X_TOXIC_ROUTE_CODE

Line 1111: GR_TOXIC_ROUTES_TL_PKG.INSERT_ROW(

1107: ,X_RETURN_STATUS => l_return_status
1108: ,X_ORACLE_ERROR => l_oracle_error
1109: ,X_MSG_DATA => l_msg_data);
1110: ELSE
1111: GR_TOXIC_ROUTES_TL_PKG.INSERT_ROW(
1112: P_COMMIT => 'T'
1113: ,P_CALLED_BY_FORM => 'F'
1114: ,P_TOXIC_ROUTE_CODE => X_TOXIC_ROUTE_CODE
1115: ,P_LANGUAGE => X_LANGUAGE

Line 1138: delete from GR_TOXIC_ROUTES_TL T

1134: */
1135: procedure NEW_LANGUAGE
1136: is
1137: begin
1138: delete from GR_TOXIC_ROUTES_TL T
1139: where not exists
1140: (select NULL
1141: from GR_TOXIC_ROUTES_B B
1142: where B.TOXIC_ROUTE_CODE = T.TOXIC_ROUTE_CODE

Line 1145: update GR_TOXIC_ROUTES_TL T set (

1141: from GR_TOXIC_ROUTES_B B
1142: where B.TOXIC_ROUTE_CODE = T.TOXIC_ROUTE_CODE
1143: );
1144:
1145: update GR_TOXIC_ROUTES_TL T set (
1146: TOXIC_ROUTE_DESC
1147: ) = (select
1148: B.TOXIC_ROUTE_DESC
1149: from GR_TOXIC_ROUTES_TL B

Line 1149: from GR_TOXIC_ROUTES_TL B

1145: update GR_TOXIC_ROUTES_TL T set (
1146: TOXIC_ROUTE_DESC
1147: ) = (select
1148: B.TOXIC_ROUTE_DESC
1149: from GR_TOXIC_ROUTES_TL B
1150: where B.TOXIC_ROUTE_CODE = T.TOXIC_ROUTE_CODE
1151: and B.LANGUAGE = T.SOURCE_LANG)
1152: where (
1153: T.TOXIC_ROUTE_CODE,

Line 1158: from GR_TOXIC_ROUTES_TL SUBB, GR_TOXIC_ROUTES_TL SUBT

1154: T.LANGUAGE
1155: ) in (select
1156: SUBT.TOXIC_ROUTE_CODE,
1157: SUBT.LANGUAGE
1158: from GR_TOXIC_ROUTES_TL SUBB, GR_TOXIC_ROUTES_TL SUBT
1159: where SUBB.TOXIC_ROUTE_CODE = SUBT.TOXIC_ROUTE_CODE
1160: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1161: and (SUBB.TOXIC_ROUTE_DESC <> SUBT.TOXIC_ROUTE_DESC
1162: ));

Line 1164: insert into GR_TOXIC_ROUTES_TL (

1160: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1161: and (SUBB.TOXIC_ROUTE_DESC <> SUBT.TOXIC_ROUTE_DESC
1162: ));
1163:
1164: insert into GR_TOXIC_ROUTES_TL (
1165: TOXIC_ROUTE_CODE,
1166: TOXIC_ROUTE_DESC,
1167: CREATED_BY,
1168: CREATION_DATE,

Line 1184: from GR_TOXIC_ROUTES_TL B, FND_LANGUAGES L

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

Line 1189: from GR_TOXIC_ROUTES_TL T

1185: where L.INSTALLED_FLAG in ('I', 'B')
1186: and B.LANGUAGE = userenv('LANG')
1187: and not exists
1188: (select NULL
1189: from GR_TOXIC_ROUTES_TL T
1190: where T.TOXIC_ROUTE_CODE = B.TOXIC_ROUTE_CODE
1191: and T.LANGUAGE = L.LANGUAGE_CODE);
1192: end NEW_LANGUAGE;
1193:

Line 1196: END GR_TOXIC_ROUTES_TL_PKG;

1192: end NEW_LANGUAGE;
1193:
1194:
1195:
1196: END GR_TOXIC_ROUTES_TL_PKG;