[Home] [Help]
1: package body okl_okc_migration_pvt_w as
2: /* $Header: OKLEOKCB.pls 115.6 2003/10/16 09:58:47 avsingh 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:
18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy okl_okc_migration_pvt.cvmv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
53: end loop;
54: end if;
55: end if;
56: end rosetta_table_copy_in_p1;
57: procedure rosetta_table_copy_out_p1(t okl_okc_migration_pvt.cvmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_NUMBER_TABLE
60: , a3 out nocopy JTF_NUMBER_TABLE
61: , a4 out nocopy JTF_NUMBER_TABLE
117: end if;
118: end if;
119: end rosetta_table_copy_out_p1;
120:
121: procedure rosetta_table_copy_in_p3(t out nocopy okl_okc_migration_pvt.chrv_tbl_type, a0 JTF_NUMBER_TABLE
122: , a1 JTF_NUMBER_TABLE
123: , a2 JTF_VARCHAR2_TABLE_100
124: , a3 JTF_NUMBER_TABLE
125: , a4 JTF_NUMBER_TABLE
344: end loop;
345: end if;
346: end if;
347: end rosetta_table_copy_in_p3;
348: procedure rosetta_table_copy_out_p3(t okl_okc_migration_pvt.chrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
349: , a1 out nocopy JTF_NUMBER_TABLE
350: , a2 out nocopy JTF_VARCHAR2_TABLE_100
351: , a3 out nocopy JTF_NUMBER_TABLE
352: , a4 out nocopy JTF_NUMBER_TABLE
888: end if;
889: end if;
890: end rosetta_table_copy_out_p3;
891:
892: procedure rosetta_table_copy_in_p5(t out nocopy okl_okc_migration_pvt.clev_tbl_type, a0 JTF_NUMBER_TABLE
893: , a1 JTF_NUMBER_TABLE
894: , a2 JTF_VARCHAR2_TABLE_100
895: , a3 JTF_NUMBER_TABLE
896: , a4 JTF_NUMBER_TABLE
1085: end loop;
1086: end if;
1087: end if;
1088: end rosetta_table_copy_in_p5;
1089: procedure rosetta_table_copy_out_p5(t okl_okc_migration_pvt.clev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1090: , a1 out nocopy JTF_NUMBER_TABLE
1091: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1092: , a3 out nocopy JTF_NUMBER_TABLE
1093: , a4 out nocopy JTF_NUMBER_TABLE
1554: end if;
1555: end if;
1556: end rosetta_table_copy_out_p5;
1557:
1558: procedure rosetta_table_copy_in_p7(t out nocopy okl_okc_migration_pvt.cimv_tbl_type, a0 JTF_NUMBER_TABLE
1559: , a1 JTF_NUMBER_TABLE
1560: , a2 JTF_NUMBER_TABLE
1561: , a3 JTF_NUMBER_TABLE
1562: , a4 JTF_NUMBER_TABLE
1611: end loop;
1612: end if;
1613: end if;
1614: end rosetta_table_copy_in_p7;
1615: procedure rosetta_table_copy_out_p7(t okl_okc_migration_pvt.cimv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1616: , a1 out nocopy JTF_NUMBER_TABLE
1617: , a2 out nocopy JTF_NUMBER_TABLE
1618: , a3 out nocopy JTF_NUMBER_TABLE
1619: , a4 out nocopy JTF_NUMBER_TABLE
1730: end if;
1731: end if;
1732: end rosetta_table_copy_out_p7;
1733:
1734: procedure rosetta_table_copy_in_p9(t out nocopy okl_okc_migration_pvt.cplv_tbl_type, a0 JTF_NUMBER_TABLE
1735: , a1 JTF_NUMBER_TABLE
1736: , a2 JTF_VARCHAR2_TABLE_100
1737: , a3 JTF_NUMBER_TABLE
1738: , a4 JTF_NUMBER_TABLE
1829: end loop;
1830: end if;
1831: end if;
1832: end rosetta_table_copy_in_p9;
1833: procedure rosetta_table_copy_out_p9(t okl_okc_migration_pvt.cplv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1834: , a1 out nocopy JTF_NUMBER_TABLE
1835: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1836: , a3 out nocopy JTF_NUMBER_TABLE
1837: , a4 out nocopy JTF_NUMBER_TABLE
2053: end if;
2054: end if;
2055: end rosetta_table_copy_out_p9;
2056:
2057: procedure rosetta_table_copy_in_p11(t out nocopy okl_okc_migration_pvt.gvev_tbl_type, a0 JTF_NUMBER_TABLE
2058: , a1 JTF_NUMBER_TABLE
2059: , a2 JTF_NUMBER_TABLE
2060: , a3 JTF_NUMBER_TABLE
2061: , a4 JTF_NUMBER_TABLE
2098: end loop;
2099: end if;
2100: end if;
2101: end rosetta_table_copy_in_p11;
2102: procedure rosetta_table_copy_out_p11(t okl_okc_migration_pvt.gvev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2103: , a1 out nocopy JTF_NUMBER_TABLE
2104: , a2 out nocopy JTF_NUMBER_TABLE
2105: , a3 out nocopy JTF_NUMBER_TABLE
2106: , a4 out nocopy JTF_NUMBER_TABLE
2187: end if;
2188: end if;
2189: end rosetta_table_copy_out_p11;
2190:
2191: procedure rosetta_table_copy_in_p13(t out nocopy okl_okc_migration_pvt.rgpv_tbl_type, a0 JTF_NUMBER_TABLE
2192: , a1 JTF_NUMBER_TABLE
2193: , a2 JTF_VARCHAR2_TABLE_100
2194: , a3 JTF_VARCHAR2_TABLE_100
2195: , a4 JTF_VARCHAR2_TABLE_100
2268: end loop;
2269: end if;
2270: end if;
2271: end rosetta_table_copy_in_p13;
2272: procedure rosetta_table_copy_out_p13(t okl_okc_migration_pvt.rgpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2273: , a1 out nocopy JTF_NUMBER_TABLE
2274: , a2 out nocopy JTF_VARCHAR2_TABLE_100
2275: , a3 out nocopy JTF_VARCHAR2_TABLE_100
2276: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2447: end if;
2448: end if;
2449: end rosetta_table_copy_out_p13;
2450:
2451: procedure rosetta_table_copy_in_p15(t out nocopy okl_okc_migration_pvt.rmpv_tbl_type, a0 JTF_NUMBER_TABLE
2452: , a1 JTF_NUMBER_TABLE
2453: , a2 JTF_NUMBER_TABLE
2454: , a3 JTF_NUMBER_TABLE
2455: , a4 JTF_NUMBER_TABLE
2486: end loop;
2487: end if;
2488: end if;
2489: end rosetta_table_copy_in_p15;
2490: procedure rosetta_table_copy_out_p15(t okl_okc_migration_pvt.rmpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2491: , a1 out nocopy JTF_NUMBER_TABLE
2492: , a2 out nocopy JTF_NUMBER_TABLE
2493: , a3 out nocopy JTF_NUMBER_TABLE
2494: , a4 out nocopy JTF_NUMBER_TABLE
2560: end if;
2561: end if;
2562: end rosetta_table_copy_out_p15;
2563:
2564: procedure rosetta_table_copy_in_p17(t out nocopy okl_okc_migration_pvt.ctcv_tbl_type, a0 JTF_NUMBER_TABLE
2565: , a1 JTF_NUMBER_TABLE
2566: , a2 JTF_NUMBER_TABLE
2567: , a3 JTF_VARCHAR2_TABLE_100
2568: , a4 JTF_NUMBER_TABLE
2641: end loop;
2642: end if;
2643: end if;
2644: end rosetta_table_copy_in_p17;
2645: procedure rosetta_table_copy_out_p17(t okl_okc_migration_pvt.ctcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2646: , a1 out nocopy JTF_NUMBER_TABLE
2647: , a2 out nocopy JTF_NUMBER_TABLE
2648: , a3 out nocopy JTF_VARCHAR2_TABLE_100
2649: , a4 out nocopy JTF_NUMBER_TABLE
3038: , p5_a104 NUMBER := 0-1962.0724
3039: )
3040:
3041: as
3042: ddp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
3043: ddx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
3044: ddindx binary_integer; indx binary_integer;
3045: begin
3046:
3039: )
3040:
3041: as
3042: ddp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
3043: ddx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
3044: ddindx binary_integer; indx binary_integer;
3045: begin
3046:
3047: -- copy data to the local IN or IN-OUT args, if any
3157: ddp_chrv_rec.payment_term_id := rosetta_g_miss_num_map(p5_a104);
3158:
3159:
3160: -- here's the delegated call to the old PL/SQL routine
3161: okl_okc_migration_pvt.create_contract_header(p_api_version,
3162: p_init_msg_list,
3163: x_return_status,
3164: x_msg_count,
3165: x_msg_data,
3498: , p6_a104 NUMBER := 0-1962.0724
3499: )
3500:
3501: as
3502: ddp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
3503: ddx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
3504: ddindx binary_integer; indx binary_integer;
3505: begin
3506:
3499: )
3500:
3501: as
3502: ddp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
3503: ddx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
3504: ddindx binary_integer; indx binary_integer;
3505: begin
3506:
3507: -- copy data to the local IN or IN-OUT args, if any
3618: ddp_chrv_rec.payment_term_id := rosetta_g_miss_num_map(p6_a104);
3619:
3620:
3621: -- here's the delegated call to the old PL/SQL routine
3622: okl_okc_migration_pvt.update_contract_header(p_api_version,
3623: p_init_msg_list,
3624: x_return_status,
3625: x_msg_count,
3626: x_msg_data,
3855: , p5_a104 NUMBER := 0-1962.0724
3856: )
3857:
3858: as
3859: ddp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
3860: ddindx binary_integer; indx binary_integer;
3861: begin
3862:
3863: -- copy data to the local IN or IN-OUT args, if any
3972: ddp_chrv_rec.ship_to_site_use_id := rosetta_g_miss_num_map(p5_a103);
3973: ddp_chrv_rec.payment_term_id := rosetta_g_miss_num_map(p5_a104);
3974:
3975: -- here's the delegated call to the old PL/SQL routine
3976: okl_okc_migration_pvt.delete_contract_header(p_api_version,
3977: p_init_msg_list,
3978: x_return_status,
3979: x_msg_count,
3980: x_msg_data,
4100: , p5_a104 NUMBER := 0-1962.0724
4101: )
4102:
4103: as
4104: ddp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
4105: ddindx binary_integer; indx binary_integer;
4106: begin
4107:
4108: -- copy data to the local IN or IN-OUT args, if any
4217: ddp_chrv_rec.ship_to_site_use_id := rosetta_g_miss_num_map(p5_a103);
4218: ddp_chrv_rec.payment_term_id := rosetta_g_miss_num_map(p5_a104);
4219:
4220: -- here's the delegated call to the old PL/SQL routine
4221: okl_okc_migration_pvt.lock_contract_header(p_api_version,
4222: p_init_msg_list,
4223: x_return_status,
4224: x_msg_count,
4225: x_msg_data,
4345: , p5_a104 NUMBER := 0-1962.0724
4346: )
4347:
4348: as
4349: ddp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
4350: ddindx binary_integer; indx binary_integer;
4351: begin
4352:
4353: -- copy data to the local IN or IN-OUT args, if any
4462: ddp_chrv_rec.ship_to_site_use_id := rosetta_g_miss_num_map(p5_a103);
4463: ddp_chrv_rec.payment_term_id := rosetta_g_miss_num_map(p5_a104);
4464:
4465: -- here's the delegated call to the old PL/SQL routine
4466: okl_okc_migration_pvt.validate_contract_header(p_api_version,
4467: p_init_msg_list,
4468: x_return_status,
4469: x_msg_count,
4470: x_msg_data,
4666: , p6_a89 NUMBER := 0-1962.0724
4667: )
4668:
4669: as
4670: ddp_clev_rec okl_okc_migration_pvt.clev_rec_type;
4671: ddx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4672: ddindx binary_integer; indx binary_integer;
4673: begin
4674:
4667: )
4668:
4669: as
4670: ddp_clev_rec okl_okc_migration_pvt.clev_rec_type;
4671: ddx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4672: ddindx binary_integer; indx binary_integer;
4673: begin
4674:
4675: -- copy data to the local IN or IN-OUT args, if any
4771: ddp_clev_rec.payment_term_id := rosetta_g_miss_num_map(p6_a89);
4772:
4773:
4774: -- here's the delegated call to the old PL/SQL routine
4775: okl_okc_migration_pvt.create_contract_line(p_api_version,
4776: p_init_msg_list,
4777: x_return_status,
4778: x_msg_count,
4779: x_msg_data,
5069: , p7_a89 out nocopy JTF_NUMBER_TABLE
5070: )
5071:
5072: as
5073: ddp_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5074: ddx_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5075: ddindx binary_integer; indx binary_integer;
5076: begin
5077:
5070: )
5071:
5072: as
5073: ddp_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5074: ddx_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5075: ddindx binary_integer; indx binary_integer;
5076: begin
5077:
5078: -- copy data to the local IN or IN-OUT args, if any
5081:
5082:
5083:
5084:
5085: okl_okc_migration_pvt_w.rosetta_table_copy_in_p5(ddp_clev_tbl, p6_a0
5086: , p6_a1
5087: , p6_a2
5088: , p6_a3
5089: , p6_a4
5175: );
5176:
5177:
5178: -- here's the delegated call to the old PL/SQL routine
5179: okl_okc_migration_pvt.create_contract_line(p_api_version,
5180: p_init_msg_list,
5181: x_return_status,
5182: x_msg_count,
5183: x_msg_data,
5192:
5193:
5194:
5195:
5196: okl_okc_migration_pvt_w.rosetta_table_copy_out_p5(ddx_clev_tbl, p7_a0
5197: , p7_a1
5198: , p7_a2
5199: , p7_a3
5200: , p7_a4
5474: , p6_a89 NUMBER := 0-1962.0724
5475: )
5476:
5477: as
5478: ddp_clev_rec okl_okc_migration_pvt.clev_rec_type;
5479: ddx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5480: ddindx binary_integer; indx binary_integer;
5481: begin
5482:
5475: )
5476:
5477: as
5478: ddp_clev_rec okl_okc_migration_pvt.clev_rec_type;
5479: ddx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5480: ddindx binary_integer; indx binary_integer;
5481: begin
5482:
5483: -- copy data to the local IN or IN-OUT args, if any
5579: ddp_clev_rec.payment_term_id := rosetta_g_miss_num_map(p6_a89);
5580:
5581:
5582: -- here's the delegated call to the old PL/SQL routine
5583: okl_okc_migration_pvt.update_contract_line(p_api_version,
5584: p_init_msg_list,
5585: x_return_status,
5586: x_msg_count,
5587: x_msg_data,
5877: , p7_a89 out nocopy JTF_NUMBER_TABLE
5878: )
5879:
5880: as
5881: ddp_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5882: ddx_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5883: ddindx binary_integer; indx binary_integer;
5884: begin
5885:
5878: )
5879:
5880: as
5881: ddp_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5882: ddx_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5883: ddindx binary_integer; indx binary_integer;
5884: begin
5885:
5886: -- copy data to the local IN or IN-OUT args, if any
5889:
5890:
5891:
5892:
5893: okl_okc_migration_pvt_w.rosetta_table_copy_in_p5(ddp_clev_tbl, p6_a0
5894: , p6_a1
5895: , p6_a2
5896: , p6_a3
5897: , p6_a4
5983: );
5984:
5985:
5986: -- here's the delegated call to the old PL/SQL routine
5987: okl_okc_migration_pvt.update_contract_line(p_api_version,
5988: p_init_msg_list,
5989: x_return_status,
5990: x_msg_count,
5991: x_msg_data,
6000:
6001:
6002:
6003:
6004: okl_okc_migration_pvt_w.rosetta_table_copy_out_p5(ddx_clev_tbl, p7_a0
6005: , p7_a1
6006: , p7_a2
6007: , p7_a3
6008: , p7_a4
6191: , p5_a89 NUMBER := 0-1962.0724
6192: )
6193:
6194: as
6195: ddp_clev_rec okl_okc_migration_pvt.clev_rec_type;
6196: ddindx binary_integer; indx binary_integer;
6197: begin
6198:
6199: -- copy data to the local IN or IN-OUT args, if any
6293: ddp_clev_rec.ship_to_site_use_id := rosetta_g_miss_num_map(p5_a88);
6294: ddp_clev_rec.payment_term_id := rosetta_g_miss_num_map(p5_a89);
6295:
6296: -- here's the delegated call to the old PL/SQL routine
6297: okl_okc_migration_pvt.delete_contract_line(p_api_version,
6298: p_init_msg_list,
6299: x_return_status,
6300: x_msg_count,
6301: x_msg_data,
6406: , p5_a89 JTF_NUMBER_TABLE
6407: )
6408:
6409: as
6410: ddp_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
6411: ddindx binary_integer; indx binary_integer;
6412: begin
6413:
6414: -- copy data to the local IN or IN-OUT args, if any
6416:
6417:
6418:
6419:
6420: okl_okc_migration_pvt_w.rosetta_table_copy_in_p5(ddp_clev_tbl, p5_a0
6421: , p5_a1
6422: , p5_a2
6423: , p5_a3
6424: , p5_a4
6509: , p5_a89
6510: );
6511:
6512: -- here's the delegated call to the old PL/SQL routine
6513: okl_okc_migration_pvt.delete_contract_line(p_api_version,
6514: p_init_msg_list,
6515: x_return_status,
6516: x_msg_count,
6517: x_msg_data,
6622: , p5_a89 NUMBER := 0-1962.0724
6623: )
6624:
6625: as
6626: ddp_clev_rec okl_okc_migration_pvt.clev_rec_type;
6627: ddindx binary_integer; indx binary_integer;
6628: begin
6629:
6630: -- copy data to the local IN or IN-OUT args, if any
6724: ddp_clev_rec.ship_to_site_use_id := rosetta_g_miss_num_map(p5_a88);
6725: ddp_clev_rec.payment_term_id := rosetta_g_miss_num_map(p5_a89);
6726:
6727: -- here's the delegated call to the old PL/SQL routine
6728: okl_okc_migration_pvt.lock_contract_line(p_api_version,
6729: p_init_msg_list,
6730: x_return_status,
6731: x_msg_count,
6732: x_msg_data,
6837: , p5_a89 NUMBER := 0-1962.0724
6838: )
6839:
6840: as
6841: ddp_clev_rec okl_okc_migration_pvt.clev_rec_type;
6842: ddindx binary_integer; indx binary_integer;
6843: begin
6844:
6845: -- copy data to the local IN or IN-OUT args, if any
6939: ddp_clev_rec.ship_to_site_use_id := rosetta_g_miss_num_map(p5_a88);
6940: ddp_clev_rec.payment_term_id := rosetta_g_miss_num_map(p5_a89);
6941:
6942: -- here's the delegated call to the old PL/SQL routine
6943: okl_okc_migration_pvt.validate_contract_line(p_api_version,
6944: p_init_msg_list,
6945: x_return_status,
6946: x_msg_count,
6947: x_msg_data,
6990: , p5_a13 NUMBER := 0-1962.0724
6991: )
6992:
6993: as
6994: ddp_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
6995: ddx_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
6996: ddindx binary_integer; indx binary_integer;
6997: begin
6998:
6991: )
6992:
6993: as
6994: ddp_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
6995: ddx_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
6996: ddindx binary_integer; indx binary_integer;
6997: begin
6998:
6999: -- copy data to the local IN or IN-OUT args, if any
7018: ddp_gvev_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
7019:
7020:
7021: -- here's the delegated call to the old PL/SQL routine
7022: okl_okc_migration_pvt.create_governance(p_api_version,
7023: p_init_msg_list,
7024: x_return_status,
7025: x_msg_count,
7026: x_msg_data,
7085: , p5_a13 NUMBER := 0-1962.0724
7086: )
7087:
7088: as
7089: ddp_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
7090: ddx_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
7091: ddindx binary_integer; indx binary_integer;
7092: begin
7093:
7086: )
7087:
7088: as
7089: ddp_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
7090: ddx_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
7091: ddindx binary_integer; indx binary_integer;
7092: begin
7093:
7094: -- copy data to the local IN or IN-OUT args, if any
7113: ddp_gvev_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
7114:
7115:
7116: -- here's the delegated call to the old PL/SQL routine
7117: okl_okc_migration_pvt.update_governance(p_api_version,
7118: p_init_msg_list,
7119: x_return_status,
7120: x_msg_count,
7121: x_msg_data,
7166: , p5_a13 NUMBER := 0-1962.0724
7167: )
7168:
7169: as
7170: ddp_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
7171: ddindx binary_integer; indx binary_integer;
7172: begin
7173:
7174: -- copy data to the local IN or IN-OUT args, if any
7192: ddp_gvev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a12);
7193: ddp_gvev_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
7194:
7195: -- here's the delegated call to the old PL/SQL routine
7196: okl_okc_migration_pvt.delete_governance(p_api_version,
7197: p_init_msg_list,
7198: x_return_status,
7199: x_msg_count,
7200: x_msg_data,
7229: , p5_a13 NUMBER := 0-1962.0724
7230: )
7231:
7232: as
7233: ddp_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
7234: ddindx binary_integer; indx binary_integer;
7235: begin
7236:
7237: -- copy data to the local IN or IN-OUT args, if any
7255: ddp_gvev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a12);
7256: ddp_gvev_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
7257:
7258: -- here's the delegated call to the old PL/SQL routine
7259: okl_okc_migration_pvt.lock_governance(p_api_version,
7260: p_init_msg_list,
7261: x_return_status,
7262: x_msg_count,
7263: x_msg_data,
7292: , p5_a13 NUMBER := 0-1962.0724
7293: )
7294:
7295: as
7296: ddp_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
7297: ddindx binary_integer; indx binary_integer;
7298: begin
7299:
7300: -- copy data to the local IN or IN-OUT args, if any
7318: ddp_gvev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a12);
7319: ddp_gvev_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
7320:
7321: -- here's the delegated call to the old PL/SQL routine
7322: okl_okc_migration_pvt.validate_governance(p_api_version,
7323: p_init_msg_list,
7324: x_return_status,
7325: x_msg_count,
7326: x_msg_data,
7360: , p5_a8 NUMBER := 0-1962.0724
7361: )
7362:
7363: as
7364: ddp_cvmv_rec okl_okc_migration_pvt.cvmv_rec_type;
7365: ddx_cvmv_rec okl_okc_migration_pvt.cvmv_rec_type;
7366: ddindx binary_integer; indx binary_integer;
7367: begin
7368:
7361: )
7362:
7363: as
7364: ddp_cvmv_rec okl_okc_migration_pvt.cvmv_rec_type;
7365: ddx_cvmv_rec okl_okc_migration_pvt.cvmv_rec_type;
7366: ddindx binary_integer; indx binary_integer;
7367: begin
7368:
7369: -- copy data to the local IN or IN-OUT args, if any
7384:
7385:
7386:
7387: -- here's the delegated call to the old PL/SQL routine
7388: okl_okc_migration_pvt.version_contract(p_api_version,
7389: p_init_msg_list,
7390: x_return_status,
7391: x_msg_count,
7392: x_msg_data,
7439: , p7_a8 out nocopy JTF_NUMBER_TABLE
7440: )
7441:
7442: as
7443: ddp_cvmv_tbl okl_okc_migration_pvt.cvmv_tbl_type;
7444: ddx_cvmv_tbl okl_okc_migration_pvt.cvmv_tbl_type;
7445: ddindx binary_integer; indx binary_integer;
7446: begin
7447:
7440: )
7441:
7442: as
7443: ddp_cvmv_tbl okl_okc_migration_pvt.cvmv_tbl_type;
7444: ddx_cvmv_tbl okl_okc_migration_pvt.cvmv_tbl_type;
7445: ddindx binary_integer; indx binary_integer;
7446: begin
7447:
7448: -- copy data to the local IN or IN-OUT args, if any
7450:
7451:
7452:
7453:
7454: okl_okc_migration_pvt_w.rosetta_table_copy_in_p1(ddp_cvmv_tbl, p5_a0
7455: , p5_a1
7456: , p5_a2
7457: , p5_a3
7458: , p5_a4
7464:
7465:
7466:
7467: -- here's the delegated call to the old PL/SQL routine
7468: okl_okc_migration_pvt.version_contract(p_api_version,
7469: p_init_msg_list,
7470: x_return_status,
7471: x_msg_count,
7472: x_msg_data,
7481:
7482:
7483:
7484:
7485: okl_okc_migration_pvt_w.rosetta_table_copy_out_p1(ddx_cvmv_tbl, p7_a0
7486: , p7_a1
7487: , p7_a2
7488: , p7_a3
7489: , p7_a4
7541: , p5_a19 NUMBER := 0-1962.0724
7542: )
7543:
7544: as
7545: ddp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
7546: ddx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
7547: ddindx binary_integer; indx binary_integer;
7548: begin
7549:
7542: )
7543:
7544: as
7545: ddp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
7546: ddx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
7547: ddindx binary_integer; indx binary_integer;
7548: begin
7549:
7550: -- copy data to the local IN or IN-OUT args, if any
7575: ddp_cimv_rec.last_update_login := rosetta_g_miss_num_map(p5_a19);
7576:
7577:
7578: -- here's the delegated call to the old PL/SQL routine
7579: okl_okc_migration_pvt.create_contract_item(p_api_version,
7580: p_init_msg_list,
7581: x_return_status,
7582: x_msg_count,
7583: x_msg_data,
7660: , p6_a19 out nocopy JTF_NUMBER_TABLE
7661: )
7662:
7663: as
7664: ddp_cimv_tbl okl_okc_migration_pvt.cimv_tbl_type;
7665: ddx_cimv_tbl okl_okc_migration_pvt.cimv_tbl_type;
7666: ddindx binary_integer; indx binary_integer;
7667: begin
7668:
7661: )
7662:
7663: as
7664: ddp_cimv_tbl okl_okc_migration_pvt.cimv_tbl_type;
7665: ddx_cimv_tbl okl_okc_migration_pvt.cimv_tbl_type;
7666: ddindx binary_integer; indx binary_integer;
7667: begin
7668:
7669: -- copy data to the local IN or IN-OUT args, if any
7671:
7672:
7673:
7674:
7675: okl_okc_migration_pvt_w.rosetta_table_copy_in_p7(ddp_cimv_tbl, p5_a0
7676: , p5_a1
7677: , p5_a2
7678: , p5_a3
7679: , p5_a4
7695: );
7696:
7697:
7698: -- here's the delegated call to the old PL/SQL routine
7699: okl_okc_migration_pvt.create_contract_item(p_api_version,
7700: p_init_msg_list,
7701: x_return_status,
7702: x_msg_count,
7703: x_msg_data,
7710:
7711:
7712:
7713:
7714: okl_okc_migration_pvt_w.rosetta_table_copy_out_p7(ddx_cimv_tbl, p6_a0
7715: , p6_a1
7716: , p6_a2
7717: , p6_a3
7718: , p6_a4
7781: , p5_a19 NUMBER := 0-1962.0724
7782: )
7783:
7784: as
7785: ddp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
7786: ddx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
7787: ddindx binary_integer; indx binary_integer;
7788: begin
7789:
7782: )
7783:
7784: as
7785: ddp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
7786: ddx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
7787: ddindx binary_integer; indx binary_integer;
7788: begin
7789:
7790: -- copy data to the local IN or IN-OUT args, if any
7815: ddp_cimv_rec.last_update_login := rosetta_g_miss_num_map(p5_a19);
7816:
7817:
7818: -- here's the delegated call to the old PL/SQL routine
7819: okl_okc_migration_pvt.update_contract_item(p_api_version,
7820: p_init_msg_list,
7821: x_return_status,
7822: x_msg_count,
7823: x_msg_data,
7900: , p6_a19 out nocopy JTF_NUMBER_TABLE
7901: )
7902:
7903: as
7904: ddp_cimv_tbl okl_okc_migration_pvt.cimv_tbl_type;
7905: ddx_cimv_tbl okl_okc_migration_pvt.cimv_tbl_type;
7906: ddindx binary_integer; indx binary_integer;
7907: begin
7908:
7901: )
7902:
7903: as
7904: ddp_cimv_tbl okl_okc_migration_pvt.cimv_tbl_type;
7905: ddx_cimv_tbl okl_okc_migration_pvt.cimv_tbl_type;
7906: ddindx binary_integer; indx binary_integer;
7907: begin
7908:
7909: -- copy data to the local IN or IN-OUT args, if any
7911:
7912:
7913:
7914:
7915: okl_okc_migration_pvt_w.rosetta_table_copy_in_p7(ddp_cimv_tbl, p5_a0
7916: , p5_a1
7917: , p5_a2
7918: , p5_a3
7919: , p5_a4
7935: );
7936:
7937:
7938: -- here's the delegated call to the old PL/SQL routine
7939: okl_okc_migration_pvt.update_contract_item(p_api_version,
7940: p_init_msg_list,
7941: x_return_status,
7942: x_msg_count,
7943: x_msg_data,
7950:
7951:
7952:
7953:
7954: okl_okc_migration_pvt_w.rosetta_table_copy_out_p7(ddx_cimv_tbl, p6_a0
7955: , p6_a1
7956: , p6_a2
7957: , p6_a3
7958: , p6_a4
8001: , p5_a19 NUMBER := 0-1962.0724
8002: )
8003:
8004: as
8005: ddp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
8006: ddindx binary_integer; indx binary_integer;
8007: begin
8008:
8009: -- copy data to the local IN or IN-OUT args, if any
8033: ddp_cimv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a18);
8034: ddp_cimv_rec.last_update_login := rosetta_g_miss_num_map(p5_a19);
8035:
8036: -- here's the delegated call to the old PL/SQL routine
8037: okl_okc_migration_pvt.delete_contract_item(p_api_version,
8038: p_init_msg_list,
8039: x_return_status,
8040: x_msg_count,
8041: x_msg_data,
8076: , p5_a19 JTF_NUMBER_TABLE
8077: )
8078:
8079: as
8080: ddp_cimv_tbl okl_okc_migration_pvt.cimv_tbl_type;
8081: ddindx binary_integer; indx binary_integer;
8082: begin
8083:
8084: -- copy data to the local IN or IN-OUT args, if any
8086:
8087:
8088:
8089:
8090: okl_okc_migration_pvt_w.rosetta_table_copy_in_p7(ddp_cimv_tbl, p5_a0
8091: , p5_a1
8092: , p5_a2
8093: , p5_a3
8094: , p5_a4
8109: , p5_a19
8110: );
8111:
8112: -- here's the delegated call to the old PL/SQL routine
8113: okl_okc_migration_pvt.delete_contract_item(p_api_version,
8114: p_init_msg_list,
8115: x_return_status,
8116: x_msg_count,
8117: x_msg_data,
8214: , p5_a40 NUMBER := 0-1962.0724
8215: )
8216:
8217: as
8218: ddp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
8219: ddx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
8220: ddindx binary_integer; indx binary_integer;
8221: begin
8222:
8215: )
8216:
8217: as
8218: ddp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
8219: ddx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
8220: ddindx binary_integer; indx binary_integer;
8221: begin
8222:
8223: -- copy data to the local IN or IN-OUT args, if any
8269: ddp_cplv_rec.bill_to_site_use_id := rosetta_g_miss_num_map(p5_a40);
8270:
8271:
8272: -- here's the delegated call to the old PL/SQL routine
8273: okl_okc_migration_pvt.create_k_party_role(p_api_version,
8274: p_init_msg_list,
8275: x_return_status,
8276: x_msg_count,
8277: x_msg_data,
8417: , p6_a40 out nocopy JTF_NUMBER_TABLE
8418: )
8419:
8420: as
8421: ddp_cplv_tbl okl_okc_migration_pvt.cplv_tbl_type;
8422: ddx_cplv_tbl okl_okc_migration_pvt.cplv_tbl_type;
8423: ddindx binary_integer; indx binary_integer;
8424: begin
8425:
8418: )
8419:
8420: as
8421: ddp_cplv_tbl okl_okc_migration_pvt.cplv_tbl_type;
8422: ddx_cplv_tbl okl_okc_migration_pvt.cplv_tbl_type;
8423: ddindx binary_integer; indx binary_integer;
8424: begin
8425:
8426: -- copy data to the local IN or IN-OUT args, if any
8428:
8429:
8430:
8431:
8432: okl_okc_migration_pvt_w.rosetta_table_copy_in_p9(ddp_cplv_tbl, p5_a0
8433: , p5_a1
8434: , p5_a2
8435: , p5_a3
8436: , p5_a4
8473: );
8474:
8475:
8476: -- here's the delegated call to the old PL/SQL routine
8477: okl_okc_migration_pvt.create_k_party_role(p_api_version,
8478: p_init_msg_list,
8479: x_return_status,
8480: x_msg_count,
8481: x_msg_data,
8488:
8489:
8490:
8491:
8492: okl_okc_migration_pvt_w.rosetta_table_copy_out_p9(ddx_cplv_tbl, p6_a0
8493: , p6_a1
8494: , p6_a2
8495: , p6_a3
8496: , p6_a4
8622: , p5_a40 NUMBER := 0-1962.0724
8623: )
8624:
8625: as
8626: ddp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
8627: ddx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
8628: ddindx binary_integer; indx binary_integer;
8629: begin
8630:
8623: )
8624:
8625: as
8626: ddp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
8627: ddx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
8628: ddindx binary_integer; indx binary_integer;
8629: begin
8630:
8631: -- copy data to the local IN or IN-OUT args, if any
8677: ddp_cplv_rec.bill_to_site_use_id := rosetta_g_miss_num_map(p5_a40);
8678:
8679:
8680: -- here's the delegated call to the old PL/SQL routine
8681: okl_okc_migration_pvt.update_k_party_role(p_api_version,
8682: p_init_msg_list,
8683: x_return_status,
8684: x_msg_count,
8685: x_msg_data,
8825: , p6_a40 out nocopy JTF_NUMBER_TABLE
8826: )
8827:
8828: as
8829: ddp_cplv_tbl okl_okc_migration_pvt.cplv_tbl_type;
8830: ddx_cplv_tbl okl_okc_migration_pvt.cplv_tbl_type;
8831: ddindx binary_integer; indx binary_integer;
8832: begin
8833:
8826: )
8827:
8828: as
8829: ddp_cplv_tbl okl_okc_migration_pvt.cplv_tbl_type;
8830: ddx_cplv_tbl okl_okc_migration_pvt.cplv_tbl_type;
8831: ddindx binary_integer; indx binary_integer;
8832: begin
8833:
8834: -- copy data to the local IN or IN-OUT args, if any
8836:
8837:
8838:
8839:
8840: okl_okc_migration_pvt_w.rosetta_table_copy_in_p9(ddp_cplv_tbl, p5_a0
8841: , p5_a1
8842: , p5_a2
8843: , p5_a3
8844: , p5_a4
8881: );
8882:
8883:
8884: -- here's the delegated call to the old PL/SQL routine
8885: okl_okc_migration_pvt.update_k_party_role(p_api_version,
8886: p_init_msg_list,
8887: x_return_status,
8888: x_msg_count,
8889: x_msg_data,
8896:
8897:
8898:
8899:
8900: okl_okc_migration_pvt_w.rosetta_table_copy_out_p9(ddx_cplv_tbl, p6_a0
8901: , p6_a1
8902: , p6_a2
8903: , p6_a3
8904: , p6_a4
8989: , p5_a40 NUMBER := 0-1962.0724
8990: )
8991:
8992: as
8993: ddp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
8994: ddindx binary_integer; indx binary_integer;
8995: begin
8996:
8997: -- copy data to the local IN or IN-OUT args, if any
9042: ddp_cplv_rec.cust_acct_id := rosetta_g_miss_num_map(p5_a39);
9043: ddp_cplv_rec.bill_to_site_use_id := rosetta_g_miss_num_map(p5_a40);
9044:
9045: -- here's the delegated call to the old PL/SQL routine
9046: okl_okc_migration_pvt.delete_k_party_role(p_api_version,
9047: p_init_msg_list,
9048: x_return_status,
9049: x_msg_count,
9050: x_msg_data,
9106: , p5_a40 JTF_NUMBER_TABLE
9107: )
9108:
9109: as
9110: ddp_cplv_tbl okl_okc_migration_pvt.cplv_tbl_type;
9111: ddindx binary_integer; indx binary_integer;
9112: begin
9113:
9114: -- copy data to the local IN or IN-OUT args, if any
9116:
9117:
9118:
9119:
9120: okl_okc_migration_pvt_w.rosetta_table_copy_in_p9(ddp_cplv_tbl, p5_a0
9121: , p5_a1
9122: , p5_a2
9123: , p5_a3
9124: , p5_a4
9160: , p5_a40
9161: );
9162:
9163: -- here's the delegated call to the old PL/SQL routine
9164: okl_okc_migration_pvt.delete_k_party_role(p_api_version,
9165: p_init_msg_list,
9166: x_return_status,
9167: x_msg_count,
9168: x_msg_data,
9247: , p5_a31 DATE := fnd_api.g_miss_date
9248: )
9249:
9250: as
9251: ddp_ctcv_rec okl_okc_migration_pvt.ctcv_rec_type;
9252: ddx_ctcv_rec okl_okc_migration_pvt.ctcv_rec_type;
9253: ddindx binary_integer; indx binary_integer;
9254: begin
9255:
9248: )
9249:
9250: as
9251: ddp_ctcv_rec okl_okc_migration_pvt.ctcv_rec_type;
9252: ddx_ctcv_rec okl_okc_migration_pvt.ctcv_rec_type;
9253: ddindx binary_integer; indx binary_integer;
9254: begin
9255:
9256: -- copy data to the local IN or IN-OUT args, if any
9293: ddp_ctcv_rec.end_date := rosetta_g_miss_date_in_map(p5_a31);
9294:
9295:
9296: -- here's the delegated call to the old PL/SQL routine
9297: okl_okc_migration_pvt.create_contact(p_api_version,
9298: p_init_msg_list,
9299: x_return_status,
9300: x_msg_count,
9301: x_msg_data,
9414: , p6_a31 out nocopy JTF_DATE_TABLE
9415: )
9416:
9417: as
9418: ddp_ctcv_tbl okl_okc_migration_pvt.ctcv_tbl_type;
9419: ddx_ctcv_tbl okl_okc_migration_pvt.ctcv_tbl_type;
9420: ddindx binary_integer; indx binary_integer;
9421: begin
9422:
9415: )
9416:
9417: as
9418: ddp_ctcv_tbl okl_okc_migration_pvt.ctcv_tbl_type;
9419: ddx_ctcv_tbl okl_okc_migration_pvt.ctcv_tbl_type;
9420: ddindx binary_integer; indx binary_integer;
9421: begin
9422:
9423: -- copy data to the local IN or IN-OUT args, if any
9425:
9426:
9427:
9428:
9429: okl_okc_migration_pvt_w.rosetta_table_copy_in_p17(ddp_ctcv_tbl, p5_a0
9430: , p5_a1
9431: , p5_a2
9432: , p5_a3
9433: , p5_a4
9461: );
9462:
9463:
9464: -- here's the delegated call to the old PL/SQL routine
9465: okl_okc_migration_pvt.create_contact(p_api_version,
9466: p_init_msg_list,
9467: x_return_status,
9468: x_msg_count,
9469: x_msg_data,
9476:
9477:
9478:
9479:
9480: okl_okc_migration_pvt_w.rosetta_table_copy_out_p17(ddx_ctcv_tbl, p6_a0
9481: , p6_a1
9482: , p6_a2
9483: , p6_a3
9484: , p6_a4
9583: , p5_a31 DATE := fnd_api.g_miss_date
9584: )
9585:
9586: as
9587: ddp_ctcv_rec okl_okc_migration_pvt.ctcv_rec_type;
9588: ddx_ctcv_rec okl_okc_migration_pvt.ctcv_rec_type;
9589: ddindx binary_integer; indx binary_integer;
9590: begin
9591:
9584: )
9585:
9586: as
9587: ddp_ctcv_rec okl_okc_migration_pvt.ctcv_rec_type;
9588: ddx_ctcv_rec okl_okc_migration_pvt.ctcv_rec_type;
9589: ddindx binary_integer; indx binary_integer;
9590: begin
9591:
9592: -- copy data to the local IN or IN-OUT args, if any
9629: ddp_ctcv_rec.end_date := rosetta_g_miss_date_in_map(p5_a31);
9630:
9631:
9632: -- here's the delegated call to the old PL/SQL routine
9633: okl_okc_migration_pvt.update_contact(p_api_version,
9634: p_init_msg_list,
9635: x_return_status,
9636: x_msg_count,
9637: x_msg_data,
9750: , p6_a31 out nocopy JTF_DATE_TABLE
9751: )
9752:
9753: as
9754: ddp_ctcv_tbl okl_okc_migration_pvt.ctcv_tbl_type;
9755: ddx_ctcv_tbl okl_okc_migration_pvt.ctcv_tbl_type;
9756: ddindx binary_integer; indx binary_integer;
9757: begin
9758:
9751: )
9752:
9753: as
9754: ddp_ctcv_tbl okl_okc_migration_pvt.ctcv_tbl_type;
9755: ddx_ctcv_tbl okl_okc_migration_pvt.ctcv_tbl_type;
9756: ddindx binary_integer; indx binary_integer;
9757: begin
9758:
9759: -- copy data to the local IN or IN-OUT args, if any
9761:
9762:
9763:
9764:
9765: okl_okc_migration_pvt_w.rosetta_table_copy_in_p17(ddp_ctcv_tbl, p5_a0
9766: , p5_a1
9767: , p5_a2
9768: , p5_a3
9769: , p5_a4
9797: );
9798:
9799:
9800: -- here's the delegated call to the old PL/SQL routine
9801: okl_okc_migration_pvt.update_contact(p_api_version,
9802: p_init_msg_list,
9803: x_return_status,
9804: x_msg_count,
9805: x_msg_data,
9812:
9813:
9814:
9815:
9816: okl_okc_migration_pvt_w.rosetta_table_copy_out_p17(ddx_ctcv_tbl, p6_a0
9817: , p6_a1
9818: , p6_a2
9819: , p6_a3
9820: , p6_a4
9887: , p5_a31 DATE := fnd_api.g_miss_date
9888: )
9889:
9890: as
9891: ddp_ctcv_rec okl_okc_migration_pvt.ctcv_rec_type;
9892: ddindx binary_integer; indx binary_integer;
9893: begin
9894:
9895: -- copy data to the local IN or IN-OUT args, if any
9931: ddp_ctcv_rec.start_date := rosetta_g_miss_date_in_map(p5_a30);
9932: ddp_ctcv_rec.end_date := rosetta_g_miss_date_in_map(p5_a31);
9933:
9934: -- here's the delegated call to the old PL/SQL routine
9935: okl_okc_migration_pvt.delete_contact(p_api_version,
9936: p_init_msg_list,
9937: x_return_status,
9938: x_msg_count,
9939: x_msg_data,
9986: , p5_a31 JTF_DATE_TABLE
9987: )
9988:
9989: as
9990: ddp_ctcv_tbl okl_okc_migration_pvt.ctcv_tbl_type;
9991: ddindx binary_integer; indx binary_integer;
9992: begin
9993:
9994: -- copy data to the local IN or IN-OUT args, if any
9996:
9997:
9998:
9999:
10000: okl_okc_migration_pvt_w.rosetta_table_copy_in_p17(ddp_ctcv_tbl, p5_a0
10001: , p5_a1
10002: , p5_a2
10003: , p5_a3
10004: , p5_a4
10031: , p5_a31
10032: );
10033:
10034: -- here's the delegated call to the old PL/SQL routine
10035: okl_okc_migration_pvt.delete_contact(p_api_version,
10036: p_init_msg_list,
10037: x_return_status,
10038: x_msg_count,
10039: x_msg_data,
10118: , p5_a31 NUMBER := 0-1962.0724
10119: )
10120:
10121: as
10122: ddp_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;
10123: ddx_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;
10124: ddindx binary_integer; indx binary_integer;
10125: begin
10126:
10119: )
10120:
10121: as
10122: ddp_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;
10123: ddx_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;
10124: ddindx binary_integer; indx binary_integer;
10125: begin
10126:
10127: -- copy data to the local IN or IN-OUT args, if any
10164: ddp_rgpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
10165:
10166:
10167: -- here's the delegated call to the old PL/SQL routine
10168: okl_okc_migration_pvt.create_rule_group(p_api_version,
10169: p_init_msg_list,
10170: x_return_status,
10171: x_msg_count,
10172: x_msg_data,
10285: , p5_a31 NUMBER := 0-1962.0724
10286: )
10287:
10288: as
10289: ddp_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;
10290: ddx_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;
10291: ddindx binary_integer; indx binary_integer;
10292: begin
10293:
10286: )
10287:
10288: as
10289: ddp_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;
10290: ddx_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;
10291: ddindx binary_integer; indx binary_integer;
10292: begin
10293:
10294: -- copy data to the local IN or IN-OUT args, if any
10331: ddp_rgpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
10332:
10333:
10334: -- here's the delegated call to the old PL/SQL routine
10335: okl_okc_migration_pvt.update_rule_group(p_api_version,
10336: p_init_msg_list,
10337: x_return_status,
10338: x_msg_count,
10339: x_msg_data,
10420: , p5_a31 NUMBER := 0-1962.0724
10421: )
10422:
10423: as
10424: ddp_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;
10425: ddindx binary_integer; indx binary_integer;
10426: begin
10427:
10428: -- copy data to the local IN or IN-OUT args, if any
10464: ddp_rgpv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a30);
10465: ddp_rgpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
10466:
10467: -- here's the delegated call to the old PL/SQL routine
10468: okl_okc_migration_pvt.delete_rule_group(p_api_version,
10469: p_init_msg_list,
10470: x_return_status,
10471: x_msg_count,
10472: x_msg_data,
10519: , p5_a31 NUMBER := 0-1962.0724
10520: )
10521:
10522: as
10523: ddp_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;
10524: ddindx binary_integer; indx binary_integer;
10525: begin
10526:
10527: -- copy data to the local IN or IN-OUT args, if any
10563: ddp_rgpv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a30);
10564: ddp_rgpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
10565:
10566: -- here's the delegated call to the old PL/SQL routine
10567: okl_okc_migration_pvt.lock_rule_group(p_api_version,
10568: p_init_msg_list,
10569: x_return_status,
10570: x_msg_count,
10571: x_msg_data,
10618: , p5_a31 NUMBER := 0-1962.0724
10619: )
10620:
10621: as
10622: ddp_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;
10623: ddindx binary_integer; indx binary_integer;
10624: begin
10625:
10626: -- copy data to the local IN or IN-OUT args, if any
10662: ddp_rgpv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a30);
10663: ddp_rgpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a31);
10664:
10665: -- here's the delegated call to the old PL/SQL routine
10666: okl_okc_migration_pvt.validate_rule_group(p_api_version,
10667: p_init_msg_list,
10668: x_return_status,
10669: x_msg_count,
10670: x_msg_data,
10707: , p5_a10 NUMBER := 0-1962.0724
10708: )
10709:
10710: as
10711: ddp_rmpv_rec okl_okc_migration_pvt.rmpv_rec_type;
10712: ddx_rmpv_rec okl_okc_migration_pvt.rmpv_rec_type;
10713: ddindx binary_integer; indx binary_integer;
10714: begin
10715:
10708: )
10709:
10710: as
10711: ddp_rmpv_rec okl_okc_migration_pvt.rmpv_rec_type;
10712: ddx_rmpv_rec okl_okc_migration_pvt.rmpv_rec_type;
10713: ddindx binary_integer; indx binary_integer;
10714: begin
10715:
10716: -- copy data to the local IN or IN-OUT args, if any
10732: ddp_rmpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
10733:
10734:
10735: -- here's the delegated call to the old PL/SQL routine
10736: okl_okc_migration_pvt.create_rg_mode_pty_role(p_api_version,
10737: p_init_msg_list,
10738: x_return_status,
10739: x_msg_count,
10740: x_msg_data,
10790: , p5_a10 NUMBER := 0-1962.0724
10791: )
10792:
10793: as
10794: ddp_rmpv_rec okl_okc_migration_pvt.rmpv_rec_type;
10795: ddx_rmpv_rec okl_okc_migration_pvt.rmpv_rec_type;
10796: ddindx binary_integer; indx binary_integer;
10797: begin
10798:
10791: )
10792:
10793: as
10794: ddp_rmpv_rec okl_okc_migration_pvt.rmpv_rec_type;
10795: ddx_rmpv_rec okl_okc_migration_pvt.rmpv_rec_type;
10796: ddindx binary_integer; indx binary_integer;
10797: begin
10798:
10799: -- copy data to the local IN or IN-OUT args, if any
10815: ddp_rmpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
10816:
10817:
10818: -- here's the delegated call to the old PL/SQL routine
10819: okl_okc_migration_pvt.update_rg_mode_pty_role(p_api_version,
10820: p_init_msg_list,
10821: x_return_status,
10822: x_msg_count,
10823: x_msg_data,
10862: , p5_a10 NUMBER := 0-1962.0724
10863: )
10864:
10865: as
10866: ddp_rmpv_rec okl_okc_migration_pvt.rmpv_rec_type;
10867: ddindx binary_integer; indx binary_integer;
10868: begin
10869:
10870: -- copy data to the local IN or IN-OUT args, if any
10885: ddp_rmpv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a9);
10886: ddp_rmpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
10887:
10888: -- here's the delegated call to the old PL/SQL routine
10889: okl_okc_migration_pvt.delete_rg_mode_pty_role(p_api_version,
10890: p_init_msg_list,
10891: x_return_status,
10892: x_msg_count,
10893: x_msg_data,
10919: , p5_a10 NUMBER := 0-1962.0724
10920: )
10921:
10922: as
10923: ddp_rmpv_rec okl_okc_migration_pvt.rmpv_rec_type;
10924: ddindx binary_integer; indx binary_integer;
10925: begin
10926:
10927: -- copy data to the local IN or IN-OUT args, if any
10942: ddp_rmpv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a9);
10943: ddp_rmpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
10944:
10945: -- here's the delegated call to the old PL/SQL routine
10946: okl_okc_migration_pvt.lock_rg_mode_pty_role(p_api_version,
10947: p_init_msg_list,
10948: x_return_status,
10949: x_msg_count,
10950: x_msg_data,
10976: , p5_a10 NUMBER := 0-1962.0724
10977: )
10978:
10979: as
10980: ddp_rmpv_rec okl_okc_migration_pvt.rmpv_rec_type;
10981: ddindx binary_integer; indx binary_integer;
10982: begin
10983:
10984: -- copy data to the local IN or IN-OUT args, if any
10999: ddp_rmpv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a9);
11000: ddp_rmpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
11001:
11002: -- here's the delegated call to the old PL/SQL routine
11003: okl_okc_migration_pvt.validate_rg_mode_pty_role(p_api_version,
11004: p_init_msg_list,
11005: x_return_status,
11006: x_msg_count,
11007: x_msg_data,
11014:
11015:
11016: end;
11017:
11018: end okl_okc_migration_pvt_w;