1 package BIS_SUBMIT_REQUESTSET AS
2 /*$Header: BISSRSUS.pls 120.0.12010000.2 2008/08/12 07:53:39 bijain ship $*/
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
4 -- dbdrv: checkfile(120.0.12000000.2=120.1):~PROD:~PATH:~FILE
5 TYPE table_sorting_rec_type IS RECORD (
6 tbl_index NUMBER,
7 refresh_date date);
8
9 TYPE table_sorting_tbl_type is TABLE of table_sorting_rec_type
10 INDEX BY BINARY_INTEGER;
11
12 function get_parameter_flag(p_program_name varchar2, p_app_id number) return varchar2;
13 procedure update_default_value(p_program_name varchar2, p_app_id number) ;
14 function get_last_refreshtime(p_obj_type varchar2,p_obj_owner varchar2,p_obj_name varchar2) return varchar2;
15 function get_last_refreshdate(p_obj_type varchar2,p_obj_owner varchar2,p_obj_name varchar2) return date;
16 procedure sort_table(p_sorting_tbl in out NOCOPY table_sorting_tbl_type) ;
17 procedure update_last_refresh_date(
18 errbuf OUT NOCOPY VARCHAR2,
19 retcode OUT NOCOPY VARCHAR2,
20 p_request_id IN NUMBER
21 );
22
23
24 /**
25 procedure get_last_refreshdate(p_obj_type in varchar2,
26 p_obj_owner in varchar2,
27 p_obj_name in varchar2,
28 x_last_refresh_date out NOCOPY date,
29 x_detail_string out NOCOPY varchar2);
30 **/
31 /** This api has been deprecated. But to be on the safer side,
32 the api has not been deleted.**/
33 function get_last_refreshdate_url(p_obj_type in varchar2,
34 p_obj_owner in varchar2,
35 p_obj_name in varchar2,
36 p_url_flag in varchar2 default 'Y') return varchar2;
37
38 function get_last_refreshdate_url(p_obj_type in varchar2,
39 p_obj_owner in varchar2,
40 p_obj_name in varchar2,
41 p_url_flag in varchar2 default 'Y',
42 p_RF_Url in varchar2) return varchar2;
43
44
45
46
47 END BIS_SUBMIT_REQUESTSET;