[Home] [Help]
PACKAGE: APPS.JTF_DIAGNOSTIC_COREAPI
Source
1 PACKAGE JTF_DIAGNOSTIC_COREAPI AUTHID CURRENT_USER AS
2 /* $Header: jtfdiagcoreapi_s.pls 120.4 2011/05/03 10:46:54 kbnair ship $ */
3
4 l_newline varchar2(1) := fnd_global.newline;
5 l_tab varchar2(1) := fnd_global.tab;
6 l_return varchar2(1) := fnd_global.local_chr(13);
7
8 /* Default starting point for date searches - Date 30 years ago */
9 olddate DATE := SYSDATE-(365*30);
10
11 g_hold_output clob;
12 counter number := 0;
13 failures number := 0;
14 g_curr_loc number := 1;
15
16 /* Global variables set by Set_Client which can be used throughout a script */
17 g_user_id number;
18 g_resp_id number;
19 g_appl_id number;
20 g_org_id number;
21
22 /* Global variable set by Show_Header which can be referenced in scripts
23 which branch based on applications release */
24 g_appl_version varchar2(10);
25
26 type V2T is table of varchar2(32767);
27
28 /* Types for use as parameters to the Display_SQL and Run_SQL API's */
29 type headers is table of varchar2(32767);
30 type lengths is table of integer;
31
32
33 procedure line_out (text varchar2);
34 procedure Insert_Style_Sheet;
35 procedure Insert_HTML(p_text varchar2);
36 procedure ActionErrorPrint(p_text varchar2);
37 procedure ActionPrint(p_text varchar2);
38 procedure ActionWarningPrint(p_text varchar2);
39 procedure WarningPrint(p_text varchar2);
40 procedure ActionErrorLink(p_txt1 varchar2
41 , p_note varchar2
42 , p_txt2 varchar2);
43 procedure ActionErrorLink(p_txt1 varchar2
44 , p_url varchar2
45 , p_link_txt varchar2
46 , p_txt2 varchar2);
47 procedure ActionWarningLink(p_txt1 varchar2
48 , p_note varchar2
49 , p_txt2 varchar2);
50 procedure ActionWarningLink(p_txt1 varchar2
51 , p_url varchar2
52 , p_link_txt varchar2
53 , p_txt2 varchar2);
54 procedure ErrorPrint(p_text varchar2);
55 procedure SectionPrint (p_text varchar2);
56 procedure Tab0Print (p_text varchar2);
57 procedure Tab1Print (p_text varchar2);
58 procedure Tab2Print (p_text varchar2);
59 procedure Tab3Print (p_text varchar2);
60 procedure BRPrint;
61 procedure checkFinPeriod (p_sobid NUMBER, p_appid NUMBER );
62 procedure CheckKeyFlexfield(p_flex_code in varchar2
63 , p_flex_num in number default null
64 , p_print_heading in boolean default true);
65 procedure CheckProfile(p_prof_name in varchar2
66 , p_user_id in number
67 , p_resp_id in number
68 , p_appl_id in number
69 , p_default in varchar2 default null
70 , p_indent in integer default 0);
71 procedure Begin_Pre;
72 procedure End_Pre;
73 procedure Show_Table(p_type varchar2, p_values V2T, p_caption varchar2 default null, p_options V2T default null);
74 procedure Show_Table(p_values V2T);
75 procedure Show_Table(p_type varchar2);
76 procedure Show_Table_Row(p_values V2T, p_options V2T default null);
77 procedure Show_Table_Header(p_values V2T, p_options V2T default null);
78 procedure Show_Table_Header(p_headers in headers, p_lengths in out NOCOPY lengths);
79 procedure Start_Table (p_caption varchar2 default null);
80 procedure End_Table;
81 function Run_SQL(p_title varchar2, p_sql_statement varchar2) return number;
82 function Run_SQL(p_title varchar2,p_sql_statement varchar2,p_feedback varchar2) return number;
83 function Run_SQL(p_title varchar2,p_sql_statement varchar2,p_max_rows number) return number;
84 function Run_SQL(p_title varchar2,p_sql_statement varchar2,p_feedback varchar2, p_max_rows number) return number;
85 procedure Run_SQL(p_title varchar2, p_sql_statement varchar2);
86 procedure Run_SQL(p_title varchar2, p_sql_statement varchar2,p_feedback varchar2);
87 procedure Run_SQL(p_title varchar2,p_sql_statement varchar2,p_max_rows number);
88 procedure Run_SQL(p_title varchar2,p_sql_statement varchar2,p_feedback varchar2,p_max_rows number);
89 function Run_SQL(p_title varchar2,p_sql_statement varchar2, p_disp_lengths lengths) return number;
90 function Run_SQL(p_title varchar2,p_sql_statement varchar2,p_disp_lengths lengths,p_headers headers) return number;
91 function Run_SQL(p_title varchar2,p_sql_statement varchar2,p_disp_lengths lengths,p_headers headers,p_feedback varchar2) return number;
92 function Run_SQL(p_title varchar2,p_sql_statement varchar2,p_disp_lengths lengths,p_headers headers,p_max_rows number) return number;
93 function Run_SQL(p_title varchar2,p_sql_statement varchar2,p_disp_lengths lengths,p_headers headers,p_feedback varchar2,p_max_rows number) return number;
94 procedure Run_SQL(p_title varchar2,p_sql_statement varchar2,p_disp_lengths lengths);
95 procedure Run_SQL(p_title varchar2,p_sql_statement varchar2,p_disp_lengths lengths,p_headers headers);
96 procedure Display_Table (p_table_name varchar2,
97 p_table_alias varchar2,
98 p_where_clause varchar2,
99 p_order_by_clause varchar2 default null,
100 p_display_longs varchar2 default 'Y');
101 procedure Show_Header(p_note varchar2, p_title varchar2);
102 procedure Show_Footer(p_script_name varchar2, p_header varchar2);
103 procedure Show_Footer;
104 procedure Show_Link(p_note varchar2);
105 procedure Show_Link(p_link varchar2, p_link_name varchar2 );
106 procedure Send_Email ( p_sender varchar2
107 , p_recipient varchar2
108 , p_subject varchar2
109 , p_message varchar2
110 , p_mailhost varchar2);
111 procedure Display_Profiles (p_application_id varchar2
112 , p_short_name varchar2 default null);
113 procedure Set_Org (p_org_id number);
114 procedure Set_Client(p_user_name varchar2, p_resp_id number,
115 p_app_id number, p_sec_grp_id number);
116 procedure Set_Client(p_user_name varchar2, p_resp_id number);
117 procedure Set_Client(p_user_name varchar2, p_resp_id number,
118 p_app_id number );
119
120 /*
121 procedure Get_DB_Patch_List (p_heading varchar2 default 'AD_BUGS'
122 , p_app_short_name varchar2 default '%'
123 , p_bug_number varchar2 default '%'
124 , p_start_date date default to_date(olddate,'MM-DD-YYYY')
125 , p_output_option varchar2 default 'TABLE');
126 Procedure Show_Invalids (p_start_string varchar2
127 , p_include_errors varchar2 default 'N'
128 , p_heading varchar2 default null);
129 */
130
131 Function CheckKeyFlexfield(p_flex_code in varchar2
132 , p_flex_num in number default null
133 , p_print_heading in boolean default true) return V2T;
134 function CheckProfile(p_prof_name in varchar2
135 , p_user_id in number
136 , p_resp_id in number
137 , p_appl_id in number
138 , p_default in varchar2 default null
139 , p_indent in integer default 0) return varchar2;
140 function Column_Exists(p_tab in varchar, p_col in varchar, p_owner in varchar) return varchar2;
141 function Display_SQL (p_sql_statement varchar2
142 , table_alias varchar2
143 , display_longs varchar2 default 'Y'
144 , p_feedback varchar2 default 'Y'
145 , p_max_rows number default null
146 , p_current_exec number default 0) return number;
147
148 function Display_SQL (p_sql_statement varchar2
149 , table_alias varchar2
150 , hideHeader Boolean
151 , display_longs varchar2 default 'Y'
152 , p_feedback varchar2 default 'Y'
153 , p_max_rows number default null
154 , p_current_exec number default 0) return number;
155
156 function Display_SQL (
157 p_sql_statement varchar2
158 , p_disp_lengths lengths
159 , p_headers headers default null
160 , p_feedback varchar2 default 'Y'
161 , p_max_rows number default null) return number;
162 procedure Display_SQL (
163 p_sql_statement varchar2
164 , p_disp_lengths lengths);
165 procedure Display_SQL (
166 p_sql_statement varchar2
167 , p_disp_lengths lengths
168 , p_headers headers);
169 procedure Display_SQL (
170 p_sql_statement varchar2
171 , p_disp_lengths lengths
172 , p_headers headers
173 , p_feedback varchar2);
174 procedure Display_SQL(
175 p_sql_statement varchar2
176 , p_disp_lengths lengths
177 , p_headers headers
178 , p_feedback varchar2
179 , p_max_rows number);
180 function Display_Table (p_table_name varchar2,
181 p_table_alias varchar2,
182 p_where_clause varchar2,
183 p_order_by_clause varchar2 default null,
184 p_display_longs varchar2 default 'Y') return number;
185 function Get_DB_Apps_Version return varchar2;
186 function Get_Package_Version (p_type varchar2, p_schema varchar2, p_package varchar2) return varchar2;
187 function Get_Package_Spec(p_package varchar2) return varchar2;
188 function Get_Package_Body(p_package varchar2) return varchar2;
189 function Get_Profile_Option (p_profile_option varchar2) return varchar2;
190 Function Get_RDBMS_Header return varchar2;
191 Function Get_Apps_Schema_Name return varchar2;
192 Function Compare_Pkg_Version(
193 package_name in varchar2,
194 object_type in varchar2,
195 object_owner in varchar2,
196 version_str in out NOCOPY varchar2,
197 compare_version in varchar2) return varchar2;
198 Function Compare_Pkg_Version_text(
199 package_name in varchar2,
200 object_type in varchar2,
201 version_str in out NOCOPY varchar2,
202 compare_version in varchar2 default null) return varchar2;
203
204 END JTF_DIAGNOSTIC_COREAPI;
205