1: package body okl_late_policies_pub_w as
2: /* $Header: OKLULPOB.pls 115.5 2003/11/06 01:33:10 pjgomes 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:
120: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
121: )
122:
123: as
124: ddp_lpov_tbl okl_late_policies_pub.lpov_tbl_type;
125: ddx_lpov_tbl okl_late_policies_pub.lpov_tbl_type;
126: ddindx binary_integer; indx binary_integer;
127: begin
128:
121: )
122:
123: as
124: ddp_lpov_tbl okl_late_policies_pub.lpov_tbl_type;
125: ddx_lpov_tbl okl_late_policies_pub.lpov_tbl_type;
126: ddindx binary_integer; indx binary_integer;
127: begin
128:
129: -- copy data to the local IN or IN-OUT args, if any
182: );
183:
184:
185: -- here's the delegated call to the old PL/SQL routine
186: okl_late_policies_pub.insert_late_policies(p_api_version,
187: p_init_msg_list,
188: x_return_status,
189: x_msg_count,
190: x_msg_data,
349: , p5_a46 VARCHAR2 := okl_api.g_miss_char
350: )
351:
352: as
353: ddp_lpov_rec okl_late_policies_pub.lpov_rec_type;
354: ddx_lpov_rec okl_late_policies_pub.lpov_rec_type;
355: ddindx binary_integer; indx binary_integer;
356: begin
357:
350: )
351:
352: as
353: ddp_lpov_rec okl_late_policies_pub.lpov_rec_type;
354: ddx_lpov_rec okl_late_policies_pub.lpov_rec_type;
355: ddindx binary_integer; indx binary_integer;
356: begin
357:
358: -- copy data to the local IN or IN-OUT args, if any
410: ddp_lpov_rec.days_in_year := p5_a46;
411:
412:
413: -- here's the delegated call to the old PL/SQL routine
414: okl_late_policies_pub.insert_late_policies(p_api_version,
415: p_init_msg_list,
416: x_return_status,
417: x_msg_count,
418: x_msg_data,
529: , p5_a46 JTF_VARCHAR2_TABLE_100
530: )
531:
532: as
533: ddp_lpov_tbl okl_late_policies_pub.lpov_tbl_type;
534: ddindx binary_integer; indx binary_integer;
535: begin
536:
537: -- copy data to the local IN or IN-OUT args, if any
589: , p5_a46
590: );
591:
592: -- here's the delegated call to the old PL/SQL routine
593: okl_late_policies_pub.lock_late_policies(p_api_version,
594: p_init_msg_list,
595: x_return_status,
596: x_msg_count,
597: x_msg_data,
659: , p5_a46 VARCHAR2 := okl_api.g_miss_char
660: )
661:
662: as
663: ddp_lpov_rec okl_late_policies_pub.lpov_rec_type;
664: ddindx binary_integer; indx binary_integer;
665: begin
666:
667: -- copy data to the local IN or IN-OUT args, if any
718: ddp_lpov_rec.last_update_login := rosetta_g_miss_num_map(p5_a45);
719: ddp_lpov_rec.days_in_year := p5_a46;
720:
721: -- here's the delegated call to the old PL/SQL routine
722: okl_late_policies_pub.lock_late_policies(p_api_version,
723: p_init_msg_list,
724: x_return_status,
725: x_msg_count,
726: x_msg_data,
835: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
836: )
837:
838: as
839: ddp_lpov_tbl okl_late_policies_pub.lpov_tbl_type;
840: ddx_lpov_tbl okl_late_policies_pub.lpov_tbl_type;
841: ddindx binary_integer; indx binary_integer;
842: begin
843:
836: )
837:
838: as
839: ddp_lpov_tbl okl_late_policies_pub.lpov_tbl_type;
840: ddx_lpov_tbl okl_late_policies_pub.lpov_tbl_type;
841: ddindx binary_integer; indx binary_integer;
842: begin
843:
844: -- copy data to the local IN or IN-OUT args, if any
897: );
898:
899:
900: -- here's the delegated call to the old PL/SQL routine
901: okl_late_policies_pub.update_late_policies(p_api_version,
902: p_init_msg_list,
903: x_return_status,
904: x_msg_count,
905: x_msg_data,
1064: , p5_a46 VARCHAR2 := okl_api.g_miss_char
1065: )
1066:
1067: as
1068: ddp_lpov_rec okl_late_policies_pub.lpov_rec_type;
1069: ddx_lpov_rec okl_late_policies_pub.lpov_rec_type;
1070: ddindx binary_integer; indx binary_integer;
1071: begin
1072:
1065: )
1066:
1067: as
1068: ddp_lpov_rec okl_late_policies_pub.lpov_rec_type;
1069: ddx_lpov_rec okl_late_policies_pub.lpov_rec_type;
1070: ddindx binary_integer; indx binary_integer;
1071: begin
1072:
1073: -- copy data to the local IN or IN-OUT args, if any
1125: ddp_lpov_rec.days_in_year := p5_a46;
1126:
1127:
1128: -- here's the delegated call to the old PL/SQL routine
1129: okl_late_policies_pub.update_late_policies(p_api_version,
1130: p_init_msg_list,
1131: x_return_status,
1132: x_msg_count,
1133: x_msg_data,
1244: , p5_a46 JTF_VARCHAR2_TABLE_100
1245: )
1246:
1247: as
1248: ddp_lpov_tbl okl_late_policies_pub.lpov_tbl_type;
1249: ddindx binary_integer; indx binary_integer;
1250: begin
1251:
1252: -- copy data to the local IN or IN-OUT args, if any
1304: , p5_a46
1305: );
1306:
1307: -- here's the delegated call to the old PL/SQL routine
1308: okl_late_policies_pub.delete_late_policies(p_api_version,
1309: p_init_msg_list,
1310: x_return_status,
1311: x_msg_count,
1312: x_msg_data,
1374: , p5_a46 VARCHAR2 := okl_api.g_miss_char
1375: )
1376:
1377: as
1378: ddp_lpov_rec okl_late_policies_pub.lpov_rec_type;
1379: ddindx binary_integer; indx binary_integer;
1380: begin
1381:
1382: -- copy data to the local IN or IN-OUT args, if any
1433: ddp_lpov_rec.last_update_login := rosetta_g_miss_num_map(p5_a45);
1434: ddp_lpov_rec.days_in_year := p5_a46;
1435:
1436: -- here's the delegated call to the old PL/SQL routine
1437: okl_late_policies_pub.delete_late_policies(p_api_version,
1438: p_init_msg_list,
1439: x_return_status,
1440: x_msg_count,
1441: x_msg_data,
1503: , p5_a46 JTF_VARCHAR2_TABLE_100
1504: )
1505:
1506: as
1507: ddp_lpov_tbl okl_late_policies_pub.lpov_tbl_type;
1508: ddindx binary_integer; indx binary_integer;
1509: begin
1510:
1511: -- copy data to the local IN or IN-OUT args, if any
1563: , p5_a46
1564: );
1565:
1566: -- here's the delegated call to the old PL/SQL routine
1567: okl_late_policies_pub.validate_late_policies(p_api_version,
1568: p_init_msg_list,
1569: x_return_status,
1570: x_msg_count,
1571: x_msg_data,
1633: , p5_a46 VARCHAR2 := okl_api.g_miss_char
1634: )
1635:
1636: as
1637: ddp_lpov_rec okl_late_policies_pub.lpov_rec_type;
1638: ddindx binary_integer; indx binary_integer;
1639: begin
1640:
1641: -- copy data to the local IN or IN-OUT args, if any
1692: ddp_lpov_rec.last_update_login := rosetta_g_miss_num_map(p5_a45);
1693: ddp_lpov_rec.days_in_year := p5_a46;
1694:
1695: -- here's the delegated call to the old PL/SQL routine
1696: okl_late_policies_pub.validate_late_policies(p_api_version,
1697: p_init_msg_list,
1698: x_return_status,
1699: x_msg_count,
1700: x_msg_data,
1707:
1708:
1709: end;
1710:
1711: end okl_late_policies_pub_w;