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_PROPERTY_VALUES_TL_PKG dependencies on GR_PROPERTY_VALUES_TL

Line 1: PACKAGE BODY GR_PROPERTY_VALUES_TL_PKG AS

1: PACKAGE BODY GR_PROPERTY_VALUES_TL_PKG AS
2: /*$Header: GRHIPVTB.pls 120.1 2006/06/16 21:40:51 pbamb noship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 81: INSERT INTO gr_property_values_tl

77: IF FND_API.To_Boolean(l_key_exists) THEN
78: RAISE Item_Exists_Error;
79: END IF;
80:
81: INSERT INTO gr_property_values_tl
82: (property_id,
83: language,
84: value,
85: display_order,

Line 257: UPDATE gr_property_values_tl

253:
254: IF l_return_status <> 'S' THEN
255: RAISE Foreign_Key_Error;
256: ELSE
257: UPDATE gr_property_values_tl
258: SET property_id = p_property_id,
259: language = p_language,
260: value = p_value,
261: display_order = p_display_order,

Line 373: FROM gr_property_values_tl pv

369:
370: CURSOR c_get_descs_value
371: IS
372: SELECT pv.value
373: FROM gr_property_values_tl pv
374: WHERE pv.property_id = p_property_id
375: AND pv.language = l_language
376: AND pv.value = l_value;
377:

Line 388: FROM gr_property_values_tl pv

384: pv.creation_date,
385: pv.last_updated_by,
386: pv.last_update_date,
387: pv.last_update_login
388: FROM gr_property_values_tl pv
389: WHERE pv.property_id = p_property_id
390: AND pv.language = l_language;
391:
392: PropertyDesc c_get_descs%ROWTYPE;

Line 414: delete from GR_PROPERTY_VALUES_TL T

410: l_msg_token := p_property_id || ' ' || p_language;
411:
412: /* Remove translations with no base row */
413:
414: delete from GR_PROPERTY_VALUES_TL T
415: where not exists
416: (select NULL
417: from GR_PROPERTIES_B B
418: where B.PROPERTY_ID = T.PROPERTY_ID

Line 423: update gr_property_values_tl t set (

419: );
420:
421: /* Redefault translations from the source language */
422:
423: update gr_property_values_tl t set (
424: meaning ) =
425: ( select
426: B.MEANING
427: from GR_PROPERTY_VALUES_TL B

Line 427: from GR_PROPERTY_VALUES_TL B

423: update gr_property_values_tl t set (
424: meaning ) =
425: ( select
426: B.MEANING
427: from GR_PROPERTY_VALUES_TL B
428: where B.PROPERTY_ID = T.PROPERTY_ID
429: and B.LANGUAGE = T.SOURCE_LANG
430: and B.VALUE = T.VALUE)
431: where (

Line 439: from GR_PROPERTY_VALUES_TL SUBB, GR_PROPERTY_VALUES_TL SUBT

435: ) in (select
436: SUBT.PROPERTY_ID,
437: SUBT.LANGUAGE,
438: SUBT.VALUE
439: from GR_PROPERTY_VALUES_TL SUBB, GR_PROPERTY_VALUES_TL SUBT
440: where SUBB.PROPERTY_ID = SUBT.PROPERTY_ID
441: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
442: and SUBB.VALUE = SUBT.VALUE
443: and (SUBB.MEANING <> SUBT.MEANING

Line 483: INSERT INTO gr_property_values_tl

479: l_language := InstLang.language_code;
480: OPEN c_get_descs_value;
481: FETCH c_get_descs_value INTO PropertyDesc_Value;
482: IF c_get_descs_value%NOTFOUND THEN
483: INSERT INTO gr_property_values_tl
484: (property_id,
485: language,
486: value,
487: display_order,

Line 596: FROM gr_property_values_tl

592:
593: CURSOR c_lock_property_values
594: IS
595: SELECT *
596: FROM gr_property_values_tl
597: WHERE rowid = p_rowid
598: FOR UPDATE NOWAIT;
599: LockValueRcd c_lock_property_values%ROWTYPE;
600: BEGIN

Line 738: DELETE FROM gr_property_values_tl

734: IF l_return_status <> 'S' THEN
735: RAISE Check_Integrity_Error;
736: END IF;
737:
738: DELETE FROM gr_property_values_tl
739: WHERE rowid = p_rowid;
740:
741: /* Check the commit flag and if set, then commit the work. */
742:

Line 823: DELETE FROM gr_property_values_tl

819: x_oracle_error := 0;
820: x_msg_data := NULL;
821: l_msg_token := p_property_id;
822:
823: DELETE FROM gr_property_values_tl
824: WHERE property_id = p_property_id;
825:
826: IF FND_API.To_Boolean(p_commit) THEN
827: COMMIT WORK;

Line 1059: FROM gr_property_values_tl pv

1055:
1056: CURSOR c_get_property_values_rowid
1057: IS
1058: SELECT pv.rowid
1059: FROM gr_property_values_tl pv
1060: WHERE pv.property_id = p_property_id
1061: AND pv.language = p_language
1062: AND pv.value = p_value;
1063: PropertyTLRecord c_get_property_values_rowid%ROWTYPE;

Line 1104: UPDATE GR_PROPERTY_VALUES_TL SET

1100: ,X_SOURCE_LANG IN VARCHAR2
1101: ,X_MEANING IN VARCHAR2
1102: ) IS
1103: BEGIN
1104: UPDATE GR_PROPERTY_VALUES_TL SET
1105: MEANING = X_MEANING,
1106: SOURCE_LANG = USERENV('LANG'),
1107: LAST_UPDATE_DATE = sysdate,
1108: LAST_UPDATED_BY = 1,

Line 1126: FROM GR_PROPERTY_VALUES_TL

1122: ,X_MEANING IN VARCHAR2
1123: ) IS
1124: CURSOR Cur_rowid IS
1125: SELECT rowid
1126: FROM GR_PROPERTY_VALUES_TL
1127: WHERE (PROPERTY_ID = X_PROPERTY_ID) AND (VALUE = X_VALUE)
1128: AND (LANGUAGE = X_LANGUAGE);
1129: l_user_id NUMBER DEFAULT 1;
1130: l_row_id VARCHAR2(64);

Line 1138: GR_PROPERTY_VALUES_TL_PKG.UPDATE_ROW(

1134: BEGIN
1135: OPEN Cur_rowid;
1136: FETCH Cur_rowid INTO l_row_id;
1137: IF Cur_rowid%FOUND THEN
1138: GR_PROPERTY_VALUES_TL_PKG.UPDATE_ROW(
1139: P_COMMIT => 'T'
1140: ,P_CALLED_BY_FORM => 'F'
1141: ,P_ROWID => l_row_id
1142: ,P_PROPERTY_ID => X_PROPERTY_ID

Line 1157: GR_PROPERTY_VALUES_TL_PKG.INSERT_ROW(

1153: ,X_RETURN_STATUS => l_return_status
1154: ,X_ORACLE_ERROR => l_oracle_error
1155: ,X_MSG_DATA => l_msg_data);
1156: ELSE
1157: GR_PROPERTY_VALUES_TL_PKG.INSERT_ROW(
1158: P_COMMIT => 'T'
1159: ,P_CALLED_BY_FORM => 'F'
1160: ,P_PROPERTY_ID => X_PROPERTY_ID
1161: ,P_LANGUAGE => X_LANGUAGE

Line 1187: update GR_PROPERTY_VALUES_TL T set (

1183: */
1184: procedure NEW_LANGUAGE
1185: is
1186: begin
1187: update GR_PROPERTY_VALUES_TL T set (
1188: MEANING,
1189: DISPLAY_ORDER
1190: ) = (select
1191: B.MEANING,

Line 1193: from GR_PROPERTY_VALUES_TL B

1189: DISPLAY_ORDER
1190: ) = (select
1191: B.MEANING,
1192: B.DISPLAY_ORDER
1193: from GR_PROPERTY_VALUES_TL B
1194: where B.PROPERTY_ID = T.PROPERTY_ID
1195: and B.VALUE = T.VALUE
1196: and B.LANGUAGE = T.SOURCE_LANG)
1197: where (

Line 1205: from GR_PROPERTY_VALUES_TL SUBB, GR_PROPERTY_VALUES_TL SUBT

1201: ) in (select
1202: SUBT.PROPERTY_ID,
1203: SUBT.VALUE,
1204: SUBT.LANGUAGE
1205: from GR_PROPERTY_VALUES_TL SUBB, GR_PROPERTY_VALUES_TL SUBT
1206: where SUBB.PROPERTY_ID = SUBT.PROPERTY_ID
1207: and SUBB.VALUE = SUBT.VALUE
1208: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1209: and (SUBB.MEANING <> SUBT.MEANING

Line 1215: insert into GR_PROPERTY_VALUES_TL (

1211: or (SUBB.MEANING is not null and SUBT.MEANING is null)
1212: or SUBB.DISPLAY_ORDER <> SUBT.DISPLAY_ORDER
1213: ));
1214:
1215: insert into GR_PROPERTY_VALUES_TL (
1216: PROPERTY_ID,
1217: VALUE,
1218: DISPLAY_ORDER,
1219: MEANING,

Line 1239: from GR_PROPERTY_VALUES_TL B, FND_LANGUAGES L

1235: B.LAST_UPDATE_DATE,
1236: B.LAST_UPDATE_LOGIN,
1237: L.LANGUAGE_CODE,
1238: B.SOURCE_LANG
1239: from GR_PROPERTY_VALUES_TL B, FND_LANGUAGES L
1240: where L.INSTALLED_FLAG in ('I', 'B')
1241: and B.LANGUAGE = userenv('LANG')
1242: and not exists
1243: (select NULL

Line 1244: from GR_PROPERTY_VALUES_TL T

1240: where L.INSTALLED_FLAG in ('I', 'B')
1241: and B.LANGUAGE = userenv('LANG')
1242: and not exists
1243: (select NULL
1244: from GR_PROPERTY_VALUES_TL T
1245: where T.PROPERTY_ID = B.PROPERTY_ID
1246: and T.VALUE = B.VALUE
1247: and T.LANGUAGE = L.LANGUAGE_CODE);
1248:

Line 1253: END GR_PROPERTY_VALUES_TL_PKG;

1249: end NEW_LANGUAGE;
1250:
1251:
1252:
1253: END GR_PROPERTY_VALUES_TL_PKG;