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_SCHEDULE_PREFERENCES

Line 943: UPDATE bis_schedule_preferences

939: )
940: IS
941: BEGIN
942: -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
943: UPDATE bis_schedule_preferences
944: SET last_update_date = SYSDATE
945: WHERE schedule_id = p_schedule_id;
946:
947: COMMIT;

Line 1182: from bis_schedule_preferences

1178: -- Check if user has already subscribed to this report
1179: -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
1180: select count(1)
1181: into vUserExists
1182: from bis_schedule_preferences
1183: where schedule_id = vDupScheduleId
1184: and user_id = pUserId
1185: and nvl(plug_id, 0) = nvl(pPlugId, 0);
1186:

Line 1526: -- Create a new record in bis_schedule_preferences

1522: -- Check if duplicate schedule exists
1523: vScheduleId := getDuplicateSchedule(pFunctionName, vParameters, pSchedule, pPlugId);
1524: if vScheduleId is not null then
1525: -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
1526: -- Create a new record in bis_schedule_preferences
1527: -- Check if another subscriber has the same preferences, if so, then reuse FileId
1528:
1529: begin
1530: select file_id

Line 1532: from bis_schedule_preferences

1528:
1529: begin
1530: select file_id
1531: into vFileId
1532: from bis_schedule_preferences
1533: where schedule_id = vScheduleId
1534: and nvl(title, ' ') = nvl(vReportName, ' ')
1535: and request_type = pRequestType
1536: and nvl(graph_type, ' ') = nvl(pGraphType, ' ');

Line 1745: from bis_schedule_preferences

1741: vCount number := 0;
1742:
1743: cursor cUserFiles (cpScheduleId number, cpPlugId number) is
1744: select distinct file_id
1745: from bis_schedule_preferences
1746: where schedule_id = cpScheduleId
1747: and user_id = vUserId
1748: and nvl(plug_id, 0) = nvl(cpPlugID, 0);
1749:

Line 1819: from bis_schedule_preferences

1815: end if;
1816:
1817: select distinct title
1818: into vReportName
1819: from bis_schedule_preferences
1820: where schedule_id = pScheduleId
1821: and file_id = c1.file_id;
1822:
1823: delete_schedule_preferences(pScheduleId, vUserId, pPlugId);

Line 1829: from bis_schedule_preferences

1825: end loop;
1826:
1827: -- mdamle 08/21/2001 - Purge Data
1828: select count(*) into vCount
1829: from bis_schedule_preferences
1830: where schedule_id = pScheduleId;
1831:
1832: if vCount = 0 then
1833:

Line 1988: -- Step 3 - Delete from bis_schedule_preferences

1984:
1985: delete bis_user_attributes
1986: where schedule_id = pScheduleId;
1987:
1988: -- Step 3 - Delete from bis_schedule_preferences
1989:
1990: delete_schedule_preferences(pScheduleId);
1991:
1992: -- Step 4 - Delete from bis_scheduler

Line 2035: from bis_schedule_preferences

2031:
2032: if pPlugId is not null then
2033: select distinct schedule_id, request_type
2034: into vScheduleId, vRequestType
2035: from bis_schedule_preferences
2036: where user_id = pUserId
2037: and plug_id = pPlugId;
2038:
2039: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS

Line 2051: from bis_schedule_preferences

2047:
2048: delete_schedule_preferences(vScheduleId, pUserId, pPlugId);
2049:
2050: select count(*) into vCount
2051: from bis_schedule_preferences
2052: where schedule_id = vScheduleId;
2053: if vCount = 0 then
2054: delete_schedule(vScheduleId);
2055: end if;

Line 2141: -- Step 6 - Delete from bis_schedule_preferences

2137:
2138: -- Step 5 - Cancel Request
2139: cancelRequest(vRequestId);
2140:
2141: -- Step 6 - Delete from bis_schedule_preferences
2142:
2143: delete_schedule_preferences(pScheduleId);
2144:
2145: -- Step 7 - Delete from bis_scheduler

Line 2173: and 0 = (select count(*) from bis_schedule_preferences sp

2169: from fnd_concurrent_requests
2170: where phase_code IN ('P', 'R')
2171: start with request_id = cr.request_id
2172: connect by prior request_id = parent_request_id)
2173: and 0 = (select count(*) from bis_schedule_preferences sp
2174: where sp.schedule_id = s.schedule_id
2175: and plug_id is not null);
2176:
2177: vCount number;

Line 2183: from wf_notifications w, bis_schedule_preferences sp

2179: for c1 in cNotificationSchedules loop
2180: -- Check if the notification is closed
2181: select count(*)
2182: into vCount
2183: from wf_notifications w, bis_schedule_preferences sp
2184: where sp.schedule_id = c1.schedule_id
2185: and w.recipient_role = gvRoleName||sp.file_id
2186: and w.status = 'CLOSED';
2187:

Line 2195: -- there is now no record in bis_schedule_preferences since the user has unsubscribed from the schedule.

2191: end loop;
2192:
2193: -- When a user unsubscribes from a notification (when email is not sent), without closing the notification,
2194: -- the file_id is retained in FND_LOBS since the user may wish to view the file again. In this case though,
2195: -- there is now no record in bis_schedule_preferences since the user has unsubscribed from the schedule.
2196: -- Check to see if any of notifications are now closed, and delete the file if they are.
2197:
2198: delete fnd_lobs
2199: where file_id in(

Line 2241: from bis_schedule_preferences

2237: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS -- added vRequestType
2238: begin
2239: select external_source_id, request_type
2240: into vExternalSourceId, vRequestType
2241: from bis_schedule_preferences
2242: where user_id = p_user_id
2243: and plug_id = p_plug_id;
2244: exception
2245: when others then vExternalSourceId := null;

Line 2282: insert into bis_schedule_preferences

2278: p_file_id := get_file_id(p_request_type);
2279: end if;
2280: end if;
2281:
2282: insert into bis_schedule_preferences
2283: (schedule_id
2284: ,user_id
2285: ,plug_id
2286: ,request_type

Line 2337: from bis_schedule_preferences

2333: ) IS
2334:
2335: cursor cUserFiles (cpScheduleId number, cpUserId number, cpPlugId number) is
2336: select distinct file_id
2337: from bis_schedule_preferences
2338: where schedule_id = cpScheduleId
2339: and user_id = cpUserId
2340: and nvl(plug_id, 0) = nvl(cpPlugID, 0);
2341:

Line 2351: from bis_schedule_preferences sp, wf_notifications w

2347: for c1 in cUserFiles(pScheduleId, pUserId, pPlugId) loop
2348:
2349: select count(*)
2350: into vCount
2351: from bis_schedule_preferences sp, wf_notifications w
2352: where file_id = c1.file_id
2353: and w.recipient_role = gvRoleName||sp.file_id
2354: and w.status = 'CLOSED';
2355:

Line 2368: delete bis_schedule_preferences

2364: where name = gvRoleName||c1.file_id;
2365: end if;
2366:
2367: -- Step 3 - Delete the user preference
2368: delete bis_schedule_preferences
2369: where schedule_id = pScheduleId
2370: and user_id = pUserId
2371: and nvl(plug_id, 0) = nvl(pPlugID, 0);
2372: end loop;

Line 2378: where file_id IN (select file_id from bis_schedule_preferences where schedule_id = pScheduleId);

2374: else
2375: -- Step 1 - Delete all schedule files from FND_LOBS
2376:
2377: delete fnd_lobs
2378: where file_id IN (select file_id from bis_schedule_preferences where schedule_id = pScheduleId);
2379:
2380: -- Step 2 - Delete Role
2381:
2382: delete wf_local_roles

Line 2383: where name IN (select gvRoleName||file_id from bis_schedule_preferences where schedule_id = pScheduleId);

2379:
2380: -- Step 2 - Delete Role
2381:
2382: delete wf_local_roles
2383: where name IN (select gvRoleName||file_id from bis_schedule_preferences where schedule_id = pScheduleId);
2384:
2385: -- Step 3 - Delete all preferences for this schedule
2386: delete bis_schedule_preferences
2387: where schedule_id = pScheduleId;

Line 2386: delete bis_schedule_preferences

2382: delete wf_local_roles
2383: where name IN (select gvRoleName||file_id from bis_schedule_preferences where schedule_id = pScheduleId);
2384:
2385: -- Step 3 - Delete all preferences for this schedule
2386: delete bis_schedule_preferences
2387: where schedule_id = pScheduleId;
2388: end if;
2389:
2390: commit;

Line 2579: update bis_schedule_preferences

2575: p_plug_id in varchar2) is
2576:
2577: begin
2578:
2579: update bis_schedule_preferences
2580: set request_type = p_request_type,
2581: graph_type = decode(p_request_type, 'G', p_graph_type, null),
2582: title = p_title
2583: where user_id = p_user_id

Line 2601: update bis_schedule_preferences

2597: p_file_id in varchar2,
2598: p_external_source_id in varchar2) is
2599: begin
2600:
2601: update bis_schedule_preferences
2602: set external_source_id = p_external_source_id
2603: where schedule_id = p_schedule_id
2604: and nvl(p_file_id, 0) = nvl(p_file_id, 0);
2605:

Line 2618: FROM bis_schedule_preferences

2614: ) IS
2615: BEGIN
2616:
2617: SELECT external_source_id INTO o_external_source_id
2618: FROM bis_schedule_preferences
2619: WHERE schedule_id = p_schedule_id
2620: AND nvl(file_id, 0) = nvl(p_file_id, 0);
2621:
2622: IF (o_external_source_id IS NOT NULL) THEN