DBA Data[Home] [Help]

APPS.FA_ASSET_TRACE_PKG dependencies on FA_API_TYPES

Line 6: PROCEDURE load_tbls (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

2: /* $Header: faxtrcb.pls 120.27.12010000.4 2008/12/11 19:00:57 hhafid ship $ */
3:
4: FUNCTION fafsc (p_col VARCHAR2) RETURN VARCHAR2;
5: FUNCTION fparse_header(p_in_str VARCHAR2) RETURN VARCHAR2;
6: PROCEDURE load_tbls (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
7: PROCEDURE load_setup_tbls (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
8: PROCEDURE deprn_calc_info (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
9: PROCEDURE load_xla_info (p_banner IN varchar2,
10: x_retcode OUT NOCOPY NUMBER,

Line 7: PROCEDURE load_setup_tbls (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

3:
4: FUNCTION fafsc (p_col VARCHAR2) RETURN VARCHAR2;
5: FUNCTION fparse_header(p_in_str VARCHAR2) RETURN VARCHAR2;
6: PROCEDURE load_tbls (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
7: PROCEDURE load_setup_tbls (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
8: PROCEDURE deprn_calc_info (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
9: PROCEDURE load_xla_info (p_banner IN varchar2,
10: x_retcode OUT NOCOPY NUMBER,
11: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

Line 8: PROCEDURE deprn_calc_info (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

4: FUNCTION fafsc (p_col VARCHAR2) RETURN VARCHAR2;
5: FUNCTION fparse_header(p_in_str VARCHAR2) RETURN VARCHAR2;
6: PROCEDURE load_tbls (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
7: PROCEDURE load_setup_tbls (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
8: PROCEDURE deprn_calc_info (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
9: PROCEDURE load_xla_info (p_banner IN varchar2,
10: x_retcode OUT NOCOPY NUMBER,
11: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
12: PROCEDURE submit_subrequest(p_parent_request IN NUMBER,

Line 11: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

7: PROCEDURE load_setup_tbls (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
8: PROCEDURE deprn_calc_info (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
9: PROCEDURE load_xla_info (p_banner IN varchar2,
10: x_retcode OUT NOCOPY NUMBER,
11: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
12: PROCEDURE submit_subrequest(p_parent_request IN NUMBER,
13: x_retcode OUT NOCOPY NUMBER,
14: x_errbuf OUT NOCOPY VARCHAR2);
15: FUNCTION enqueue_request RETURN BOOLEAN;

Line 23: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

19: FUNCTION get_event_list RETURN VARCHAR2;
20: FUNCTION get_schema (p_app_short_name VARCHAR2) RETURN VARCHAR2;
21: PROCEDURE log(p_calling_fn IN VARCHAR2,
22: p_msg IN VARCHAR2 default null,
23: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
24:
25: TYPE t_asset_tbl IS TABLE OF VARCHAR2(32767)
26: INDEX BY BINARY_INTEGER;
27:

Line 35: g_log_level_rec fa_api_types.log_level_rec_type;

31: Type t_cc_cols IS TABLE OF t_cc_cols_rec INDEX BY BINARY_INTEGER;
32:
33: TYPE t_num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
34:
35: g_log_level_rec fa_api_types.log_level_rec_type;
36: g_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
37: g_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;
38: g_tmpc_tbl t_col_tbl;
39: g_tbl_hldr t_col_tbl;

Line 81: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

77: PROCEDURE do_trace (errbuf OUT NOCOPY VARCHAR2,
78: retcode OUT NOCOPY NUMBER,
79: p_book IN VARCHAR2,
80: p_asset_number IN VARCHAR2,
81: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
82:
83: l_asset_id NUMBER;
84: l_book VARCHAR2(15);
85: l_tblcount NUMBER;

Line 414: PROCEDURE load_tbls (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

410: END do_trace;
411: --
412: --Load tables to be processed
413: --
414: PROCEDURE load_tbls (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
415:
416: l_nmrc_count NUMBER;
417: l_check_reval NUMBER;
418: l_idx number := 0;

Line 766: PROCEDURE load_setup_tbls (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

762: --
763: -- Gets setup-related tbls.
764: --
765:
766: PROCEDURE load_setup_tbls (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
767:
768: l_counter NUMBER;
769: l_idx number;
770: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;

Line 917: PROCEDURE get_dist_info (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

913: -- Gets account info for the active distribution(s).
914: -- Not happy with this solution, but works for now.
915: --
916:
917: PROCEDURE get_dist_info (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
918:
919: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
920: l_select_clause varchar2(2000);
921: l_stmt varchar2(4000);

Line 1159: PROCEDURE deprn_calc_info (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

1155: raise;
1156:
1157: END get_dist_info;
1158: --
1159: PROCEDURE deprn_calc_info (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1160:
1161: l_stmt varchar2(4000);
1162: l_cnt_stmt varchar2(4000);
1163: l_select_clause varchar2(4000);

Line 1371: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

1367: END get_event_list;
1368: --
1369: PROCEDURE load_xla_info (p_banner IN varchar2,
1370: x_retcode OUT NOCOPY NUMBER,
1371: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1372:
1373: l_event_list VARCHAR2(2000);
1374: l_tblcount number;
1375: l_retcode number;

Line 1786: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

1782: END get_schema;
1783: --
1784: PROCEDURE log(p_calling_fn IN VARCHAR2,
1785: p_msg IN VARCHAR2 default null,
1786: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1787:
1788: BEGIN
1789:
1790: FA_ASSET_TRACE_PVT.LOG(p_calling_fn,p_msg,g_log_level_rec);