DBA Data[Home] [Help]

APPS.OZF_FUNDTHRESHOLD_PVT_W dependencies on OZF_FUNDTHRESHOLD_PVT

Line 1: package body ozf_fundthreshold_pvt_w as

1: package body ozf_fundthreshold_pvt_w as
2: /* $Header: ozfwthrb.pls 120.1 2008/03/05 06:54:49 kpatro 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_fundthreshold_pvt.threshold_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_fundthreshold_pvt.threshold_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_DATE_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE

Line 117: procedure rosetta_table_copy_out_p3(t ozf_fundthreshold_pvt.threshold_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

113: end loop;
114: end if;
115: end if;
116: end rosetta_table_copy_in_p3;
117: procedure rosetta_table_copy_out_p3(t ozf_fundthreshold_pvt.threshold_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
118: , a1 out nocopy JTF_DATE_TABLE
119: , a2 out nocopy JTF_NUMBER_TABLE
120: , a3 out nocopy JTF_NUMBER_TABLE
121: , a4 out nocopy JTF_DATE_TABLE

Line 399: ddp_threshold_rec ozf_fundthreshold_pvt.threshold_rec_type;

395: , x_threshold_id out nocopy NUMBER
396: )
397:
398: as
399: ddp_threshold_rec ozf_fundthreshold_pvt.threshold_rec_type;
400: ddindx binary_integer; indx binary_integer;
401: begin
402:
403: -- copy data to the local IN or IN-OUT args, if any

Line 456: ozf_fundthreshold_pvt.create_threshold(p_api_version_number,

452: ddp_threshold_rec.threshold_type := p7_a41;
453:
454:
455: -- here's the delegated call to the old PL/SQL routine
456: ozf_fundthreshold_pvt.create_threshold(p_api_version_number,
457: p_init_msg_list,
458: p_commit,
459: p_validation_level,
460: x_return_status,

Line 530: ddp_threshold_rec ozf_fundthreshold_pvt.threshold_rec_type;

526: , x_object_version_number out nocopy NUMBER
527: )
528:
529: as
530: ddp_threshold_rec ozf_fundthreshold_pvt.threshold_rec_type;
531: ddindx binary_integer; indx binary_integer;
532: begin
533:
534: -- copy data to the local IN or IN-OUT args, if any

Line 587: ozf_fundthreshold_pvt.update_threshold(p_api_version_number,

583: ddp_threshold_rec.threshold_type := p7_a41;
584:
585:
586: -- here's the delegated call to the old PL/SQL routine
587: ozf_fundthreshold_pvt.update_threshold(p_api_version_number,
588: p_init_msg_list,
589: p_commit,
590: p_validation_level,
591: x_return_status,

Line 659: ddp_threshold_rec ozf_fundthreshold_pvt.threshold_rec_type;

655: , x_msg_data out nocopy VARCHAR2
656: )
657:
658: as
659: ddp_threshold_rec ozf_fundthreshold_pvt.threshold_rec_type;
660: ddindx binary_integer; indx binary_integer;
661: begin
662:
663: -- copy data to the local IN or IN-OUT args, if any

Line 714: ozf_fundthreshold_pvt.validate_threshold(p_api_version_number,

710:
711:
712:
713: -- here's the delegated call to the old PL/SQL routine
714: ozf_fundthreshold_pvt.validate_threshold(p_api_version_number,
715: p_init_msg_list,
716: p_validation_level,
717: ddp_threshold_rec,
718: x_return_status,

Line 778: ddp_threshold_rec ozf_fundthreshold_pvt.threshold_rec_type;

774: , x_return_status out nocopy VARCHAR2
775: )
776:
777: as
778: ddp_threshold_rec ozf_fundthreshold_pvt.threshold_rec_type;
779: ddindx binary_integer; indx binary_integer;
780: begin
781:
782: -- copy data to the local IN or IN-OUT args, if any

Line 829: ozf_fundthreshold_pvt.check_threshold_items(ddp_threshold_rec,

825:
826:
827:
828: -- here's the delegated call to the old PL/SQL routine
829: ozf_fundthreshold_pvt.check_threshold_items(ddp_threshold_rec,
830: p_validation_mode,
831: x_return_status);
832:
833: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 888: ddp_threshold_rec ozf_fundthreshold_pvt.threshold_rec_type;

884: , p5_a41 VARCHAR2
885: )
886:
887: as
888: ddp_threshold_rec ozf_fundthreshold_pvt.threshold_rec_type;
889: ddindx binary_integer; indx binary_integer;
890: begin
891:
892: -- copy data to the local IN or IN-OUT args, if any

Line 942: ozf_fundthreshold_pvt.validate_threshold_rec(p_api_version_number,

938: ddp_threshold_rec.source_lang := p5_a40;
939: ddp_threshold_rec.threshold_type := p5_a41;
940:
941: -- here's the delegated call to the old PL/SQL routine
942: ozf_fundthreshold_pvt.validate_threshold_rec(p_api_version_number,
943: p_init_msg_list,
944: x_return_status,
945: x_msg_count,
946: x_msg_data,

Line 1044: ddp_threshold_rec ozf_fundthreshold_pvt.threshold_rec_type;

1040: , p1_a41 out nocopy VARCHAR2
1041: )
1042:
1043: as
1044: ddp_threshold_rec ozf_fundthreshold_pvt.threshold_rec_type;
1045: ddx_complete_rec ozf_fundthreshold_pvt.threshold_rec_type;
1046: ddindx binary_integer; indx binary_integer;
1047: begin
1048:

Line 1045: ddx_complete_rec ozf_fundthreshold_pvt.threshold_rec_type;

1041: )
1042:
1043: as
1044: ddp_threshold_rec ozf_fundthreshold_pvt.threshold_rec_type;
1045: ddx_complete_rec ozf_fundthreshold_pvt.threshold_rec_type;
1046: ddindx binary_integer; indx binary_integer;
1047: begin
1048:
1049: -- copy data to the local IN or IN-OUT args, if any

Line 1095: ozf_fundthreshold_pvt.complete_threshold_rec(ddp_threshold_rec,

1091: ddp_threshold_rec.threshold_type := p0_a41;
1092:
1093:
1094: -- here's the delegated call to the old PL/SQL routine
1095: ozf_fundthreshold_pvt.complete_threshold_rec(ddp_threshold_rec,
1096: ddx_complete_rec);
1097:
1098: -- copy data back from the local variables to OUT or IN-OUT args, if any
1099:

Line 1144: end ozf_fundthreshold_pvt_w;

1140: p1_a40 := ddx_complete_rec.source_lang;
1141: p1_a41 := ddx_complete_rec.threshold_type;
1142: end;
1143:
1144: end ozf_fundthreshold_pvt_w;