3:
4: g_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
5: g_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;
6: g_tmp_opt_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
7: g_tmpc_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
8: g_tbl_hldr FA_ASSET_TRACE_PKG.t_col_tbl;
9: g_anchor_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
10: g_no_rec_tbl t_asset_tbl;
11: g_tmp_tbl t_asset_tbl;
4: g_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
5: g_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;
6: g_tmp_opt_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
7: g_tmpc_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
8: g_tbl_hldr FA_ASSET_TRACE_PKG.t_col_tbl;
9: g_anchor_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
10: g_no_rec_tbl t_asset_tbl;
11: g_tmp_tbl t_asset_tbl;
12: g_output_tbl t_asset_tbl;
5: g_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;
6: g_tmp_opt_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
7: g_tmpc_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
8: g_tbl_hldr FA_ASSET_TRACE_PKG.t_col_tbl;
9: g_anchor_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
10: g_no_rec_tbl t_asset_tbl;
11: g_tmp_tbl t_asset_tbl;
12: g_output_tbl t_asset_tbl;
13: g_req_tbl t_num_tbl;
103: PROCEDURE do_primary IS
104:
105: l_cursor c_stmt;
106: l_primary_tbls FA_ASSET_TRACE_PUB.t_options_tbl;
107: l_col_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
108: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
109: l_cur_tab_name varchar2(100);
110: l_tmp_tbl VARCHAR2(100):='NOTHING';
111: l_tblcount number;
104:
105: l_cursor c_stmt;
106: l_primary_tbls FA_ASSET_TRACE_PUB.t_options_tbl;
107: l_col_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
108: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
109: l_cur_tab_name varchar2(100);
110: l_tmp_tbl VARCHAR2(100):='NOTHING';
111: l_tblcount number;
112: l_sel VARCHAR2(2000);
294: -- note: it's not efficient to build the full header or select clause here
295: -- as there are tables that we want to have certain leading columns to identify
296: -- the row.
297: --
298: PROCEDURE build_stmt(p_t_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
299: p_col_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
300: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)IS
301:
302: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
295: -- as there are tables that we want to have certain leading columns to identify
296: -- the row.
297: --
298: PROCEDURE build_stmt(p_t_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
299: p_col_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
300: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)IS
301:
302: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
303: l_col_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
298: PROCEDURE build_stmt(p_t_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
299: p_col_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
300: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)IS
301:
302: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
303: l_col_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
304: l_dummy_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
305: l_tmp varchar2(100);
306: l_tmpt varchar2(100);
299: p_col_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
300: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)IS
301:
302: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
303: l_col_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
304: l_dummy_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
305: l_tmp varchar2(100);
306: l_tmpt varchar2(100);
307: l_tmp_col varchar2(100);
627: l_resp_name VARCHAR2(100);
628: l_stmt VARCHAR2(32767);
629: l_counter NUMBER :=0;
630: l_cursor c_stmt;
631: l_col_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
632: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
633:
634: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.get_system_options';
635:
628: l_stmt VARCHAR2(32767);
629: l_counter NUMBER :=0;
630: l_cursor c_stmt;
631: l_col_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
632: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
633:
634: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.get_system_options';
635:
636: BEGIN
762: --
763: --parse the desired colum order for tables in options tbl.
764: --
765: PROCEDURE col_order (x_table IN VARCHAR2,
766: x_col_tbl IN OUT NOCOPY FA_ASSET_TRACE_PKG.t_col_tbl,
767: x_t_tbl IN OUT NOCOPY FA_ASSET_TRACE_PKG.t_col_tbl,
768: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
769:
770: l_ord_list varchar2(2000);
763: --parse the desired colum order for tables in options tbl.
764: --
765: PROCEDURE col_order (x_table IN VARCHAR2,
766: x_col_tbl IN OUT NOCOPY FA_ASSET_TRACE_PKG.t_col_tbl,
767: x_t_tbl IN OUT NOCOPY FA_ASSET_TRACE_PKG.t_col_tbl,
768: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
769:
770: l_ord_list varchar2(2000);
771: l_parsed_str varchar2(100);
770: l_ord_list varchar2(2000);
771: l_parsed_str varchar2(100);
772: l_counter number:=0;
773: l_idx NUMBER:=0;
774: l_col_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
775: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
776: l_found BOOLEAN :=FALSE;
777:
778: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.col_order';
771: l_parsed_str varchar2(100);
772: l_counter number:=0;
773: l_idx NUMBER:=0;
774: l_col_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
775: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
776: l_found BOOLEAN :=FALSE;
777:
778: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.col_order';
779:
1019: raise;
1020:
1021: END fparse_header;
1022: --
1023: PROCEDURE build_anchors (p_t_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
1024: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1025:
1026: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl := p_t_tbl;
1027: l_anchor VARCHAR2(32767);
1022: --
1023: PROCEDURE build_anchors (p_t_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
1024: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1025:
1026: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl := p_t_tbl;
1027: l_anchor VARCHAR2(32767);
1028: l_tbl VARCHAR2(150);
1029: l_count number:=0;
1030: