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 41: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

37: PROCEDURE initialize_globals (p_opt_tbl IN FA_ASSET_TRACE_PUB.t_options_tbl,
38: p_exc_tbl IN FA_ASSET_TRACE_PUB.t_excl_tbl,
39: p_schema OUT NOCOPY VARCHAR2,
40: p_debug_flag IN BOOLEAN,
41: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
42:
43: PROCEDURE do_primary;
44:
45: PROCEDURE do_col_exclusions (p_tbl IN VARCHAR2,

Line 48: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

44:
45: PROCEDURE do_col_exclusions (p_tbl IN VARCHAR2,
46: p_schema IN VARCHAR2,
47: x_stmt OUT NOCOPY VARCHAR2,
48: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
49:
50: PROCEDURE exec_sql (p_table IN VARCHAR2,
51: p_sel_clause IN VARCHAR2,
52: p_stmt IN VARCHAR2,

Line 54: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

50: PROCEDURE exec_sql (p_table IN VARCHAR2,
51: p_sel_clause IN VARCHAR2,
52: p_stmt IN VARCHAR2,
53: p_schema IN VARCHAR2 DEFAULT 'FA',
54: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
55:
56: PROCEDURE get_final_sql (p_table IN OUT NOCOPY VARCHAR2,
57: p_sel_clause IN VARCHAR2,
58: x_header OUT NOCOPY VARCHAR2,

Line 61: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

57: p_sel_clause IN VARCHAR2,
58: x_header OUT NOCOPY VARCHAR2,
59: px_sql IN OUT NOCOPY VARCHAR2,
60: p_schema IN VARCHAR2,
61: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
62:
63: PROCEDURE get_options (p_table IN VARCHAR2,
64: p_opt_tbl IN OUT NOCOPY FA_ASSET_TRACE_PUB.t_options_tbl,
65: p_sv_col IN OUT NOCOPY NUMBER,

Line 67: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

63: PROCEDURE get_options (p_table IN VARCHAR2,
64: p_opt_tbl IN OUT NOCOPY FA_ASSET_TRACE_PUB.t_options_tbl,
65: p_sv_col IN OUT NOCOPY NUMBER,
66: p_mode IN VARCHAR2 default null,
67: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
68:
69: PROCEDURE get_system_options (p_sys_opt_tbl IN VARCHAR2,
70: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
71:

Line 70: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

66: p_mode IN VARCHAR2 default null,
67: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
68:
69: PROCEDURE get_system_options (p_sys_opt_tbl IN VARCHAR2,
70: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
71:
72: FUNCTION get_param (p_numcol IN number,
73: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return VARCHAR2;
74:

Line 73: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return VARCHAR2;

69: PROCEDURE get_system_options (p_sys_opt_tbl IN VARCHAR2,
70: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
71:
72: FUNCTION get_param (p_numcol IN number,
73: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return VARCHAR2;
74:
75: FUNCTION get_tbl_cnt (p_table IN VARCHAR2,
76: p_stmt IN VARCHAR2,
77: p_schema IN VARCHAR2,

Line 78: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;

74:
75: FUNCTION get_tbl_cnt (p_table IN VARCHAR2,
76: p_stmt IN VARCHAR2,
77: p_schema IN VARCHAR2,
78: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
79:
80: FUNCTION check_column (p_table IN VARCHAR2,
81: p_schema IN VARCHAR2 DEFAULT 'FA',
82: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN NUMBER;

Line 82: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN NUMBER;

78: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
79:
80: FUNCTION check_column (p_table IN VARCHAR2,
81: p_schema IN VARCHAR2 DEFAULT 'FA',
82: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN NUMBER;
83:
84: FUNCTION fafsc (p_col IN VARCHAR2,
85: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN VARCHAR2;
86:

Line 85: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN VARCHAR2;

81: p_schema IN VARCHAR2 DEFAULT 'FA',
82: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN NUMBER;
83:
84: FUNCTION fafsc (p_col IN VARCHAR2,
85: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN VARCHAR2;
86:
87: FUNCTION fparse_header(p_in_str IN VARCHAR2,
88: p_add_html IN VARCHAR2 DEFAULT 'Y',
89: p_break_size IN NUMBER DEFAULT 14,

Line 90: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN VARCHAR2;

86:
87: FUNCTION fparse_header(p_in_str IN VARCHAR2,
88: p_add_html IN VARCHAR2 DEFAULT 'Y',
89: p_break_size IN NUMBER DEFAULT 14,
90: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN VARCHAR2;
91:
92: PROCEDURE build_stmt(p_t_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
93: p_col_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
94: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

Line 94: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

90: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN VARCHAR2;
91:
92: PROCEDURE build_stmt(p_t_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
93: p_col_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
94: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
95:
96: PROCEDURE col_order (x_table IN VARCHAR2,
97: x_col_tbl IN OUT NOCOPY FA_ASSET_TRACE_PKG.t_col_tbl,
98: x_t_tbl IN OUT NOCOPY FA_ASSET_TRACE_PKG.t_col_tbl,

Line 99: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

95:
96: PROCEDURE col_order (x_table IN VARCHAR2,
97: x_col_tbl IN OUT NOCOPY FA_ASSET_TRACE_PKG.t_col_tbl,
98: x_t_tbl IN OUT NOCOPY FA_ASSET_TRACE_PKG.t_col_tbl,
99: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
100:
101: PROCEDURE build_anchors (p_t_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
102: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
103:

Line 102: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

98: x_t_tbl IN OUT NOCOPY FA_ASSET_TRACE_PKG.t_col_tbl,
99: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
100:
101: PROCEDURE build_anchors (p_t_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
102: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
103:
104: PROCEDURE save_output (p_calling_prog IN VARCHAR2, --i.e. FATRACE
105: p_use_utl_file IN VARCHAR2,
106: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

Line 106: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

102: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
103:
104: PROCEDURE save_output (p_calling_prog IN VARCHAR2, --i.e. FATRACE
105: p_use_utl_file IN VARCHAR2,
106: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
107:
108: PROCEDURE log(p_calling_fn IN VARCHAR2,
109: p_msg IN VARCHAR2 default null,
110: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

Line 110: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

106: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
107:
108: PROCEDURE log(p_calling_fn IN VARCHAR2,
109: p_msg IN VARCHAR2 default null,
110: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
111:
112: PROCEDURE ocfile (p_handle IN OUT NOCOPY utl_file.file_type,
113: p_file IN VARCHAR2,
114: p_mode IN VARCHAR2); --C(lose) or O(pen)