APPS.OKL_INS_RATES_PUB_W dependencies on OKL_INS_RATES_PUB

Line 1: package body okl_ins_rates_pub_w as

1: package body okl_ins_rates_pub_w as
2: /* $Header: OKLOINRB.pls 120.1 2005/07/14 12:01:00 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_inrv_tbl okl_ins_rates_pub.inrv_tbl_type;

94: , p6_a33 out nocopy JTF_NUMBER_TABLE
95: )
96:
97: as
98: ddp_inrv_tbl okl_ins_rates_pub.inrv_tbl_type;
99: ddx_inrv_tbl okl_ins_rates_pub.inrv_tbl_type;
100: ddindx binary_integer; indx binary_integer;
101: begin
102:

Line 99: ddx_inrv_tbl okl_ins_rates_pub.inrv_tbl_type;

95: )
96:
97: as
98: ddp_inrv_tbl okl_ins_rates_pub.inrv_tbl_type;
99: ddx_inrv_tbl okl_ins_rates_pub.inrv_tbl_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 147: okl_ins_rates_pub.insert_ins_rates(p_api_version,

143: );
144:
145:
146: -- here's the delegated call to the old PL/SQL routine
147: okl_ins_rates_pub.insert_ins_rates(p_api_version,
148: p_init_msg_list,
149: x_return_status,
150: x_msg_count,
151: x_msg_data,

Line 275: ddp_inrv_rec okl_ins_rates_pub.inrv_rec_type;

271: , p5_a33 NUMBER := 0-1962.0724
272: )
273:
274: as
275: ddp_inrv_rec okl_ins_rates_pub.inrv_rec_type;
276: ddx_inrv_rec okl_ins_rates_pub.inrv_rec_type;
277: ddindx binary_integer; indx binary_integer;
278: begin
279:

Line 276: ddx_inrv_rec okl_ins_rates_pub.inrv_rec_type;

272: )
273:
274: as
275: ddp_inrv_rec okl_ins_rates_pub.inrv_rec_type;
276: ddx_inrv_rec okl_ins_rates_pub.inrv_rec_type;
277: ddindx binary_integer; indx binary_integer;
278: begin
279:
280: -- copy data to the local IN or IN-OUT args, if any

Line 323: okl_ins_rates_pub.insert_ins_rates(p_api_version,

319: ddp_inrv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
320:
321:
322: -- here's the delegated call to the old PL/SQL routine
323: okl_ins_rates_pub.insert_ins_rates(p_api_version,
324: p_init_msg_list,
325: x_return_status,
326: x_msg_count,
327: x_msg_data,

Line 416: ddp_inrv_tbl okl_ins_rates_pub.inrv_tbl_type;

412: , p5_a33 JTF_NUMBER_TABLE
413: )
414:
415: as
416: ddp_inrv_tbl okl_ins_rates_pub.inrv_tbl_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 463: okl_ins_rates_pub.lock_ins_rates(p_api_version,

459: , p5_a33
460: );
461:
462: -- here's the delegated call to the old PL/SQL routine
463: okl_ins_rates_pub.lock_ins_rates(p_api_version,
464: p_init_msg_list,
465: x_return_status,
466: x_msg_count,
467: x_msg_data,

Line 520: ddp_inrv_rec okl_ins_rates_pub.inrv_rec_type;

516: , p5_a33 NUMBER := 0-1962.0724
517: )
518:
519: as
520: ddp_inrv_rec okl_ins_rates_pub.inrv_rec_type;
521: ddindx binary_integer; indx binary_integer;
522: begin
523:
524: -- copy data to the local IN or IN-OUT args, if any

Line 566: okl_ins_rates_pub.lock_ins_rates(p_api_version,

562: ddp_inrv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a32);
563: ddp_inrv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
564:
565: -- here's the delegated call to the old PL/SQL routine
566: okl_ins_rates_pub.lock_ins_rates(p_api_version,
567: p_init_msg_list,
568: x_return_status,
569: x_msg_count,
570: x_msg_data,

Line 657: ddp_inrv_tbl okl_ins_rates_pub.inrv_tbl_type;

653: , p6_a33 out nocopy JTF_NUMBER_TABLE
654: )
655:
656: as
657: ddp_inrv_tbl okl_ins_rates_pub.inrv_tbl_type;
658: ddx_inrv_tbl okl_ins_rates_pub.inrv_tbl_type;
659: ddindx binary_integer; indx binary_integer;
660: begin
661:

Line 658: ddx_inrv_tbl okl_ins_rates_pub.inrv_tbl_type;

654: )
655:
656: as
657: ddp_inrv_tbl okl_ins_rates_pub.inrv_tbl_type;
658: ddx_inrv_tbl okl_ins_rates_pub.inrv_tbl_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 706: okl_ins_rates_pub.update_ins_rates(p_api_version,

702: );
703:
704:
705: -- here's the delegated call to the old PL/SQL routine
706: okl_ins_rates_pub.update_ins_rates(p_api_version,
707: p_init_msg_list,
708: x_return_status,
709: x_msg_count,
710: x_msg_data,

Line 834: ddp_inrv_rec okl_ins_rates_pub.inrv_rec_type;

830: , p5_a33 NUMBER := 0-1962.0724
831: )
832:
833: as
834: ddp_inrv_rec okl_ins_rates_pub.inrv_rec_type;
835: ddx_inrv_rec okl_ins_rates_pub.inrv_rec_type;
836: ddindx binary_integer; indx binary_integer;
837: begin
838:

Line 835: ddx_inrv_rec okl_ins_rates_pub.inrv_rec_type;

831: )
832:
833: as
834: ddp_inrv_rec okl_ins_rates_pub.inrv_rec_type;
835: ddx_inrv_rec okl_ins_rates_pub.inrv_rec_type;
836: ddindx binary_integer; indx binary_integer;
837: begin
838:
839: -- copy data to the local IN or IN-OUT args, if any

Line 882: okl_ins_rates_pub.update_ins_rates(p_api_version,

878: ddp_inrv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
879:
880:
881: -- here's the delegated call to the old PL/SQL routine
882: okl_ins_rates_pub.update_ins_rates(p_api_version,
883: p_init_msg_list,
884: x_return_status,
885: x_msg_count,
886: x_msg_data,

Line 975: ddp_inrv_tbl okl_ins_rates_pub.inrv_tbl_type;

971: , p5_a33 JTF_NUMBER_TABLE
972: )
973:
974: as
975: ddp_inrv_tbl okl_ins_rates_pub.inrv_tbl_type;
976: ddindx binary_integer; indx binary_integer;
977: begin
978:
979: -- copy data to the local IN or IN-OUT args, if any

Line 1022: okl_ins_rates_pub.delete_ins_rates(p_api_version,

1018: , p5_a33
1019: );
1020:
1021: -- here's the delegated call to the old PL/SQL routine
1022: okl_ins_rates_pub.delete_ins_rates(p_api_version,
1023: p_init_msg_list,
1024: x_return_status,
1025: x_msg_count,
1026: x_msg_data,

Line 1079: ddp_inrv_rec okl_ins_rates_pub.inrv_rec_type;

1075: , p5_a33 NUMBER := 0-1962.0724
1076: )
1077:
1078: as
1079: ddp_inrv_rec okl_ins_rates_pub.inrv_rec_type;
1080: ddindx binary_integer; indx binary_integer;
1081: begin
1082:
1083: -- copy data to the local IN or IN-OUT args, if any

Line 1125: okl_ins_rates_pub.delete_ins_rates(p_api_version,

1121: ddp_inrv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a32);
1122: ddp_inrv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
1123:
1124: -- here's the delegated call to the old PL/SQL routine
1125: okl_ins_rates_pub.delete_ins_rates(p_api_version,
1126: p_init_msg_list,
1127: x_return_status,
1128: x_msg_count,
1129: x_msg_data,

Line 1182: ddp_inrv_tbl okl_ins_rates_pub.inrv_tbl_type;

1178: , p5_a33 JTF_NUMBER_TABLE
1179: )
1180:
1181: as
1182: ddp_inrv_tbl okl_ins_rates_pub.inrv_tbl_type;
1183: ddindx binary_integer; indx binary_integer;
1184: begin
1185:
1186: -- copy data to the local IN or IN-OUT args, if any

Line 1229: okl_ins_rates_pub.validate_ins_rates(p_api_version,

1225: , p5_a33
1226: );
1227:
1228: -- here's the delegated call to the old PL/SQL routine
1229: okl_ins_rates_pub.validate_ins_rates(p_api_version,
1230: p_init_msg_list,
1231: x_return_status,
1232: x_msg_count,
1233: x_msg_data,

Line 1286: ddp_inrv_rec okl_ins_rates_pub.inrv_rec_type;

1282: , p5_a33 NUMBER := 0-1962.0724
1283: )
1284:
1285: as
1286: ddp_inrv_rec okl_ins_rates_pub.inrv_rec_type;
1287: ddindx binary_integer; indx binary_integer;
1288: begin
1289:
1290: -- copy data to the local IN or IN-OUT args, if any

Line 1332: okl_ins_rates_pub.validate_ins_rates(p_api_version,

1328: ddp_inrv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a32);
1329: ddp_inrv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
1330:
1331: -- here's the delegated call to the old PL/SQL routine
1332: okl_ins_rates_pub.validate_ins_rates(p_api_version,
1333: p_init_msg_list,
1334: x_return_status,
1335: x_msg_count,
1336: x_msg_data,

Line 1347: end okl_ins_rates_pub_w;

1343:
1344:
1345: end;
1346:
1347: end okl_ins_rates_pub_w;