eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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.38.12020000.6 2013/02/07 07:03:38 rmandali 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 434: PROCEDURE load_tbls (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

430: END do_trace;
431: --
432: --Load tables to be processed
433: --
434: PROCEDURE load_tbls (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
435:
436: l_nmrc_count NUMBER;
437: l_check_reval NUMBER;
438: l_idx number := 0;

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

790: --
791: -- Gets setup-related tbls.
792: --
793:
794: PROCEDURE load_setup_tbls (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
795:
796: l_counter NUMBER;
797: l_idx number;
798: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;

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

941: -- Gets account info for the active distribution(s).
942: -- Not happy with this solution, but works for now.
943: --
944:
945: PROCEDURE get_dist_info (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
946:
947: l_appid fnd_profile_option_values.level_value_application_id%type;
948: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
949: l_select_clause varchar2(2000);

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

1188: raise;
1189:
1190: END get_dist_info;
1191: --
1192: PROCEDURE deprn_calc_info (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1193:
1194: l_stmt varchar2(4000);
1195: l_cnt_stmt varchar2(4000);
1196: l_select_clause varchar2(4000);

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

1423: END get_event_list;
1424: --
1425: PROCEDURE load_xla_info (p_banner IN varchar2,
1426: x_retcode OUT NOCOPY NUMBER,
1427: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1428:
1429: l_event_list VARCHAR2(32767);
1430: l_tblcount number;
1431: l_retcode number;

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

1837: END get_schema;
1838: --
1839: PROCEDURE log(p_calling_fn IN VARCHAR2,
1840: p_msg IN VARCHAR2 default null,
1841: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1842:
1843: BEGIN
1844:
1845: FA_ASSET_TRACE_PVT.LOG(p_calling_fn,p_msg,g_log_level_rec);