APPS.BIS_CREATE_REQUESTSET dependencies on FND_CONCURRENT_PROGRAMS

Line 536: fnd_concurrent_programs d,

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
540: and b.request_set_stage_id=c.request_set_stage_id

Line 1092: fnd_concurrent_programs b

1088: a.CONC_PROGRAM_NAME CONCURRENT_PROGRAM_NAME,
1089: a.CONC_APP_SHORT_NAME APPLICATION_SHORT_NAME
1090: from
1091: bis_obj_prog_linkages a,
1092: fnd_concurrent_programs b
1093: where a.object_name=p_objectname
1094: and a.object_type=p_objecttype
1095: and a.enabled_flag='Y'
1096: and a.CONC_PROGRAM_NAME<>g_bsc_loader_ind_program

Line 1811: fnd_concurrent_programs b

1807: a.CONC_PROGRAM_NAME CONCURRENT_PROGRAM_NAME,
1808: a.CONC_APP_SHORT_NAME APPLICATION_SHORT_NAME
1809: from
1810: bis_obj_prog_linkages a,
1811: fnd_concurrent_programs b
1812: where a.object_name=p_objectname
1813: and a.object_type=p_objecttype
1814: and a.enabled_flag='Y'
1815: ---and (nvl(a.refresh_mode,'INCR')=p_refresh_mode or nvl(a.refresh_mode,'INCR')='INIT_INCR')

Line 2802: fnd_concurrent_programs b,

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
2806: and a.request_set_id=p_set_id

Line 2841: fnd_concurrent_programs b,

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
2845: and a.request_set_id=p_set_id

Line 3638: FROM fnd_concurrent_programs prog, fnd_concurrent_requests req

3634: req.request_id = p_req_id ;
3635:
3636: CURSOR mv_log_truncate_running IS
3637: SELECT req.request_id REQUEST, req.phase_code Phase, requested_start_date s_date
3638: FROM fnd_concurrent_programs prog, fnd_concurrent_requests req
3639: WHERE prog.CONCURRENT_PROGRAM_NAME = 'BIS_BIA_TRUNCATE_EMPTY_MV_LOGS'
3640: AND req.concurrent_program_id = prog.concurrent_program_id
3641: AND req.program_application_id = prog.application_id
3642: AND req.phase_code = 'R';

Line 3863: from fnd_concurrent_programs

3859: begin
3860: l_exist_flag:='N';
3861: select 'Y'
3862: into l_exist_flag
3863: from fnd_concurrent_programs
3864: where concurrent_program_name='BSC_LOAD_INDICATORS_DATA'
3865: and application_id=271;
3866: return l_exist_flag;
3867: exception

Line 4441: FROM BIS_RS_PROG_RUN_HISTORY bis, FND_CONCURRENT_PROGRAMS_VL fnd

4437: l_root_request_id NUMBER;
4438:
4439: CURSOR c_get_all_prog_status IS
4440: SELECT request_id, user_concurrent_program_name NAME, 'PROG' TYPE
4441: FROM BIS_RS_PROG_RUN_HISTORY bis, FND_CONCURRENT_PROGRAMS_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