DBA Data[Home] [Help]

APPS.HZ_MIXNM_WEBUI_UTILITY_JW dependencies on HZ_MIXNM_WEBUI_UTILITY_JW

Line 1: package body hz_mixnm_webui_utility_jw as

1: package body hz_mixnm_webui_utility_jw as
2: /* $Header: ARHXWUJB.pls 120.2 2005/06/18 04:28:31 jhuang noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 124: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);

120: -- copy data to the local IN or IN-OUT args, if any
121:
122:
123:
124: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);
125:
126: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
127:
128: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_flag_tab, p_flag_tab);

Line 126: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);

122:
123:
124: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);
125:
126: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
127:
128: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_flag_tab, p_flag_tab);
129:
130: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_os_tab, p_os_tab);

Line 128: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_flag_tab, p_flag_tab);

124: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);
125:
126: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
127:
128: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_flag_tab, p_flag_tab);
129:
130: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_os_tab, p_os_tab);
131:
132: -- here's the delegated call to the old PL/SQL routine

Line 130: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_os_tab, p_os_tab);

126: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
127:
128: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_flag_tab, p_flag_tab);
129:
130: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_os_tab, p_os_tab);
131:
132: -- here's the delegated call to the old PL/SQL routine
133: hz_mixnm_webui_utility.create_rule(p_rule_type,
134: p_rule_id,

Line 170: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);

166: -- copy data to the local IN or IN-OUT args, if any
167:
168:
169:
170: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);
171:
172: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
173:
174: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_flag_tab, p_flag_tab);

Line 172: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);

168:
169:
170: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);
171:
172: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
173:
174: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_flag_tab, p_flag_tab);
175:
176: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_os_tab, p_os_tab);

Line 174: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_flag_tab, p_flag_tab);

170: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);
171:
172: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
173:
174: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_flag_tab, p_flag_tab);
175:
176: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_os_tab, p_os_tab);
177:
178: -- here's the delegated call to the old PL/SQL routine

Line 176: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_os_tab, p_os_tab);

172: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
173:
174: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_flag_tab, p_flag_tab);
175:
176: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_os_tab, p_os_tab);
177:
178: -- here's the delegated call to the old PL/SQL routine
179: hz_mixnm_webui_utility.update_rule(p_rule_type,
180: p_rule_id,

Line 212: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);

208: begin
209:
210: -- copy data to the local IN or IN-OUT args, if any
211:
212: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);
213:
214: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
215:
216: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_flag_tab, p_flag_tab);

Line 214: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);

210: -- copy data to the local IN or IN-OUT args, if any
211:
212: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);
213:
214: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
215:
216: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_flag_tab, p_flag_tab);
217:
218: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_os_tab, p_os_tab);

Line 216: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_flag_tab, p_flag_tab);

212: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);
213:
214: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
215:
216: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_flag_tab, p_flag_tab);
217:
218: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_os_tab, p_os_tab);
219:
220: -- here's the delegated call to the old PL/SQL routine

Line 218: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_os_tab, p_os_tab);

214: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
215:
216: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_flag_tab, p_flag_tab);
217:
218: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_os_tab, p_os_tab);
219:
220: -- here's the delegated call to the old PL/SQL routine
221: hz_mixnm_webui_utility.update_thirdpartyrule(p_rule_exists,
222: ddp_entity_attr_id_tab,

Line 250: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);

246: ddindx binary_integer; indx binary_integer;
247: begin
248:
249: -- copy data to the local IN or IN-OUT args, if any
250: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);
251:
252: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
253:
254: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_range_tab, p_range_tab);

Line 252: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);

248:
249: -- copy data to the local IN or IN-OUT args, if any
250: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);
251:
252: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
253:
254: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_range_tab, p_range_tab);
255:
256: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_data_sources_tab, p_data_sources_tab);

Line 254: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_range_tab, p_range_tab);

250: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);
251:
252: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
253:
254: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_range_tab, p_range_tab);
255:
256: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_data_sources_tab, p_data_sources_tab);
257:
258: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_ranking_tab, p_ranking_tab);

Line 256: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_data_sources_tab, p_data_sources_tab);

252: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
253:
254: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_range_tab, p_range_tab);
255:
256: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_data_sources_tab, p_data_sources_tab);
257:
258: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_ranking_tab, p_ranking_tab);
259:
260: -- here's the delegated call to the old PL/SQL routine

Line 258: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_ranking_tab, p_ranking_tab);

254: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_range_tab, p_range_tab);
255:
256: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_data_sources_tab, p_data_sources_tab);
257:
258: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_ranking_tab, p_ranking_tab);
259:
260: -- here's the delegated call to the old PL/SQL routine
261: hz_mixnm_webui_utility.set_datasources(ddp_entity_attr_id_tab,
262: ddp_attribute_group_name_tab,

Line 291: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);

287: begin
288:
289: -- copy data to the local IN or IN-OUT args, if any
290:
291: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);
292:
293:
294:
295:

Line 309: hz_mixnm_webui_utility_jw.rosetta_table_copy_out_p1(ddx_data_sources_tab, x_data_sources_tab);

305: -- copy data back from the local OUT or IN-OUT args, if any
306:
307:
308:
309: hz_mixnm_webui_utility_jw.rosetta_table_copy_out_p1(ddx_data_sources_tab, x_data_sources_tab);
310:
311: hz_mixnm_webui_utility_jw.rosetta_table_copy_out_p1(ddx_meaning_tab, x_meaning_tab);
312:
313: hz_mixnm_webui_utility_jw.rosetta_table_copy_out_p0(ddx_ranking_tab, x_ranking_tab);

Line 311: hz_mixnm_webui_utility_jw.rosetta_table_copy_out_p1(ddx_meaning_tab, x_meaning_tab);

307:
308:
309: hz_mixnm_webui_utility_jw.rosetta_table_copy_out_p1(ddx_data_sources_tab, x_data_sources_tab);
310:
311: hz_mixnm_webui_utility_jw.rosetta_table_copy_out_p1(ddx_meaning_tab, x_meaning_tab);
312:
313: hz_mixnm_webui_utility_jw.rosetta_table_copy_out_p0(ddx_ranking_tab, x_ranking_tab);
314: end;
315:

Line 313: hz_mixnm_webui_utility_jw.rosetta_table_copy_out_p0(ddx_ranking_tab, x_ranking_tab);

309: hz_mixnm_webui_utility_jw.rosetta_table_copy_out_p1(ddx_data_sources_tab, x_data_sources_tab);
310:
311: hz_mixnm_webui_utility_jw.rosetta_table_copy_out_p1(ddx_meaning_tab, x_meaning_tab);
312:
313: hz_mixnm_webui_utility_jw.rosetta_table_copy_out_p0(ddx_ranking_tab, x_ranking_tab);
314: end;
315:
316: procedure set_datasourcesforagroup_6(p_entity_attr_id_tab JTF_NUMBER_TABLE
317: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100

Line 330: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);

326: ddindx binary_integer; indx binary_integer;
327: begin
328:
329: -- copy data to the local IN or IN-OUT args, if any
330: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);
331:
332: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
333:
334: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_data_sources_tab, p_data_sources_tab);

Line 332: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);

328:
329: -- copy data to the local IN or IN-OUT args, if any
330: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);
331:
332: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
333:
334: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_data_sources_tab, p_data_sources_tab);
335:
336: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_ranking_tab, p_ranking_tab);

Line 334: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_data_sources_tab, p_data_sources_tab);

330: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_entity_attr_id_tab, p_entity_attr_id_tab);
331:
332: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
333:
334: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_data_sources_tab, p_data_sources_tab);
335:
336: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_ranking_tab, p_ranking_tab);
337:
338: -- here's the delegated call to the old PL/SQL routine

Line 336: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_ranking_tab, p_ranking_tab);

332: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_attribute_group_name_tab, p_attribute_group_name_tab);
333:
334: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p1(ddp_data_sources_tab, p_data_sources_tab);
335:
336: hz_mixnm_webui_utility_jw.rosetta_table_copy_in_p0(ddp_ranking_tab, p_ranking_tab);
337:
338: -- here's the delegated call to the old PL/SQL routine
339: hz_mixnm_webui_utility.set_datasourcesforagroup(ddp_entity_attr_id_tab,
340: ddp_attribute_group_name_tab,

Line 350: end hz_mixnm_webui_utility_jw;

346:
347:
348: end;
349:
350: end hz_mixnm_webui_utility_jw;