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_RSG_PMV_REPORT_PKG dependencies on BIS_RSG_PMV_REPORT_PKG

Line 1: PACKAGE BODY BIS_RSG_PMV_REPORT_PKG AS

1: PACKAGE BODY BIS_RSG_PMV_REPORT_PKG AS
2: /* $Header: BISRSPRB.pls 120.2 2006/03/27 09:34:38 amitgupt noship $ */
3:
4: PROCEDURE debug ( text varchar2 )
5: IS

Line 260: BIS_RSG_PMV_REPORT_PKG.duration(avg(avg_run_time)) AS BIS_TIME,

256: IF(view_by_id = 1) THEN
257: l_sql_stmt := 'select
258: view_type.value AS VIEWBY,
259: view_type.ID AS VIEWBYID,
260: BIS_RSG_PMV_REPORT_PKG.duration(avg(avg_run_time)) AS BIS_TIME,
261: BIS_RSG_PMV_REPORT_PKG.duration_str(avg(avg_run_time)) AS BIS_REQUEST_REFRESH_TIME,
262: BIS_RSG_PMV_REPORT_PKG.duration(max(max_run_time)) AS BIS_MAXIMUM,
263: BIS_RSG_PMV_REPORT_PKG.duration_str(max(max_run_time)) AS BIS_MAX,
264: BIS_RSG_PMV_REPORT_PKG.duration(min(min_run_time)) AS BIS_MINIMUM,

Line 261: BIS_RSG_PMV_REPORT_PKG.duration_str(avg(avg_run_time)) AS BIS_REQUEST_REFRESH_TIME,

257: l_sql_stmt := 'select
258: view_type.value AS VIEWBY,
259: view_type.ID AS VIEWBYID,
260: BIS_RSG_PMV_REPORT_PKG.duration(avg(avg_run_time)) AS BIS_TIME,
261: BIS_RSG_PMV_REPORT_PKG.duration_str(avg(avg_run_time)) AS BIS_REQUEST_REFRESH_TIME,
262: BIS_RSG_PMV_REPORT_PKG.duration(max(max_run_time)) AS BIS_MAXIMUM,
263: BIS_RSG_PMV_REPORT_PKG.duration_str(max(max_run_time)) AS BIS_MAX,
264: BIS_RSG_PMV_REPORT_PKG.duration(min(min_run_time)) AS BIS_MINIMUM,
265: BIS_RSG_PMV_REPORT_PKG.duration_str(min(min_run_time)) AS BIS_MIN,

Line 262: BIS_RSG_PMV_REPORT_PKG.duration(max(max_run_time)) AS BIS_MAXIMUM,

258: view_type.value AS VIEWBY,
259: view_type.ID AS VIEWBYID,
260: BIS_RSG_PMV_REPORT_PKG.duration(avg(avg_run_time)) AS BIS_TIME,
261: BIS_RSG_PMV_REPORT_PKG.duration_str(avg(avg_run_time)) AS BIS_REQUEST_REFRESH_TIME,
262: BIS_RSG_PMV_REPORT_PKG.duration(max(max_run_time)) AS BIS_MAXIMUM,
263: BIS_RSG_PMV_REPORT_PKG.duration_str(max(max_run_time)) AS BIS_MAX,
264: BIS_RSG_PMV_REPORT_PKG.duration(min(min_run_time)) AS BIS_MINIMUM,
265: BIS_RSG_PMV_REPORT_PKG.duration_str(min(min_run_time)) AS BIS_MIN,
266: sum(num_runs) AS BIS_RUN,

Line 263: BIS_RSG_PMV_REPORT_PKG.duration_str(max(max_run_time)) AS BIS_MAX,

259: view_type.ID AS VIEWBYID,
260: BIS_RSG_PMV_REPORT_PKG.duration(avg(avg_run_time)) AS BIS_TIME,
261: BIS_RSG_PMV_REPORT_PKG.duration_str(avg(avg_run_time)) AS BIS_REQUEST_REFRESH_TIME,
262: BIS_RSG_PMV_REPORT_PKG.duration(max(max_run_time)) AS BIS_MAXIMUM,
263: BIS_RSG_PMV_REPORT_PKG.duration_str(max(max_run_time)) AS BIS_MAX,
264: BIS_RSG_PMV_REPORT_PKG.duration(min(min_run_time)) AS BIS_MINIMUM,
265: BIS_RSG_PMV_REPORT_PKG.duration_str(min(min_run_time)) AS BIS_MIN,
266: sum(num_runs) AS BIS_RUN,
267: sum(space_use)/(1024*1024) AS BIS_RS_TOTAL_SPACE_OCCUPIED,

Line 264: BIS_RSG_PMV_REPORT_PKG.duration(min(min_run_time)) AS BIS_MINIMUM,

260: BIS_RSG_PMV_REPORT_PKG.duration(avg(avg_run_time)) AS BIS_TIME,
261: BIS_RSG_PMV_REPORT_PKG.duration_str(avg(avg_run_time)) AS BIS_REQUEST_REFRESH_TIME,
262: BIS_RSG_PMV_REPORT_PKG.duration(max(max_run_time)) AS BIS_MAXIMUM,
263: BIS_RSG_PMV_REPORT_PKG.duration_str(max(max_run_time)) AS BIS_MAX,
264: BIS_RSG_PMV_REPORT_PKG.duration(min(min_run_time)) AS BIS_MINIMUM,
265: BIS_RSG_PMV_REPORT_PKG.duration_str(min(min_run_time)) AS BIS_MIN,
266: sum(num_runs) AS BIS_RUN,
267: sum(space_use)/(1024*1024) AS BIS_RS_TOTAL_SPACE_OCCUPIED,
268: NULL

Line 265: BIS_RSG_PMV_REPORT_PKG.duration_str(min(min_run_time)) AS BIS_MIN,

261: BIS_RSG_PMV_REPORT_PKG.duration_str(avg(avg_run_time)) AS BIS_REQUEST_REFRESH_TIME,
262: BIS_RSG_PMV_REPORT_PKG.duration(max(max_run_time)) AS BIS_MAXIMUM,
263: BIS_RSG_PMV_REPORT_PKG.duration_str(max(max_run_time)) AS BIS_MAX,
264: BIS_RSG_PMV_REPORT_PKG.duration(min(min_run_time)) AS BIS_MINIMUM,
265: BIS_RSG_PMV_REPORT_PKG.duration_str(min(min_run_time)) AS BIS_MIN,
266: sum(num_runs) AS BIS_RUN,
267: sum(space_use)/(1024*1024) AS BIS_RS_TOTAL_SPACE_OCCUPIED,
268: NULL
269: BISREPORTURL ';

Line 275: BIS_RSG_PMV_REPORT_PKG.duration(avg_run_time) AS BIS_TIME,

271: ELSE -- if the view by is request set name
272: l_sql_stmt := 'select
273: view_type.value AS VIEWBY,
274: view_type.ID AS VIEWBYID,
275: BIS_RSG_PMV_REPORT_PKG.duration(avg_run_time) AS BIS_TIME,
276: BIS_RSG_PMV_REPORT_PKG.duration_str(avg_run_time) AS BIS_REQUEST_REFRESH_TIME,
277: BIS_RSG_PMV_REPORT_PKG.duration(max_run_time) AS BIS_MAXIMUM,
278: BIS_RSG_PMV_REPORT_PKG.duration_str(max_run_time) AS BIS_MAX,
279: BIS_RSG_PMV_REPORT_PKG.duration(min_run_time) AS BIS_MINIMUM,

Line 276: BIS_RSG_PMV_REPORT_PKG.duration_str(avg_run_time) AS BIS_REQUEST_REFRESH_TIME,

272: l_sql_stmt := 'select
273: view_type.value AS VIEWBY,
274: view_type.ID AS VIEWBYID,
275: BIS_RSG_PMV_REPORT_PKG.duration(avg_run_time) AS BIS_TIME,
276: BIS_RSG_PMV_REPORT_PKG.duration_str(avg_run_time) AS BIS_REQUEST_REFRESH_TIME,
277: BIS_RSG_PMV_REPORT_PKG.duration(max_run_time) AS BIS_MAXIMUM,
278: BIS_RSG_PMV_REPORT_PKG.duration_str(max_run_time) AS BIS_MAX,
279: BIS_RSG_PMV_REPORT_PKG.duration(min_run_time) AS BIS_MINIMUM,
280: BIS_RSG_PMV_REPORT_PKG.duration_str(min_run_time) AS BIS_MIN,

