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.AMS_LIST_QUERIES_PARAM_PKG dependencies on AMS_LIST_QUERIES_PARAM

Line 1: package body AMS_LIST_QUERIES_PARAM_PKG as

1: package body AMS_LIST_QUERIES_PARAM_PKG as
2: /* $Header: amstlqpb.pls 120.1 2005/06/27 05:40:16 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_LIST_QUERY_PARAM_ID in NUMBER,

Line 21: cursor C is select ROWID from AMS_LIST_QUERIES_PARAM

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from AMS_LIST_QUERIES_PARAM
22: where LIST_QUERY_PARAM_ID = X_LIST_QUERY_PARAM_ID
23: ;
24: begin
25: insert into AMS_LIST_QUERIES_PARAM (

Line 25: insert into AMS_LIST_QUERIES_PARAM (

21: cursor C is select ROWID from AMS_LIST_QUERIES_PARAM
22: where LIST_QUERY_PARAM_ID = X_LIST_QUERY_PARAM_ID
23: ;
24: begin
25: insert into AMS_LIST_QUERIES_PARAM (
26: ATTB_LOV_ID,
27: PARAM_VALUE_2,
28: CONDITION_VALUE,
29: PARAMETER_NAME,

Line 57: insert into AMS_LIST_QUERIES_PARAM_TL (

53: X_LAST_UPDATED_BY,
54: X_LAST_UPDATE_LOGIN
55: );
56:
57: insert into AMS_LIST_QUERIES_PARAM_TL (
58: LIST_QUERY_PARAM_ID,
59: LAST_UPDATE_DATE,
60: LAST_UPDATED_BY,
61: CREATION_DATE,

Line 81: from AMS_LIST_QUERIES_PARAM_TL T

77: from FND_LANGUAGES L
78: where L.INSTALLED_FLAG in ('I', 'B')
79: and not exists
80: (select NULL
81: from AMS_LIST_QUERIES_PARAM_TL T
82: where T.LIST_QUERY_PARAM_ID = X_LIST_QUERY_PARAM_ID
83: and T.LANGUAGE = L.LANGUAGE_CODE);
84:
85: open c;

Line 116: from AMS_LIST_QUERIES_PARAM

112: LIST_QUERY_ID,
113: PARAMETER_ORDER,
114: PARAMETER_VALUE,
115: OBJECT_VERSION_NUMBER
116: from AMS_LIST_QUERIES_PARAM
117: where LIST_QUERY_PARAM_ID = X_LIST_QUERY_PARAM_ID
118: for update of LIST_QUERY_PARAM_ID nowait;
119: recinfo c%rowtype;
120:

Line 124: from AMS_LIST_QUERIES_PARAM_TL

120:
121: cursor c1 is select
122: DISPLAY_NAME,
123: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
124: from AMS_LIST_QUERIES_PARAM_TL
125: where LIST_QUERY_PARAM_ID = X_LIST_QUERY_PARAM_ID
126: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
127: for update of LIST_QUERY_PARAM_ID nowait;
128: begin

Line 189: update AMS_LIST_QUERIES_PARAM set

185: X_LAST_UPDATED_BY in NUMBER,
186: X_LAST_UPDATE_LOGIN in NUMBER
187: ) is
188: begin
189: update AMS_LIST_QUERIES_PARAM set
190: ATTB_LOV_ID = X_ATTB_LOV_ID,
191: PARAM_VALUE_2 = X_PARAM_VALUE_2,
192: CONDITION_VALUE = X_CONDITION_VALUE,
193: PARAMETER_NAME = X_PARAMETER_NAME,

Line 207: update AMS_LIST_QUERIES_PARAM_TL set

203: if (sql%notfound) then
204: raise no_data_found;
205: end if;
206:
207: update AMS_LIST_QUERIES_PARAM_TL set
208: DISPLAY_NAME = X_DISPLAY_NAME,
209: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
210: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
211: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 225: delete from AMS_LIST_QUERIES_PARAM_TL

221: procedure DELETE_ROW (
222: X_LIST_QUERY_PARAM_ID in NUMBER
223: ) is
224: begin
225: delete from AMS_LIST_QUERIES_PARAM_TL
226: where LIST_QUERY_PARAM_ID = X_LIST_QUERY_PARAM_ID;
227:
228: if (sql%notfound) then
229: raise no_data_found;

Line 232: delete from AMS_LIST_QUERIES_PARAM

228: if (sql%notfound) then
229: raise no_data_found;
230: end if;
231:
232: delete from AMS_LIST_QUERIES_PARAM
233: where LIST_QUERY_PARAM_ID = X_LIST_QUERY_PARAM_ID;
234:
235: if (sql%notfound) then
236: raise no_data_found;

Line 243: delete from AMS_LIST_QUERIES_PARAM_TL T

239:
240: procedure ADD_LANGUAGE
241: is
242: begin
243: delete from AMS_LIST_QUERIES_PARAM_TL T
244: where not exists
245: (select NULL
246: from AMS_LIST_QUERIES_PARAM B
247: where B.LIST_QUERY_PARAM_ID = T.LIST_QUERY_PARAM_ID

Line 246: from AMS_LIST_QUERIES_PARAM B

242: begin
243: delete from AMS_LIST_QUERIES_PARAM_TL T
244: where not exists
245: (select NULL
246: from AMS_LIST_QUERIES_PARAM B
247: where B.LIST_QUERY_PARAM_ID = T.LIST_QUERY_PARAM_ID
248: );
249:
250: update AMS_LIST_QUERIES_PARAM_TL T set (

Line 250: update AMS_LIST_QUERIES_PARAM_TL T set (

246: from AMS_LIST_QUERIES_PARAM B
247: where B.LIST_QUERY_PARAM_ID = T.LIST_QUERY_PARAM_ID
248: );
249:
250: update AMS_LIST_QUERIES_PARAM_TL T set (
251: DISPLAY_NAME
252: ) = (select
253: B.DISPLAY_NAME
254: from AMS_LIST_QUERIES_PARAM_TL B

Line 254: from AMS_LIST_QUERIES_PARAM_TL B

250: update AMS_LIST_QUERIES_PARAM_TL T set (
251: DISPLAY_NAME
252: ) = (select
253: B.DISPLAY_NAME
254: from AMS_LIST_QUERIES_PARAM_TL B
255: where B.LIST_QUERY_PARAM_ID = T.LIST_QUERY_PARAM_ID
256: and B.LANGUAGE = T.SOURCE_LANG)
257: where (
258: T.LIST_QUERY_PARAM_ID,

Line 263: from AMS_LIST_QUERIES_PARAM_TL SUBB, AMS_LIST_QUERIES_PARAM_TL SUBT

259: T.LANGUAGE
260: ) in (select
261: SUBT.LIST_QUERY_PARAM_ID,
262: SUBT.LANGUAGE
263: from AMS_LIST_QUERIES_PARAM_TL SUBB, AMS_LIST_QUERIES_PARAM_TL SUBT
264: where SUBB.LIST_QUERY_PARAM_ID = SUBT.LIST_QUERY_PARAM_ID
265: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
266: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
267: ));

Line 269: insert into AMS_LIST_QUERIES_PARAM_TL (

265: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
266: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
267: ));
268:
269: insert into AMS_LIST_QUERIES_PARAM_TL (
270: LIST_QUERY_PARAM_ID,
271: LAST_UPDATE_DATE,
272: LAST_UPDATED_BY,
273: CREATION_DATE,

Line 289: from AMS_LIST_QUERIES_PARAM_TL B, FND_LANGUAGES L

285: B.LAST_UPDATE_LOGIN,
286: B.DISPLAY_NAME,
287: L.LANGUAGE_CODE,
288: B.SOURCE_LANG
289: from AMS_LIST_QUERIES_PARAM_TL B, FND_LANGUAGES L
290: where L.INSTALLED_FLAG in ('I', 'B')
291: and B.LANGUAGE = userenv('LANG')
292: and not exists
293: (select NULL

Line 294: from AMS_LIST_QUERIES_PARAM_TL T

290: where L.INSTALLED_FLAG in ('I', 'B')
291: and B.LANGUAGE = userenv('LANG')
292: and not exists
293: (select NULL
294: from AMS_LIST_QUERIES_PARAM_TL T
295: where T.LIST_QUERY_PARAM_ID = B.LIST_QUERY_PARAM_ID
296: and T.LANGUAGE = L.LANGUAGE_CODE);
297: end ADD_LANGUAGE;
298:

Line 318: insert into AMS_LIST_QUERIES_PARAM (

314: X_LAST_UPDATE_LOGIN in NUMBER
315:
316: ) is
317: begin
318: insert into AMS_LIST_QUERIES_PARAM (
319: ATTB_LOV_ID,
320: PARAM_VALUE_2,
321: CONDITION_VALUE,
322: PARAMETER_NAME,

Line 350: insert into AMS_LIST_QUERIES_PARAM_TL (

346: X_LAST_UPDATED_BY,
347: X_LAST_UPDATE_LOGIN
348: );
349:
350: insert into AMS_LIST_QUERIES_PARAM_TL (
351: LIST_QUERY_PARAM_ID,
352: LAST_UPDATE_DATE,
353: LAST_UPDATED_BY,
354: CREATION_DATE,

Line 374: from AMS_LIST_QUERIES_PARAM_TL T

370: from FND_LANGUAGES L
371: where L.INSTALLED_FLAG in ('I', 'B')
372: and not exists
373: (select NULL
374: from AMS_LIST_QUERIES_PARAM_TL T
375: where T.LIST_QUERY_PARAM_ID = X_LIST_QUERY_PARAM_ID
376: and T.LANGUAGE = L.LANGUAGE_CODE);
377:
378: end INSERT_ROW;

Line 404: FROM AMS_LIST_QUERIES_PARAM

400: l_last_updated_by number;
401:
402: CURSOR c_obj_verno IS
403: SELECT object_version_number, last_updated_by
404: FROM AMS_LIST_QUERIES_PARAM
405: WHERE LIST_QUERY_PARAM_ID = X_LIST_QUERY_PARAM_ID;
406:
407: CURSOR c_chk_exists is
408: SELECT 'x'

Line 409: FROM AMS_LIST_QUERIES_PARAM

405: WHERE LIST_QUERY_PARAM_ID = X_LIST_QUERY_PARAM_ID;
406:
407: CURSOR c_chk_exists is
408: SELECT 'x'
409: FROM AMS_LIST_QUERIES_PARAM
410: WHERE LIST_QUERY_PARAM_ID = X_LIST_QUERY_PARAM_ID;
411:
412: CURSOR c_get_id is
413: SELECT AMS_LIST_QUERIES_PARAM_S.NEXTVAL

Line 413: SELECT AMS_LIST_QUERIES_PARAM_S.NEXTVAL

409: FROM AMS_LIST_QUERIES_PARAM
410: WHERE LIST_QUERY_PARAM_ID = X_LIST_QUERY_PARAM_ID;
411:
412: CURSOR c_get_id is
413: SELECT AMS_LIST_QUERIES_PARAM_S.NEXTVAL
414: FROM DUAL;
415: BEGIN
416: if X_OWNER = 'SEED' then
417: l_user_id := 1;

Line 439: AMS_LIST_QUERIES_PARAM_PKG.INSERT_ROW (

435: END IF;
436:
437: l_obj_verno := 1;
438:
439: AMS_LIST_QUERIES_PARAM_PKG.INSERT_ROW (
440: X_LIST_QUERY_PARAM_ID => x_list_query_param_id,
441: X_ATTB_LOV_ID => x_attb_lov_id,
442: X_PARAM_VALUE_2 => X_PARAM_VALUE_2 ,
443: X_CONDITION_VALUE => X_CONDITION_VALUE ,

Line 465: AMS_LIST_QUERIES_PARAM_PKG.UPDATE_ROW (

461:
462: if (l_last_updated_by in (1,2,0) OR
463: NVL(x_custom_mode,'PRESERVE')='FORCE') THEN
464:
465: AMS_LIST_QUERIES_PARAM_PKG.UPDATE_ROW (
466: X_LIST_QUERY_PARAM_ID => x_list_query_param_id,
467: X_ATTB_LOV_ID => x_attb_lov_id,
468: X_PARAM_VALUE_2 => X_PARAM_VALUE_2 ,
469: X_CONDITION_VALUE => X_CONDITION_VALUE ,

Line 495: FROM AMS_LIST_QUERIES_PARAM_TL

491: ) IS
492:
493: cursor c_last_updated_by is
494: select last_updated_by
495: FROM AMS_LIST_QUERIES_PARAM_TL
496: where LIST_QUERY_PARAM_ID = x_LIST_QUERY_PARAM_ID
497: and USERENV('LANG') = LANGUAGE;
498:
499: l_last_updated_by number;

Line 512: UPDATE AMS_LIST_QUERIES_PARAM_TL

508: if (l_last_updated_by in (1,2,0) OR
509: NVL(x_custom_mode,'PRESERVE')='FORCE') THEN
510:
511:
512: UPDATE AMS_LIST_QUERIES_PARAM_TL
513: SET
514: DISPLAY_NAME = NVL(X_DISPLAY_NAME, DISPLAY_NAME),
515: SOURCE_LANG = userenv('LANG'),
516: LAST_UPDATE_DATE = SYSDATE,

Line 526: end AMS_LIST_QUERIES_PARAM_PKG;

522:
523: end if;
524: END TRANSLATE_ROW;
525:
526: end AMS_LIST_QUERIES_PARAM_PKG;