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_ASSET_TRACE_PUB

Line 18: PROCEDURE prt_opt_tbl (p_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl);

14: x_errbuf OUT NOCOPY VARCHAR2);
15: FUNCTION enqueue_request RETURN BOOLEAN;
16: FUNCTION dequeue_request (p_request IN VARCHAR2,
17: x_desc OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
18: PROCEDURE prt_opt_tbl (p_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl);
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,

Line 36: g_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;

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;
40: g_anchor_tbl t_col_tbl;

Line 37: g_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;

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;
40: g_anchor_tbl t_col_tbl;
41: g_hdr_tbl t_asset_tbl;

Line 148: l_qstarted := FA_ASSET_TRACE_PUB.start_queue (p_qtable => g_qtable,

144: if (l_playload_mesg is NULL) then
145: l_playload_mesg := 'GAT_message_type';
146: end if;
147:
148: l_qstarted := FA_ASSET_TRACE_PUB.start_queue (p_qtable => g_qtable,
149: p_qpayload_type => l_playload_mesg,
150: p_qname => g_qname);
151:
152: log(l_calling_fn, 'l_qstarted: '|| l_qstarted);

Line 166: l_req_count := FA_ASSET_TRACE_PUB.g_req_tbl.count +1;

162:
163: --Check number of requests in the queue + add to queue.
164: --Doing this to force serial processing in case requests were submitted in
165: --the same manner as bug 3184059.
166: l_req_count := FA_ASSET_TRACE_PUB.g_req_tbl.count +1;
167: FA_ASSET_TRACE_PUB.g_req_tbl(l_req_count) := l_parent_request;
168: FA_ASSET_TRACE_PUB.wait_for_req;
169:
170: end if; --(nvl(fa_asset_trace_pkg.g_use_utl_file, 'Y') = 'N') ...

Line 167: FA_ASSET_TRACE_PUB.g_req_tbl(l_req_count) := l_parent_request;

163: --Check number of requests in the queue + add to queue.
164: --Doing this to force serial processing in case requests were submitted in
165: --the same manner as bug 3184059.
166: l_req_count := FA_ASSET_TRACE_PUB.g_req_tbl.count +1;
167: FA_ASSET_TRACE_PUB.g_req_tbl(l_req_count) := l_parent_request;
168: FA_ASSET_TRACE_PUB.wait_for_req;
169:
170: end if; --(nvl(fa_asset_trace_pkg.g_use_utl_file, 'Y') = 'N') ...
171:

Line 168: FA_ASSET_TRACE_PUB.wait_for_req;

164: --Doing this to force serial processing in case requests were submitted in
165: --the same manner as bug 3184059.
166: l_req_count := FA_ASSET_TRACE_PUB.g_req_tbl.count +1;
167: FA_ASSET_TRACE_PUB.g_req_tbl(l_req_count) := l_parent_request;
168: FA_ASSET_TRACE_PUB.wait_for_req;
169:
170: end if; --(nvl(fa_asset_trace_pkg.g_use_utl_file, 'Y') = 'N') ...
171:
172: g_print_debug := fa_cache_pkg.fa_print_debug;

Line 323: FA_ASSET_TRACE_PUB.set_temp_head (l_temp_head);

319: '||g_book_class||'
320: '||l_app_version||'
321: '||sysdate||'

';
322:
323: FA_ASSET_TRACE_PUB.set_temp_head (l_temp_head);
324: --
325: if (g_submit_sub) then
326:
327: l_stmt :=''''||''||''''||'||bk.BOOK_TYPE_CODE||'||''''||''||''''||'||''''||';

Line 353: FA_ASSET_TRACE_PUB.run_trace(p_opt_tbl => g_options_tbl,

349: ||fparse_header('DEPRN_STATUS')||fparse_header('MASS_REQUEST_ID')
350: ||fparse_header('LAST_PERIOD_COUNTER')||fparse_header('CURRENT_PERIOD_COUNTER')||'';
351:
352: load_tbls;
353: FA_ASSET_TRACE_PUB.run_trace(p_opt_tbl => g_options_tbl,
354: p_exc_tbl => g_col_exclusions,
355: p_tdyn_head => l_banner,
356: p_stmt => l_stmt,
357: p_sys_opt_tbl => 'FA_SYSTEM_CONTROLS',

Line 439: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;

435:
436: l_nmrc_count NUMBER;
437: l_check_reval NUMBER;
438: l_idx number := 0;
439: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
440:
441: l_calling_fn varchar2(40) := 'fa_asset_trace_pkg.load_tbls';
442:
443: BEGIN

Line 798: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;

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;
799:
800: l_calling_fn varchar2(40) := 'fa_asset_trace_pkg.load_setup_tbls';
801:
802: BEGIN

Line 948: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;

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);
950: l_stmt varchar2(32767);
951: l_tbl varchar2(100);
952: l_dist_tbl t_col_tbl;

Line 1208: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;

1204:
1205:
1206: l_counter NUMBER;
1207: l_idx number;
1208: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
1209:
1210: l_calling_fn varchar2(80):= 'fa_asset_trace_pkg.deprn_calc_tbls';
1211:
1212: BEGIN

Line 1435: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;

1431: l_retcode number;
1432:
1433: l_counter NUMBER;
1434: l_idx number;
1435: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
1436: l_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;
1437: l_appid fnd_profile_option_values.level_value_application_id%type;
1438:
1439: l_calling_fn varchar2(80) := 'fa_asset_trace_pkg.load_xla_info';

Line 1436: l_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;

1432:
1433: l_counter NUMBER;
1434: l_idx number;
1435: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
1436: l_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;
1437: l_appid fnd_profile_option_values.level_value_application_id%type;
1438:
1439: l_calling_fn varchar2(80) := 'fa_asset_trace_pkg.load_xla_info';
1440:

Line 1603: FA_ASSET_TRACE_PUB.run_trace (p_opt_tbl => l_options_tbl,

1599: l_col_exclusions(l_idx).cValue := 'TAX%'; l_col_exclusions(l_idx).cType := 'P';
1600: l_idx:= l_idx+ 1;
1601: l_col_exclusions(l_idx).cValue := '%PARTY%'; l_col_exclusions(l_idx).cType := 'P';
1602: --
1603: FA_ASSET_TRACE_PUB.run_trace (p_opt_tbl => l_options_tbl,
1604: p_exc_tbl => l_col_exclusions,
1605: p_tdyn_head => null,
1606: p_stmt => null,
1607: p_sys_opt_tbl => NULL,

Line 1664: IF (NOT FA_ASSET_TRACE_PUB.add_subscriber (p_qname => g_qname,

1660:
1661: log(l_calling_fn,'Adding subscriber S'||to_char(l_xla_reqID));
1662: log(l_calling_fn,'l_sub_rule '||l_sub_rule);
1663:
1664: IF (NOT FA_ASSET_TRACE_PUB.add_subscriber (p_qname => g_qname,
1665: p_subscriber => 'S'||to_char(l_xla_reqID),
1666: p_sub_rule => l_sub_rule)) THEN
1667: log(l_calling_fn,'Failed to add subscriber.');
1668: END IF;

Line 1784: PROCEDURE prt_opt_tbl (p_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl) IS

1780: END dequeue_request;
1781: --
1782: --Used for debugging.
1783: --
1784: PROCEDURE prt_opt_tbl (p_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl) IS
1785:
1786: BEGIN
1787:
1788: for i in p_options_tbl.first .. p_options_tbl.last loop