DBA Data[Home] [Help]

APPS.OKL_SERVICE_FEES_PUB_W dependencies on OKL_SERVICE_FEES_PUB

Line 1: package body okl_service_fees_pub_w as

1: package body okl_service_fees_pub_w as
2: /* $Header: OKLUSVFB.pls 120.1 2005/07/18 16:00:01 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:

Line 92: ddp_svfv_tbl okl_service_fees_pub.svfv_tbl_type;

88: , p6_a30 out nocopy JTF_NUMBER_TABLE
89: )
90:
91: as
92: ddp_svfv_tbl okl_service_fees_pub.svfv_tbl_type;
93: ddx_svfv_tbl okl_service_fees_pub.svfv_tbl_type;
94: ddindx binary_integer; indx binary_integer;
95: begin
96:

Line 93: ddx_svfv_tbl okl_service_fees_pub.svfv_tbl_type;

89: )
90:
91: as
92: ddp_svfv_tbl okl_service_fees_pub.svfv_tbl_type;
93: ddx_svfv_tbl okl_service_fees_pub.svfv_tbl_type;
94: ddindx binary_integer; indx binary_integer;
95: begin
96:
97: -- copy data to the local IN or IN-OUT args, if any

Line 138: okl_service_fees_pub.insert_service_fees(p_api_version,

134: );
135:
136:
137: -- here's the delegated call to the old PL/SQL routine
138: okl_service_fees_pub.insert_service_fees(p_api_version,
139: p_init_msg_list,
140: x_return_status,
141: x_msg_count,
142: x_msg_data,

Line 257: ddp_svfv_rec okl_service_fees_pub.svfv_rec_type;

253: , p5_a30 NUMBER := 0-1962.0724
254: )
255:
256: as
257: ddp_svfv_rec okl_service_fees_pub.svfv_rec_type;
258: ddx_svfv_rec okl_service_fees_pub.svfv_rec_type;
259: ddindx binary_integer; indx binary_integer;
260: begin
261:

Line 258: ddx_svfv_rec okl_service_fees_pub.svfv_rec_type;

254: )
255:
256: as
257: ddp_svfv_rec okl_service_fees_pub.svfv_rec_type;
258: ddx_svfv_rec okl_service_fees_pub.svfv_rec_type;
259: ddindx binary_integer; indx binary_integer;
260: begin
261:
262: -- copy data to the local IN or IN-OUT args, if any

Line 302: okl_service_fees_pub.insert_service_fees(p_api_version,

298: ddp_svfv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
299:
300:
301: -- here's the delegated call to the old PL/SQL routine
302: okl_service_fees_pub.insert_service_fees(p_api_version,
303: p_init_msg_list,
304: x_return_status,
305: x_msg_count,
306: x_msg_data,

Line 389: ddp_svfv_tbl okl_service_fees_pub.svfv_tbl_type;

385: , p5_a30 JTF_NUMBER_TABLE
386: )
387:
388: as
389: ddp_svfv_tbl okl_service_fees_pub.svfv_tbl_type;
390: ddindx binary_integer; indx binary_integer;
391: begin
392:
393: -- copy data to the local IN or IN-OUT args, if any

Line 433: okl_service_fees_pub.lock_service_fees(p_api_version,

429: , p5_a30
430: );
431:
432: -- here's the delegated call to the old PL/SQL routine
433: okl_service_fees_pub.lock_service_fees(p_api_version,
434: p_init_msg_list,
435: x_return_status,
436: x_msg_count,
437: x_msg_data,

Line 487: ddp_svfv_rec okl_service_fees_pub.svfv_rec_type;

483: , p5_a30 NUMBER := 0-1962.0724
484: )
485:
486: as
487: ddp_svfv_rec okl_service_fees_pub.svfv_rec_type;
488: ddindx binary_integer; indx binary_integer;
489: begin
490:
491: -- copy data to the local IN or IN-OUT args, if any

Line 530: okl_service_fees_pub.lock_service_fees(p_api_version,

526: ddp_svfv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a29);
527: ddp_svfv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
528:
529: -- here's the delegated call to the old PL/SQL routine
530: okl_service_fees_pub.lock_service_fees(p_api_version,
531: p_init_msg_list,
532: x_return_status,
533: x_msg_count,
534: x_msg_data,

Line 615: ddp_svfv_tbl okl_service_fees_pub.svfv_tbl_type;

611: , p6_a30 out nocopy JTF_NUMBER_TABLE
612: )
613:
614: as
615: ddp_svfv_tbl okl_service_fees_pub.svfv_tbl_type;
616: ddx_svfv_tbl okl_service_fees_pub.svfv_tbl_type;
617: ddindx binary_integer; indx binary_integer;
618: begin
619:

Line 616: ddx_svfv_tbl okl_service_fees_pub.svfv_tbl_type;

612: )
613:
614: as
615: ddp_svfv_tbl okl_service_fees_pub.svfv_tbl_type;
616: ddx_svfv_tbl okl_service_fees_pub.svfv_tbl_type;
617: ddindx binary_integer; indx binary_integer;
618: begin
619:
620: -- copy data to the local IN or IN-OUT args, if any

Line 661: okl_service_fees_pub.update_service_fees(p_api_version,

657: );
658:
659:
660: -- here's the delegated call to the old PL/SQL routine
661: okl_service_fees_pub.update_service_fees(p_api_version,
662: p_init_msg_list,
663: x_return_status,
664: x_msg_count,
665: x_msg_data,

Line 780: ddp_svfv_rec okl_service_fees_pub.svfv_rec_type;

776: , p5_a30 NUMBER := 0-1962.0724
777: )
778:
779: as
780: ddp_svfv_rec okl_service_fees_pub.svfv_rec_type;
781: ddx_svfv_rec okl_service_fees_pub.svfv_rec_type;
782: ddindx binary_integer; indx binary_integer;
783: begin
784:

Line 781: ddx_svfv_rec okl_service_fees_pub.svfv_rec_type;

777: )
778:
779: as
780: ddp_svfv_rec okl_service_fees_pub.svfv_rec_type;
781: ddx_svfv_rec okl_service_fees_pub.svfv_rec_type;
782: ddindx binary_integer; indx binary_integer;
783: begin
784:
785: -- copy data to the local IN or IN-OUT args, if any

Line 825: okl_service_fees_pub.update_service_fees(p_api_version,

821: ddp_svfv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
822:
823:
824: -- here's the delegated call to the old PL/SQL routine
825: okl_service_fees_pub.update_service_fees(p_api_version,
826: p_init_msg_list,
827: x_return_status,
828: x_msg_count,
829: x_msg_data,

Line 912: ddp_svfv_tbl okl_service_fees_pub.svfv_tbl_type;

908: , p5_a30 JTF_NUMBER_TABLE
909: )
910:
911: as
912: ddp_svfv_tbl okl_service_fees_pub.svfv_tbl_type;
913: ddindx binary_integer; indx binary_integer;
914: begin
915:
916: -- copy data to the local IN or IN-OUT args, if any

Line 956: okl_service_fees_pub.delete_service_fees(p_api_version,

952: , p5_a30
953: );
954:
955: -- here's the delegated call to the old PL/SQL routine
956: okl_service_fees_pub.delete_service_fees(p_api_version,
957: p_init_msg_list,
958: x_return_status,
959: x_msg_count,
960: x_msg_data,

Line 1010: ddp_svfv_rec okl_service_fees_pub.svfv_rec_type;

1006: , p5_a30 NUMBER := 0-1962.0724
1007: )
1008:
1009: as
1010: ddp_svfv_rec okl_service_fees_pub.svfv_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 1053: okl_service_fees_pub.delete_service_fees(p_api_version,

1049: ddp_svfv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a29);
1050: ddp_svfv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
1051:
1052: -- here's the delegated call to the old PL/SQL routine
1053: okl_service_fees_pub.delete_service_fees(p_api_version,
1054: p_init_msg_list,
1055: x_return_status,
1056: x_msg_count,
1057: x_msg_data,

Line 1107: ddp_svfv_tbl okl_service_fees_pub.svfv_tbl_type;

1103: , p5_a30 JTF_NUMBER_TABLE
1104: )
1105:
1106: as
1107: ddp_svfv_tbl okl_service_fees_pub.svfv_tbl_type;
1108: ddindx binary_integer; indx binary_integer;
1109: begin
1110:
1111: -- copy data to the local IN or IN-OUT args, if any

Line 1151: okl_service_fees_pub.validate_service_fees(p_api_version,

1147: , p5_a30
1148: );
1149:
1150: -- here's the delegated call to the old PL/SQL routine
1151: okl_service_fees_pub.validate_service_fees(p_api_version,
1152: p_init_msg_list,
1153: x_return_status,
1154: x_msg_count,
1155: x_msg_data,

Line 1205: ddp_svfv_rec okl_service_fees_pub.svfv_rec_type;

1201: , p5_a30 NUMBER := 0-1962.0724
1202: )
1203:
1204: as
1205: ddp_svfv_rec okl_service_fees_pub.svfv_rec_type;
1206: ddindx binary_integer; indx binary_integer;
1207: begin
1208:
1209: -- copy data to the local IN or IN-OUT args, if any

Line 1248: okl_service_fees_pub.validate_service_fees(p_api_version,

1244: ddp_svfv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a29);
1245: ddp_svfv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
1246:
1247: -- here's the delegated call to the old PL/SQL routine
1248: okl_service_fees_pub.validate_service_fees(p_api_version,
1249: p_init_msg_list,
1250: x_return_status,
1251: x_msg_count,
1252: x_msg_data,

Line 1263: end okl_service_fees_pub_w;

1259:
1260:
1261: end;
1262:
1263: end okl_service_fees_pub_w;