PACKAGE: APPS.BIS_RSG_PMV_REPORT_PKG

Source

1 PACKAGE BIS_RSG_PMV_REPORT_PKG AS
2 /* $Header: BISRSPRS.pls 120.1 2006/03/27 09:31:21 amitgupt noship $ */
3 
4  FUNCTION duration_str(
5  	p_duration		number) return VARCHAR2;
6 
7  FUNCTION duration_HHMM(
8  	p_duration		number) return VARCHAR2;
9 
10  FUNCTION duration(
11 	p_duration		number) return NUMBER;
12 
13  FUNCTION get_meaning(p_status_code VARCHAR2,
14                    p_phase_code VARCHAR2) return VARCHAR2 ;
15 
16  PROCEDURE request_set_perf_report (
17             p_param 	IN 		BIS_PMV_PAGE_PARAMETER_TBL,
18 			x_custom_sql	OUT NOCOPY	VARCHAR2,
19 			x_custom_output OUT NOCOPY 	BIS_QUERY_ATTRIBUTES_TBL);
20  PROCEDURE request_set_perf_det_rep(
21              p_param 	IN 		BIS_PMV_PAGE_PARAMETER_TBL,
22  			x_custom_sql	OUT NOCOPY	VARCHAR2,
23 			x_custom_output OUT NOCOPY 	BIS_QUERY_ATTRIBUTES_TBL);
24 
25  PROCEDURE request_set_sub_req_rep(
26              p_param 	IN 		BIS_PMV_PAGE_PARAMETER_TBL,
27    			x_custom_sql	OUT NOCOPY	VARCHAR2,
28 			x_custom_output OUT NOCOPY 	BIS_QUERY_ATTRIBUTES_TBL);
29 
30  PROCEDURE request_set_space_rep(
31               p_param 	IN 		BIS_PMV_PAGE_PARAMETER_TBL,
32     			x_custom_sql	OUT NOCOPY	VARCHAR2,
33 			x_custom_output OUT NOCOPY 	BIS_QUERY_ATTRIBUTES_TBL);
34 
35  PROCEDURE tablespace_detail_report(
36                p_param 	IN 		BIS_PMV_PAGE_PARAMETER_TBL,
37      			x_custom_sql	OUT NOCOPY	VARCHAR2,
38 			x_custom_output OUT NOCOPY 	BIS_QUERY_ATTRIBUTES_TBL);
39 
40  PROCEDURE request_details_report(
41                 p_param 	IN 		BIS_PMV_PAGE_PARAMETER_TBL,
42       			x_custom_sql	OUT NOCOPY	VARCHAR2,
43 			x_custom_output OUT NOCOPY 	BIS_QUERY_ATTRIBUTES_TBL);
44 
45  FUNCTION  gtitle(p_param 			BIS_PMV_PAGE_PARAMETER_TBL) return varchar2;
46 
47  FUNCTION  get_max_stg(prog_id Number,
48                        set_req_id Number,
49                        stage_id varchar2) return Number;
50 
51  FUNCTION  get_latest_run(req_set_id Number) return Number;
52 
53  FUNCTION  Check_rsid(req_set_id Number) return Number;
54 
55  FUNCTION  returnLogUrl(req_id Number, fromReport Number) return Varchar2;
56 
57  -- added for bug 4486989
58  -- function is added for timezone conversion
59  -- is also being called from BIS_SUBMIT_REQUESTSET
60  FUNCTION date_to_charDTTZ(pServerDate DATE) return varchar2;
61 
62 END BIS_RSG_PMV_REPORT_PKG;