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.FND_REQUEST_SETS_PKG dependencies on FND_REQUEST_SETS

Line 1: package body FND_REQUEST_SETS_PKG as

1: package body FND_REQUEST_SETS_PKG as
2: /* $Header: AFRSFRSB.pls 120.2 2005/08/19 20:18:41 ckclark ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 27: cursor C is select ROWID from FND_REQUEST_SETS

23: X_LAST_UPDATE_DATE in DATE,
24: X_LAST_UPDATED_BY in NUMBER,
25: X_LAST_UPDATE_LOGIN in NUMBER
26: ) is
27: cursor C is select ROWID from FND_REQUEST_SETS
28: where REQUEST_SET_ID = X_REQUEST_SET_ID
29: and APPLICATION_ID = X_APPLICATION_ID
30: ;
31: begin

Line 32: insert into FND_REQUEST_SETS (

28: where REQUEST_SET_ID = X_REQUEST_SET_ID
29: and APPLICATION_ID = X_APPLICATION_ID
30: ;
31: begin
32: insert into FND_REQUEST_SETS (
33: APPLICATION_ID,
34: REQUEST_SET_ID,
35: REQUEST_SET_NAME,
36: ALLOW_CONSTRAINTS_FLAG,

Line 72: insert into FND_REQUEST_SETS_TL (

68: X_LAST_UPDATED_BY,
69: X_LAST_UPDATE_LOGIN
70: );
71:
72: insert into FND_REQUEST_SETS_TL (
73: APPLICATION_ID,
74: REQUEST_SET_ID,
75: CREATION_DATE,
76: CREATED_BY,

Line 100: from FND_REQUEST_SETS_TL T

96: from FND_LANGUAGES L
97: where L.INSTALLED_FLAG in ('I', 'B')
98: and not exists
99: (select NULL
100: from FND_REQUEST_SETS_TL T
101: where T.REQUEST_SET_ID = X_REQUEST_SET_ID
102: and T.APPLICATION_ID = X_APPLICATION_ID
103: and T.LANGUAGE = L.LANGUAGE_CODE);
104:

Line 144: from FND_REQUEST_SETS

140: OWNER,
141: PRINTER,
142: PRINT_STYLE,
143: ICON_NAME
144: from FND_REQUEST_SETS
145: where REQUEST_SET_ID = X_REQUEST_SET_ID
146: and APPLICATION_ID = X_APPLICATION_ID
147: for update of REQUEST_SET_ID nowait;
148: recinfo c%rowtype;

Line 153: from FND_REQUEST_SETS_TL

149:
150: cursor c1 is select
151: USER_REQUEST_SET_NAME,
152: DESCRIPTION
153: from FND_REQUEST_SETS_TL
154: where REQUEST_SET_ID = X_REQUEST_SET_ID
155: and APPLICATION_ID = X_APPLICATION_ID
156: and LANGUAGE = userenv('LANG')
157: for update of REQUEST_SET_ID nowait;

Line 235: update FND_REQUEST_SETS set

231: X_LAST_UPDATED_BY in NUMBER,
232: X_LAST_UPDATE_LOGIN in NUMBER
233: ) is
234: begin
235: update FND_REQUEST_SETS set
236: REQUEST_SET_NAME = X_REQUEST_SET_NAME,
237: ALLOW_CONSTRAINTS_FLAG = X_ALLOW_CONSTRAINTS_FLAG,
238: PRINT_TOGETHER_FLAG = X_PRINT_TOGETHER_FLAG,
239: START_DATE_ACTIVE = X_START_DATE_ACTIVE,

Line 257: update FND_REQUEST_SETS_TL set

253: if (sql%notfound) then
254: raise no_data_found;
255: end if;
256:
257: update FND_REQUEST_SETS_TL set
258: USER_REQUEST_SET_NAME = X_USER_REQUEST_SET_NAME,
259: DESCRIPTION = X_DESCRIPTION,
260: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
261: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 288: from fnd_request_sets

284: set enabled_flag='N'
285: where application_id = x_application_id
286: and concurrent_program_id in
287: (select concurrent_program_id
288: from fnd_request_sets
289: where application_id = x_application_id
290: and request_set_id = x_request_set_id
291: and concurrent_program_id is not null);
292: exception

Line 297: delete from FND_REQUEST_SETS

293: when no_data_found then -- We don't care.
294: null;
295: end;
296:
297: delete from FND_REQUEST_SETS
298: where APPLICATION_ID = X_APPLICATION_ID
299: and REQUEST_SET_ID = X_REQUEST_SET_ID;
300:
301: if (sql%notfound) then

Line 305: delete from FND_REQUEST_SETS_TL

301: if (sql%notfound) then
302: raise no_data_found;
303: end if;
304:
305: delete from FND_REQUEST_SETS_TL
306: where APPLICATION_ID = X_APPLICATION_ID
307: and REQUEST_SET_ID = X_REQUEST_SET_ID;
308:
309: if (sql%notfound) then

Line 346: delete from FND_REQUEST_SETS_TL T

342: /* as a quick workaround to fix the time-consuming table handler issue */
343: /* Eventually we'll need to turn them into a separate fix_language procedure */
344: /*
345:
346: delete from FND_REQUEST_SETS_TL T
347: where not exists
348: (select NULL
349: from FND_REQUEST_SETS B
350: where B.REQUEST_SET_ID = T.REQUEST_SET_ID

Line 349: from FND_REQUEST_SETS B

345:
346: delete from FND_REQUEST_SETS_TL T
347: where not exists
348: (select NULL
349: from FND_REQUEST_SETS B
350: where B.REQUEST_SET_ID = T.REQUEST_SET_ID
351: and B.APPLICATION_ID = T.APPLICATION_ID
352: );
353:

Line 354: update FND_REQUEST_SETS_TL T set (

350: where B.REQUEST_SET_ID = T.REQUEST_SET_ID
351: and B.APPLICATION_ID = T.APPLICATION_ID
352: );
353:
354: update FND_REQUEST_SETS_TL T set (
355: USER_REQUEST_SET_NAME,
356: DESCRIPTION
357: ) = (select
358: B.USER_REQUEST_SET_NAME,

Line 360: from FND_REQUEST_SETS_TL B

356: DESCRIPTION
357: ) = (select
358: B.USER_REQUEST_SET_NAME,
359: B.DESCRIPTION
360: from FND_REQUEST_SETS_TL B
361: where B.REQUEST_SET_ID = T.REQUEST_SET_ID
362: and B.APPLICATION_ID = T.APPLICATION_ID
363: and B.LANGUAGE = T.SOURCE_LANG)
364: where (

Line 372: from FND_REQUEST_SETS_TL SUBB, FND_REQUEST_SETS_TL SUBT

368: ) in (select
369: SUBT.REQUEST_SET_ID,
370: SUBT.APPLICATION_ID,
371: SUBT.LANGUAGE
372: from FND_REQUEST_SETS_TL SUBB, FND_REQUEST_SETS_TL SUBT
373: where SUBB.REQUEST_SET_ID = SUBT.REQUEST_SET_ID
374: and SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
375: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
376: and (SUBB.USER_REQUEST_SET_NAME <> SUBT.USER_REQUEST_SET_NAME

Line 383: insert into FND_REQUEST_SETS_TL (

379: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
380: ));
381: */
382:
383: insert into FND_REQUEST_SETS_TL (
384: APPLICATION_ID,
385: REQUEST_SET_ID,
386: CREATION_DATE,
387: CREATED_BY,

Line 407: from FND_REQUEST_SETS_TL B, FND_LANGUAGES L

403: B.USER_REQUEST_SET_NAME,
404: B.DESCRIPTION,
405: L.LANGUAGE_CODE,
406: B.SOURCE_LANG
407: from FND_REQUEST_SETS_TL B, FND_LANGUAGES L
408: where L.INSTALLED_FLAG in ('I', 'B')
409: and B.LANGUAGE = userenv('LANG')
410: and not exists
411: (select NULL

Line 412: from FND_REQUEST_SETS_TL T

408: where L.INSTALLED_FLAG in ('I', 'B')
409: and B.LANGUAGE = userenv('LANG')
410: and not exists
411: (select NULL
412: from FND_REQUEST_SETS_TL T
413: where T.REQUEST_SET_ID = B.REQUEST_SET_ID
414: and T.APPLICATION_ID = B.APPLICATION_ID
415: and T.LANGUAGE = L.LANGUAGE_CODE);
416: end ADD_LANGUAGE;

Line 418: end FND_REQUEST_SETS_PKG;

414: and T.APPLICATION_ID = B.APPLICATION_ID
415: and T.LANGUAGE = L.LANGUAGE_CODE);
416: end ADD_LANGUAGE;
417:
418: end FND_REQUEST_SETS_PKG;