[Home] [Help]
1: package body ams_template_attr_pvt_w as
2: /* $Header: amswpatb.pls 120.1 2005/06/28 16:14 appldev ship $ */
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:
18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t out nocopy ams_template_attr_pvt.template_attr_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
65: end loop;
66: end if;
67: end if;
68: end rosetta_table_copy_in_p3;
69: procedure rosetta_table_copy_out_p3(t ams_template_attr_pvt.template_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
70: , a1 out nocopy JTF_NUMBER_TABLE
71: , a2 out nocopy JTF_DATE_TABLE
72: , a3 out nocopy JTF_NUMBER_TABLE
73: , a4 out nocopy JTF_DATE_TABLE
185: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
186: )
187:
188: as
189: ddp_template_attr_rec ams_template_attr_pvt.template_attr_rec_type;
190: ddindx binary_integer; indx binary_integer;
191: begin
192:
193: -- copy data to the local IN or IN-OUT args, if any
215: ddp_template_attr_rec.hide_flag := p7_a14;
216:
217:
218: -- here's the delegated call to the old PL/SQL routine
219: ams_template_attr_pvt.create_template_attr(p_api_version_number,
220: p_init_msg_list,
221: p_commit,
222: p_validation_level,
223: x_return_status,
261: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
262: )
263:
264: as
265: ddp_template_attr_rec ams_template_attr_pvt.template_attr_rec_type;
266: ddindx binary_integer; indx binary_integer;
267: begin
268:
269: -- copy data to the local IN or IN-OUT args, if any
290: ddp_template_attr_rec.editable_flag := p7_a13;
291: ddp_template_attr_rec.hide_flag := p7_a14;
292:
293: -- here's the delegated call to the old PL/SQL routine
294: ams_template_attr_pvt.update_template_attr(p_api_version_number,
295: p_init_msg_list,
296: p_commit,
297: p_validation_level,
298: x_return_status,
334: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
335: )
336:
337: as
338: ddp_template_attr_rec ams_template_attr_pvt.template_attr_rec_type;
339: ddindx binary_integer; indx binary_integer;
340: begin
341:
342: -- copy data to the local IN or IN-OUT args, if any
363:
364:
365:
366: -- here's the delegated call to the old PL/SQL routine
367: ams_template_attr_pvt.validate_template_attr(p_api_version_number,
368: p_init_msg_list,
369: p_validation_level,
370: ddp_template_attr_rec,
371: p_validation_mode,
402: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
403: )
404:
405: as
406: ddp_template_attr_rec ams_template_attr_pvt.template_attr_rec_type;
407: ddindx binary_integer; indx binary_integer;
408: begin
409:
410: -- copy data to the local IN or IN-OUT args, if any
426:
427:
428:
429: -- here's the delegated call to the old PL/SQL routine
430: ams_template_attr_pvt.check_template_attr_items(ddp_template_attr_rec,
431: p_validation_mode,
432: x_return_status);
433:
434: -- copy data back from the local variables to OUT or IN-OUT args, if any
458: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
459: )
460:
461: as
462: ddp_template_attr_rec ams_template_attr_pvt.template_attr_rec_type;
463: ddindx binary_integer; indx binary_integer;
464: begin
465:
466: -- copy data to the local IN or IN-OUT args, if any
485: ddp_template_attr_rec.editable_flag := p5_a13;
486: ddp_template_attr_rec.hide_flag := p5_a14;
487:
488: -- here's the delegated call to the old PL/SQL routine
489: ams_template_attr_pvt.validate_template_attr_rec(p_api_version_number,
490: p_init_msg_list,
491: x_return_status,
492: x_msg_count,
493: x_msg_data,
500:
501:
502: end;
503:
504: end ams_template_attr_pvt_w;