[Home] [Help]
1: package body pv_entity_attribute_pvt_w as
2: /* $Header: pvxweatb.pls 120.2 2005/07/05 14:45 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_p2(t out nocopy pv_entity_attribute_pvt.pv_entity_attr_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
81: end loop;
82: end if;
83: end if;
84: end rosetta_table_copy_in_p2;
85: procedure rosetta_table_copy_out_p2(t pv_entity_attribute_pvt.pv_entity_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_DATE_TABLE
87: , a2 out nocopy JTF_NUMBER_TABLE
88: , a3 out nocopy JTF_DATE_TABLE
89: , a4 out nocopy JTF_NUMBER_TABLE
249: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
250: )
251:
252: as
253: ddp_entity_attr_rec pv_entity_attribute_pvt.entity_attr_rec_type;
254: ddindx binary_integer; indx binary_integer;
255: begin
256:
257: -- copy data to the local IN or IN-OUT args, if any
287: ddp_entity_attr_rec.display_external_value_flag := p7_a22;
288:
289:
290: -- here's the delegated call to the old PL/SQL routine
291: pv_entity_attribute_pvt.create_entity_attr(p_api_version_number,
292: p_init_msg_list,
293: p_commit,
294: p_validation_level,
295: x_return_status,
342: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
343: )
344:
345: as
346: ddp_entity_attr_rec pv_entity_attribute_pvt.entity_attr_rec_type;
347: ddindx binary_integer; indx binary_integer;
348: begin
349:
350: -- copy data to the local IN or IN-OUT args, if any
380: ddp_entity_attr_rec.display_external_value_flag := p7_a22;
381:
382:
383: -- here's the delegated call to the old PL/SQL routine
384: pv_entity_attribute_pvt.update_entity_attr(p_api_version_number,
385: p_init_msg_list,
386: p_commit,
387: p_validation_level,
388: x_return_status,
434: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
435: )
436:
437: as
438: ddp_entity_attr_rec pv_entity_attribute_pvt.entity_attr_rec_type;
439: ddindx binary_integer; indx binary_integer;
440: begin
441:
442: -- copy data to the local IN or IN-OUT args, if any
471:
472:
473:
474: -- here's the delegated call to the old PL/SQL routine
475: pv_entity_attribute_pvt.validate_entity_attr(p_api_version_number,
476: p_init_msg_list,
477: p_validation_level,
478: p_validation_mode,
479: ddp_entity_attr_rec,
518: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
519: )
520:
521: as
522: ddp_entity_attr_rec pv_entity_attribute_pvt.entity_attr_rec_type;
523: ddindx binary_integer; indx binary_integer;
524: begin
525:
526: -- copy data to the local IN or IN-OUT args, if any
550:
551:
552:
553: -- here's the delegated call to the old PL/SQL routine
554: pv_entity_attribute_pvt.check_entity_attr_items(ddp_entity_attr_rec,
555: p_validation_mode,
556: x_return_status);
557:
558: -- copy data back from the local variables to OUT or IN-OUT args, if any
591: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
592: )
593:
594: as
595: ddp_entity_attr_rec pv_entity_attribute_pvt.entity_attr_rec_type;
596: ddindx binary_integer; indx binary_integer;
597: begin
598:
599: -- copy data to the local IN or IN-OUT args, if any
627: ddp_entity_attr_rec.display_external_value_flag := p5_a22;
628:
629:
630: -- here's the delegated call to the old PL/SQL routine
631: pv_entity_attribute_pvt.validate_entity_attr_rec(p_api_version_number,
632: p_init_msg_list,
633: x_return_status,
634: x_msg_count,
635: x_msg_data,
644:
645:
646: end;
647:
648: end pv_entity_attribute_pvt_w;