1: package body okl_sif_ret_errors_pub_w as
2: /* $Header: OKLUSRMB.pls 120.1 2005/07/19 09:44:07 viselvar 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:
84: , p5_a28 NUMBER := 0-1962.0724
85: )
86:
87: as
88: ddp_srmv_rec okl_sif_ret_errors_pub.srmv_rec_type;
89: ddx_srmv_rec okl_sif_ret_errors_pub.srmv_rec_type;
90: ddindx binary_integer; indx binary_integer;
91: begin
92:
85: )
86:
87: as
88: ddp_srmv_rec okl_sif_ret_errors_pub.srmv_rec_type;
89: ddx_srmv_rec okl_sif_ret_errors_pub.srmv_rec_type;
90: ddindx binary_integer; indx binary_integer;
91: begin
92:
93: -- copy data to the local IN or IN-OUT args, if any
127: ddp_srmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a28);
128:
129:
130: -- here's the delegated call to the old PL/SQL routine
131: okl_sif_ret_errors_pub.insert_sif_ret_errors(p_api_version,
132: p_init_msg_list,
133: x_return_status,
134: x_msg_count,
135: x_msg_data,
239: , p6_a28 out nocopy JTF_NUMBER_TABLE
240: )
241:
242: as
243: ddp_srmv_tbl okl_sif_ret_errors_pub.srmv_tbl_type;
244: ddx_srmv_tbl okl_sif_ret_errors_pub.srmv_tbl_type;
245: ddindx binary_integer; indx binary_integer;
246: begin
247:
240: )
241:
242: as
243: ddp_srmv_tbl okl_sif_ret_errors_pub.srmv_tbl_type;
244: ddx_srmv_tbl okl_sif_ret_errors_pub.srmv_tbl_type;
245: ddindx binary_integer; indx binary_integer;
246: begin
247:
248: -- copy data to the local IN or IN-OUT args, if any
283: );
284:
285:
286: -- here's the delegated call to the old PL/SQL routine
287: okl_sif_ret_errors_pub.insert_sif_ret_errors(p_api_version,
288: p_init_msg_list,
289: x_return_status,
290: x_msg_count,
291: x_msg_data,
367: , p5_a28 NUMBER := 0-1962.0724
368: )
369:
370: as
371: ddp_srmv_rec okl_sif_ret_errors_pub.srmv_rec_type;
372: ddindx binary_integer; indx binary_integer;
373: begin
374:
375: -- copy data to the local IN or IN-OUT args, if any
408: ddp_srmv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a27);
409: ddp_srmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a28);
410:
411: -- here's the delegated call to the old PL/SQL routine
412: okl_sif_ret_errors_pub.lock_sif_ret_errors(p_api_version,
413: p_init_msg_list,
414: x_return_status,
415: x_msg_count,
416: x_msg_data,
460: , p5_a28 JTF_NUMBER_TABLE
461: )
462:
463: as
464: ddp_srmv_tbl okl_sif_ret_errors_pub.srmv_tbl_type;
465: ddindx binary_integer; indx binary_integer;
466: begin
467:
468: -- copy data to the local IN or IN-OUT args, if any
502: , p5_a28
503: );
504:
505: -- here's the delegated call to the old PL/SQL routine
506: okl_sif_ret_errors_pub.lock_sif_ret_errors(p_api_version,
507: p_init_msg_list,
508: x_return_status,
509: x_msg_count,
510: x_msg_data,
583: , p5_a28 NUMBER := 0-1962.0724
584: )
585:
586: as
587: ddp_srmv_rec okl_sif_ret_errors_pub.srmv_rec_type;
588: ddx_srmv_rec okl_sif_ret_errors_pub.srmv_rec_type;
589: ddindx binary_integer; indx binary_integer;
590: begin
591:
584: )
585:
586: as
587: ddp_srmv_rec okl_sif_ret_errors_pub.srmv_rec_type;
588: ddx_srmv_rec okl_sif_ret_errors_pub.srmv_rec_type;
589: ddindx binary_integer; indx binary_integer;
590: begin
591:
592: -- copy data to the local IN or IN-OUT args, if any
626: ddp_srmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a28);
627:
628:
629: -- here's the delegated call to the old PL/SQL routine
630: okl_sif_ret_errors_pub.update_sif_ret_errors(p_api_version,
631: p_init_msg_list,
632: x_return_status,
633: x_msg_count,
634: x_msg_data,
738: , p6_a28 out nocopy JTF_NUMBER_TABLE
739: )
740:
741: as
742: ddp_srmv_tbl okl_sif_ret_errors_pub.srmv_tbl_type;
743: ddx_srmv_tbl okl_sif_ret_errors_pub.srmv_tbl_type;
744: ddindx binary_integer; indx binary_integer;
745: begin
746:
739: )
740:
741: as
742: ddp_srmv_tbl okl_sif_ret_errors_pub.srmv_tbl_type;
743: ddx_srmv_tbl okl_sif_ret_errors_pub.srmv_tbl_type;
744: ddindx binary_integer; indx binary_integer;
745: begin
746:
747: -- copy data to the local IN or IN-OUT args, if any
782: );
783:
784:
785: -- here's the delegated call to the old PL/SQL routine
786: okl_sif_ret_errors_pub.update_sif_ret_errors(p_api_version,
787: p_init_msg_list,
788: x_return_status,
789: x_msg_count,
790: x_msg_data,
895: , p5_a28 NUMBER := 0-1962.0724
896: )
897:
898: as
899: ddp_srmv_rec okl_sif_ret_errors_pub.srmv_rec_type;
900: ddx_srmv_rec okl_sif_ret_errors_pub.srmv_rec_type;
901: ddindx binary_integer; indx binary_integer;
902: begin
903:
896: )
897:
898: as
899: ddp_srmv_rec okl_sif_ret_errors_pub.srmv_rec_type;
900: ddx_srmv_rec okl_sif_ret_errors_pub.srmv_rec_type;
901: ddindx binary_integer; indx binary_integer;
902: begin
903:
904: -- copy data to the local IN or IN-OUT args, if any
938: ddp_srmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a28);
939:
940:
941: -- here's the delegated call to the old PL/SQL routine
942: okl_sif_ret_errors_pub.delete_sif_ret_errors(p_api_version,
943: p_init_msg_list,
944: x_return_status,
945: x_msg_count,
946: x_msg_data,
1050: , p6_a28 out nocopy JTF_NUMBER_TABLE
1051: )
1052:
1053: as
1054: ddp_srmv_tbl okl_sif_ret_errors_pub.srmv_tbl_type;
1055: ddx_srmv_tbl okl_sif_ret_errors_pub.srmv_tbl_type;
1056: ddindx binary_integer; indx binary_integer;
1057: begin
1058:
1051: )
1052:
1053: as
1054: ddp_srmv_tbl okl_sif_ret_errors_pub.srmv_tbl_type;
1055: ddx_srmv_tbl okl_sif_ret_errors_pub.srmv_tbl_type;
1056: ddindx binary_integer; indx binary_integer;
1057: begin
1058:
1059: -- copy data to the local IN or IN-OUT args, if any
1094: );
1095:
1096:
1097: -- here's the delegated call to the old PL/SQL routine
1098: okl_sif_ret_errors_pub.delete_sif_ret_errors(p_api_version,
1099: p_init_msg_list,
1100: x_return_status,
1101: x_msg_count,
1102: x_msg_data,
1207: , p5_a28 NUMBER := 0-1962.0724
1208: )
1209:
1210: as
1211: ddp_srmv_rec okl_sif_ret_errors_pub.srmv_rec_type;
1212: ddx_srmv_rec okl_sif_ret_errors_pub.srmv_rec_type;
1213: ddindx binary_integer; indx binary_integer;
1214: begin
1215:
1208: )
1209:
1210: as
1211: ddp_srmv_rec okl_sif_ret_errors_pub.srmv_rec_type;
1212: ddx_srmv_rec okl_sif_ret_errors_pub.srmv_rec_type;
1213: ddindx binary_integer; indx binary_integer;
1214: begin
1215:
1216: -- copy data to the local IN or IN-OUT args, if any
1250: ddp_srmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a28);
1251:
1252:
1253: -- here's the delegated call to the old PL/SQL routine
1254: okl_sif_ret_errors_pub.validate_sif_ret_errors(p_api_version,
1255: p_init_msg_list,
1256: x_return_status,
1257: x_msg_count,
1258: x_msg_data,
1362: , p6_a28 out nocopy JTF_NUMBER_TABLE
1363: )
1364:
1365: as
1366: ddp_srmv_tbl okl_sif_ret_errors_pub.srmv_tbl_type;
1367: ddx_srmv_tbl okl_sif_ret_errors_pub.srmv_tbl_type;
1368: ddindx binary_integer; indx binary_integer;
1369: begin
1370:
1363: )
1364:
1365: as
1366: ddp_srmv_tbl okl_sif_ret_errors_pub.srmv_tbl_type;
1367: ddx_srmv_tbl okl_sif_ret_errors_pub.srmv_tbl_type;
1368: ddindx binary_integer; indx binary_integer;
1369: begin
1370:
1371: -- copy data to the local IN or IN-OUT args, if any
1406: );
1407:
1408:
1409: -- here's the delegated call to the old PL/SQL routine
1410: okl_sif_ret_errors_pub.validate_sif_ret_errors(p_api_version,
1411: p_init_msg_list,
1412: x_return_status,
1413: x_msg_count,
1414: x_msg_data,
1453: , p6_a28
1454: );
1455: end;
1456:
1457: end okl_sif_ret_errors_pub_w;