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.BIS_CREATE_REQUESTSET dependencies on FND_REQUEST

Line 117: fnd_request_sets_vl a,

113: cursor c_setname is
114: select
115: REQUEST_SET_NAME
116: from
117: fnd_request_sets_vl a,
118: fnd_application b
119: where a.USER_REQUEST_SET_NAME=p_setlongname
120: and a.application_id=b.application_id
121: and b.application_short_name=p_setapp;

Line 199: fnd_request_sets_vl a,

195: cursor c_setname is
196: select
197: REQUEST_SET_NAME
198: from
199: fnd_request_sets_vl a,
200: fnd_application b
201: where a.USER_REQUEST_SET_NAME=p_setlongname
202: and a.application_id=b.application_id
203: and b.application_short_name=p_setapp;

Line 533: fnd_request_sets a,

529: select
530: c.stage_name,
531: b.sequence
532: from
533: fnd_request_sets a,
534: fnd_request_set_programs b,
535: fnd_request_set_stages c,
536: fnd_concurrent_programs d,
537: fnd_application e,

Line 534: fnd_request_set_programs b,

530: c.stage_name,
531: b.sequence
532: from
533: fnd_request_sets a,
534: fnd_request_set_programs b,
535: fnd_request_set_stages c,
536: fnd_concurrent_programs d,
537: fnd_application e,
538: fnd_application f

Line 535: fnd_request_set_stages c,

531: b.sequence
532: from
533: fnd_request_sets a,
534: fnd_request_set_programs b,
535: fnd_request_set_stages c,
536: fnd_concurrent_programs d,
537: fnd_application e,
538: fnd_application f
539: where a.request_set_id=b.request_set_id

Line 550: -- added to pickup indexes on FND_REQUEST_SET_STAGES and FND_REQUEST_SET_PROGRAMS

546: and a.request_set_name=p_set_name
547: and d.concurrent_program_name=p_process_name
548: and e.application_short_name=p_set_app
549: and f.application_short_name=p_process_app
550: -- added to pickup indexes on FND_REQUEST_SET_STAGES and FND_REQUEST_SET_PROGRAMS
551: -- bug3143536
552: and c.set_application_id = a.application_id
553: and b.request_set_id = c.request_set_id
554: and a.application_id = b.set_application_id;

Line 582: fnd_request_sets a,

578: cursor c_max_seq is
579: select
580: max(b.sequence) max_prog_seq
581: from
582: fnd_request_sets a,
583: fnd_request_set_programs b,
584: fnd_request_set_stages c,
585: fnd_application d
586: where a.request_set_id=b.request_set_id

Line 583: fnd_request_set_programs b,

579: select
580: max(b.sequence) max_prog_seq
581: from
582: fnd_request_sets a,
583: fnd_request_set_programs b,
584: fnd_request_set_stages c,
585: fnd_application d
586: where a.request_set_id=b.request_set_id
587: and b.request_set_stage_id=c.request_set_stage_id

Line 584: fnd_request_set_stages c,

580: max(b.sequence) max_prog_seq
581: from
582: fnd_request_sets a,
583: fnd_request_set_programs b,
584: fnd_request_set_stages c,
585: fnd_application d
586: where a.request_set_id=b.request_set_id
587: and b.request_set_stage_id=c.request_set_stage_id
588: and a.request_set_id=c.request_set_id

Line 593: -- added to pickup indexes on FND_REQUEST_SET_STAGES and FND_REQUEST_SET_PROGRAMS

589: and a.application_id=d.application_id
590: and d.application_short_name=p_set_app
591: and a.request_set_name=p_set_name
592: and c.stage_name=p_stage_name
593: -- added to pickup indexes on FND_REQUEST_SET_STAGES and FND_REQUEST_SET_PROGRAMS
594: -- bug3143536
595: and c.set_application_id = a.application_id
596: and b.request_set_id = c.request_set_id
597: and a.application_id = b.set_application_id

Line 1109: fnd_request_sets a,

1105: cursor c_max_stage is
1106: select
1107: max(b.display_sequence)
1108: from
1109: fnd_request_sets a,
1110: fnd_request_set_stages b,
1111: fnd_application c
1112: where a.request_set_id=b.request_set_id
1113: and a.application_id=b.set_application_id

Line 1110: fnd_request_set_stages b,

1106: select
1107: max(b.display_sequence)
1108: from
1109: fnd_request_sets a,
1110: fnd_request_set_stages b,
1111: fnd_application c
1112: where a.request_set_id=b.request_set_id
1113: and a.application_id=b.set_application_id
1114: and a.application_id=c.application_id

