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_API_TYPES

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

25: PROCEDURE initialize_globals (p_opt_tbl IN FA_ASSET_TRACE_PUB.t_options_tbl,
26: p_exc_tbl IN FA_ASSET_TRACE_PUB.t_excl_tbl,
27: p_schema OUT NOCOPY VARCHAR2,
28: p_debug_flag IN BOOLEAN,
29: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
30:
31: l_app_short_name VARCHAR2(50);
32: l_status varchar2(100);
33: l_industry varchar2(100);

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

200: --
201: PROCEDURE do_col_exclusions (p_tbl IN VARCHAR2,
202: p_schema IN VARCHAR2,
203: x_stmt OUT NOCOPY VARCHAR2,
204: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
205:
206: l_col_exclusions FA_ASSET_TRACE_PUB.t_excl_tbl;
207: l_tmp_tbl FA_ASSET_TRACE_PUB.t_excl_tbl;
208: l_stmt VARCHAR2(32767);

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

289: -- the row.
290: --
291: PROCEDURE build_stmt(p_t_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
292: p_col_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
293: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)IS
294:
295: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
296: l_col_tbl FA_ASSET_TRACE_PKG.t_col_tbl;
297: l_dummy_tbl FA_ASSET_TRACE_PUB.t_options_tbl;

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

423: PROCEDURE exec_sql (p_table IN VARCHAR2,
424: p_sel_clause IN VARCHAR2,
425: p_stmt IN VARCHAR2,
426: p_schema IN VARCHAR2 DEFAULT 'FA',
427: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
428:
429: l_sql_stmt VARCHAR2(4000) :=p_stmt;
430: l_stmt VARCHAR2(4000);
431: l_insert VARCHAR2(4000);

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

511: p_sel_clause IN VARCHAR2,
512: x_header OUT NOCOPY VARCHAR2,
513: px_sql IN OUT NOCOPY VARCHAR2,
514: p_schema IN VARCHAR2,
515: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
516:
517: l_sql_stmt VARCHAR2(4000) := ' SELECT '||''''||''||''''||'||';
518: l_tbl VARCHAR2(100) := p_table;
519: l_from VARCHAR2(2000);

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

586: PROCEDURE get_options (p_table IN VARCHAR2,
587: p_opt_tbl IN OUT NOCOPY FA_ASSET_TRACE_PUB.t_options_tbl,
588: p_sv_col IN OUT NOCOPY NUMBER,
589: p_mode IN VARCHAR2 default null,
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';

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

611: --
612: --Get profile and system options.
613: --
614: PROCEDURE get_system_options (p_sys_opt_tbl IN VARCHAR2,
615: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
616:
617: l_userid NUMBER;
618: l_respid fnd_profile_option_values.level_value%type;
619: l_appid fnd_profile_option_values.level_value_application_id%type;

Line 702: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return VARCHAR2 IS

698:
699: END get_system_options;
700: --
701: FUNCTION get_param (p_numcol IN number,
702: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return VARCHAR2 IS
703:
704: l_pclause VARCHAR2(500) := ' WHERE ';
705: l_sclause VARCHAR2(500);
706: l_cnt NUMBER :=0;

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

751: --
752: PROCEDURE col_order (x_table IN VARCHAR2,
753: x_col_tbl IN OUT NOCOPY FA_ASSET_TRACE_PKG.t_col_tbl,
754: x_t_tbl IN OUT NOCOPY FA_ASSET_TRACE_PKG.t_col_tbl,
755: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
756:
757: l_ord_list varchar2(2000);
758: l_parsed_str varchar2(100);
759: l_counter number:=0;

Line 820: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

816: --
817: FUNCTION get_tbl_cnt (p_table IN VARCHAR2,
818: p_stmt IN VARCHAR2,
819: p_schema IN VARCHAR2,
820: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
821:
822: l_sql_stmt VARCHAR2(4000);
823: l_stmt VARCHAR2(4000);
824: l_clause VARCHAR2(500);

Line 861: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN NUMBER IS

857: --Checks whether primary or secondary driving columns exist in the table being processed.
858:
859: FUNCTION check_column (p_table IN VARCHAR2,
860: p_schema IN VARCHAR2 DEFAULT 'FA',
861: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN NUMBER IS
862:
863: l_primary NUMBER:=0;
864: l_secondary NUMBER;
865: l_both NUMBER;

Line 920: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN VARCHAR2 IS

916: END check_column;
917: --
918: --
919: FUNCTION fafsc (p_col IN VARCHAR2,
920: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN VARCHAR2 IS
921:
922: l_out VARCHAR2(500);
923:
924: BEGIN

Line 939: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN VARCHAR2 IS

935: --
936: FUNCTION fparse_header(p_in_str IN VARCHAR2,
937: p_add_html IN VARCHAR2 DEFAULT 'Y',
938: p_break_size IN NUMBER DEFAULT 14,
939: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN VARCHAR2 IS
940:
941: l_start NUMBER:= 1;
942: l_prior_start NUMBER:= 0;
943: l_out_string VARCHAR2(500);

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

1004:
1005: END fparse_header;
1006: --
1007: PROCEDURE build_anchors (p_t_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
1008: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1009:
1010: l_t_tbl FA_ASSET_TRACE_PKG.t_col_tbl := p_t_tbl;
1011: l_anchor VARCHAR2(32767);
1012: l_tbl VARCHAR2(150);

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

1044: -- writes output to out file.
1045: --
1046: PROCEDURE save_output(p_calling_prog IN VARCHAR2,
1047: p_use_utl_file IN VARCHAR2,
1048: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1049:
1050: utl_file_dir VARCHAR2(2000);
1051: outfile UTL_FILE.FILE_TYPE;
1052: l_filename VARCHAR2(30);

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

1175: --Message logging routine
1176: --
1177: PROCEDURE log(p_calling_fn IN VARCHAR2,
1178: p_msg IN VARCHAR2 default null,
1179: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1180:
1181: l_module varchar2(150);
1182:
1183: BEGIN