APPS.FA_ASSET_TRACE_PVT dependencies on FA_ASSET_TRACE_PUB

Line 4: g_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;

1: PACKAGE BODY FA_ASSET_TRACE_PVT AS
2: /* $Header: faxtrcvb.pls 120.6.12020000.3 2012/12/04 11:43:00 deemitta ship $ */
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;

Line 5: g_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;

1: PACKAGE BODY FA_ASSET_TRACE_PVT AS
2: /* $Header: faxtrcvb.pls 120.6.12020000.3 2012/12/04 11:43:00 deemitta ship $ */
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;

Line 6: g_tmp_opt_tbl FA_ASSET_TRACE_PUB.t_options_tbl;

2: /* $Header: faxtrcvb.pls 120.6.12020000.3 2012/12/04 11:43:00 deemitta ship $ */
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;

Line 25: PROCEDURE initialize_globals (p_opt_tbl IN FA_ASSET_TRACE_PUB.t_options_tbl,

21: g_print_debug boolean;
22:
23: --Load global table.
24:
25: PROCEDURE initialize_globals (p_opt_tbl IN FA_ASSET_TRACE_PUB.t_options_tbl,
26: p_exc_tbl IN FA_ASSET_TRACE_PUB.t_excl_tbl,
27: p_schema OUT NOCOPY VARCHAR2,
28: p_debug_flag IN BOOLEAN,
29: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

Line 26: p_exc_tbl IN FA_ASSET_TRACE_PUB.t_excl_tbl,

22:
23: --Load global table.
24:
25: PROCEDURE initialize_globals (p_opt_tbl IN FA_ASSET_TRACE_PUB.t_options_tbl,
26: p_exc_tbl IN FA_ASSET_TRACE_PUB.t_excl_tbl,
27: p_schema OUT NOCOPY VARCHAR2,
28: p_debug_flag IN BOOLEAN,
29: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
30:

Line 106: l_primary_tbls FA_ASSET_TRACE_PUB.t_options_tbl;

102: --
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';

Line 212: l_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;

208: p_schema IN VARCHAR2,
209: x_stmt OUT NOCOPY VARCHAR2,
210: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
211:
212: l_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;
213: l_tmp_tbl FA_ASSET_TRACE_PUB.t_excl_tbl;
214: l_stmt VARCHAR2(32767);
215: l_part_stmt VARCHAR2(4000);
216: l_col_list VARCHAR2(1000);

Line 213: l_tmp_tbl FA_ASSET_TRACE_PUB.t_excl_tbl;

209: x_stmt OUT NOCOPY VARCHAR2,
210: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
211:
212: l_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;
213: l_tmp_tbl FA_ASSET_TRACE_PUB.t_excl_tbl;
214: l_stmt VARCHAR2(32767);
215: l_part_stmt VARCHAR2(4000);
216: l_col_list VARCHAR2(1000);
217: l_col_order varchar2(2000);

Line 304: l_dummy_tbl FA_ASSET_TRACE_PUB.t_options_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);
308: l_tmp_ctr number;

Line 594: p_opt_tbl IN OUT NOCOPY FA_ASSET_TRACE_PUB.t_options_tbl,

590: --
591: --gets table options.
592: --
593: PROCEDURE get_options (p_table IN VARCHAR2,
594: p_opt_tbl IN OUT NOCOPY FA_ASSET_TRACE_PUB.t_options_tbl,
595: p_sv_col IN OUT NOCOPY NUMBER,
596: p_mode IN VARCHAR2 default null,
597: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
598: