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 FND_LOBS

Line 213: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS

209: ,p_Security_group_id => icx_sec.g_Security_group_id
210: );
211:
212: end scheduleReports;
213: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS
214: procedure deleteReportGraphsLobs(p_user_id in varchar2
215: ,p_schedule_id in varchar2
216: ,p_function_name in varchar2);
217:

Line 1750: -- jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS

1746: where schedule_id = cpScheduleId
1747: and user_id = vUserId
1748: and nvl(plug_id, 0) = nvl(cpPlugID, 0);
1749:
1750: -- jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS
1751: vGraphFileId varchar2(20);
1752: vAttrName varchar2(20);
1753: vFunctionName fnd_form_functions.function_name%TYPE;
1754:

Line 1834: -- jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS

1830: where schedule_id = pScheduleId;
1831:
1832: if vCount = 0 then
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;

Line 1842: delete fnd_lobs where file_id = vGraphFileId;

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
1842: delete fnd_lobs where file_id = vGraphFileId;
1843: else
1844: deleteReportGraphsLobs(vUserId,pScheduleId,vFunctionName);
1845: end if;
1846:

Line 2015: -- jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS -- added xGraphFileId

2011: -- mdamle 09/04/01 Scheduling Enhancements - Phase II - Purge Portlet Data
2012: procedure delete_portlet(
2013: pPlugId IN NUMBER
2014: ,pUserId IN NUMBER
2015: -- jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS -- added xGraphFileId
2016: ,xGraphFileId OUT NOCOPY VARCHAR2) is
2017:
2018:
2019: vCount number;

Line 2021: -- jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS

2017:
2018:
2019: vCount number;
2020: vScheduleId number;
2021: -- jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS
2022: vFunctionName fnd_form_functions.function_name%TYPE;
2023: vRequestType varchar2(1);
2024:
2025: begin

Line 2030: -- jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS -added vRequestType

2026:
2027: -- Purge Portlet data, whenever portlet is deleted or customized, basically whenever
2028: -- a new schedule is being created.
2029:
2030: -- jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS -added vRequestType
2031:
2032: if pPlugId is not null then
2033: select distinct schedule_id, request_type
2034: into vScheduleId, vRequestType

Line 2039: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS

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
2040: if vRequestType = 'G' then
2041: select function_name
2042: into vFunctionName
2043: from bis_scheduler

Line 2123: -- Step 2 - Delete all schedule files from FND_LOBS

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:
2125: delete fnd_lobs
2126: where file_id = vFileId;
2127:

Line 2125: delete fnd_lobs

2121: where schedule_id = pScheduleId;
2122:
2123: -- Step 2 - Delete all schedule files from FND_LOBS
2124:
2125: delete fnd_lobs
2126: where file_id = vFileId;
2127:
2128: -- Step 3 - Delete from BIS_USER_ATTRIBUTES
2129:

Line 2194: -- the file_id is retained in FND_LOBS since the user may wish to view the file again. In this case though,

2190: end if;
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

Line 2198: delete fnd_lobs

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(
2200: select substr(recipient_role, Length(gvRoleName)+1)
2201: from wf_notifications w
2202: where w.recipient_role like gvRoleName || '%'

Line 2227: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS

2223: ) is
2224:
2225: vExternalSourceId number;
2226:
2227: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS
2228: vGraphFileId varchar2(20);
2229: vRequestType varchar2(1);
2230:
2231: BEGIN

Line 2237: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS -- added vRequestType

2233: -- Before delete existing plug id, get the external source id
2234: -- and then update the new record with this source id
2235:
2236:
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

Line 2250: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS -- added vGraphFileId

2246: end;
2247:
2248:
2249: if p_plug_id is not null then
2250: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS -- added vGraphFileId
2251: delete_portlet(p_plug_id, p_user_id, vGraphFileId);
2252:
2253: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS
2254: -- save the file id associated with the previous schedule, for the same plug,

Line 2253: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS

2249: if p_plug_id is not null then
2250: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS -- added vGraphFileId
2251: delete_portlet(p_plug_id, p_user_id, vGraphFileId);
2252:
2253: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS
2254: -- save the file id associated with the previous schedule, for the same plug,
2255: -- for the new schedule id as the previous schedule gets deleted.
2256: --jprabhud - 12/20/02 - NLS Bug 2320171
2257: if p_request_type = 'G' and vGraphFileId is not null then

Line 2358: -- Step 1 - Delete file from FND_LOBS for this preference

2354: and w.status = 'CLOSED';
2355:
2356: -- If notification still open, then leave it alone.
2357: if vCount = 1 then
2358: -- Step 1 - Delete file from FND_LOBS for this preference
2359: delete fnd_lobs
2360: where file_id = c1.file_id;
2361:
2362: -- Step 2 - Delete Role

Line 2359: delete fnd_lobs

2355:
2356: -- If notification still open, then leave it alone.
2357: if vCount = 1 then
2358: -- Step 1 - Delete file from FND_LOBS for this preference
2359: delete fnd_lobs
2360: where file_id = c1.file_id;
2361:
2362: -- Step 2 - Delete Role
2363: delete wf_local_roles

Line 2375: -- Step 1 - Delete all schedule files from FND_LOBS

2371: and nvl(plug_id, 0) = nvl(pPlugID, 0);
2372: end loop;
2373:
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:

Line 2377: delete fnd_lobs

2373:
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:

Line 2623: update fnd_lobs

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
2623: update fnd_lobs
2624: SET expiration_date = SYSDATE
2625: WHERE file_id = o_external_source_id;
2626:
2627: COMMIT;

Line 2633: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS

2629: END IF;
2630: END expireExistingFile;
2631:
2632:
2633: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS
2634: procedure deleteReportGraphsLobs(p_user_id in varchar2
2635: ,p_schedule_id in varchar2
2636: ,p_function_name in varchar2)
2637: IS

Line 2639: delete fnd_lobs where file_id in

2635: ,p_schedule_id in varchar2
2636: ,p_function_name in varchar2)
2637: IS
2638: BEGIN
2639: delete fnd_lobs where file_id in
2640: (select session_value
2641: from bis_user_attributes
2642: where user_id = p_user_id
2643: and schedule_id = p_schedule_id