1 PACKAGE FA_ASSET_TRACE_PUB AS
2 /* $Header: faxtrcps.pls 120.1.12010000.2 2008/10/13 15:03:00 hhafid noship $ */
3
4 Type t_col_exclusions_rec IS RECORD (cType VARCHAR2(1), cValue VARCHAR2(100));
5 Type t_excl_tbl IS TABLE OF t_col_exclusions_rec INDEX BY BINARY_INTEGER;
6
7 TYPE t_tbl_rec IS RECORD (l_tbl varchar2(100), --table_name
8 l_schema varchar2(50), --schema if <> calling app schema
9 l_lcs varchar2(500), --leading column(s)
10 l_leading_cols varchar2(500), --html-formatted l_lcs
11 l_order_by varchar2(500), --order by column(s)
12 l_lc_header varchar2(1000), --html-formatted heading of l_lcs
13 l_num_cols number, --# of leading columns
14 l_col_order varchar2(2000), --prefered col order
15 l_fullcol_list varchar2(1), --'Y' if l_col_order is the entire select list
16 l_gen_select varchar2(1), --Generate select column list
17 l_no_header varchar2(1), --no row header generated when 'Y'
18 l_no_anchor varchar2(1), --no anchor generated when set to 'Y''
19 l_add_clause varchar2(2000), --additional where-clause. could also include from-clause
20 l_cnt_stmt varchar2(2000) --count stmt to check tbl count
21 );
22 TYPE t_options_tbl IS TABLE of t_tbl_rec INDEX BY BINARY_INTEGER;
23
24 TYPE t_vchar_tbl IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
25
26 TYPE t_num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
27
28 g_req_tbl t_num_tbl;
29
30 g_submit_subreq VARCHAR2(1) DEFAULT 'N';
31 g_submit_counter number DEFAULT 0;
32
33 PROCEDURE run_trace (p_opt_tbl IN t_options_tbl,
34 p_exc_tbl IN t_excl_tbl,
35 p_tdyn_head IN VARCHAR2,
36 p_stmt IN VARCHAR2,
37 p_sys_opt_tbl IN VARCHAR2 DEFAULT NULL,
38 p_use_utl_file IN VARCHAR2 DEFAULT 'N',
39 p_debug_flag IN BOOLEAN,
40 p_calling_prog IN VARCHAR2,
41 p_retcode OUT NOCOPY NUMBER,
42 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
43
44 PROCEDURE wait_for_req;
45
46 PROCEDURE set_temp_head (p_temp_head IN VARCHAR2,
47 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
48
49 PROCEDURE do_top_section (p_tdyn_head IN VARCHAR2,
50 p_stmt IN VARCHAR2,
51 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
52
53 FUNCTION start_queue (p_qtable IN varchar2,
54 p_qpayload_type IN varchar2,
55 p_qname IN varchar2) RETURN VARCHAR2;
56
57 FUNCTION add_subscriber (p_qname IN varchar2,
58 p_subscriber IN varchar2,
59 p_sub_rule IN varchar2) RETURN BOOLEAN;
60
61 PROCEDURE log(p_calling_fn IN VARCHAR2,
62 p_msg IN VARCHAR2 default null,
63 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
64
65 END FA_ASSET_TRACE_PUB;