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.0.12010000.2 2008/10/13 19:43:54 hhafid noship $ */
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.0.12010000.2 2008/10/13 19:43:54 hhafid noship $ */
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.0.12010000.2 2008/10/13 19:43:54 hhafid noship $ */
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 100: l_primary_tbls FA_ASSET_TRACE_PUB.t_options_tbl;

96: --
97: PROCEDURE do_primary IS
98:
99: l_cursor c_stmt;
100: l_primary_tbls FA_ASSET_TRACE_PUB.t_options_tbl;
101: l_col_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
102: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
103: l_cur_tab_name varchar2(100);
104: l_tmp_tbl VARCHAR2(100):='NOTHING';

Line 206: l_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;

202: p_schema IN VARCHAR2,
203: x_stmt OUT NOCOPY VARCHAR2,
204: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
205:
206: l_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;
207: l_tmp_tbl FA_ASSET_TRACE_PUB.t_excl_tbl;
208: l_stmt VARCHAR2(32767);
209: l_part_stmt VARCHAR2(4000);
210: l_col_list VARCHAR2(1000);

Line 207: l_tmp_tbl FA_ASSET_TRACE_PUB.t_excl_tbl;

203: x_stmt OUT NOCOPY VARCHAR2,
204: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
205:
206: l_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;
207: l_tmp_tbl FA_ASSET_TRACE_PUB.t_excl_tbl;
208: l_stmt VARCHAR2(32767);
209: l_part_stmt VARCHAR2(4000);
210: l_col_list VARCHAR2(1000);
211: l_col_order varchar2(2000);

Line 297: l_dummy_tbl FA_ASSET_TRACE_PUB.t_options_tbl;

293: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)IS
294:
295: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
296: l_col_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
297: l_dummy_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
298: l_tmp varchar2(100);
299: l_tmpt varchar2(100);
300: l_tmp_col varchar2(100);
301: l_tmp_ctr number;

Line 587: p_opt_tbl IN OUT NOCOPY FA_ASSET_TRACE_PUB.t_options_tbl,

583: --
584: --gets table options.
585: --
586: PROCEDURE get_options (p_table IN VARCHAR2,
587: p_opt_tbl IN OUT NOCOPY FA_ASSET_TRACE_PUB.t_options_tbl,
588: p_sv_col IN OUT NOCOPY NUMBER,
589: p_mode IN VARCHAR2 default null,
590: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
591: