PACKAGE: APPS.BIS_COLL_RS_HISTORY

Source

1 package BIS_COLL_RS_HISTORY AS
2 /*$Header: BISRSHTS.pls 120.1 2006/05/18 12:28:42 aguwalan noship $*/
3 
4 procedure rsg_history_report (
5 	errbuf  		   OUT NOCOPY VARCHAR2,
6         retcode		           OUT NOCOPY VARCHAR2,
7 	Root_request_id		   IN    NUMBER);
8 
9 procedure insert_program_object_data (	x_request_id    IN NUMBER,
10 					x_stage_req_id  IN NUMBER,
11 					x_object_name   IN VARCHAR2,
12 					x_object_type   IN VARCHAR2,
13 					x_refresh_type  IN VARCHAR2,
14 					x_set_request_id IN NUMBER);
15 
16 
17 procedure purgeHistory;
18 
19 procedure get_space_usage_details( p_object_name	     IN			varchar2,
20 				    p_Object_type	     IN			varchar2,
21 				    p_Object_row_count	     OUT  NOCOPY	number,
22 				    p_Object_space_usage     OUT  NOCOPY	number,
23 				    p_Tablespace_name        OUT  NOCOPY	varchar2,
24 				    p_Free_tablespace_size   OUT  NOCOPY	number
25 				    );
26 PROCEDURE add_rsg_rs_run_record(p_request_set_id	IN NUMBER,
27 				p_request_set_appl_id	IN NUMBER,
28 				p_request_name		IN VARCHAR2,
29 				p_root_req_id		IN NUMBER);
30 
31 FUNCTION get_refresh_mode(p_request_set_id	IN NUMBER,
32 			  p_request_set_appl_id	IN NUMBER) RETURN VARCHAR2;
33 
34 FUNCTION if_program_already_ran(l_root_request_id NUMBER ) RETURN BOOLEAN;
35 
36 FUNCTION get_req_set_details(p_request_set_id	   OUT    NOCOPY NUMBER,
37 			 p_request_set_appl_id	   OUT    NOCOPY NUMBER,
38 			 p_request_set_name        OUT    NOCOPY VARCHAR2,
39 			 p_root_request_id	   IN     NUMBER ) RETURN BOOLEAN  ;
40 
41 function get_lookup_meaning(p_lookup_type varchar2, p_lookup_code varchar2) return varchar2;
42 
43 PROCEDURE update_warn_compl_txt(p_root_req_id IN NUMBER);
44 
45 procedure update_terminated_rs;
46 
47 PROCEDURE update_rs_stage_dates(p_root_req_id IN NUMBER);
48 
49 PROCEDURE  update_report_date;
50 
51 PROCEDURE capture_object_info(p_root_request_id IN NUMBER);
52 
53 END BIS_COLL_RS_HISTORY;