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_BIA_RSG_PSTATE dependencies on BIS_BIA_RSG_PSTATE

Line 1: PACKAGE BODY BIS_BIA_RSG_PSTATE AS

1: PACKAGE BODY BIS_BIA_RSG_PSTATE AS
2: /* $Header: BISPGSTB.pls 120.6 2006/05/09 05:30:59 rkumar ship $ */
3:
4: PROCEDURE debug ( text varchar2 )
5: IS

Line 149: BIS_BIA_RSG_PSTATE.get_refresh_mode(REQUEST_SET_NAME) <> 'ANAL';

145: and object_type ='PAGE'
146: union -- request set for report directly
147: select request_set_name from bis_request_set_objects
148: where object_name =l_report_name and object_type ='REPORT') where
149: BIS_BIA_RSG_PSTATE.get_refresh_mode(REQUEST_SET_NAME) <> 'ANAL';
150:
151: cursor c_rs_for_pages (l_page_name varchar2) is
152: SELECT REQUEST_SET_NAME FROM
153: (select request_set_name from bis_request_set_objects

Line 155: BIS_BIA_RSG_PSTATE.get_refresh_mode(REQUEST_SET_NAME) <> 'ANAL';

151: cursor c_rs_for_pages (l_page_name varchar2) is
152: SELECT REQUEST_SET_NAME FROM
153: (select request_set_name from bis_request_set_objects
154: where object_name =l_PAGE_name and object_type ='PAGE') WHERE
155: BIS_BIA_RSG_PSTATE.get_refresh_mode(REQUEST_SET_NAME) <> 'ANAL';
156:
157: l_rs_names varchar2(32767);
158: l_currow1 c_rs_for_reports%rowtype;
159: l_currow2 c_rs_for_reports%rowtype;

Line 283: BIS_BIA_RSG_PSTATE.sync_last_refresh_time(Last_Refresh_Time) Last_Refresh_Time

279:
280: (
281: select OBJECT_NAME,
282: decode(Last_Refresh_Time,to_date(''01-01-1900'',''DD-MM-YYYY''),null,Last_Refresh_Duration) Last_Refresh_Duration,
283: BIS_BIA_RSG_PSTATE.sync_last_refresh_time(Last_Refresh_Time) Last_Refresh_Time
284: from
285: (
286: select OBJECTS.OBJECT_NAME,
287: BIS_BIA_RSG_PSTATE.duration(COMPLETION_DATE - START_DATE) Last_Refresh_Duration,

Line 287: BIS_BIA_RSG_PSTATE.duration(COMPLETION_DATE - START_DATE) Last_Refresh_Duration,

283: BIS_BIA_RSG_PSTATE.sync_last_refresh_time(Last_Refresh_Time) Last_Refresh_Time
284: from
285: (
286: select OBJECTS.OBJECT_NAME,
287: BIS_BIA_RSG_PSTATE.duration(COMPLETION_DATE - START_DATE) Last_Refresh_Duration,
288: bis_submit_requestset.get_last_refreshdate(objects.object_type,null,objects.object_name) Last_Refresh_Time,
289: rank() over(partition by OBJECTS.OBJECT_NAME order by START_DATE desc) rk
290: FROM BIS_RS_RUN_HISTORY HISTORY, BIS_REQUEST_SET_OBJECTS OBJECTS
291: WHERE

Line 294: BIS_BIA_RSG_PSTATE.get_refresh_mode(OBJECTS.REQUEST_SET_NAME) <> ''ANAL'' AND

290: FROM BIS_RS_RUN_HISTORY HISTORY, BIS_REQUEST_SET_OBJECTS OBJECTS
291: WHERE
292: '|| l_bind ||' AND
293: OBJECTS.OBJECT_TYPE = ''PAGE'' AND
294: BIS_BIA_RSG_PSTATE.get_refresh_mode(OBJECTS.REQUEST_SET_NAME) <> ''ANAL'' AND
295: OBJECTS.REQUEST_SET_NAME = HISTORY.REQUEST_SET_NAME AND
296: HISTORY.PHASE_CODE = ''C'' AND
297: (HISTORY.STATUS_CODE = ''C'' OR HISTORY.STATUS_CODE = ''G'')
298: )

Line 311: BIS_BIA_RSG_PSTATE.get_refresh_mode(OBJECTS.REQUEST_SET_NAME) <>''ANAL'' AND

307: FROM BIS_RS_RUN_HISTORY HISTORY, BIS_REQUEST_SET_OBJECTS OBJECTS, FND_LOOKUPS LOOKUPS
308: WHERE
309: '|| l_bind ||' AND
310: OBJECTS.OBJECT_TYPE = ''PAGE'' AND
311: BIS_BIA_RSG_PSTATE.get_refresh_mode(OBJECTS.REQUEST_SET_NAME) <>''ANAL'' AND
312: OBJECTS.REQUEST_SET_NAME = HISTORY.REQUEST_SET_NAME AND
313: HISTORY.PHASE_CODE = ''R'' AND
314: HISTORY.PHASE_CODE = LOOKUPS.LOOKUP_CODE AND
315: LOOKUPS.LOOKUP_TYPE = ''BIS_RSG_PSTATE_RPT_LKP'' --modified for bug#5144541: rkumar

Line 331: BIS_BIA_RSG_PSTATE.get_refresh_mode(OBJECTS.REQUEST_SET_NAME) <> ''ANAL'' AND

327: FND_REQUEST_SETS FND
328: where
329: '|| l_bind ||' AND
330: OBJECTS.OBJECT_TYPE = ''PAGE'' AND
331: BIS_BIA_RSG_PSTATE.get_refresh_mode(OBJECTS.REQUEST_SET_NAME) <> ''ANAL'' AND
332: OBJECTS.REQUEST_SET_NAME = FND.REQUEST_SET_NAME AND
333: OBJECTS.SET_APP_ID = FND.APPLICATION_ID AND
334: to_char(FND.APPLICATION_ID) = FND_CONC.ARGUMENT1 AND
335: to_char(FND.REQUEST_SET_ID) = FND_CONC.ARGUMENT2 AND

Line 369: BIS_BIA_RSG_PSTATE.sync_last_refresh_time(Last_refresh_time) Last_Refresh_Time

365: (SELECT ''Dummy'' JOIN_COL,id,value from BIS_BIA_RSG_PAGE_STATUS_V where TYPE=''REPORT''
366: AND ID=:CONTENT_NAME) DISP,
367: ( select ''Dummy'' AS JOIN_COL,
368: decode(Last_Refresh_Time,to_date(''01-01-1900'',''DD-MM-YYYY''),null,Last_Refresh_Duration) Last_Refresh_Duration,
369: BIS_BIA_RSG_PSTATE.sync_last_refresh_time(Last_refresh_time) Last_Refresh_Time
370: from (SELECT Last_Refresh_Duration,
371: bis_submit_requestset.get_last_refreshdate(''REPORT'',null,:CONTENT_NAME) Last_refresh_time
372: from
373: (select BIS_BIA_RSG_PSTATE.duration(COMPLETION_DATE - START_DATE) Last_Refresh_Duration

Line 373: (select BIS_BIA_RSG_PSTATE.duration(COMPLETION_DATE - START_DATE) Last_Refresh_Duration

369: BIS_BIA_RSG_PSTATE.sync_last_refresh_time(Last_refresh_time) Last_Refresh_Time
370: from (SELECT Last_Refresh_Duration,
371: bis_submit_requestset.get_last_refreshdate(''REPORT'',null,:CONTENT_NAME) Last_refresh_time
372: from
373: (select BIS_BIA_RSG_PSTATE.duration(COMPLETION_DATE - START_DATE) Last_Refresh_Duration
374: FROM BIS_RS_RUN_HISTORY HISTORY WHERE
375: HISTORY.REQUEST_SET_NAME IN
376: (select request_set_name RS_NAME from (select request_set_name --request set for dashboard that has this report
377: from bis_request_set_objects where object_name in ( select Distinct obj.OBJECT_NAME

Line 384: where BIS_BIA_RSG_PSTATE.get_refresh_mode(REQUEST_SET_NAME) != ''ANAL'') AND

380: connect by prior obj.OBJECT_NAME=obj.depend_object_name and
381: prior obj.OBJECT_TYPE=obj.depend_object_TYPE) and object_type =''PAGE'' union -- request set for report directly
382: select request_set_name RS_NAME from bis_request_set_objects
383: where object_name =:CONTENT_NAME and object_type =''REPORT'')
384: where BIS_BIA_RSG_PSTATE.get_refresh_mode(REQUEST_SET_NAME) != ''ANAL'') AND
385: HISTORY.PHASE_CODE = ''C'' AND
386: (HISTORY.STATUS_CODE = ''C'' OR HISTORY.STATUS_CODE = ''G'')
387: order by start_date desc
388: )

Line 407: where BIS_BIA_RSG_PSTATE.get_refresh_mode(REQUEST_SET_NAME) != ''ANAL'')AND

403: connect by prior obj.OBJECT_NAME=obj.depend_object_name and
404: prior obj.OBJECT_TYPE=obj.depend_object_TYPE) and object_type =''PAGE'' union -- request set for report directly
405: select request_set_name RS_NAME from bis_request_set_objects
406: where object_name =:CONTENT_NAME and object_type =''REPORT'')
407: where BIS_BIA_RSG_PSTATE.get_refresh_mode(REQUEST_SET_NAME) != ''ANAL'')AND
408: HISTORY.PHASE_CODE = ''R'' AND
409: HISTORY.PHASE_CODE = LOOKUPS.LOOKUP_CODE AND
410: LOOKUPS.LOOKUP_TYPE = ''BIS_RSG_PSTATE_RPT_LKP''
411: group by history.request_id,LOOKUPS.MEANING

Line 430: where BIS_BIA_RSG_PSTATE.get_refresh_mode(REQUEST_SET_NAME) != ''ANAL'') and

426: connect by prior obj.OBJECT_NAME=obj.depend_object_name and
427: prior obj.OBJECT_TYPE=obj.depend_object_TYPE) and object_type =''PAGE'' union -- request set for report directly
428: select request_set_name RS_NAME from bis_request_set_objects
429: where object_name =:CONTENT_NAME and object_type =''REPORT'')
430: where BIS_BIA_RSG_PSTATE.get_refresh_mode(REQUEST_SET_NAME) != ''ANAL'') and
431: OBJECTS.REQUEST_SET_NAME = FND.REQUEST_SET_NAME AND
432: OBJECTS.SET_APP_ID = FND.APPLICATION_ID AND
433: to_char(FND.APPLICATION_ID) = FND_CONC.ARGUMENT1 AND
434: to_char(FND.REQUEST_SET_ID) = FND_CONC.ARGUMENT2 AND

Line 483: END; -- Package Body BIS_BIA_RSG_PSTATE

479:
480: END GET_SQL ;
481:
482:
483: END; -- Package Body BIS_BIA_RSG_PSTATE