DBA Data[Home] [Help]

APPS.BIS_COLL_RS_HISTORY dependencies on FND_CONCURRENT_PROGRAMS

Line 103: from fnd_concurrent_programs

99: c_sub_programs_Rec c_sub_programs%rowtype;
100:
101: cursor c_get_program_id is
102: select CONCURRENT_PROGRAM_ID
103: from fnd_concurrent_programs
104: where concurrent_program_name ='FNDGTST'
105: and APPLICATION_ID =0;
106:
107: cursor c_obj_type(l_object_name varchar2 ) is

Line 118: fnd_concurrent_programs fnd,

114: --for MVs of type consider refresh
115: cursor c_refresh_mv is
116: select obj.prog_request_id request_id
117: from BIS_RS_PROG_RUN_HISTORY prog,
118: fnd_concurrent_programs fnd,
119: BIS_OBJ_REFRESH_HISTORY obj
120: where prog.set_request_id = l_root_request_id
121: and prog.program_id = fnd.CONCURRENT_PROGRAM_ID
122: and fnd.CONCURRENT_PROGRAM_NAME ='BIS_MV_REFRESH'

Line 134: from fnd_concurrent_programs

130: from BIS_RS_PROG_RUN_HISTORY
131: where set_request_id = l_root_request_id
132: and PROG_APP_ID =191
133: and program_id = ( select CONCURRENT_PROGRAM_ID
134: from fnd_concurrent_programs
135: where CONCURRENT_PROGRAM_NAME ='BIS_MV_DUMMY_REFRESH' and APPLICATION_ID =191);
136:
137: -- get_stage
138: cursor c_get_stage(p_prog_req_id in number) is

Line 461: from fnd_concurrent_requests req, fnd_concurrent_programs prog

457: actual_start_date,
458: actual_completion_date,
459: completion_text,
460: concurrent_program_name
461: from fnd_concurrent_requests req, fnd_concurrent_programs prog
462: where request_id = x_request_id and req.concurrent_program_id = prog.concurrent_program_id
463: and req.program_application_id = prog.application_id;
464:
465: req_details_rec request_details%rowtype;

Line 478: fnd_concurrent_programs fnd,

474: select linkage.OBJECT_TYPE obj_type,
475: linkage.object_name obj_name,
476: linkage.refresh_mode obj_refresh_mode
477: from BIS_RS_PROG_RUN_HISTORY prog,
478: fnd_concurrent_programs fnd,
479: bis_obj_prog_linkages linkage
480: where prog.request_id = x_request_id
481: and prog.program_id = fnd.CONCURRENT_PROGRAM_ID
482: and prog.prog_app_id = fnd.application_id