Line 277: BIS_RSG_PMV_REPORT_PKG.duration(max_run_time) AS BIS_MAXIMUM,

273: view_type.value AS VIEWBY,
274: view_type.ID AS VIEWBYID,
275: BIS_RSG_PMV_REPORT_PKG.duration(avg_run_time) AS BIS_TIME,
276: BIS_RSG_PMV_REPORT_PKG.duration_str(avg_run_time) AS BIS_REQUEST_REFRESH_TIME,
277: BIS_RSG_PMV_REPORT_PKG.duration(max_run_time) AS BIS_MAXIMUM,
278: BIS_RSG_PMV_REPORT_PKG.duration_str(max_run_time) AS BIS_MAX,
279: BIS_RSG_PMV_REPORT_PKG.duration(min_run_time) AS BIS_MINIMUM,
280: BIS_RSG_PMV_REPORT_PKG.duration_str(min_run_time) AS BIS_MIN,
281: num_runs AS BIS_RUN,

Line 278: BIS_RSG_PMV_REPORT_PKG.duration_str(max_run_time) AS BIS_MAX,

274: view_type.ID AS VIEWBYID,
275: BIS_RSG_PMV_REPORT_PKG.duration(avg_run_time) AS BIS_TIME,
276: BIS_RSG_PMV_REPORT_PKG.duration_str(avg_run_time) AS BIS_REQUEST_REFRESH_TIME,
277: BIS_RSG_PMV_REPORT_PKG.duration(max_run_time) AS BIS_MAXIMUM,
278: BIS_RSG_PMV_REPORT_PKG.duration_str(max_run_time) AS BIS_MAX,
279: BIS_RSG_PMV_REPORT_PKG.duration(min_run_time) AS BIS_MINIMUM,
280: BIS_RSG_PMV_REPORT_PKG.duration_str(min_run_time) AS BIS_MIN,
281: num_runs AS BIS_RUN,
282: space_use/(1024*1024) AS BIS_RS_TOTAL_SPACE_OCCUPIED,

Line 279: BIS_RSG_PMV_REPORT_PKG.duration(min_run_time) AS BIS_MINIMUM,

