DBA Data[Home] [Help]

APPS.OKL_SIF_YIELDS_PUB_W dependencies on OKL_SIF_YIELDS_PUB

Line 1: package body okl_sif_yields_pub_w as

1: package body okl_sif_yields_pub_w as
2: /* $Header: OKLUSIYB.pls 120.1 2005/09/13 12:40:22 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 98: ddp_siyv_rec okl_sif_yields_pub.siyv_rec_type;

94: , p5_a33 NUMBER := 0-1962.0724
95: )
96:
97: as
98: ddp_siyv_rec okl_sif_yields_pub.siyv_rec_type;
99: ddx_siyv_rec okl_sif_yields_pub.siyv_rec_type;
100: ddindx binary_integer; indx binary_integer;
101: begin
102:

Line 99: ddx_siyv_rec okl_sif_yields_pub.siyv_rec_type;

95: )
96:
97: as
98: ddp_siyv_rec okl_sif_yields_pub.siyv_rec_type;
99: ddx_siyv_rec okl_sif_yields_pub.siyv_rec_type;
100: ddindx binary_integer; indx binary_integer;
101: begin
102:
103: -- copy data to the local IN or IN-OUT args, if any

Line 146: okl_sif_yields_pub.insert_sif_yields(p_api_version,

142: ddp_siyv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
143:
144:
145: -- here's the delegated call to the old PL/SQL routine
146: okl_sif_yields_pub.insert_sif_yields(p_api_version,
147: p_init_msg_list,
148: x_return_status,
149: x_msg_count,
150: x_msg_data,

Line 273: ddp_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;

269: , p6_a33 out nocopy JTF_NUMBER_TABLE
270: )
271:
272: as
273: ddp_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;
274: ddx_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;
275: ddindx binary_integer; indx binary_integer;
276: begin
277:

Line 274: ddx_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;

270: )
271:
272: as
273: ddp_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;
274: ddx_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;
275: ddindx binary_integer; indx binary_integer;
276: begin
277:
278: -- copy data to the local IN or IN-OUT args, if any

Line 322: okl_sif_yields_pub.insert_sif_yields(p_api_version,

318: );
319:
320:
321: -- here's the delegated call to the old PL/SQL routine
322: okl_sif_yields_pub.insert_sif_yields(p_api_version,
323: p_init_msg_list,
324: x_return_status,
325: x_msg_count,
326: x_msg_data,

Line 416: ddp_siyv_rec okl_sif_yields_pub.siyv_rec_type;

412: , p5_a33 NUMBER := 0-1962.0724
413: )
414:
415: as
416: ddp_siyv_rec okl_sif_yields_pub.siyv_rec_type;
417: ddindx binary_integer; indx binary_integer;
418: begin
419:
420: -- copy data to the local IN or IN-OUT args, if any

Line 462: okl_sif_yields_pub.lock_sif_yields(p_api_version,

458: ddp_siyv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a32);
459: ddp_siyv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
460:
461: -- here's the delegated call to the old PL/SQL routine
462: okl_sif_yields_pub.lock_sif_yields(p_api_version,
463: p_init_msg_list,
464: x_return_status,
465: x_msg_count,
466: x_msg_data,

Line 519: ddp_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;

515: , p5_a33 JTF_NUMBER_TABLE
516: )
517:
518: as
519: ddp_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;
520: ddindx binary_integer; indx binary_integer;
521: begin
522:
523: -- copy data to the local IN or IN-OUT args, if any

Line 566: okl_sif_yields_pub.lock_sif_yields(p_api_version,

562: , p5_a33
563: );
564:
565: -- here's the delegated call to the old PL/SQL routine
566: okl_sif_yields_pub.lock_sif_yields(p_api_version,
567: p_init_msg_list,
568: x_return_status,
569: x_msg_count,
570: x_msg_data,

Line 657: ddp_siyv_rec okl_sif_yields_pub.siyv_rec_type;

653: , p5_a33 NUMBER := 0-1962.0724
654: )
655:
656: as
657: ddp_siyv_rec okl_sif_yields_pub.siyv_rec_type;
658: ddx_siyv_rec okl_sif_yields_pub.siyv_rec_type;
659: ddindx binary_integer; indx binary_integer;
660: begin
661:

Line 658: ddx_siyv_rec okl_sif_yields_pub.siyv_rec_type;

654: )
655:
656: as
657: ddp_siyv_rec okl_sif_yields_pub.siyv_rec_type;
658: ddx_siyv_rec okl_sif_yields_pub.siyv_rec_type;
659: ddindx binary_integer; indx binary_integer;
660: begin
661:
662: -- copy data to the local IN or IN-OUT args, if any

Line 705: okl_sif_yields_pub.update_sif_yields(p_api_version,

701: ddp_siyv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
702:
703:
704: -- here's the delegated call to the old PL/SQL routine
705: okl_sif_yields_pub.update_sif_yields(p_api_version,
706: p_init_msg_list,
707: x_return_status,
708: x_msg_count,
709: x_msg_data,

Line 832: ddp_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;

828: , p6_a33 out nocopy JTF_NUMBER_TABLE
829: )
830:
831: as
832: ddp_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;
833: ddx_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;
834: ddindx binary_integer; indx binary_integer;
835: begin
836:

Line 833: ddx_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;

829: )
830:
831: as
832: ddp_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;
833: ddx_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;
834: ddindx binary_integer; indx binary_integer;
835: begin
836:
837: -- copy data to the local IN or IN-OUT args, if any

Line 881: okl_sif_yields_pub.update_sif_yields(p_api_version,

877: );
878:
879:
880: -- here's the delegated call to the old PL/SQL routine
881: okl_sif_yields_pub.update_sif_yields(p_api_version,
882: p_init_msg_list,
883: x_return_status,
884: x_msg_count,
885: x_msg_data,

Line 1009: ddp_siyv_rec okl_sif_yields_pub.siyv_rec_type;

1005: , p5_a33 NUMBER := 0-1962.0724
1006: )
1007:
1008: as
1009: ddp_siyv_rec okl_sif_yields_pub.siyv_rec_type;
1010: ddx_siyv_rec okl_sif_yields_pub.siyv_rec_type;
1011: ddindx binary_integer; indx binary_integer;
1012: begin
1013:

Line 1010: ddx_siyv_rec okl_sif_yields_pub.siyv_rec_type;

1006: )
1007:
1008: as
1009: ddp_siyv_rec okl_sif_yields_pub.siyv_rec_type;
1010: ddx_siyv_rec okl_sif_yields_pub.siyv_rec_type;
1011: ddindx binary_integer; indx binary_integer;
1012: begin
1013:
1014: -- copy data to the local IN or IN-OUT args, if any

Line 1057: okl_sif_yields_pub.delete_sif_yields(p_api_version,

1053: ddp_siyv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
1054:
1055:
1056: -- here's the delegated call to the old PL/SQL routine
1057: okl_sif_yields_pub.delete_sif_yields(p_api_version,
1058: p_init_msg_list,
1059: x_return_status,
1060: x_msg_count,
1061: x_msg_data,

Line 1184: ddp_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;

1180: , p6_a33 out nocopy JTF_NUMBER_TABLE
1181: )
1182:
1183: as
1184: ddp_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;
1185: ddx_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;
1186: ddindx binary_integer; indx binary_integer;
1187: begin
1188:

Line 1185: ddx_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;

1181: )
1182:
1183: as
1184: ddp_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;
1185: ddx_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;
1186: ddindx binary_integer; indx binary_integer;
1187: begin
1188:
1189: -- copy data to the local IN or IN-OUT args, if any

Line 1233: okl_sif_yields_pub.delete_sif_yields(p_api_version,

1229: );
1230:
1231:
1232: -- here's the delegated call to the old PL/SQL routine
1233: okl_sif_yields_pub.delete_sif_yields(p_api_version,
1234: p_init_msg_list,
1235: x_return_status,
1236: x_msg_count,
1237: x_msg_data,

Line 1361: ddp_siyv_rec okl_sif_yields_pub.siyv_rec_type;

1357: , p5_a33 NUMBER := 0-1962.0724
1358: )
1359:
1360: as
1361: ddp_siyv_rec okl_sif_yields_pub.siyv_rec_type;
1362: ddx_siyv_rec okl_sif_yields_pub.siyv_rec_type;
1363: ddindx binary_integer; indx binary_integer;
1364: begin
1365:

Line 1362: ddx_siyv_rec okl_sif_yields_pub.siyv_rec_type;

1358: )
1359:
1360: as
1361: ddp_siyv_rec okl_sif_yields_pub.siyv_rec_type;
1362: ddx_siyv_rec okl_sif_yields_pub.siyv_rec_type;
1363: ddindx binary_integer; indx binary_integer;
1364: begin
1365:
1366: -- copy data to the local IN or IN-OUT args, if any

Line 1409: okl_sif_yields_pub.validate_sif_yields(p_api_version,

1405: ddp_siyv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
1406:
1407:
1408: -- here's the delegated call to the old PL/SQL routine
1409: okl_sif_yields_pub.validate_sif_yields(p_api_version,
1410: p_init_msg_list,
1411: x_return_status,
1412: x_msg_count,
1413: x_msg_data,

Line 1536: ddp_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;

1532: , p6_a33 out nocopy JTF_NUMBER_TABLE
1533: )
1534:
1535: as
1536: ddp_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;
1537: ddx_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;
1538: ddindx binary_integer; indx binary_integer;
1539: begin
1540:

Line 1537: ddx_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;

1533: )
1534:
1535: as
1536: ddp_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;
1537: ddx_siyv_tbl okl_sif_yields_pub.siyv_tbl_type;
1538: ddindx binary_integer; indx binary_integer;
1539: begin
1540:
1541: -- copy data to the local IN or IN-OUT args, if any

Line 1585: okl_sif_yields_pub.validate_sif_yields(p_api_version,

1581: );
1582:
1583:
1584: -- here's the delegated call to the old PL/SQL routine
1585: okl_sif_yields_pub.validate_sif_yields(p_api_version,
1586: p_init_msg_list,
1587: x_return_status,
1588: x_msg_count,
1589: x_msg_data,

Line 1637: end okl_sif_yields_pub_w;

1633: , p6_a33
1634: );
1635: end;
1636:
1637: end okl_sif_yields_pub_w;