DBA Data[Home] [Help]

APPS.OZF_REASON_PVT_W dependencies on OZF_REASON_PVT

Line 1: package body ozf_reason_pvt_w as

1: package body ozf_reason_pvt_w as
2: /* $Header: ozfwreab.pls 120.3 2006/05/17 01:16:17 sshivali 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p3(t out nocopy ozf_reason_pvt.action_tbl_type, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy ozf_reason_pvt.action_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100

Line 26: t := ozf_reason_pvt.action_tbl_type();

22: ) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is not null and a0.count=0 then
26: t := ozf_reason_pvt.action_tbl_type();
27: elsif a0 is not null and a0.count > 0 then
28: if a0.count > 0 then
29: t := ozf_reason_pvt.action_tbl_type();
30: t.extend(a0.count);

Line 29: t := ozf_reason_pvt.action_tbl_type();

25: if a0 is not null and a0.count=0 then
26: t := ozf_reason_pvt.action_tbl_type();
27: elsif a0 is not null and a0.count > 0 then
28: if a0.count > 0 then
29: t := ozf_reason_pvt.action_tbl_type();
30: t.extend(a0.count);
31: indx := a0.first;
32: ddindx := 1;
33: while true loop

Line 49: procedure rosetta_table_copy_out_p3(t ozf_reason_pvt.action_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

45: end loop;
46: end if;
47: end if;
48: end rosetta_table_copy_in_p3;
49: procedure rosetta_table_copy_out_p3(t ozf_reason_pvt.action_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_NUMBER_TABLE
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 105: procedure rosetta_table_copy_in_p7(t out nocopy ozf_reason_pvt.reason_tbl_type, a0 JTF_NUMBER_TABLE

101: end if;
102: end if;
103: end rosetta_table_copy_out_p3;
104:
105: procedure rosetta_table_copy_in_p7(t out nocopy ozf_reason_pvt.reason_tbl_type, a0 JTF_NUMBER_TABLE
106: , a1 JTF_NUMBER_TABLE
107: , a2 JTF_DATE_TABLE
108: , a3 JTF_NUMBER_TABLE
109: , a4 JTF_DATE_TABLE

Line 143: t := ozf_reason_pvt.reason_tbl_type();

139: ) as
140: ddindx binary_integer; indx binary_integer;
141: begin
142: if a0 is not null and a0.count=0 then
143: t := ozf_reason_pvt.reason_tbl_type();
144: elsif a0 is not null and a0.count > 0 then
145: if a0.count > 0 then
146: t := ozf_reason_pvt.reason_tbl_type();
147: t.extend(a0.count);

Line 146: t := ozf_reason_pvt.reason_tbl_type();

142: if a0 is not null and a0.count=0 then
143: t := ozf_reason_pvt.reason_tbl_type();
144: elsif a0 is not null and a0.count > 0 then
145: if a0.count > 0 then
146: t := ozf_reason_pvt.reason_tbl_type();
147: t.extend(a0.count);
148: indx := a0.first;
149: ddindx := 1;
150: while true loop

Line 194: procedure rosetta_table_copy_out_p7(t ozf_reason_pvt.reason_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

190: end loop;
191: end if;
192: end if;
193: end rosetta_table_copy_in_p7;
194: procedure rosetta_table_copy_out_p7(t ozf_reason_pvt.reason_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
195: , a1 out nocopy JTF_NUMBER_TABLE
196: , a2 out nocopy JTF_DATE_TABLE
197: , a3 out nocopy JTF_NUMBER_TABLE
198: , a4 out nocopy JTF_DATE_TABLE

Line 463: ddp_reason_rec ozf_reason_pvt.reason_rec_type;

459: , x_reason_code_id out nocopy NUMBER
460: )
461:
462: as
463: ddp_reason_rec ozf_reason_pvt.reason_rec_type;
464: ddindx binary_integer; indx binary_integer;
465: begin
466:
467: -- copy data to the local IN or IN-OUT args, if any

Line 512: ozf_reason_pvt.create_reason(p_api_version_number,

508: ddp_reason_rec.partner_access_flag := p7_a33;
509:
510:
511: -- here's the delegated call to the old PL/SQL routine
512: ozf_reason_pvt.create_reason(p_api_version_number,
513: p_init_msg_list,
514: p_commit,
515: p_validation_level,
516: x_return_status,

Line 578: ddp_reason_rec ozf_reason_pvt.reason_rec_type;

574: , x_object_version_number out nocopy NUMBER
575: )
576:
577: as
578: ddp_reason_rec ozf_reason_pvt.reason_rec_type;
579: ddindx binary_integer; indx binary_integer;
580: begin
581:
582: -- copy data to the local IN or IN-OUT args, if any

Line 627: ozf_reason_pvt.update_reason(p_api_version_number,

623: ddp_reason_rec.partner_access_flag := p7_a33;
624:
625:
626: -- here's the delegated call to the old PL/SQL routine
627: ozf_reason_pvt.update_reason(p_api_version_number,
628: p_init_msg_list,
629: p_commit,
630: p_validation_level,
631: x_return_status,

Line 664: ddp_action_tbl ozf_reason_pvt.action_tbl_type;

660: , p7_a5 JTF_VARCHAR2_TABLE_100
661: )
662:
663: as
664: ddp_action_tbl ozf_reason_pvt.action_tbl_type;
665: ddindx binary_integer; indx binary_integer;
666: begin
667:
668: -- copy data to the local IN or IN-OUT args, if any

Line 676: ozf_reason_pvt_w.rosetta_table_copy_in_p3(ddp_action_tbl, p7_a0

672:
673:
674:
675:
676: ozf_reason_pvt_w.rosetta_table_copy_in_p3(ddp_action_tbl, p7_a0
677: , p7_a1
678: , p7_a2
679: , p7_a3
680: , p7_a4

Line 685: ozf_reason_pvt.update_actions(p_api_version_number,

681: , p7_a5
682: );
683:
684: -- here's the delegated call to the old PL/SQL routine
685: ozf_reason_pvt.update_actions(p_api_version_number,
686: p_init_msg_list,
687: p_commit,
688: p_validation_level,
689: x_return_status,

Line 715: ddp_action_rec ozf_reason_pvt.action_rec_type;

711: , x_return_status out nocopy VARCHAR2
712: )
713:
714: as
715: ddp_action_rec ozf_reason_pvt.action_rec_type;
716: ddindx binary_integer; indx binary_integer;
717: begin
718:
719: -- copy data to the local IN or IN-OUT args, if any

Line 730: ozf_reason_pvt.check_unique_action(ddp_action_rec,

726:
727:
728:
729: -- here's the delegated call to the old PL/SQL routine
730: ozf_reason_pvt.check_unique_action(ddp_action_rec,
731: p_validation_mode,
732: x_return_status);
733:
734: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 781: ddp_reason_rec ozf_reason_pvt.reason_rec_type;

777: , p5_a33 VARCHAR2
778: )
779:
780: as
781: ddp_reason_rec ozf_reason_pvt.reason_rec_type;
782: ddindx binary_integer; indx binary_integer;
783: begin
784:
785: -- copy data to the local IN or IN-OUT args, if any

Line 827: ozf_reason_pvt.validate_reason_rec(p_api_version_number,

823: ddp_reason_rec.order_type_id := p5_a32;
824: ddp_reason_rec.partner_access_flag := p5_a33;
825:
826: -- here's the delegated call to the old PL/SQL routine
827: ozf_reason_pvt.validate_reason_rec(p_api_version_number,
828: p_init_msg_list,
829: x_return_status,
830: x_msg_count,
831: x_msg_data,

Line 885: ddp_reason_rec ozf_reason_pvt.reason_rec_type;

881: , x_msg_data out nocopy VARCHAR2
882: )
883:
884: as
885: ddp_reason_rec ozf_reason_pvt.reason_rec_type;
886: ddindx binary_integer; indx binary_integer;
887: begin
888:
889: -- copy data to the local IN or IN-OUT args, if any

Line 932: ozf_reason_pvt.validate_reason(p_api_version_number,

928:
929:
930:
931: -- here's the delegated call to the old PL/SQL routine
932: ozf_reason_pvt.validate_reason(p_api_version_number,
933: p_init_msg_list,
934: p_validation_level,
935: ddp_reason_rec,
936: x_return_status,

Line 1017: ddp_reason_rec ozf_reason_pvt.reason_rec_type;

1013: , x_return_status out nocopy VARCHAR2
1014: )
1015:
1016: as
1017: ddp_reason_rec ozf_reason_pvt.reason_rec_type;
1018: ddx_complete_rec ozf_reason_pvt.reason_rec_type;
1019: ddindx binary_integer; indx binary_integer;
1020: begin
1021:

Line 1018: ddx_complete_rec ozf_reason_pvt.reason_rec_type;

1014: )
1015:
1016: as
1017: ddp_reason_rec ozf_reason_pvt.reason_rec_type;
1018: ddx_complete_rec ozf_reason_pvt.reason_rec_type;
1019: ddindx binary_integer; indx binary_integer;
1020: begin
1021:
1022: -- copy data to the local IN or IN-OUT args, if any

Line 1061: ozf_reason_pvt.complete_reason_rec(ddp_reason_rec,

1057:
1058:
1059:
1060: -- here's the delegated call to the old PL/SQL routine
1061: ozf_reason_pvt.complete_reason_rec(ddp_reason_rec,
1062: ddx_complete_rec,
1063: x_return_status);
1064:
1065: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 1104: end ozf_reason_pvt_w;

1100: p1_a33 := ddx_complete_rec.partner_access_flag;
1101:
1102: end;
1103:
1104: end ozf_reason_pvt_w;