1 package FND_CONC_TEMPLATES as
2 /* $Header: AFCPTPLS.pls 120.3.12010000.2 2008/11/12 19:54:41 jtoruno ship $ */
3 --
4 -- Package
5 -- FND_CONC_TEMPLATES
6 --
7 -- Purpose
8 -- Concurrent processing utilities for Templates and OPP
9 --
10
11 --
12 -- PRIVATE VARIABLES
13 --
14 -- Exceptions
15
16 --
17 -- PRIVATE FUNCTIONS
18 --
19 --
20
21 --
22 -- PUBLIC VARIABLES
23 --
24
25 -- Exceptions
26
27 -- Exception Pragmas
28
29 --
30 -- PUBLIC FUNCTIONS
31 --
32
33 -- NAME
34 -- get_template_information
35 -- Purpose
36 -- Called to retrieve the xml template details needed for OPP
37 --
38
39 procedure get_template_information(
40 prog_app_id IN number,
41 prog_app_name IN varchar2,
42 conc_prog_name IN varchar2,
43 nls_lang IN varchar2,
44 nls_terr IN varchar2,
45 s_nls_lang IN varchar2,
46 s_nls_terr IN varchar2,
47 template_obtained IN OUT NOCOPY varchar2,
48 template_name IN OUT NOCOPY varchar2,
49 template_language IN OUT NOCOPY varchar2,
50 format IN OUT NOCOPY varchar2,
51 request_language IN OUT NOCOPY varchar2,
52 iso_language IN OUT NOCOPY varchar2,
53 iso_territory IN OUT NOCOPY varchar2,
54 template_app_name IN OUT NOCOPY varchar2,
55 template_code IN OUT NOCOPY varchar2,
56 format_type IN OUT NOCOPY varchar2 );
57
58 -- NAME
59 -- fill_no_def_template
60 -- Purpose
61 -- Called to obtain the info for templates which does not
62 -- have default template set in fnd_concurrent_program table
63 --
64
65 procedure fill_no_def_template(
66 prog_app_name IN varchar2,
67 conc_prog_name IN varchar2,
68 nls_lang IN varchar2,
69 iso_lang IN varchar2,
70 iso_terr IN varchar2,
71 terr_indep IN varchar2,
72 template_obtained IN OUT NOCOPY varchar2,
73 template_name IN OUT NOCOPY varchar2,
74 template_language IN OUT NOCOPY varchar2,
75 format IN OUT NOCOPY varchar2,
76 request_language IN OUT NOCOPY varchar2,
77 iso_language IN OUT NOCOPY varchar2,
78 iso_territory IN OUT NOCOPY varchar2,
79 template_app_name IN OUT NOCOPY varchar2,
80 template_code IN OUT NOCOPY varchar2,
81 format_type IN OUT NOCOPY varchar2,
82 def_output_type IN OUT NOCOPY varchar2 );
83
84
85 -- NAME
86 -- fill_default_template
87 -- Purpose
88 -- Called to obtain the info for templates which does
89 -- have default template set in fnd_concurrent_program table
90 --
91
92 procedure fill_default_template(
93 prog_app_name IN varchar2,
94 conc_prog_name IN varchar2,
95 default_templ_code IN varchar2,
96 nls_lang IN varchar2,
97 iso_lang IN varchar2,
98 iso_terr IN varchar2,
99 terr_indep IN varchar2,
100 template_obtained IN OUT NOCOPY varchar2,
101 template_name IN OUT NOCOPY varchar2,
102 template_language IN OUT NOCOPY varchar2,
103 format IN OUT NOCOPY varchar2,
104 request_language IN OUT NOCOPY varchar2,
105 iso_language IN OUT NOCOPY varchar2,
106 iso_territory IN OUT NOCOPY varchar2,
107 template_app_name IN OUT NOCOPY varchar2,
108 template_code IN OUT NOCOPY varchar2,
109 format_type IN OUT NOCOPY varchar2,
110 def_output_type IN OUT NOCOPY varchar2 );
111
112 -- NAME
113 -- fill_special_def_template
114 -- Purpose
115 -- Called to obtain the info for templates which require a specific query
116 --
117
118 procedure fill_special_def_template(
119 prog_app_name IN varchar2,
120 conc_prog_name IN varchar2,
121 default_templ_code IN varchar2,
122 nls_lang IN varchar2,
123 iso_lang IN varchar2,
124 iso_terr IN varchar2,
125 terr_indep IN varchar2,
126 template_obtained IN OUT NOCOPY varchar2,
127 template_name IN OUT NOCOPY varchar2,
128 template_language IN OUT NOCOPY varchar2,
129 format IN OUT NOCOPY varchar2,
130 request_language IN OUT NOCOPY varchar2,
131 iso_language IN OUT NOCOPY varchar2,
132 iso_territory IN OUT NOCOPY varchar2,
133 template_app_name IN OUT NOCOPY varchar2,
134 template_code IN OUT NOCOPY varchar2,
135 format_type IN OUT NOCOPY varchar2,
136 def_output_type IN OUT NOCOPY varchar2 );
137
138 -- NAME
139 -- find_the_format
140 -- Purpose
141 -- Called to obtain the correct lookup value for the associated tag.
142 --
143
144 procedure find_the_format(
145 format_type IN varchar2,
146 format IN OUT NOCOPY varchar2 );
147
148 -- NAME
149 -- get_iso_lang_and_terr
150 -- Purpose
151 -- Called to obtain the iso codes for the specific language and territory
152 --
153
154 procedure get_iso_lang_and_terr(
155 nls_lang IN varchar2,
156 nls_terr IN varchar2,
157 iso_lang IN OUT NOCOPY varchar2,
158 iso_terr IN OUT NOCOPY varchar2 );
159
160 -- NAME
161 -- get_iso_lang_and_terr
162 -- Purpose
163 -- Called to obtain the default iso territory code for the specific lang
164 --
165
166 procedure get_def_iso_terr(
167 nls_lang IN varchar2,
168 def_iso_terr IN OUT NOCOPY varchar2 );
169
170
171
172 -- NAME
173 -- get_template_info_options
174 -- Purpose
175 -- Called to obtain the info for templates when called from the Options
176 -- window and a new template has to be validated and setup in the
177 -- templates row
178 --
179 procedure get_template_info_options(
180 prog_app_id IN number,
181 prog_app_name IN varchar2,
182 conc_prog_name IN varchar2,
183 nls_lang IN varchar2,
184 nls_terr IN varchar2,
185 s_nls_lang IN varchar2,
186 s_nls_terr IN varchar2,
187 new_template_name IN varchar2,
188 template_obtained IN OUT NOCOPY varchar2,
189 template_name IN OUT NOCOPY varchar2,
190 template_language IN OUT NOCOPY varchar2,
191 format IN OUT NOCOPY varchar2,
192 request_language IN OUT NOCOPY varchar2,
193 iso_language IN OUT NOCOPY varchar2,
194 iso_territory IN OUT NOCOPY varchar2,
195 template_app_name IN OUT NOCOPY varchar2,
196 template_code IN OUT NOCOPY varchar2,
197 format_type IN OUT NOCOPY varchar2 );
198
199 -- NAME
200 -- def_template_check
201 -- no_def_template_check
202 -- Purpose
203 -- setup to call proc data, return true if template info obtained
204
205 function def_template_check (
206 prog_app_name IN varchar2,
207 conc_prog_name IN varchar2,
208 def_templ_code IN varchar2,
209 nls_lang IN varchar2,
210 iso_lang IN varchar2,
211 iso_terr IN varchar2,
212 terr_indep IN varchar2,
213 template_obtained IN OUT NOCOPY varchar2,
214 template_name IN OUT NOCOPY varchar2,
215 template_language IN OUT NOCOPY varchar2,
216 format IN OUT NOCOPY varchar2,
217 request_language IN OUT NOCOPY varchar2,
218 iso_language IN OUT NOCOPY varchar2,
219 iso_territory IN OUT NOCOPY varchar2,
220 template_app_name IN OUT NOCOPY varchar2,
221 template_code IN OUT NOCOPY varchar2,
222 format_type IN OUT NOCOPY varchar2,
223 def_output_type IN OUT NOCOPY varchar2 )
224 return boolean;
225
226 function no_def_template_check (
227 prog_app_name IN varchar2,
228 conc_prog_name IN varchar2,
229 nls_lang IN varchar2,
230 iso_lang IN varchar2,
231 iso_terr IN varchar2,
232 terr_indep IN varchar2,
233 template_obtained IN OUT NOCOPY varchar2,
234 template_name IN OUT NOCOPY varchar2,
235 template_language IN OUT NOCOPY varchar2,
236 format IN OUT NOCOPY varchar2,
237 request_language IN OUT NOCOPY varchar2,
238 iso_language IN OUT NOCOPY varchar2,
239 iso_territory IN OUT NOCOPY varchar2,
240 template_app_name IN OUT NOCOPY varchar2,
241 template_code IN OUT NOCOPY varchar2,
242 format_type IN OUT NOCOPY varchar2,
243 def_output_type IN OUT NOCOPY varchar2 )
244 return boolean;
245
246
247 end FND_CONC_TEMPLATES;