DBA Data[Home] [Help]

APPS.OKL_SIF_PRICE_PARMS_PUB_W dependencies on OKL_SIF_PRICE_PARMS_PUB

Line 1: package body okl_sif_price_parms_pub_w as

1: package body okl_sif_price_parms_pub_w as
2: /* $Header: OKLUSPPB.pls 120.1 2005/07/19 07:31:17 asawanka 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 94: ddp_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;

90: , p5_a31 NUMBER := 0-1962.0724
91: )
92:
93: as
94: ddp_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;
95: ddx_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;
96: ddindx binary_integer; indx binary_integer;
97: begin
98:

Line 95: ddx_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;

91: )
92:
93: as
94: ddp_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;
95: ddx_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;
96: ddindx binary_integer; indx binary_integer;
97: begin
98:
99: -- copy data to the local IN or IN-OUT args, if any

Line 140: okl_sif_price_parms_pub.insert_sif_price_parms(p_api_version,

136: ddp_sppv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
137:
138:
139: -- here's the delegated call to the old PL/SQL routine
140: okl_sif_price_parms_pub.insert_sif_price_parms(p_api_version,
141: p_init_msg_list,
142: x_return_status,
143: x_msg_count,
144: x_msg_data,

Line 261: ddp_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;

257: , p6_a31 out nocopy JTF_NUMBER_TABLE
258: )
259:
260: as
261: ddp_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;
262: ddx_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;
263: ddindx binary_integer; indx binary_integer;
264: begin
265:

Line 262: ddx_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;

258: )
259:
260: as
261: ddp_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;
262: ddx_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;
263: ddindx binary_integer; indx binary_integer;
264: begin
265:
266: -- copy data to the local IN or IN-OUT args, if any

Line 308: okl_sif_price_parms_pub.insert_sif_price_parms(p_api_version,

304: );
305:
306:
307: -- here's the delegated call to the old PL/SQL routine
308: okl_sif_price_parms_pub.insert_sif_price_parms(p_api_version,
309: p_init_msg_list,
310: x_return_status,
311: x_msg_count,
312: x_msg_data,

Line 398: ddp_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;

394: , p5_a31 NUMBER := 0-1962.0724
395: )
396:
397: as
398: ddp_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;
399: ddindx binary_integer; indx binary_integer;
400: begin
401:
402: -- copy data to the local IN or IN-OUT args, if any

Line 442: okl_sif_price_parms_pub.lock_sif_price_parms(p_api_version,

438: ddp_sppv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a30);
439: ddp_sppv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
440:
441: -- here's the delegated call to the old PL/SQL routine
442: okl_sif_price_parms_pub.lock_sif_price_parms(p_api_version,
443: p_init_msg_list,
444: x_return_status,
445: x_msg_count,
446: x_msg_data,

Line 497: ddp_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;

493: , p5_a31 JTF_NUMBER_TABLE
494: )
495:
496: as
497: ddp_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;
498: ddindx binary_integer; indx binary_integer;
499: begin
500:
501: -- copy data to the local IN or IN-OUT args, if any

Line 542: okl_sif_price_parms_pub.lock_sif_price_parms(p_api_version,

538: , p5_a31
539: );
540:
541: -- here's the delegated call to the old PL/SQL routine
542: okl_sif_price_parms_pub.lock_sif_price_parms(p_api_version,
543: p_init_msg_list,
544: x_return_status,
545: x_msg_count,
546: x_msg_data,

Line 629: ddp_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;

625: , p5_a31 NUMBER := 0-1962.0724
626: )
627:
628: as
629: ddp_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;
630: ddx_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;
631: ddindx binary_integer; indx binary_integer;
632: begin
633:

Line 630: ddx_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;

626: )
627:
628: as
629: ddp_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;
630: ddx_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;
631: ddindx binary_integer; indx binary_integer;
632: begin
633:
634: -- copy data to the local IN or IN-OUT args, if any

Line 675: okl_sif_price_parms_pub.update_sif_price_parms(p_api_version,

671: ddp_sppv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
672:
673:
674: -- here's the delegated call to the old PL/SQL routine
675: okl_sif_price_parms_pub.update_sif_price_parms(p_api_version,
676: p_init_msg_list,
677: x_return_status,
678: x_msg_count,
679: x_msg_data,

Line 796: ddp_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;

792: , p6_a31 out nocopy JTF_NUMBER_TABLE
793: )
794:
795: as
796: ddp_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;
797: ddx_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;
798: ddindx binary_integer; indx binary_integer;
799: begin
800:

Line 797: ddx_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;

793: )
794:
795: as
796: ddp_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;
797: ddx_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;
798: ddindx binary_integer; indx binary_integer;
799: begin
800:
801: -- copy data to the local IN or IN-OUT args, if any

Line 843: okl_sif_price_parms_pub.update_sif_price_parms(p_api_version,

839: );
840:
841:
842: -- here's the delegated call to the old PL/SQL routine
843: okl_sif_price_parms_pub.update_sif_price_parms(p_api_version,
844: p_init_msg_list,
845: x_return_status,
846: x_msg_count,
847: x_msg_data,

Line 965: ddp_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;

961: , p5_a31 NUMBER := 0-1962.0724
962: )
963:
964: as
965: ddp_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;
966: ddx_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;
967: ddindx binary_integer; indx binary_integer;
968: begin
969:

Line 966: ddx_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;

962: )
963:
964: as
965: ddp_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;
966: ddx_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;
967: ddindx binary_integer; indx binary_integer;
968: begin
969:
970: -- copy data to the local IN or IN-OUT args, if any

Line 1011: okl_sif_price_parms_pub.delete_sif_price_parms(p_api_version,

1007: ddp_sppv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
1008:
1009:
1010: -- here's the delegated call to the old PL/SQL routine
1011: okl_sif_price_parms_pub.delete_sif_price_parms(p_api_version,
1012: p_init_msg_list,
1013: x_return_status,
1014: x_msg_count,
1015: x_msg_data,

Line 1132: ddp_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;

1128: , p6_a31 out nocopy JTF_NUMBER_TABLE
1129: )
1130:
1131: as
1132: ddp_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;
1133: ddx_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;
1134: ddindx binary_integer; indx binary_integer;
1135: begin
1136:

Line 1133: ddx_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;

1129: )
1130:
1131: as
1132: ddp_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;
1133: ddx_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;
1134: ddindx binary_integer; indx binary_integer;
1135: begin
1136:
1137: -- copy data to the local IN or IN-OUT args, if any

Line 1179: okl_sif_price_parms_pub.delete_sif_price_parms(p_api_version,

1175: );
1176:
1177:
1178: -- here's the delegated call to the old PL/SQL routine
1179: okl_sif_price_parms_pub.delete_sif_price_parms(p_api_version,
1180: p_init_msg_list,
1181: x_return_status,
1182: x_msg_count,
1183: x_msg_data,

Line 1301: ddp_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;

1297: , p5_a31 NUMBER := 0-1962.0724
1298: )
1299:
1300: as
1301: ddp_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;
1302: ddx_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;
1303: ddindx binary_integer; indx binary_integer;
1304: begin
1305:

Line 1302: ddx_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;

1298: )
1299:
1300: as
1301: ddp_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;
1302: ddx_sppv_rec okl_sif_price_parms_pub.sppv_rec_type;
1303: ddindx binary_integer; indx binary_integer;
1304: begin
1305:
1306: -- copy data to the local IN or IN-OUT args, if any

Line 1347: okl_sif_price_parms_pub.validate_sif_price_parms(p_api_version,

1343: ddp_sppv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
1344:
1345:
1346: -- here's the delegated call to the old PL/SQL routine
1347: okl_sif_price_parms_pub.validate_sif_price_parms(p_api_version,
1348: p_init_msg_list,
1349: x_return_status,
1350: x_msg_count,
1351: x_msg_data,

Line 1468: ddp_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;

1464: , p6_a31 out nocopy JTF_NUMBER_TABLE
1465: )
1466:
1467: as
1468: ddp_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;
1469: ddx_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;
1470: ddindx binary_integer; indx binary_integer;
1471: begin
1472:

Line 1469: ddx_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;

1465: )
1466:
1467: as
1468: ddp_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;
1469: ddx_sppv_tbl okl_sif_price_parms_pub.sppv_tbl_type;
1470: ddindx binary_integer; indx binary_integer;
1471: begin
1472:
1473: -- copy data to the local IN or IN-OUT args, if any

Line 1515: okl_sif_price_parms_pub.validate_sif_price_parms(p_api_version,

1511: );
1512:
1513:
1514: -- here's the delegated call to the old PL/SQL routine
1515: okl_sif_price_parms_pub.validate_sif_price_parms(p_api_version,
1516: p_init_msg_list,
1517: x_return_status,
1518: x_msg_count,
1519: x_msg_data,

Line 1565: end okl_sif_price_parms_pub_w;

1561: , p6_a31
1562: );
1563: end;
1564:
1565: end okl_sif_price_parms_pub_w;