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.0.12010000.2 2008/10/13 19:43:54 hhafid noship $ */
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 111: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.do_primary';

107: l_cnt_stmt VARCHAR2(2000);
108: l_stmt VARCHAR2(32767);
109: l_schema VARCHAR2(5);
110:
111: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.do_primary';
112:
113: BEGIN
114:
115: l_primary_tbls := g_options_tbl;

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

211: l_col_order varchar2(2000);
212: l_ord_list VARCHAR2(4000);
213: l_parsed_str varchar2(100);
214:
215: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.do_col_exclusions';
216:
217: BEGIN
218:
219: --Reinitialize the table.

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

304: l_idx number:=0;
305: l_select_clause varchar2(32767);
306: l_dyn_head VARCHAR2(32767);
307:
308: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.build_stmt';
309:
310: BEGIN
311: g_tbl_hldr:= g_tmpc_tbl;
312: g_sel_tbl :=g_tmp_tbl;

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

436: l_anchor_cnt NUMBER;
437: l_counter NUMBER;
438: l_cursor c_stmt;
439:
440: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.exec_sql';
441:
442: BEGIN
443:
444: get_final_sql (p_table => l_tbl,

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

525: l_leading_cols VARCHAR2(1000);
526:
527: l_found BOOLEAN :=FALSE;
528:
529: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.get_final_sql';
530:
531: BEGIN
532:
533: IF p_schema <> 'NONE' THEN

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

590: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
591:
592: l_count NUMBER:=1;
593:
594: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.get_options';
595:
596: BEGIN
597:
598: FOR i IN g_options_tbl.FIRST .. g_options_tbl.LAST LOOP

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

623: l_cursor c_stmt;
624: l_col_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
625: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
626:
627: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.get_system_options';
628:
629: BEGIN
630: l_appid := FND_GLOBAL.resp_appl_id; log(l_calling_fn, 'l_appid: '||l_appid);
631: l_userid := fnd_global.user_id; log(l_calling_fn, 'l_userid: '||l_userid);

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

704: l_pclause VARCHAR2(500) := ' WHERE ';
705: l_sclause VARCHAR2(500);
706: l_cnt NUMBER :=0;
707:
708: l_calling_fn VARCHAR2(40) := 'fa_asset_trace_pvt.get_param';
709:
710: BEGIN
711:
712: for i in g_param_tbl.first .. g_param_tbl.last loop

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

761: l_col_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
762: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
763: l_found BOOLEAN :=FALSE;
764:
765: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.col_order';
766:
767: BEGIN
768:
769: l_col_tbl := g_tmpc_tbl;

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

824: l_clause VARCHAR2(500);
825: l_count number;
826: l_chk_col number;
827:
828: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.get_tbl_cnt';
829:
830: BEGIN
831:
832: IF (p_schema <> 'NONE') and (p_table is not null) THEN

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

866: l_primary_column VARCHAR2(40);
867: l_secondary_column VARCHAR2(40);
868: l_stmt VARCHAR2(4000);
869:
870: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.check_column';
871:
872: BEGIN
873:
874: FOR i IN g_param_tbl.first .. g_param_tbl.last LOOP

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

946: l_flag VARCHAR2(1);
947: l_first_run BOOLEAN := TRUE;
948: l_break_size NUMBER := p_break_size; -- Maximum break size.
949:
950: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.fparse_header';
951:
952:
953: BEGIN
954:

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

1011: l_anchor VARCHAR2(32767);
1012: l_tbl VARCHAR2(150);
1013: l_count number:=0;
1014:
1015: l_calling_fn varchar2(35) := 'fa_asset_trace_pvt.build_anchors';
1016:
1017: BEGIN
1018:
1019: l_anchor :='

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

1064: l_sec_col VARCHAR2(40);
1065:
1066: l_cnt number;
1067:
1068: l_calling_fn varchar2(80) := 'fa_asset_trace_pvt.save_output';
1069:
1070: BEGIN
1071: log(l_calling_fn, 'Entered save_output');
1072:

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

1208: PROCEDURE ocfile (p_handle IN OUT NOCOPY utl_file.file_type,
1209: p_file IN VARCHAR2,
1210: p_mode IN VARCHAR2) IS
1211:
1212: l_calling_fn varchar2(80) := 'fa_asset_trace_pvt.ocfile';
1213: BEGIN
1214:
1215: if (p_mode = 'C') then
1216: if (utl_file.is_open(p_handle) = TRUE) then

Line 1250: END FA_ASSET_TRACE_PVT;

1246: raise;
1247: END ocfile;
1248: --
1249:
1250: END FA_ASSET_TRACE_PVT;