Line 1406: from fnd_request_sets a,

1402: select 'Y'
1403: from dual
1404: where exists
1405: (select a.request_set_name
1406: from fnd_request_sets a,
1407: fnd_request_group_units b,
1408: fnd_request_groups c,
1409: fnd_application d1,
1410: fnd_application d2

Line 1407: fnd_request_group_units b,

1403: from dual
1404: where exists
1405: (select a.request_set_name
1406: from fnd_request_sets a,
1407: fnd_request_group_units b,
1408: fnd_request_groups c,
1409: fnd_application d1,
1410: fnd_application d2
1411: where a.application_id=b.unit_application_id

Line 1408: fnd_request_groups c,

1404: where exists
1405: (select a.request_set_name
1406: from fnd_request_sets a,
1407: fnd_request_group_units b,
1408: fnd_request_groups c,
1409: fnd_application d1,
1410: fnd_application d2
1411: where a.application_id=b.unit_application_id
1412: and a.request_set_id=b.request_unit_id

Line 1451: fnd_request_sets a,

1447: c.REQUEST_SET_STAGE_ID stage_id,
1448: c.STAGE_NAME stage_name,
1449: c.display_sequence
1450: from
1451: fnd_request_sets a,
1452: fnd_application b,
1453: fnd_request_set_stages c
1454: where
1455: a.application_id=b.application_id

Line 1453: fnd_request_set_stages c

1449: c.display_sequence
1450: from
1451: fnd_request_sets a,
1452: fnd_application b,
1453: fnd_request_set_stages c
1454: where
1455: a.application_id=b.application_id
1456: and b.application_short_name=p_setapp
1457: and a.application_id=c.SET_APPLICATION_ID

Line 1465: fnd_request_sets a,

1461:
1462: cursor c_start_stage is
1463: select start_stage
1464: from
1465: fnd_request_sets a,
1466: fnd_application b
1467: where
1468: a.application_id=b.application_id
1469: and a.request_set_name=p_set_name

Line 1529: update fnd_request_sets

1525: end if;
1526: close c_start_stage;
1527: if nvl(l_start_stage_id, -1)<>nvl(l_first_stage_id,-1) then
1528: ---update the start stage
1529: update fnd_request_sets
1530: set start_stage=l_first_stage_id
1531: where request_set_id=l_set_id
1532: and application_id=l_set_app_id;
1533: commit;

Line 1548: fnd_request_set_programs

1544: from dual
1545: where exists
1546: (select request_set_program_id
1547: from
1548: fnd_request_set_programs
1549: where set_application_id=p_setapp_id
1550: and request_set_id=p_set_id
1551: and request_set_stage_id=p_set_stage_id);
1552: l_dummy varchar2(1);

Line 1580: fnd_request_sets a,

1576: distinct
1577: b.stage_name,
1578: c.sequence
1579: from
1580: fnd_request_sets a,
1581: fnd_request_set_stages b,
1582: fnd_request_set_programs c,
1583: fnd_request_set_program_args d,
1584: fnd_application e

Line 1581: fnd_request_set_stages b,

1577: b.stage_name,
1578: c.sequence
1579: from
1580: fnd_request_sets a,
1581: fnd_request_set_stages b,
1582: fnd_request_set_programs c,
1583: fnd_request_set_program_args d,
1584: fnd_application e
1585: where a.request_set_id=b.request_set_id

Line 1582: fnd_request_set_programs c,

1578: c.sequence
1579: from
1580: fnd_request_sets a,
1581: fnd_request_set_stages b,
1582: fnd_request_set_programs c,
1583: fnd_request_set_program_args d,
1584: fnd_application e
1585: where a.request_set_id=b.request_set_id
1586: and a.application_id=b.set_application_id

Line 1583: fnd_request_set_program_args d,

1579: from
1580: fnd_request_sets a,
1581: fnd_request_set_stages b,
1582: fnd_request_set_programs c,
1583: fnd_request_set_program_args d,
1584: fnd_application e
1585: where a.request_set_id=b.request_set_id
1586: and a.application_id=b.set_application_id
1587: and a.application_id=e.application_id

Line 1825: fnd_request_sets a,

1821: cursor c_min_stage is
1822: select
1823: min(b.display_sequence)
1824: from
1825: fnd_request_sets a,
1826: fnd_request_set_stages b,
1827: fnd_application c
1828: where a.request_set_id=b.request_set_id
1829: and a.application_id=b.set_application_id

Line 1826: fnd_request_set_stages b,

1822: select
1823: min(b.display_sequence)
1824: from
1825: fnd_request_sets a,
1826: fnd_request_set_stages b,
1827: fnd_application c
1828: where a.request_set_id=b.request_set_id
1829: and a.application_id=b.set_application_id
1830: and a.application_id=c.application_id

Line 2332: fnd_request_sets b,

2328: cursor c_pages is
2329: select distinct a.object_name,a.object_type
2330: from
2331: bis_request_set_objects a,
2332: fnd_request_sets b,
2333: fnd_application c
2334: where a.request_set_name=b.request_set_name
2335: and a.set_app_id=b.application_id
2336: and b.request_set_name=upper(p_request_set_code)

Line 2511: fnd_request_set_programs a,

2507: select distinct
2508: 'REPORT' object_type,
2509: c.default_value object_name
2510: from
2511: fnd_request_set_programs a,
2512: fnd_request_set_program_args c
2513: where a.set_application_id=p_set_app_id
2514: and a.request_set_id=p_set_id
2515: and a.request_set_stage_id=p_stage_id

Line 2512: fnd_request_set_program_args c

2508: 'REPORT' object_type,
2509: c.default_value object_name
2510: from
2511: fnd_request_set_programs a,
2512: fnd_request_set_program_args c
2513: where a.set_application_id=p_set_app_id
2514: and a.request_set_id=p_set_id
2515: and a.request_set_stage_id=p_stage_id
2516: and a.request_set_id=c.request_set_id

Line 2747: fnd_request_sets a,

2743: c.REQUEST_SET_STAGE_ID stage_id,
2744: c.STAGE_NAME stage_name,
2745: c.display_sequence
2746: from
2747: fnd_request_sets a,
2748: fnd_application b,
2749: fnd_request_set_stages c
2750: where
2751: a.application_id=b.application_id

Line 2749: fnd_request_set_stages c

2745: c.display_sequence
2746: from
2747: fnd_request_sets a,
2748: fnd_application b,
2749: fnd_request_set_stages c
2750: where
2751: a.application_id=b.application_id
2752: and b.application_short_name=p_setapp
2753: and a.application_id=c.SET_APPLICATION_ID

Line 2762: fnd_request_sets a,

2758: cursor c_max_stage is
2759: select
2760: max(b.display_sequence)
2761: from
2762: fnd_request_sets a,
2763: fnd_request_set_stages b,
2764: fnd_application c
2765: where a.request_set_id=b.request_set_id
2766: and a.application_id=b.set_application_id

Line 2763: fnd_request_set_stages b,

2759: select
2760: max(b.display_sequence)
2761: from
2762: fnd_request_sets a,
2763: fnd_request_set_stages b,
2764: fnd_application c
2765: where a.request_set_id=b.request_set_id
2766: and a.application_id=b.set_application_id
2767: and a.application_id=c.application_id

Line 2775: fnd_request_sets a,

2771: cursor c_min_stage is
2772: select
2773: min(b.display_sequence)
2774: from
2775: fnd_request_sets a,
2776: fnd_request_set_stages b,
2777: fnd_application c
2778: where a.request_set_id=b.request_set_id
2779: and a.application_id=b.set_application_id

Line 2776: fnd_request_set_stages b,

2772: select
2773: min(b.display_sequence)
2774: from
2775: fnd_request_sets a,
2776: fnd_request_set_stages b,
2777: fnd_application c
2778: where a.request_set_id=b.request_set_id
2779: and a.application_id=b.set_application_id
2780: and a.application_id=c.application_id

Line 2801: fnd_request_set_programs a,

2797: select distinct
2798: c.object_type,
2799: c.object_name
2800: from
2801: fnd_request_set_programs a,
2802: fnd_concurrent_programs b,
2803: bis_obj_prog_linkages c,
2804: BIS_BIA_RSG_STAGE_OBJECTS d
2805: where a.set_application_id=p_set_app_id

Line 2822: fnd_request_set_programs a,

2818: select distinct
2819: 'MV' object_type,
2820: c.default_value object_name
2821: from
2822: fnd_request_set_programs a,
2823: fnd_request_set_program_args c
2824: where a.set_application_id=p_set_app_id
2825: and a.request_set_id=p_set_id
2826: and a.request_set_stage_id=p_stage_id

Line 2823: fnd_request_set_program_args c

2819: 'MV' object_type,
2820: c.default_value object_name
2821: from
2822: fnd_request_set_programs a,
2823: fnd_request_set_program_args c
2824: where a.set_application_id=p_set_app_id
2825: and a.request_set_id=p_set_id
2826: and a.request_set_stage_id=p_stage_id
2827: and a.request_set_id=c.request_set_id

Line 2840: fnd_request_set_programs a,

2836: is
2837: select
2838: distinct d.CUSTOM_API custom_api
2839: from
2840: fnd_request_set_programs a,
2841: fnd_concurrent_programs b,
2842: bis_obj_prog_linkages c,
2843: bis_obj_properties d
2844: where a.set_application_id=p_set_app_id

Line 3557: fnd_request_sets_vl c

3553: cursor c_set_with_unimpl_obj is
3554: select distinct c.user_request_set_name from
3555: bis_request_set_objects a,
3556: bis_obj_properties b,
3557: fnd_request_sets_vl c
3558: where a.object_name=b.object_name
3559: and a.object_type=b.object_type
3560: and b.implementation_flag='N'
3561: and a.request_set_name=c.request_set_name

Line 3691: l_request_id := FND_REQUEST.SUBMIT_REQUEST (

3687:
3688: BEGIN
3689: BIS_COLLECTION_UTILITIES.put_line('********************************************************');
3690: BIS_COLLECTION_UTILITIES.put_line('kicking off RSG seed data validation program');
3691: l_request_id := FND_REQUEST.SUBMIT_REQUEST (
3692: APPLICATION=> 'BIS',
3693: PROGRAM=>'BIS_BIA_RSG_VALIDATION',
3694: DESCRIPTION=>NULL,
3695: START_TIME=>NULL ,

Line 3742: l_request_id := FND_REQUEST.SUBMIT_REQUEST (

3738: end if;
3739: close force_full_refresh ;
3740:
3741: if l_refresh_mode='INIT' and l_force_full_refresh='Y' then
3742: l_request_id := FND_REQUEST.SUBMIT_REQUEST (
3743: APPLICATION=> 'BIS',
3744: PROGRAM=>'BIS_BIA_RSG_MLOG_CAD',
3745: DESCRIPTION=>NULL,
3746: START_TIME=>NULL ,

Line 3786: l_request_id := FND_REQUEST.SUBMIT_REQUEST (

3782: l_root_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;
3783: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.CONC_PRIORITY_REQUEST: ' || l_root_request_id);
3784: fnd_profile.put ('CONC_SINGLE_THREAD','N');
3785:
3786: l_request_id := FND_REQUEST.SUBMIT_REQUEST (
3787: 'BIS',
3788: 'BIS_MV_DUMMY_REFRESH',
3789: NULL,
3790: NULL,

Line 3804: l_request_id := FND_REQUEST.SUBMIT_REQUEST (

3800:
3801:
3802: ---launch update last refresh date program at last so that
3803: ---it can update last refresh time for custom KPI objects
3804: l_request_id := FND_REQUEST.SUBMIT_REQUEST (
3805: 'BIS',
3806: 'BIS_LAST_REFRESH_DATE_CONC',
3807: NULL,
3808: NULL,

Line 3935: fnd_request_sets b

3931: cursor c_page_objects is
3932: select distinct a.object_name,a.object_type
3933: from
3934: bis_request_set_objects a,
3935: fnd_request_sets b
3936: where a.request_set_name=b.request_set_name
3937: and a.set_app_id=b.application_id
3938: and b.request_set_name=p_request_set_code
3939: and b.application_id=191;

Line 4018: l_request_id := FND_REQUEST.SUBMIT_REQUEST (

4014: if l_kpi_list is not null and loader_exist='Y' then
4015: if loading_mode(p_request_set_code)='INIT' and force_full_refresh(p_request_set_code)='Y' then
4016: BIS_COLLECTION_UTILITIES.put_line('Initial loading mode. calling loader program to delete data from indicators');
4017:
4018: l_request_id := FND_REQUEST.SUBMIT_REQUEST (
4019: 'BSC',
4020: 'BSC_DELETE_DATA_IND',
4021: NULL,
4022: NULL,

Line 4040: l_request_id := FND_REQUEST.SUBMIT_REQUEST (

4036: x_set_request_id => FND_GLOBAL.CONC_PRIORITY_REQUEST);
4037: END IF;
4038: end if;
4039: BIS_COLLECTION_UTILITIES.put_line('Call loader program to load custom dimensions');
4040: l_request_id := FND_REQUEST.SUBMIT_REQUEST (
4041: 'BSC',
4042: 'BSC_REFRESH_DIM_IND',
4043: NULL,
4044: NULL,

Line 4060: l_request_id := FND_REQUEST.SUBMIT_REQUEST (

4056: x_refresh_type => loading_mode(p_request_set_code),
4057: x_set_request_id => FND_GLOBAL.CONC_PRIORITY_REQUEST);
4058: END IF;
4059: BIS_COLLECTION_UTILITIES.put_line('Call loader program to load data for indicators');
4060: l_request_id := FND_REQUEST.SUBMIT_REQUEST (
4061: 'BSC',
4062: 'BSC_REFRESH_SUMMARY_IND',
4063: NULL,
4064: NULL,

Line 4151: fnd_request_sets b,

4147: cursor c_pages is
4148: select distinct a.object_name,a.object_type
4149: from
4150: bis_request_set_objects a,
4151: fnd_request_sets b,
4152: fnd_application c
4153: where a.request_set_name=b.request_set_name
4154: and a.set_app_id=b.application_id
4155: and b.request_set_name=upper(p_request_set_code)

Line 4311: from fnd_request_sets r ,fnd_request_set_stages s,

4307: report_stage_name varchar2(200);
4308: cursor c_stages
4309: is
4310: select s.STAGE_NAME
4311: from fnd_request_sets r ,fnd_request_set_stages s,
4312: fnd_application app
4313: where r.REQUEST_SET_ID= s.REQUEST_SET_ID
4314: and r.application_id = s.set_Application_id
4315: and r.REQUEST_SET_NAME = p_set_name

Line 4446: FROM BIS_RS_STAGE_RUN_HISTORY bis, FND_REQUEST_SET_STAGES_VL fnd

4442: WHERE bis.set_request_id = l_root_request_id AND bis.status_code ='E'
4443: AND bis.prog_app_id = fnd.application_id AND bis.program_id = fnd.concurrent_program_id
4444: UNION
4445: SELECT request_id, user_stage_name NAME, 'STAGE' TYPE
4446: FROM BIS_RS_STAGE_RUN_HISTORY bis, FND_REQUEST_SET_STAGES_VL fnd
4447: WHERE set_request_id = l_root_request_id AND status_code ='E'
4448: AND bis.set_app_id = fnd.set_application_id AND bis.request_set_id = fnd.request_set_id
4449: AND bis.stage_id = fnd.request_set_stage_id ;
4450:

Line 4448: AND bis.set_app_id = fnd.set_application_id AND bis.request_set_id = fnd.request_set_id

4444: UNION
4445: SELECT request_id, user_stage_name NAME, 'STAGE' TYPE
4446: FROM BIS_RS_STAGE_RUN_HISTORY bis, FND_REQUEST_SET_STAGES_VL fnd
4447: WHERE set_request_id = l_root_request_id AND status_code ='E'
4448: AND bis.set_app_id = fnd.set_application_id AND bis.request_set_id = fnd.request_set_id
4449: AND bis.stage_id = fnd.request_set_stage_id ;
4450:
4451: l_request_id VARCHAR2(100);
4452: l_name VARCHAR2(240);

Line 4449: AND bis.stage_id = fnd.request_set_stage_id ;

4445: SELECT request_id, user_stage_name NAME, 'STAGE' TYPE
4446: FROM BIS_RS_STAGE_RUN_HISTORY bis, FND_REQUEST_SET_STAGES_VL fnd
4447: WHERE set_request_id = l_root_request_id AND status_code ='E'
4448: AND bis.set_app_id = fnd.set_application_id AND bis.request_set_id = fnd.request_set_id
4449: AND bis.stage_id = fnd.request_set_stage_id ;
4450:
4451: l_request_id VARCHAR2(100);
4452: l_name VARCHAR2(240);
4453: l_type VARCHAR2(10);

Line 4515: FROM fnd_concurrent_requests cr, fnd_request_sets rs

4511: FUNCTION is_history_collect_on(p_root_request_id IN NUMBER) RETURN BOOLEAN
4512: IS
4513: CURSOR c_request_set_details IS
4514: SELECT rs.request_set_name
4515: FROM fnd_concurrent_requests cr, fnd_request_sets rs
4516: WHERE cr.request_id = p_root_request_id
4517: AND rs.application_id = cr.argument1
4518: AND rs.request_set_id = cr.argument2;
4519: l_request_set_name VARCHAR2(1000);