DBA Data[Home] [Help]

APPS.OKL_RPC_PVT_W dependencies on OKL_RPC_PVT

Line 1: package body okl_rpc_pvt_w as

1: package body okl_rpc_pvt_w as
2: /* $Header: OKLIRPCB.pls 115.3 2002/12/19 23:27:51 gkadarka 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 22: procedure rosetta_table_copy_in_p2(t out nocopy okl_rpc_pvt.okl_repair_costs_tl_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_rpc_pvt.okl_repair_costs_tl_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_300

Line 61: procedure rosetta_table_copy_out_p2(t okl_rpc_pvt.okl_repair_costs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

57: end loop;
58: end if;
59: end if;
60: end rosetta_table_copy_in_p2;
61: procedure rosetta_table_copy_out_p2(t okl_rpc_pvt.okl_repair_costs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_VARCHAR2_TABLE_100
63: , a2 out nocopy JTF_VARCHAR2_TABLE_100
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 135: procedure rosetta_table_copy_in_p5(t out nocopy okl_rpc_pvt.rpc_tbl_type, a0 JTF_NUMBER_TABLE

131: end if;
132: end if;
133: end rosetta_table_copy_out_p2;
134:
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_rpc_pvt.rpc_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_NUMBER_TABLE
137: , a2 JTF_VARCHAR2_TABLE_100
138: , a3 JTF_NUMBER_TABLE
139: , a4 JTF_NUMBER_TABLE

Line 182: procedure rosetta_table_copy_out_p5(t okl_rpc_pvt.rpc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

178: end loop;
179: end if;
180: end if;
181: end rosetta_table_copy_in_p5;
182: procedure rosetta_table_copy_out_p5(t okl_rpc_pvt.rpc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
183: , a1 out nocopy JTF_NUMBER_TABLE
184: , a2 out nocopy JTF_VARCHAR2_TABLE_100
185: , a3 out nocopy JTF_NUMBER_TABLE
186: , a4 out nocopy JTF_NUMBER_TABLE

Line 276: procedure rosetta_table_copy_in_p8(t out nocopy okl_rpc_pvt.rpcv_tbl_type, a0 JTF_NUMBER_TABLE

272: end if;
273: end if;
274: end rosetta_table_copy_out_p5;
275:
276: procedure rosetta_table_copy_in_p8(t out nocopy okl_rpc_pvt.rpcv_tbl_type, a0 JTF_NUMBER_TABLE
277: , a1 JTF_NUMBER_TABLE
278: , a2 JTF_VARCHAR2_TABLE_100
279: , a3 JTF_VARCHAR2_TABLE_100
280: , a4 JTF_NUMBER_TABLE

Line 329: procedure rosetta_table_copy_out_p8(t okl_rpc_pvt.rpcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

325: end loop;
326: end if;
327: end if;
328: end rosetta_table_copy_in_p8;
329: procedure rosetta_table_copy_out_p8(t okl_rpc_pvt.rpcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
330: , a1 out nocopy JTF_NUMBER_TABLE
331: , a2 out nocopy JTF_VARCHAR2_TABLE_100
332: , a3 out nocopy JTF_VARCHAR2_TABLE_100
333: , a4 out nocopy JTF_NUMBER_TABLE

Line 482: ddp_rpcv_rec okl_rpc_pvt.rpcv_rec_type;

478: , p5_a17 DATE := fnd_api.g_miss_date
479: )
480:
481: as
482: ddp_rpcv_rec okl_rpc_pvt.rpcv_rec_type;
483: ddx_rpcv_rec okl_rpc_pvt.rpcv_rec_type;
484: ddindx binary_integer; indx binary_integer;
485: begin
486:

Line 483: ddx_rpcv_rec okl_rpc_pvt.rpcv_rec_type;

479: )
480:
481: as
482: ddp_rpcv_rec okl_rpc_pvt.rpcv_rec_type;
483: ddx_rpcv_rec okl_rpc_pvt.rpcv_rec_type;
484: ddindx binary_integer; indx binary_integer;
485: begin
486:
487: -- copy data to the local IN or IN-OUT args, if any

Line 514: okl_rpc_pvt.insert_row(p_api_version,

510: ddp_rpcv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a17);
511:
512:
513: -- here's the delegated call to the old PL/SQL routine
514: okl_rpc_pvt.insert_row(p_api_version,
515: p_init_msg_list,
516: x_return_status,
517: x_msg_count,
518: x_msg_data,

Line 593: ddp_rpcv_tbl okl_rpc_pvt.rpcv_tbl_type;

589: , p6_a17 out nocopy JTF_DATE_TABLE
590: )
591:
592: as
593: ddp_rpcv_tbl okl_rpc_pvt.rpcv_tbl_type;
594: ddx_rpcv_tbl okl_rpc_pvt.rpcv_tbl_type;
595: ddindx binary_integer; indx binary_integer;
596: begin
597:

Line 594: ddx_rpcv_tbl okl_rpc_pvt.rpcv_tbl_type;

590: )
591:
592: as
593: ddp_rpcv_tbl okl_rpc_pvt.rpcv_tbl_type;
594: ddx_rpcv_tbl okl_rpc_pvt.rpcv_tbl_type;
595: ddindx binary_integer; indx binary_integer;
596: begin
597:
598: -- copy data to the local IN or IN-OUT args, if any

Line 604: okl_rpc_pvt_w.rosetta_table_copy_in_p8(ddp_rpcv_tbl, p5_a0

600:
601:
602:
603:
604: okl_rpc_pvt_w.rosetta_table_copy_in_p8(ddp_rpcv_tbl, p5_a0
605: , p5_a1
606: , p5_a2
607: , p5_a3
608: , p5_a4

Line 626: okl_rpc_pvt.insert_row(p_api_version,

622: );
623:
624:
625: -- here's the delegated call to the old PL/SQL routine
626: okl_rpc_pvt.insert_row(p_api_version,
627: p_init_msg_list,
628: x_return_status,
629: x_msg_count,
630: x_msg_data,

Line 641: okl_rpc_pvt_w.rosetta_table_copy_out_p8(ddx_rpcv_tbl, p6_a0

637:
638:
639:
640:
641: okl_rpc_pvt_w.rosetta_table_copy_out_p8(ddx_rpcv_tbl, p6_a0
642: , p6_a1
643: , p6_a2
644: , p6_a3
645: , p6_a4

Line 688: ddp_rpcv_rec okl_rpc_pvt.rpcv_rec_type;

684: , p5_a17 DATE := fnd_api.g_miss_date
685: )
686:
687: as
688: ddp_rpcv_rec okl_rpc_pvt.rpcv_rec_type;
689: ddindx binary_integer; indx binary_integer;
690: begin
691:
692: -- copy data to the local IN or IN-OUT args, if any

Line 718: okl_rpc_pvt.lock_row(p_api_version,

714: ddp_rpcv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a16);
715: ddp_rpcv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a17);
716:
717: -- here's the delegated call to the old PL/SQL routine
718: okl_rpc_pvt.lock_row(p_api_version,
719: p_init_msg_list,
720: x_return_status,
721: x_msg_count,
722: x_msg_data,

Line 759: ddp_rpcv_tbl okl_rpc_pvt.rpcv_tbl_type;

755: , p5_a17 JTF_DATE_TABLE
756: )
757:
758: as
759: ddp_rpcv_tbl okl_rpc_pvt.rpcv_tbl_type;
760: ddindx binary_integer; indx binary_integer;
761: begin
762:
763: -- copy data to the local IN or IN-OUT args, if any

Line 769: okl_rpc_pvt_w.rosetta_table_copy_in_p8(ddp_rpcv_tbl, p5_a0

765:
766:
767:
768:
769: okl_rpc_pvt_w.rosetta_table_copy_in_p8(ddp_rpcv_tbl, p5_a0
770: , p5_a1
771: , p5_a2
772: , p5_a3
773: , p5_a4

Line 790: okl_rpc_pvt.lock_row(p_api_version,

786: , p5_a17
787: );
788:
789: -- here's the delegated call to the old PL/SQL routine
790: okl_rpc_pvt.lock_row(p_api_version,
791: p_init_msg_list,
792: x_return_status,
793: x_msg_count,
794: x_msg_data,

Line 849: ddp_rpcv_rec okl_rpc_pvt.rpcv_rec_type;

845: , p5_a17 DATE := fnd_api.g_miss_date
846: )
847:
848: as
849: ddp_rpcv_rec okl_rpc_pvt.rpcv_rec_type;
850: ddx_rpcv_rec okl_rpc_pvt.rpcv_rec_type;
851: ddindx binary_integer; indx binary_integer;
852: begin
853:

Line 850: ddx_rpcv_rec okl_rpc_pvt.rpcv_rec_type;

846: )
847:
848: as
849: ddp_rpcv_rec okl_rpc_pvt.rpcv_rec_type;
850: ddx_rpcv_rec okl_rpc_pvt.rpcv_rec_type;
851: ddindx binary_integer; indx binary_integer;
852: begin
853:
854: -- copy data to the local IN or IN-OUT args, if any

Line 881: okl_rpc_pvt.update_row(p_api_version,

877: ddp_rpcv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a17);
878:
879:
880: -- here's the delegated call to the old PL/SQL routine
881: okl_rpc_pvt.update_row(p_api_version,
882: p_init_msg_list,
883: x_return_status,
884: x_msg_count,
885: x_msg_data,

Line 960: ddp_rpcv_tbl okl_rpc_pvt.rpcv_tbl_type;

956: , p6_a17 out nocopy JTF_DATE_TABLE
957: )
958:
959: as
960: ddp_rpcv_tbl okl_rpc_pvt.rpcv_tbl_type;
961: ddx_rpcv_tbl okl_rpc_pvt.rpcv_tbl_type;
962: ddindx binary_integer; indx binary_integer;
963: begin
964:

Line 961: ddx_rpcv_tbl okl_rpc_pvt.rpcv_tbl_type;

957: )
958:
959: as
960: ddp_rpcv_tbl okl_rpc_pvt.rpcv_tbl_type;
961: ddx_rpcv_tbl okl_rpc_pvt.rpcv_tbl_type;
962: ddindx binary_integer; indx binary_integer;
963: begin
964:
965: -- copy data to the local IN or IN-OUT args, if any

Line 971: okl_rpc_pvt_w.rosetta_table_copy_in_p8(ddp_rpcv_tbl, p5_a0

967:
968:
969:
970:
971: okl_rpc_pvt_w.rosetta_table_copy_in_p8(ddp_rpcv_tbl, p5_a0
972: , p5_a1
973: , p5_a2
974: , p5_a3
975: , p5_a4

Line 993: okl_rpc_pvt.update_row(p_api_version,

989: );
990:
991:
992: -- here's the delegated call to the old PL/SQL routine
993: okl_rpc_pvt.update_row(p_api_version,
994: p_init_msg_list,
995: x_return_status,
996: x_msg_count,
997: x_msg_data,

Line 1008: okl_rpc_pvt_w.rosetta_table_copy_out_p8(ddx_rpcv_tbl, p6_a0

1004:
1005:
1006:
1007:
1008: okl_rpc_pvt_w.rosetta_table_copy_out_p8(ddx_rpcv_tbl, p6_a0
1009: , p6_a1
1010: , p6_a2
1011: , p6_a3
1012: , p6_a4

Line 1055: ddp_rpcv_rec okl_rpc_pvt.rpcv_rec_type;

1051: , p5_a17 DATE := fnd_api.g_miss_date
1052: )
1053:
1054: as
1055: ddp_rpcv_rec okl_rpc_pvt.rpcv_rec_type;
1056: ddindx binary_integer; indx binary_integer;
1057: begin
1058:
1059: -- copy data to the local IN or IN-OUT args, if any

Line 1085: okl_rpc_pvt.delete_row(p_api_version,

1081: ddp_rpcv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a16);
1082: ddp_rpcv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a17);
1083:
1084: -- here's the delegated call to the old PL/SQL routine
1085: okl_rpc_pvt.delete_row(p_api_version,
1086: p_init_msg_list,
1087: x_return_status,
1088: x_msg_count,
1089: x_msg_data,

Line 1126: ddp_rpcv_tbl okl_rpc_pvt.rpcv_tbl_type;

1122: , p5_a17 JTF_DATE_TABLE
1123: )
1124:
1125: as
1126: ddp_rpcv_tbl okl_rpc_pvt.rpcv_tbl_type;
1127: ddindx binary_integer; indx binary_integer;
1128: begin
1129:
1130: -- copy data to the local IN or IN-OUT args, if any

Line 1136: okl_rpc_pvt_w.rosetta_table_copy_in_p8(ddp_rpcv_tbl, p5_a0

1132:
1133:
1134:
1135:
1136: okl_rpc_pvt_w.rosetta_table_copy_in_p8(ddp_rpcv_tbl, p5_a0
1137: , p5_a1
1138: , p5_a2
1139: , p5_a3
1140: , p5_a4

Line 1157: okl_rpc_pvt.delete_row(p_api_version,

1153: , p5_a17
1154: );
1155:
1156: -- here's the delegated call to the old PL/SQL routine
1157: okl_rpc_pvt.delete_row(p_api_version,
1158: p_init_msg_list,
1159: x_return_status,
1160: x_msg_count,
1161: x_msg_data,

Line 1198: ddp_rpcv_rec okl_rpc_pvt.rpcv_rec_type;

1194: , p5_a17 DATE := fnd_api.g_miss_date
1195: )
1196:
1197: as
1198: ddp_rpcv_rec okl_rpc_pvt.rpcv_rec_type;
1199: ddindx binary_integer; indx binary_integer;
1200: begin
1201:
1202: -- copy data to the local IN or IN-OUT args, if any

Line 1228: okl_rpc_pvt.validate_row(p_api_version,

1224: ddp_rpcv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a16);
1225: ddp_rpcv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a17);
1226:
1227: -- here's the delegated call to the old PL/SQL routine
1228: okl_rpc_pvt.validate_row(p_api_version,
1229: p_init_msg_list,
1230: x_return_status,
1231: x_msg_count,
1232: x_msg_data,

Line 1269: ddp_rpcv_tbl okl_rpc_pvt.rpcv_tbl_type;

1265: , p5_a17 JTF_DATE_TABLE
1266: )
1267:
1268: as
1269: ddp_rpcv_tbl okl_rpc_pvt.rpcv_tbl_type;
1270: ddindx binary_integer; indx binary_integer;
1271: begin
1272:
1273: -- copy data to the local IN or IN-OUT args, if any

Line 1279: okl_rpc_pvt_w.rosetta_table_copy_in_p8(ddp_rpcv_tbl, p5_a0

1275:
1276:
1277:
1278:
1279: okl_rpc_pvt_w.rosetta_table_copy_in_p8(ddp_rpcv_tbl, p5_a0
1280: , p5_a1
1281: , p5_a2
1282: , p5_a3
1283: , p5_a4

Line 1300: okl_rpc_pvt.validate_row(p_api_version,

1296: , p5_a17
1297: );
1298:
1299: -- here's the delegated call to the old PL/SQL routine
1300: okl_rpc_pvt.validate_row(p_api_version,
1301: p_init_msg_list,
1302: x_return_status,
1303: x_msg_count,
1304: x_msg_data,

Line 1315: end okl_rpc_pvt_w;

1311:
1312:
1313: end;
1314:
1315: end okl_rpc_pvt_w;