DBA Data[Home] [Help]

APPS.OKL_SIF_FEES_PUB_W dependencies on OKL_SIF_FEES_PUB

Line 1: package body okl_sif_fees_pub_w as

1: package body okl_sif_fees_pub_w as
2: /* $Header: OKLUSFEB.pls 120.3 2005/10/11 06:39:47 rgooty 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 140: ddp_sfev_rec okl_sif_fees_pub.sfev_rec_type;

136: , p5_a54 NUMBER := 0-1962.0724
137: )
138:
139: as
140: ddp_sfev_rec okl_sif_fees_pub.sfev_rec_type;
141: ddx_sfev_rec okl_sif_fees_pub.sfev_rec_type;
142: ddindx binary_integer; indx binary_integer;
143: begin
144:

Line 141: ddx_sfev_rec okl_sif_fees_pub.sfev_rec_type;

137: )
138:
139: as
140: ddp_sfev_rec okl_sif_fees_pub.sfev_rec_type;
141: ddx_sfev_rec okl_sif_fees_pub.sfev_rec_type;
142: ddindx binary_integer; indx binary_integer;
143: begin
144:
145: -- copy data to the local IN or IN-OUT args, if any

Line 209: okl_sif_fees_pub.insert_sif_fees(p_api_version,

205: ddp_sfev_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a54);
206:
207:
208: -- here's the delegated call to the old PL/SQL routine
209: okl_sif_fees_pub.insert_sif_fees(p_api_version,
210: p_init_msg_list,
211: x_return_status,
212: x_msg_count,
213: x_msg_data,

Line 399: ddp_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;

395: , p6_a54 out nocopy JTF_NUMBER_TABLE
396: )
397:
398: as
399: ddp_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;
400: ddx_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;
401: ddindx binary_integer; indx binary_integer;
402: begin
403:

Line 400: ddx_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;

396: )
397:
398: as
399: ddp_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;
400: ddx_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;
401: ddindx binary_integer; indx binary_integer;
402: begin
403:
404: -- copy data to the local IN or IN-OUT args, if any

Line 469: okl_sif_fees_pub.insert_sif_fees(p_api_version,

465: );
466:
467:
468: -- here's the delegated call to the old PL/SQL routine
469: okl_sif_fees_pub.insert_sif_fees(p_api_version,
470: p_init_msg_list,
471: x_return_status,
472: x_msg_count,
473: x_msg_data,

Line 605: ddp_sfev_rec okl_sif_fees_pub.sfev_rec_type;

601: , p5_a54 NUMBER := 0-1962.0724
602: )
603:
604: as
605: ddp_sfev_rec okl_sif_fees_pub.sfev_rec_type;
606: ddindx binary_integer; indx binary_integer;
607: begin
608:
609: -- copy data to the local IN or IN-OUT args, if any

Line 672: okl_sif_fees_pub.lock_sif_fees(p_api_version,

668: ddp_sfev_rec.last_update_login := rosetta_g_miss_num_map(p5_a53);
669: ddp_sfev_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a54);
670:
671: -- here's the delegated call to the old PL/SQL routine
672: okl_sif_fees_pub.lock_sif_fees(p_api_version,
673: p_init_msg_list,
674: x_return_status,
675: x_msg_count,
676: x_msg_data,

Line 750: ddp_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;

746: , p5_a54 JTF_NUMBER_TABLE
747: )
748:
749: as
750: ddp_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;
751: ddindx binary_integer; indx binary_integer;
752: begin
753:
754: -- copy data to the local IN or IN-OUT args, if any

Line 818: okl_sif_fees_pub.lock_sif_fees(p_api_version,

814: , p5_a54
815: );
816:
817: -- here's the delegated call to the old PL/SQL routine
818: okl_sif_fees_pub.lock_sif_fees(p_api_version,
819: p_init_msg_list,
820: x_return_status,
821: x_msg_count,
822: x_msg_data,

Line 951: ddp_sfev_rec okl_sif_fees_pub.sfev_rec_type;

947: , p5_a54 NUMBER := 0-1962.0724
948: )
949:
950: as
951: ddp_sfev_rec okl_sif_fees_pub.sfev_rec_type;
952: ddx_sfev_rec okl_sif_fees_pub.sfev_rec_type;
953: ddindx binary_integer; indx binary_integer;
954: begin
955:

Line 952: ddx_sfev_rec okl_sif_fees_pub.sfev_rec_type;

948: )
949:
950: as
951: ddp_sfev_rec okl_sif_fees_pub.sfev_rec_type;
952: ddx_sfev_rec okl_sif_fees_pub.sfev_rec_type;
953: ddindx binary_integer; indx binary_integer;
954: begin
955:
956: -- copy data to the local IN or IN-OUT args, if any

Line 1020: okl_sif_fees_pub.update_sif_fees(p_api_version,

1016: ddp_sfev_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a54);
1017:
1018:
1019: -- here's the delegated call to the old PL/SQL routine
1020: okl_sif_fees_pub.update_sif_fees(p_api_version,
1021: p_init_msg_list,
1022: x_return_status,
1023: x_msg_count,
1024: x_msg_data,

Line 1210: ddp_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;

1206: , p6_a54 out nocopy JTF_NUMBER_TABLE
1207: )
1208:
1209: as
1210: ddp_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;
1211: ddx_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;
1212: ddindx binary_integer; indx binary_integer;
1213: begin
1214:

Line 1211: ddx_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;

1207: )
1208:
1209: as
1210: ddp_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;
1211: ddx_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;
1212: ddindx binary_integer; indx binary_integer;
1213: begin
1214:
1215: -- copy data to the local IN or IN-OUT args, if any

Line 1280: okl_sif_fees_pub.update_sif_fees(p_api_version,

1276: );
1277:
1278:
1279: -- here's the delegated call to the old PL/SQL routine
1280: okl_sif_fees_pub.update_sif_fees(p_api_version,
1281: p_init_msg_list,
1282: x_return_status,
1283: x_msg_count,
1284: x_msg_data,

Line 1471: ddp_sfev_rec okl_sif_fees_pub.sfev_rec_type;

1467: , p5_a54 NUMBER := 0-1962.0724
1468: )
1469:
1470: as
1471: ddp_sfev_rec okl_sif_fees_pub.sfev_rec_type;
1472: ddx_sfev_rec okl_sif_fees_pub.sfev_rec_type;
1473: ddindx binary_integer; indx binary_integer;
1474: begin
1475:

Line 1472: ddx_sfev_rec okl_sif_fees_pub.sfev_rec_type;

1468: )
1469:
1470: as
1471: ddp_sfev_rec okl_sif_fees_pub.sfev_rec_type;
1472: ddx_sfev_rec okl_sif_fees_pub.sfev_rec_type;
1473: ddindx binary_integer; indx binary_integer;
1474: begin
1475:
1476: -- copy data to the local IN or IN-OUT args, if any

Line 1540: okl_sif_fees_pub.delete_sif_fees(p_api_version,

1536: ddp_sfev_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a54);
1537:
1538:
1539: -- here's the delegated call to the old PL/SQL routine
1540: okl_sif_fees_pub.delete_sif_fees(p_api_version,
1541: p_init_msg_list,
1542: x_return_status,
1543: x_msg_count,
1544: x_msg_data,

Line 1730: ddp_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;

1726: , p6_a54 out nocopy JTF_NUMBER_TABLE
1727: )
1728:
1729: as
1730: ddp_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;
1731: ddx_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;
1732: ddindx binary_integer; indx binary_integer;
1733: begin
1734:

Line 1731: ddx_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;

1727: )
1728:
1729: as
1730: ddp_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;
1731: ddx_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;
1732: ddindx binary_integer; indx binary_integer;
1733: begin
1734:
1735: -- copy data to the local IN or IN-OUT args, if any

Line 1800: okl_sif_fees_pub.delete_sif_fees(p_api_version,

1796: );
1797:
1798:
1799: -- here's the delegated call to the old PL/SQL routine
1800: okl_sif_fees_pub.delete_sif_fees(p_api_version,
1801: p_init_msg_list,
1802: x_return_status,
1803: x_msg_count,
1804: x_msg_data,

Line 1991: ddp_sfev_rec okl_sif_fees_pub.sfev_rec_type;

1987: , p5_a54 NUMBER := 0-1962.0724
1988: )
1989:
1990: as
1991: ddp_sfev_rec okl_sif_fees_pub.sfev_rec_type;
1992: ddx_sfev_rec okl_sif_fees_pub.sfev_rec_type;
1993: ddindx binary_integer; indx binary_integer;
1994: begin
1995:

Line 1992: ddx_sfev_rec okl_sif_fees_pub.sfev_rec_type;

1988: )
1989:
1990: as
1991: ddp_sfev_rec okl_sif_fees_pub.sfev_rec_type;
1992: ddx_sfev_rec okl_sif_fees_pub.sfev_rec_type;
1993: ddindx binary_integer; indx binary_integer;
1994: begin
1995:
1996: -- copy data to the local IN or IN-OUT args, if any

Line 2060: okl_sif_fees_pub.validate_sif_fees(p_api_version,

2056: ddp_sfev_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a54);
2057:
2058:
2059: -- here's the delegated call to the old PL/SQL routine
2060: okl_sif_fees_pub.validate_sif_fees(p_api_version,
2061: p_init_msg_list,
2062: x_return_status,
2063: x_msg_count,
2064: x_msg_data,

Line 2250: ddp_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;

2246: , p6_a54 out nocopy JTF_NUMBER_TABLE
2247: )
2248:
2249: as
2250: ddp_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;
2251: ddx_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;
2252: ddindx binary_integer; indx binary_integer;
2253: begin
2254:

Line 2251: ddx_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;

2247: )
2248:
2249: as
2250: ddp_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;
2251: ddx_sfev_tbl okl_sif_fees_pub.sfev_tbl_type;
2252: ddindx binary_integer; indx binary_integer;
2253: begin
2254:
2255: -- copy data to the local IN or IN-OUT args, if any

Line 2320: okl_sif_fees_pub.validate_sif_fees(p_api_version,

2316: );
2317:
2318:
2319: -- here's the delegated call to the old PL/SQL routine
2320: okl_sif_fees_pub.validate_sif_fees(p_api_version,
2321: p_init_msg_list,
2322: x_return_status,
2323: x_msg_count,
2324: x_msg_data,

Line 2393: end okl_sif_fees_pub_w;

2389: , p6_a54
2390: );
2391: end;
2392:
2393: end okl_sif_fees_pub_w;