275: BIS_RSG_PMV_REPORT_PKG.duration(avg_run_time) AS BIS_TIME,
276: BIS_RSG_PMV_REPORT_PKG.duration_str(avg_run_time) AS BIS_REQUEST_REFRESH_TIME,
277: BIS_RSG_PMV_REPORT_PKG.duration(max_run_time) AS BIS_MAXIMUM,
278: BIS_RSG_PMV_REPORT_PKG.duration_str(max_run_time) AS BIS_MAX,
279: BIS_RSG_PMV_REPORT_PKG.duration(min_run_time) AS BIS_MINIMUM,
280: BIS_RSG_PMV_REPORT_PKG.duration_str(min_run_time) AS BIS_MIN,
281: num_runs AS BIS_RUN,
282: space_use/(1024*1024) AS BIS_RS_TOTAL_SPACE_OCCUPIED,
283: nvl2(space_use,

Line 280: BIS_RSG_PMV_REPORT_PKG.duration_str(min_run_time) AS BIS_MIN,

276: BIS_RSG_PMV_REPORT_PKG.duration_str(avg_run_time) AS BIS_REQUEST_REFRESH_TIME,
277: BIS_RSG_PMV_REPORT_PKG.duration(max_run_time) AS BIS_MAXIMUM,
278: BIS_RSG_PMV_REPORT_PKG.duration_str(max_run_time) AS BIS_MAX,
279: BIS_RSG_PMV_REPORT_PKG.duration(min_run_time) AS BIS_MINIMUM,
280: BIS_RSG_PMV_REPORT_PKG.duration_str(min_run_time) AS BIS_MIN,
281: num_runs AS BIS_RUN,
282: space_use/(1024*1024) AS BIS_RS_TOTAL_SPACE_OCCUPIED,
283: nvl2(space_use,
284: ''pFunctionName=BIS_BIA_RSG_SPACE_DET_PGE&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'',

Line 430: BIS_RSG_PMV_REPORT_PKG.date_to_charDTTZ(start_date) AS BIS_RS_START_TIME,

426: counter := 1;
427:
428: l_sql_stmt := 'select B.request_id AS VIEWBY,
429: B.request_id AS VIEWBYID,
430: BIS_RSG_PMV_REPORT_PKG.date_to_charDTTZ(start_date) AS BIS_RS_START_TIME,
431: BIS_RSG_PMV_REPORT_PKG.duration_str(completion_date - start_date) AS BIS_RS_DURATION,
432: BIS_RSG_PMV_REPORT_PKG.get_meaning(STATUS_CODE,PHASE_CODE) AS BIS_RS_STATUS,
433: ''pFunctionName=BIS_BIA_RSG_SUB_REQS_PGE&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' BISREPORTURL
434: ,BIS_RSG_PMV_REPORT_PKG.returnLogUrl( B.request_id,2) BISLOGFILEURL

Line 431: BIS_RSG_PMV_REPORT_PKG.duration_str(completion_date - start_date) AS BIS_RS_DURATION,

427:
428: l_sql_stmt := 'select B.request_id AS VIEWBY,
429: B.request_id AS VIEWBYID,
430: BIS_RSG_PMV_REPORT_PKG.date_to_charDTTZ(start_date) AS BIS_RS_START_TIME,
431: BIS_RSG_PMV_REPORT_PKG.duration_str(completion_date - start_date) AS BIS_RS_DURATION,
432: BIS_RSG_PMV_REPORT_PKG.get_meaning(STATUS_CODE,PHASE_CODE) AS BIS_RS_STATUS,
433: ''pFunctionName=BIS_BIA_RSG_SUB_REQS_PGE&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' BISREPORTURL
434: ,BIS_RSG_PMV_REPORT_PKG.returnLogUrl( B.request_id,2) BISLOGFILEURL
435: from BIS_RS_RUN_HISTORY B, FND_REQUEST_SETS_VL F

Line 432: BIS_RSG_PMV_REPORT_PKG.get_meaning(STATUS_CODE,PHASE_CODE) AS BIS_RS_STATUS,

428: l_sql_stmt := 'select B.request_id AS VIEWBY,
429: B.request_id AS VIEWBYID,
430: BIS_RSG_PMV_REPORT_PKG.date_to_charDTTZ(start_date) AS BIS_RS_START_TIME,
431: BIS_RSG_PMV_REPORT_PKG.duration_str(completion_date - start_date) AS BIS_RS_DURATION,
432: BIS_RSG_PMV_REPORT_PKG.get_meaning(STATUS_CODE,PHASE_CODE) AS BIS_RS_STATUS,
433: ''pFunctionName=BIS_BIA_RSG_SUB_REQS_PGE&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' BISREPORTURL
434: ,BIS_RSG_PMV_REPORT_PKG.returnLogUrl( B.request_id,2) BISLOGFILEURL
435: from BIS_RS_RUN_HISTORY B, FND_REQUEST_SETS_VL F
436: where F.request_set_id = B.request_set_id

Line 434: ,BIS_RSG_PMV_REPORT_PKG.returnLogUrl( B.request_id,2) BISLOGFILEURL

430: BIS_RSG_PMV_REPORT_PKG.date_to_charDTTZ(start_date) AS BIS_RS_START_TIME,
431: BIS_RSG_PMV_REPORT_PKG.duration_str(completion_date - start_date) AS BIS_RS_DURATION,
432: BIS_RSG_PMV_REPORT_PKG.get_meaning(STATUS_CODE,PHASE_CODE) AS BIS_RS_STATUS,
433: ''pFunctionName=BIS_BIA_RSG_SUB_REQS_PGE&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' BISREPORTURL
434: ,BIS_RSG_PMV_REPORT_PKG.returnLogUrl( B.request_id,2) BISLOGFILEURL
435: from BIS_RS_RUN_HISTORY B, FND_REQUEST_SETS_VL F
436: where F.request_set_id = B.request_set_id
437: AND PHASE_CODE = ''C'' and STATUS_CODE <>''X'' ';
438:

Line 643: , BIS_RSG_PMV_REPORT_PKG.date_to_charDTTZ(started) BIS_RS_START_TIME

639:
640: l_sql_stmt := 'select
641: rid BIS_RS_SUB_REQS_ID,
642: rname BIS_RS_REQUEST_NAME
643: , BIS_RSG_PMV_REPORT_PKG.date_to_charDTTZ(started) BIS_RS_START_TIME
644: ,dur BIS_RS_DURATION
645: ,BIS_RSG_PMV_REPORT_PKG.get_meaning(tmp.STATUS,''C'') BIS_RS_STATUS
646: ,LOG_MESSAGE BIS_LOG_MESSAGE
647: ,decode(url,'' '',null,url) BISREPORTURL

Line 645: ,BIS_RSG_PMV_REPORT_PKG.get_meaning(tmp.STATUS,''C'') BIS_RS_STATUS

641: rid BIS_RS_SUB_REQS_ID,
642: rname BIS_RS_REQUEST_NAME
643: , BIS_RSG_PMV_REPORT_PKG.date_to_charDTTZ(started) BIS_RS_START_TIME
644: ,dur BIS_RS_DURATION
645: ,BIS_RSG_PMV_REPORT_PKG.get_meaning(tmp.STATUS,''C'') BIS_RS_STATUS
646: ,LOG_MESSAGE BIS_LOG_MESSAGE
647: ,decode(url,'' '',null,url) BISREPORTURL
648: ,BIS_RSG_PMV_REPORT_PKG.returnLogUrl(rid,1) BISLOGFILEURL
649: FROM ';

Line 648: ,BIS_RSG_PMV_REPORT_PKG.returnLogUrl(rid,1) BISLOGFILEURL

644: ,dur BIS_RS_DURATION
645: ,BIS_RSG_PMV_REPORT_PKG.get_meaning(tmp.STATUS,''C'') BIS_RS_STATUS
646: ,LOG_MESSAGE BIS_LOG_MESSAGE
647: ,decode(url,'' '',null,url) BISREPORTURL
648: ,BIS_RSG_PMV_REPORT_PKG.returnLogUrl(rid,1) BISLOGFILEURL
649: FROM ';
650:
651: l_sql_stmt:= l_sql_stmt||
652: '(select R.request_id rid,F.user_request_set_name rname,

Line 654: BIS_RSG_PMV_REPORT_PKG.Duration_str(R.completion_date-R.start_date) dur,

650:
651: l_sql_stmt:= l_sql_stmt||
652: '(select R.request_id rid,F.user_request_set_name rname,
653: R.start_date started,
654: BIS_RSG_PMV_REPORT_PKG.Duration_str(R.completion_date-R.start_date) dur,
655: STATUS_CODE status, R.completion_text LOG_MESSAGE, '' '' url
656: from bis_rs_run_history R,fnd_request_sets_vl F
657: where F.request_set_id = R.request_set_id AND R.PHASE_CODE=''C'' ' ||
658: l_type_cond ||l_setid_cond ||l_runid_cond1

Line 662: BIS_RSG_PMV_REPORT_PKG.Duration_str(B.completion_date-B.start_date) dur,

658: l_type_cond ||l_setid_cond ||l_runid_cond1
659: ||' union
660: select B.request_id rid, F.user_stage_name rname,
661: B.start_date started,
662: BIS_RSG_PMV_REPORT_PKG.Duration_str(B.completion_date-B.start_date) dur,
663: B.STATUS_CODE status,B.completion_text LOG_MESSAGE,'' '' url
664: from
665: bis_rs_stage_run_history B, fnd_request_set_stages_vl F,bis_rs_run_history R
666: where F.request_set_stage_id = B.stage_id

Line 671: BIS_RSG_PMV_REPORT_PKG.Duration_str(B.completion_date-B.start_date) dur,

667: and R.request_id = B.set_request_id AND R.PHASE_CODE=''C'' '
668: ||l_type_cond||l_setid_cond||l_runid_cond2||l_stage_cond1||l_prog_cond2
669: ||' union
670: Select B.request_id rid, F.user_concurrent_program_name rname, B.start_date started,
671: BIS_RSG_PMV_REPORT_PKG.Duration_str(B.completion_date-B.start_date) dur,
672: B.STATUS_CODE status,B.completion_text LOG_MESSAGE,
673: decode(num_obj,0,
674: ''pFunctionName=BIS_BIA_RSG_RPT_ERR_MSG_PG&formErrorType=NO_OBJECT'',
675: ''pFunctionName=BIS_BIA_RSG_REQ_DETAILS_PGE&BIS_RS_SUB_REQS_ID=BIS_RS_SUB_REQS_ID&BISRSSTAGE=''||B.stage_request_id||''&BISRSPROG=''||B.program_id||''&pParamIds=Y''