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 128: l_qstarted := FA_ASSET_TRACE_PUB.start_queue (p_qtable => g_qtable,

124: log(l_calling_fn, 'use utl file: '|| fa_asset_trace_pkg.g_use_utl_file);
125: if (nvl(fa_asset_trace_pkg.g_use_utl_file, 'Y') = 'N') then
126: l_parent_request := fnd_global.conc_request_id;
127: log(l_calling_fn, 'l_parent_request: '|| l_parent_request);
128: l_qstarted := FA_ASSET_TRACE_PUB.start_queue (p_qtable => g_qtable,
129: p_qpayload_type => 'GAT_message_type',
130: p_qname => g_qname);
131:
132: log(l_calling_fn, 'l_qstarted: '|| l_qstarted);

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

142:
143: --Check number of requests in the queue + add to queue.
144: --Doing this to force serial processing in case requests were submitted in
145: --the same manner as bug 3184059.
146: l_req_count := FA_ASSET_TRACE_PUB.g_req_tbl.count +1;
147: FA_ASSET_TRACE_PUB.g_req_tbl(l_req_count) := l_parent_request;
148: FA_ASSET_TRACE_PUB.wait_for_req;
149:
150: end if; --(nvl(fa_asset_trace_pkg.g_use_utl_file, 'Y') = 'N') ...

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

143: --Check number of requests in the queue + add to queue.
144: --Doing this to force serial processing in case requests were submitted in
145: --the same manner as bug 3184059.
146: l_req_count := FA_ASSET_TRACE_PUB.g_req_tbl.count +1;
147: FA_ASSET_TRACE_PUB.g_req_tbl(l_req_count) := l_parent_request;
148: FA_ASSET_TRACE_PUB.wait_for_req;
149:
150: end if; --(nvl(fa_asset_trace_pkg.g_use_utl_file, 'Y') = 'N') ...
151:

Line 148: FA_ASSET_TRACE_PUB.wait_for_req;

144: --Doing this to force serial processing in case requests were submitted in
145: --the same manner as bug 3184059.
146: l_req_count := FA_ASSET_TRACE_PUB.g_req_tbl.count +1;
147: FA_ASSET_TRACE_PUB.g_req_tbl(l_req_count) := l_parent_request;
148: FA_ASSET_TRACE_PUB.wait_for_req;
149:
150: end if; --(nvl(fa_asset_trace_pkg.g_use_utl_file, 'Y') = 'N') ...
151:
152: g_print_debug := fa_cache_pkg.fa_print_debug;

Line 303: FA_ASSET_TRACE_PUB.set_temp_head (l_temp_head);

299: '||g_book_class||'
300: '||l_app_version||'
301: '||sysdate||'

';
302:
303: FA_ASSET_TRACE_PUB.set_temp_head (l_temp_head);
304: --
305: if (g_submit_sub) then
306:
307: l_stmt :=''''||''||''''||'||bk.BOOK_TYPE_CODE||'||''''||''||''''||'||''''||';

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

329: ||fparse_header('DEPRN_STATUS')||fparse_header('MASS_REQUEST_ID')
330: ||fparse_header('LAST_PERIOD_COUNTER')||fparse_header('CURRENT_PERIOD_COUNTER')||'';
331:
332: load_tbls;
333: FA_ASSET_TRACE_PUB.run_trace(p_opt_tbl => g_options_tbl,
334: p_exc_tbl => g_col_exclusions,
335: p_tdyn_head => l_banner,
336: p_stmt => l_stmt,
337: p_sys_opt_tbl => 'FA_SYSTEM_CONTROLS',

Line 419: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;

415:
416: l_nmrc_count NUMBER;
417: l_check_reval NUMBER;
418: l_idx number := 0;
419: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
420:
421: l_calling_fn varchar2(40) := 'fa_asset_trace_pkg.load_tbls';
422:
423: BEGIN

Line 770: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;

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;
771:
772: l_calling_fn varchar2(40) := 'fa_asset_trace_pkg.load_setup_tbls';
773:
774: BEGIN

Line 919: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;

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);
922: l_tbl varchar2(100);
923: l_dist_tbl t_col_tbl;

Line 1175: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;

1171:
1172:
1173: l_counter NUMBER;
1174: l_idx number;
1175: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
1176:
1177: l_calling_fn varchar2(80):= 'fa_asset_trace_pkg.deprn_calc_tbls';
1178:
1179: BEGIN

Line 1379: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;

1375: l_retcode number;
1376:
1377: l_counter NUMBER;
1378: l_idx number;
1379: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
1380: l_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;
1381: l_appid fnd_profile_option_values.level_value_application_id%type;
1382:
1383: l_calling_fn varchar2(80) := 'fa_asset_trace_pkg.load_xla_info';

Line 1380: l_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;

1376:
1377: l_counter NUMBER;
1378: l_idx number;
1379: l_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
1380: l_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;
1381: l_appid fnd_profile_option_values.level_value_application_id%type;
1382:
1383: l_calling_fn varchar2(80) := 'fa_asset_trace_pkg.load_xla_info';
1384:

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

1544: l_col_exclusions(l_idx).cValue := 'TAX%'; l_col_exclusions(l_idx).cType := 'P';
1545: l_idx:= l_idx+ 1;
1546: l_col_exclusions(l_idx).cValue := '%PARTY%'; l_col_exclusions(l_idx).cType := 'P';
1547: --
1548: FA_ASSET_TRACE_PUB.run_trace (p_opt_tbl => l_options_tbl,
1549: p_exc_tbl => l_col_exclusions,
1550: p_tdyn_head => null,
1551: p_stmt => null,
1552: p_sys_opt_tbl => NULL,

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

1605:
1606: log(l_calling_fn,'Adding subscriber S'||to_char(l_xla_reqID));
1607: log(l_calling_fn,'l_sub_rule '||l_sub_rule);
1608:
1609: IF (NOT FA_ASSET_TRACE_PUB.add_subscriber (p_qname => g_qname,
1610: p_subscriber => 'S'||to_char(l_xla_reqID),
1611: p_sub_rule => l_sub_rule)) THEN
1612: log(l_calling_fn,'Failed to add subscriber.');
1613: END IF;

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

1725: END dequeue_request;
1726: --
1727: --Used for debugging.
1728: --
1729: PROCEDURE prt_opt_tbl (p_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl) IS
1730:
1731: BEGIN
1732:
1733: for i in p_options_tbl.first .. p_options_tbl.last loop