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_PVT dependencies on FA_ASSET_TRACE_PVT

Line 1: PACKAGE BODY FA_ASSET_TRACE_PVT AS

1: PACKAGE BODY FA_ASSET_TRACE_PVT AS
2: /* $Header: faxtrcvb.pls 120.6.12020000.3 2012/12/04 11:43:00 deemitta ship $ */
3:
4: g_options_tbl FA_ASSET_TRACE_PUB.t_options_tbl;
5: g_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;

Line 37: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.load_globals';

33: l_industry varchar2(100);
34: schema_err exception;
35: null_param_tbl EXCEPTION;
36:
37: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.load_globals';
38:
39: BEGIN
40: --Validate param tbl.
41: IF g_param_tbl.count = 0 THEN

Line 117: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.do_primary';

113: l_cnt_stmt VARCHAR2(32767);
114: l_stmt VARCHAR2(32767);
115: l_schema VARCHAR2(5);
116:
117: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.do_primary';
118:
119: BEGIN
120:
121: l_primary_tbls := g_options_tbl;

Line 221: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.do_col_exclusions';

217: l_col_order varchar2(2000);
218: l_ord_list VARCHAR2(4000);
219: l_parsed_str varchar2(100);
220:
221: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.do_col_exclusions';
222:
223: BEGIN
224:
225: --Reinitialize the table.

Line 315: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.build_stmt';

311: l_idx number:=0;
312: l_select_clause varchar2(32767);
313: l_dyn_head VARCHAR2(32767);
314:
315: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.build_stmt';
316:
317: BEGIN
318: g_tbl_hldr:= g_tmpc_tbl;
319: g_sel_tbl :=g_tmp_tbl;

Line 447: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.exec_sql';

443: l_anchor_cnt NUMBER;
444: l_counter NUMBER;
445: l_cursor c_stmt;
446:
447: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.exec_sql';
448:
449: BEGIN
450:
451: get_final_sql (p_table => l_tbl,

Line 536: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.get_final_sql';

532: l_leading_cols VARCHAR2(1000);
533:
534: l_found BOOLEAN :=FALSE;
535:
536: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.get_final_sql';
537:
538: BEGIN
539:
540: IF p_schema <> 'NONE' THEN

Line 601: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.get_options';

597: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
598:
599: l_count NUMBER:=1;
600:
601: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.get_options';
602:
603: BEGIN
604:
605: FOR i IN g_options_tbl.FIRST .. g_options_tbl.LAST LOOP

Line 634: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.get_system_options';

630: l_cursor c_stmt;
631: l_col_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
632: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
633:
634: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.get_system_options';
635:
636: BEGIN
637: l_appid := FND_GLOBAL.resp_appl_id; log(l_calling_fn, 'l_appid: '||l_appid);
638: l_userid := fnd_global.user_id; log(l_calling_fn, 'l_userid: '||l_userid);

Line 721: l_calling_fn VARCHAR2(40) := 'fa_asset_trace_pvt.get_param';

717: l_pclause VARCHAR2(500) := ' WHERE ';
718: l_sclause VARCHAR2(500);
719: l_cnt NUMBER :=0;
720:
721: l_calling_fn VARCHAR2(40) := 'fa_asset_trace_pvt.get_param';
722:
723: BEGIN
724:
725: for i in g_param_tbl.first .. g_param_tbl.last loop

Line 778: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.col_order';

774: l_col_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
775: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
776: l_found BOOLEAN :=FALSE;
777:
778: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.col_order';
779:
780: BEGIN
781:
782: l_col_tbl := g_tmpc_tbl;

Line 840: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.get_tbl_cnt';

836: l_stmt VARCHAR2(32767);
837: l_count number;
838: l_chk_col number;
839:
840: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.get_tbl_cnt';
841:
842: BEGIN
843:
844: IF (p_schema <> 'NONE') and (p_table is not null) THEN

Line 882: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.check_column';

878: l_primary_column VARCHAR2(40);
879: l_secondary_column VARCHAR2(40);
880: l_stmt VARCHAR2(4000);
881:
882: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.check_column';
883:
884: BEGIN
885:
886: FOR i IN g_param_tbl.first .. g_param_tbl.last LOOP

Line 966: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.fparse_header';

962: l_flag VARCHAR2(1);
963: l_first_run BOOLEAN := TRUE;
964: l_break_size NUMBER := p_break_size; -- Maximum break size.
965:
966: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.fparse_header';
967:
968:
969: BEGIN
970:

Line 1031: l_calling_fn varchar2(35) := 'fa_asset_trace_pvt.build_anchors';

1027: l_anchor VARCHAR2(32767);
1028: l_tbl VARCHAR2(150);
1029: l_count number:=0;
1030:
1031: l_calling_fn varchar2(35) := 'fa_asset_trace_pvt.build_anchors';
1032:
1033: BEGIN
1034:
1035: l_anchor :='

Line 1084: l_calling_fn varchar2(80) := 'fa_asset_trace_pvt.save_output';

1080: l_sec_col VARCHAR2(40);
1081:
1082: l_cnt number;
1083:
1084: l_calling_fn varchar2(80) := 'fa_asset_trace_pvt.save_output';
1085:
1086: BEGIN
1087: log(l_calling_fn, 'Entered save_output');
1088:

Line 1228: l_calling_fn varchar2(80) := 'fa_asset_trace_pvt.ocfile';

1224: PROCEDURE ocfile (p_handle IN OUT NOCOPY utl_file.file_type,
1225: p_file IN VARCHAR2,
1226: p_mode IN VARCHAR2) IS
1227:
1228: l_calling_fn varchar2(80) := 'fa_asset_trace_pvt.ocfile';
1229: BEGIN
1230:
1231: if (p_mode = 'C') then
1232: if (utl_file.is_open(p_handle) = TRUE) then

Line 1266: END FA_ASSET_TRACE_PVT;

1262: raise;
1263: END ocfile;
1264: --
1265:
1266: END FA_ASSET_TRACE_PVT;