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_SET_STAGES_PKG dependencies on FND_REQUEST_SET_STAGES

Line 1: package body FND_REQUEST_SET_STAGES_PKG as

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

Line 31: cursor C is select ROWID from FND_REQUEST_SET_STAGES

27: X_LAST_UPDATE_DATE in DATE,
28: X_LAST_UPDATED_BY in NUMBER,
29: X_LAST_UPDATE_LOGIN in NUMBER
30: ) is
31: cursor C is select ROWID from FND_REQUEST_SET_STAGES
32: where REQUEST_SET_ID = X_REQUEST_SET_ID
33: and SET_APPLICATION_ID = X_SET_APPLICATION_ID
34: and REQUEST_SET_STAGE_ID = X_REQUEST_SET_STAGE_ID
35: ;

Line 37: insert into FND_REQUEST_SET_STAGES (

33: and SET_APPLICATION_ID = X_SET_APPLICATION_ID
34: and REQUEST_SET_STAGE_ID = X_REQUEST_SET_STAGE_ID
35: ;
36: begin
37: insert into FND_REQUEST_SET_STAGES (
38: SET_APPLICATION_ID,
39: REQUEST_SET_ID,
40: REQUEST_SET_STAGE_ID,
41: STAGE_NAME,

Line 85: insert into FND_REQUEST_SET_STAGES_TL (

81: X_LAST_UPDATED_BY,
82: X_LAST_UPDATE_LOGIN
83: );
84:
85: insert into FND_REQUEST_SET_STAGES_TL (
86: SET_APPLICATION_ID,
87: REQUEST_SET_ID,
88: REQUEST_SET_STAGE_ID,
89: CREATION_DATE,

Line 115: from FND_REQUEST_SET_STAGES_TL T

111: from FND_LANGUAGES L
112: where L.INSTALLED_FLAG in ('I', 'B')
113: and not exists
114: (select NULL
115: from FND_REQUEST_SET_STAGES_TL T
116: where T.REQUEST_SET_ID = X_REQUEST_SET_ID
117: and T.SET_APPLICATION_ID = X_SET_APPLICATION_ID
118: and T.REQUEST_SET_STAGE_ID = X_REQUEST_SET_STAGE_ID
119: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 167: from FND_REQUEST_SET_STAGES

163: CONCURRENT_PROGRAM_ID,
164: X,
165: Y,
166: ICON_NAME
167: from FND_REQUEST_SET_STAGES
168: where REQUEST_SET_ID = X_REQUEST_SET_ID
169: and SET_APPLICATION_ID = X_SET_APPLICATION_ID
170: and REQUEST_SET_STAGE_ID = X_REQUEST_SET_STAGE_ID
171: for update of REQUEST_SET_ID nowait;

Line 177: from FND_REQUEST_SET_STAGES_TL

173:
174: cursor c1 is select
175: USER_STAGE_NAME,
176: DESCRIPTION
177: from FND_REQUEST_SET_STAGES_TL
178: where REQUEST_SET_ID = X_REQUEST_SET_ID
179: and SET_APPLICATION_ID = X_SET_APPLICATION_ID
180: and REQUEST_SET_STAGE_ID = X_REQUEST_SET_STAGE_ID
181: and LANGUAGE = userenv('LANG')

Line 269: update FND_REQUEST_SET_STAGES set

265: X_LAST_UPDATED_BY in NUMBER,
266: X_LAST_UPDATE_LOGIN in NUMBER
267: ) is
268: begin
269: update FND_REQUEST_SET_STAGES set
270: STAGE_NAME = X_STAGE_NAME,
271: CRITICAL = X_CRITICAL,
272: OUTCOME = X_OUTCOME,
273: ALLOW_CONSTRAINTS_FLAG = X_ALLOW_CONSTRAINTS_FLAG,

Line 295: update FND_REQUEST_SET_STAGES_TL set

291: if (sql%notfound) then
292: raise no_data_found;
293: end if;
294:
295: update FND_REQUEST_SET_STAGES_TL set
296: USER_STAGE_NAME = X_USER_STAGE_NAME,
297: DESCRIPTION = X_DESCRIPTION,
298: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
299: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 341: FROM fnd_request_set_stages_vl WHERE (success_link = bad_stage_id)

337:
338: bad_link_counter BINARY_INTEGER := 0;
339:
340: CURSOR get_bad_links IS SELECT set_application_id, request_set_id, request_set_stage_id
341: FROM fnd_request_set_stages_vl WHERE (success_link = bad_stage_id)
342: OR (warning_link = bad_stage_id)
343: OR (error_link = bad_stage_id);
344:
345: --BUG 871226 (End of Added Declarations)

Line 355: from fnd_request_set_stages

351: set enabled_flag='N'
352: where application_id = x_set_application_id
353: and concurrent_program_id in
354: (select concurrent_program_id
355: from fnd_request_set_stages
356: where set_application_id = x_set_application_id
357: and request_set_id = x_request_set_id
358: and request_set_stage_id = x_request_set_stage_id
359: and concurrent_program_id is null);

Line 364: FROM fnd_request_set_stages_vl

360:
361: --BUG 871226 (Begin of Added Code)
362:
363: SELECT request_set_stage_id INTO bad_stage_id
364: FROM fnd_request_set_stages_vl
365: WHERE set_application_id = x_set_application_id
366: AND request_set_id = x_request_set_id
367: AND request_set_stage_id = x_request_set_stage_id;
368:

Line 386: FROM fnd_request_set_stages_vl WHERE

382:
383: FOR array_index IN 0..bad_link_counter - 1 LOOP -- dec 1 from counter because too high
384:
385: SELECT success_link,warning_link,error_link INTO bad_SL,bad_WL,bad_EL
386: FROM fnd_request_set_stages_vl WHERE
387: set_application_id = set_app_id_array(array_index) AND
388: request_set_id = req_set_id_array(array_index) AND
389: request_set_stage_id = req_set_stage_id_array(array_index);
390:

Line 392: UPDATE fnd_request_set_stages SET success_link = NULL WHERE

388: request_set_id = req_set_id_array(array_index) AND
389: request_set_stage_id = req_set_stage_id_array(array_index);
390:
391: IF (bad_SL = bad_stage_id ) THEN
392: UPDATE fnd_request_set_stages SET success_link = NULL WHERE
393: set_application_id = set_app_id_array(array_index) AND
394: request_set_id = req_set_id_array(array_index) AND
395: request_set_stage_id = req_set_stage_id_array(array_index);
396: END IF;

Line 399: UPDATE fnd_request_set_stages SET warning_link = NULL WHERE

395: request_set_stage_id = req_set_stage_id_array(array_index);
396: END IF;
397:
398: IF (bad_WL = bad_stage_id) THEN
399: UPDATE fnd_request_set_stages SET warning_link = NULL WHERE
400: set_application_id = set_app_id_array(array_index) AND
401: request_set_id = req_set_id_array(array_index) AND
402: request_set_stage_id = req_set_stage_id_array(array_index);
403: END IF;

Line 406: UPDATE fnd_request_set_stages SET error_link = NULL WHERE

402: request_set_stage_id = req_set_stage_id_array(array_index);
403: END IF;
404:
405: IF (bad_EL = bad_stage_id) THEN
406: UPDATE fnd_request_set_stages SET error_link = NULL WHERE
407: set_application_id = set_app_id_array(array_index) AND
408: request_set_id = req_set_id_array(array_index) AND
409: request_set_stage_id = req_set_stage_id_array(array_index);
410: END IF;

Line 437: delete from FND_REQUEST_SET_STAGES

433: where SET_APPLICATION_ID = X_SET_APPLICATION_ID
434: and REQUEST_SET_ID = X_REQUEST_SET_ID
435: and REQUEST_SET_STAGE_ID = X_REQUEST_SET_STAGE_ID;
436:
437: delete from FND_REQUEST_SET_STAGES
438: where SET_APPLICATION_ID = X_SET_APPLICATION_ID
439: and REQUEST_SET_ID = X_REQUEST_SET_ID
440: and REQUEST_SET_STAGE_ID = X_REQUEST_SET_STAGE_ID;
441:

Line 446: delete from FND_REQUEST_SET_STAGES_TL

442: if (sql%notfound) then
443: raise no_data_found;
444: end if;
445:
446: delete from FND_REQUEST_SET_STAGES_TL
447: where SET_APPLICATION_ID = X_SET_APPLICATION_ID
448: and REQUEST_SET_ID = X_REQUEST_SET_ID
449: and REQUEST_SET_STAGE_ID = X_REQUEST_SET_STAGE_ID;
450:

Line 466: delete from FND_REQUEST_SET_STAGES_TL T

462: /* as a quick workaround to fix the time-consuming table handler issue */
463: /* Eventually we'll need to turn them into a separate fix_language procedure */
464: /*
465:
466: delete from FND_REQUEST_SET_STAGES_TL T
467: where not exists
468: (select NULL
469: from FND_REQUEST_SET_STAGES B
470: where B.REQUEST_SET_ID = T.REQUEST_SET_ID

Line 469: from FND_REQUEST_SET_STAGES B

465:
466: delete from FND_REQUEST_SET_STAGES_TL T
467: where not exists
468: (select NULL
469: from FND_REQUEST_SET_STAGES B
470: where B.REQUEST_SET_ID = T.REQUEST_SET_ID
471: and B.SET_APPLICATION_ID = T.SET_APPLICATION_ID
472: and B.REQUEST_SET_STAGE_ID = T.REQUEST_SET_STAGE_ID
473: );

Line 475: update FND_REQUEST_SET_STAGES_TL T set (

471: and B.SET_APPLICATION_ID = T.SET_APPLICATION_ID
472: and B.REQUEST_SET_STAGE_ID = T.REQUEST_SET_STAGE_ID
473: );
474:
475: update FND_REQUEST_SET_STAGES_TL T set (
476: USER_STAGE_NAME,
477: DESCRIPTION
478: ) = (select
479: B.USER_STAGE_NAME,

Line 481: from FND_REQUEST_SET_STAGES_TL B

477: DESCRIPTION
478: ) = (select
479: B.USER_STAGE_NAME,
480: B.DESCRIPTION
481: from FND_REQUEST_SET_STAGES_TL B
482: where B.REQUEST_SET_ID = T.REQUEST_SET_ID
483: and B.SET_APPLICATION_ID = T.SET_APPLICATION_ID
484: and B.REQUEST_SET_STAGE_ID = T.REQUEST_SET_STAGE_ID
485: and B.LANGUAGE = T.SOURCE_LANG)

Line 496: from FND_REQUEST_SET_STAGES_TL SUBB, FND_REQUEST_SET_STAGES_TL SUBT

492: SUBT.REQUEST_SET_ID,
493: SUBT.SET_APPLICATION_ID,
494: SUBT.REQUEST_SET_STAGE_ID,
495: SUBT.LANGUAGE
496: from FND_REQUEST_SET_STAGES_TL SUBB, FND_REQUEST_SET_STAGES_TL SUBT
497: where SUBB.REQUEST_SET_ID = SUBT.REQUEST_SET_ID
498: and SUBB.SET_APPLICATION_ID = SUBT.SET_APPLICATION_ID
499: and SUBB.REQUEST_SET_STAGE_ID = SUBT.REQUEST_SET_STAGE_ID
500: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 508: insert into FND_REQUEST_SET_STAGES_TL (

504: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
505: ));
506: */
507:
508: insert into FND_REQUEST_SET_STAGES_TL (
509: SET_APPLICATION_ID,
510: REQUEST_SET_ID,
511: REQUEST_SET_STAGE_ID,
512: CREATION_DATE,

Line 534: from FND_REQUEST_SET_STAGES_TL B, FND_LANGUAGES L

530: B.USER_STAGE_NAME,
531: B.DESCRIPTION,
532: L.LANGUAGE_CODE,
533: B.SOURCE_LANG
534: from FND_REQUEST_SET_STAGES_TL B, FND_LANGUAGES L
535: where L.INSTALLED_FLAG in ('I', 'B')
536: and B.LANGUAGE = userenv('LANG')
537: and not exists
538: (select NULL

Line 539: from FND_REQUEST_SET_STAGES_TL T

535: where L.INSTALLED_FLAG in ('I', 'B')
536: and B.LANGUAGE = userenv('LANG')
537: and not exists
538: (select NULL
539: from FND_REQUEST_SET_STAGES_TL T
540: where T.REQUEST_SET_ID = B.REQUEST_SET_ID
541: and T.SET_APPLICATION_ID = B.SET_APPLICATION_ID
542: and T.REQUEST_SET_STAGE_ID = B.REQUEST_SET_STAGE_ID
543: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 546: end FND_REQUEST_SET_STAGES_PKG;

542: and T.REQUEST_SET_STAGE_ID = B.REQUEST_SET_STAGE_ID
543: and T.LANGUAGE = L.LANGUAGE_CODE);
544: end ADD_LANGUAGE;
545:
546: end FND_REQUEST_SET_STAGES_PKG;