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_RG_SCHEDULES_PVT dependencies on BIS_SCHEDULER

Line 8: -- DESCRIPTION: Private package to create records in BIS_SCHEDULER

4: -- dbdrv: checkfile(115.62=120.2.12000000.3):~PROD:~PATH:~FILE
5: ----------------------------------------------------------------------------
6: -- PACKAGE: BIS_SCHEDULE_PVT
7: -- --
8: -- DESCRIPTION: Private package to create records in BIS_SCHEDULER
9: --
10: -- --
11: -- MODIFICATIONS --
12: -- Date User Modification

Line 259: SELECT bis_scheduler_s.nextval INTO l_schedule_id FROM dual;

255: delete_portlet(p_plug_id, p_user_id);
256: end if;
257: */
258:
259: SELECT bis_scheduler_s.nextval INTO l_schedule_id FROM dual;
260: INSERT INTO BIS_SCHEDULER
261: (schedule_id
262: -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
263: --,plug_id

Line 260: INSERT INTO BIS_SCHEDULER

256: end if;
257: */
258:
259: SELECT bis_scheduler_s.nextval INTO l_schedule_id FROM dual;
260: INSERT INTO BIS_SCHEDULER
261: (schedule_id
262: -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
263: --,plug_id
264: ,user_id

Line 356: SELECT bis_scheduler_s.nextval INTO l_schedule_id FROM dual;

352: if p_plug_id is not null then
353: delete_portlet(p_plug_id, p_user_id);
354: end if;
355: */
356: SELECT bis_scheduler_s.nextval INTO l_schedule_id FROM dual;
357: INSERT INTO BIS_SCHEDULER
358: (schedule_id
359: -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
360: -- ,plug_id

Line 357: INSERT INTO BIS_SCHEDULER

353: delete_portlet(p_plug_id, p_user_id);
354: end if;
355: */
356: SELECT bis_scheduler_s.nextval INTO l_schedule_id FROM dual;
357: INSERT INTO BIS_SCHEDULER
358: (schedule_id
359: -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
360: -- ,plug_id
361: ,user_id

Line 557: SELECT bis_scheduler_s.nextval INTO l_schedule_id FROM dual;

553: l_request_type := 'R';
554: else
555: l_request_type := p_request_type;
556: END IF;
557: SELECT bis_scheduler_s.nextval INTO l_schedule_id FROM dual;
558: INSERT INTO BIS_SCHEDULER
559: (schedule_id
560: -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
561: --,plug_id

Line 558: INSERT INTO BIS_SCHEDULER

554: else
555: l_request_type := p_request_type;
556: END IF;
557: SELECT bis_scheduler_s.nextval INTO l_schedule_id FROM dual;
558: INSERT INTO BIS_SCHEDULER
559: (schedule_id
560: -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
561: --,plug_id
562: ,user_id

Line 658: UPDATE BIS_SCHEDULER

654: ,p_parameters IN VARCHAR2 default null
655: )
656: IS
657: BEGIN
658: UPDATE BIS_SCHEDULER
659: SET user_id = p_user_id
660: ,function_name = p_function_name
661: ,title = p_title
662: ,graph_type = p_graph_type

Line 688: UPDATE bis_scheduler

684: IS
685: BEGIN
686: -- mdamle 07/03/01 - Scheduling Enhancements
687: -- Added parameters field to update
688: UPDATE bis_scheduler
689: SET concurrent_request_id = p_concurrent_request_id
690: , parameter_string = p_parameters
691: WHERE schedule_id = p_schedule_id;
692:

Line 1268: start with request_id = (select s.concurrent_request_id from bis_scheduler s where schedule_id = vDupScheduleId)

1264: select to_char(max(requested_start_date), 'Mon DD, YYYY HH:MI AM')
1265: into vLastRun
1266: from fnd_concurrent_requests
1267: where phase_code = 'C'
1268: start with request_id = (select s.concurrent_request_id from bis_scheduler s where schedule_id = vDupScheduleId)
1269: connect by prior request_id = parent_request_id;
1270:
1271: -- Get the next run date from the next pending request
1272: select to_char(requested_start_date, 'Mon DD, YYYY HH:MI AM')

Line 1276: start with request_id = (select s.concurrent_request_id from bis_scheduler s where schedule_id = vDupScheduleId)

1272: select to_char(requested_start_date, 'Mon DD, YYYY HH:MI AM')
1273: into vNextRun
1274: from fnd_concurrent_requests
1275: where phase_code IN ('P', 'R')
1276: start with request_id = (select s.concurrent_request_id from bis_scheduler s where schedule_id = vDupScheduleId)
1277: connect by prior request_id = parent_request_id;
1278:
1279: end if;
1280: -- rcmuthuk Bug Fix:2799113. Moved parmPrint param to last.

Line 1333: from bis_scheduler s, fnd_concurrent_requests cr, fnd_conc_release_classes rc

1329: -- mdamle 08/20/2001 - Fixed SQL
1330: begin
1331: select max(schedule_id)
1332: into vScheduleId
1333: from bis_scheduler s, fnd_concurrent_requests cr, fnd_conc_release_classes rc
1334: where s.function_name = pFunctionName
1335: and s.parameter_string = pParameters
1336: and s.concurrent_request_id = cr.request_id
1337: and cr.release_class_id = rc.release_class_id

Line 1361: from bis_scheduler s, fnd_concurrent_requests cr, fnd_conc_release_classes rc

1357: -- mdamle 08/20/2001 - Fixed SQL
1358: begin
1359: select max(schedule_id)
1360: into vScheduleId
1361: from bis_scheduler s, fnd_concurrent_requests cr, fnd_conc_release_classes rc
1362: where s.function_name = pFunctionName
1363: and s.parameter_string = pParameters
1364: and s.concurrent_request_id = cr.request_id
1365: and cr.release_class_id = rc.release_class_id

Line 1381: from bis_scheduler s, fnd_concurrent_requests cr, fnd_conc_release_classes rc

1377:
1378: begin
1379: select max(schedule_id)
1380: into vScheduleId
1381: from bis_scheduler s, fnd_concurrent_requests cr, fnd_conc_release_classes rc
1382: where s.function_name = pFunctionName
1383: -- mdamle 09/21/01 - Fixed Bug#1999262 - Added nvl
1384: and nvl(s.parameter_string, ' ') = nvl(pParameters, ' ')
1385: and s.concurrent_request_id = cr.request_id

Line 1837: from bis_scheduler

1833:
1834: -- jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS
1835: select function_name
1836: into vFunctionName
1837: from bis_scheduler
1838: where schedule_id = pScheduleId;
1839:
1840: BIS_PMV_PARAMETERS_PVT.RETRIEVE_GRAPH_FILEID(vUserId,pScheduleId,'GRAPH_FILE_ID',vFunctionName,vGraphFileId);
1841: if vGraphFileId is not null then

Line 1980: from bis_scheduler

1976: -- Step 1 - Get the File_Id and Request_Id from schedule record
1977:
1978: select concurrent_request_id
1979: into vRequestId
1980: from bis_scheduler
1981: where schedule_id = pScheduleId;
1982:
1983: -- Step 2 - Delete from BIS_USER_ATTRIBUTES
1984:

Line 1992: -- Step 4 - Delete from bis_scheduler

1988: -- Step 3 - Delete from bis_schedule_preferences
1989:
1990: delete_schedule_preferences(pScheduleId);
1991:
1992: -- Step 4 - Delete from bis_scheduler
1993:
1994: delete bis_scheduler
1995: where schedule_id = pScheduleId;
1996:

Line 1994: delete bis_scheduler

1990: delete_schedule_preferences(pScheduleId);
1991:
1992: -- Step 4 - Delete from bis_scheduler
1993:
1994: delete bis_scheduler
1995: where schedule_id = pScheduleId;
1996:
1997: -- Step 5 - Cancel Request
1998: cancelRequest(vRequestId);

Line 2043: from bis_scheduler

2039: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS
2040: if vRequestType = 'G' then
2041: select function_name
2042: into vFunctionName
2043: from bis_scheduler
2044: where schedule_id = vScheduleId;
2045: BIS_PMV_PARAMETERS_PVT.RETRIEVE_GRAPH_FILEID(pUserId,vScheduleId,'GRAPH_FILE_ID',vFunctionName,xGraphFileId);
2046: end if;
2047:

Line 2074: from bis_scheduler

2070:
2071:
2072: cursor cOldPortletSchedules (cpUserId varchar2, cpPlugId number) is
2073: select schedule_id
2074: from bis_scheduler
2075: where user_id = cpUserId
2076: and plug_id = cpPlugId
2077: order by schedule_id desc;
2078:

Line 2120: from bis_scheduler

2116: -- Step 1 - Get the File_Id and Request_Id from schedule record
2117:
2118: select concurrent_request_id, file_id
2119: into vRequestId, vFileId
2120: from bis_scheduler
2121: where schedule_id = pScheduleId;
2122:
2123: -- Step 2 - Delete all schedule files from FND_LOBS
2124:

Line 2145: -- Step 7 - Delete from bis_scheduler

2141: -- Step 6 - Delete from bis_schedule_preferences
2142:
2143: delete_schedule_preferences(pScheduleId);
2144:
2145: -- Step 7 - Delete from bis_scheduler
2146:
2147: delete bis_scheduler
2148: where schedule_id = pScheduleId;
2149:

Line 2147: delete bis_scheduler

2143: delete_schedule_preferences(pScheduleId);
2144:
2145: -- Step 7 - Delete from bis_scheduler
2146:
2147: delete bis_scheduler
2148: where schedule_id = pScheduleId;
2149:
2150: end;
2151:

Line 2166: from bis_scheduler s, fnd_concurrent_requests cr

2162: procedure delete_Notification_Data is
2163:
2164: cursor cNotificationSchedules is
2165: select schedule_id
2166: from bis_scheduler s, fnd_concurrent_requests cr
2167: where s.concurrent_request_id = cr.request_id
2168: and 0 = (select count(*)
2169: from fnd_concurrent_requests
2170: where phase_code IN ('P', 'R')

Line 2535: from bis_scheduler s, fnd_form_functions f

2531:
2532: begin
2533: select s.function_name, type
2534: into vFunctionName, vType
2535: from bis_scheduler s, fnd_form_functions f
2536: where schedule_id = p_schedule_id
2537: and s.function_name = f.function_name;
2538: exception
2539: when others then null;