APPS.BIS_TREND_PLUG dependencies on BIS_SCHEDULER

Line 277: -- mdamle 08/21/01 - Only one user_id, plug_id combination exists in bis_scheduler from now on

273:
274:
275: else
276:
277: -- mdamle 08/21/01 - Only one user_id, plug_id combination exists in bis_scheduler from now on
278: -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
279: begin
280: SELECT sp.title
281: , sp.file_id

Line 299: FROM bis_scheduler s, bis_schedule_preferences sp, fnd_form_functions ff, fnd_lobs l

295: , l_parameters
296: , l_fn_responsibility_id
297: , l_schedule_id
298: , l_file_content_type
299: FROM bis_scheduler s, bis_schedule_preferences sp, fnd_form_functions ff, fnd_lobs l
300: WHERE sp.USER_ID = l_user_id
301: AND sp.PLUG_ID = p_plug_id
302: AND sp.schedule_id = s.schedule_id
303: AND ff.function_name = s.function_name

Line 747: FROM bis_scheduler

743: ELSE
744: BEGIN
745: SELECT responsibility_id
746: INTO vResponsibilityId
747: FROM bis_scheduler
748: WHERE schedule_Id = pScheduleId;
749: EXCEPTION
750: WHEN OTHERS THEN
751: NULL;

Line 1262: -- add row in the bis_scheduler preferences table

1258: BEGIN
1259:
1260: -- validate sessionx
1261: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
1262: -- add row in the bis_scheduler preferences table
1263: BIS_RG_SCHEDULES_PVT.CREATE_SCHEDULE_NO_COMMIT (
1264: p_plug_id => pPlugId,
1265: p_user_id => pUserId,
1266: p_function_name => pFunctionName,