503:
504: as
505: ddp_fixed_asset_rec csi_fa_instance_grp.fixed_asset_rec;
506: ddp_eam_rec csi_fa_instance_grp.eam_rec;
507: ddp_instance_rec csi_datastructures_pub.instance_rec;
508: ddp_instance_serial_tbl csi_fa_instance_grp.instance_serial_tbl;
509: ddp_party_tbl csi_datastructures_pub.party_tbl;
510: ddp_party_account_tbl csi_datastructures_pub.party_account_tbl;
511: ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
505: ddp_fixed_asset_rec csi_fa_instance_grp.fixed_asset_rec;
506: ddp_eam_rec csi_fa_instance_grp.eam_rec;
507: ddp_instance_rec csi_datastructures_pub.instance_rec;
508: ddp_instance_serial_tbl csi_fa_instance_grp.instance_serial_tbl;
509: ddp_party_tbl csi_datastructures_pub.party_tbl;
510: ddp_party_account_tbl csi_datastructures_pub.party_account_tbl;
511: ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
512: ddx_instance_tbl csi_datastructures_pub.instance_tbl;
513: ddx_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
506: ddp_eam_rec csi_fa_instance_grp.eam_rec;
507: ddp_instance_rec csi_datastructures_pub.instance_rec;
508: ddp_instance_serial_tbl csi_fa_instance_grp.instance_serial_tbl;
509: ddp_party_tbl csi_datastructures_pub.party_tbl;
510: ddp_party_account_tbl csi_datastructures_pub.party_account_tbl;
511: ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
512: ddx_instance_tbl csi_datastructures_pub.instance_tbl;
513: ddx_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
514: ddindx binary_integer; indx binary_integer;
507: ddp_instance_rec csi_datastructures_pub.instance_rec;
508: ddp_instance_serial_tbl csi_fa_instance_grp.instance_serial_tbl;
509: ddp_party_tbl csi_datastructures_pub.party_tbl;
510: ddp_party_account_tbl csi_datastructures_pub.party_account_tbl;
511: ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
512: ddx_instance_tbl csi_datastructures_pub.instance_tbl;
513: ddx_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
514: ddindx binary_integer; indx binary_integer;
515: begin
508: ddp_instance_serial_tbl csi_fa_instance_grp.instance_serial_tbl;
509: ddp_party_tbl csi_datastructures_pub.party_tbl;
510: ddp_party_account_tbl csi_datastructures_pub.party_account_tbl;
511: ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
512: ddx_instance_tbl csi_datastructures_pub.instance_tbl;
513: ddx_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
514: ddindx binary_integer; indx binary_integer;
515: begin
516:
509: ddp_party_tbl csi_datastructures_pub.party_tbl;
510: ddp_party_account_tbl csi_datastructures_pub.party_account_tbl;
511: ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
512: ddx_instance_tbl csi_datastructures_pub.instance_tbl;
513: ddx_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
514: ddindx binary_integer; indx binary_integer;
515: begin
516:
517: -- copy data to the local IN or IN-OUT args, if any
661: , p3_a5
662: , p3_a6
663: );
664:
665: csi_datastructures_pub_w.rosetta_table_copy_in_p9(ddp_party_tbl, p4_a0
666: , p4_a1
667: , p4_a2
668: , p4_a3
669: , p4_a4
696: , p4_a31
697: , p4_a32
698: );
699:
700: csi_datastructures_pub_w.rosetta_table_copy_in_p6(ddp_party_account_tbl, p5_a0
701: , p5_a1
702: , p5_a2
703: , p5_a3
704: , p5_a4
840: p6_a37 := ddpx_csi_txn_rec.split_reason_code;
841: p6_a38 := ddpx_csi_txn_rec.src_txn_creation_date;
842: p6_a39 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.gl_interface_status_code);
843:
844: csi_datastructures_pub_w.rosetta_table_copy_out_p19(ddx_instance_tbl, p7_a0
845: , p7_a1
846: , p7_a2
847: , p7_a3
848: , p7_a4
965: , p7_a121
966: , p7_a122
967: );
968:
969: csi_datastructures_pub_w.rosetta_table_copy_out_p52(ddx_instance_asset_tbl, p8_a0
970: , p8_a1
971: , p8_a2
972: , p8_a3
973: , p8_a4
1321: )
1322:
1323: as
1324: ddp_fixed_asset_rec csi_fa_instance_grp.fixed_asset_rec;
1325: ddp_instance_rec csi_datastructures_pub.instance_rec;
1326: ddp_instance_serial_tbl csi_fa_instance_grp.instance_serial_tbl;
1327: ddp_eam_rec csi_fa_instance_grp.eam_rec;
1328: ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
1329: ddx_instance_tbl csi_datastructures_pub.instance_tbl;
1324: ddp_fixed_asset_rec csi_fa_instance_grp.fixed_asset_rec;
1325: ddp_instance_rec csi_datastructures_pub.instance_rec;
1326: ddp_instance_serial_tbl csi_fa_instance_grp.instance_serial_tbl;
1327: ddp_eam_rec csi_fa_instance_grp.eam_rec;
1328: ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
1329: ddx_instance_tbl csi_datastructures_pub.instance_tbl;
1330: ddx_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1331: ddindx binary_integer; indx binary_integer;
1332: begin
1325: ddp_instance_rec csi_datastructures_pub.instance_rec;
1326: ddp_instance_serial_tbl csi_fa_instance_grp.instance_serial_tbl;
1327: ddp_eam_rec csi_fa_instance_grp.eam_rec;
1328: ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
1329: ddx_instance_tbl csi_datastructures_pub.instance_tbl;
1330: ddx_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1331: ddindx binary_integer; indx binary_integer;
1332: begin
1333:
1326: ddp_instance_serial_tbl csi_fa_instance_grp.instance_serial_tbl;
1327: ddp_eam_rec csi_fa_instance_grp.eam_rec;
1328: ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
1329: ddx_instance_tbl csi_datastructures_pub.instance_tbl;
1330: ddx_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1331: ddindx binary_integer; indx binary_integer;
1332: begin
1333:
1334: -- copy data to the local IN or IN-OUT args, if any
1604: p12_a37 := ddpx_csi_txn_rec.split_reason_code;
1605: p12_a38 := ddpx_csi_txn_rec.src_txn_creation_date;
1606: p12_a39 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.gl_interface_status_code);
1607:
1608: csi_datastructures_pub_w.rosetta_table_copy_out_p19(ddx_instance_tbl, p13_a0
1609: , p13_a1
1610: , p13_a2
1611: , p13_a3
1612: , p13_a4
1729: , p13_a121
1730: , p13_a122
1731: );
1732:
1733: csi_datastructures_pub_w.rosetta_table_copy_out_p52(ddx_instance_asset_tbl, p14_a0
1734: , p14_a1
1735: , p14_a2
1736: , p14_a3
1737: , p14_a4
1941: )
1942:
1943: as
1944: ddp_fixed_asset_rec csi_fa_instance_grp.fixed_asset_rec;
1945: ddp_instance_tbl csi_datastructures_pub.instance_tbl;
1946: ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
1947: ddx_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1948: ddindx binary_integer; indx binary_integer;
1949: begin
1942:
1943: as
1944: ddp_fixed_asset_rec csi_fa_instance_grp.fixed_asset_rec;
1945: ddp_instance_tbl csi_datastructures_pub.instance_tbl;
1946: ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
1947: ddx_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1948: ddindx binary_integer; indx binary_integer;
1949: begin
1950:
1943: as
1944: ddp_fixed_asset_rec csi_fa_instance_grp.fixed_asset_rec;
1945: ddp_instance_tbl csi_datastructures_pub.instance_tbl;
1946: ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
1947: ddx_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1948: ddindx binary_integer; indx binary_integer;
1949: begin
1950:
1951: -- copy data to the local IN or IN-OUT args, if any
1955: ddp_fixed_asset_rec.asset_quantity := rosetta_g_miss_num_map(p0_a3);
1956: ddp_fixed_asset_rec.fa_sync_flag := p0_a4;
1957: ddp_fixed_asset_rec.fa_sync_validation_reqd := p0_a5;
1958:
1959: csi_datastructures_pub_w.rosetta_table_copy_in_p19(ddp_instance_tbl, p1_a0
1960: , p1_a1
1961: , p1_a2
1962: , p1_a3
1963: , p1_a4
2176: p2_a37 := ddpx_csi_txn_rec.split_reason_code;
2177: p2_a38 := ddpx_csi_txn_rec.src_txn_creation_date;
2178: p2_a39 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.gl_interface_status_code);
2179:
2180: csi_datastructures_pub_w.rosetta_table_copy_out_p52(ddx_instance_asset_tbl, p3_a0
2181: , p3_a1
2182: , p3_a2
2183: , p3_a3
2184: , p3_a4
2258: , x_error_message out nocopy VARCHAR2
2259: )
2260:
2261: as
2262: ddp_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2263: ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
2264: ddindx binary_integer; indx binary_integer;
2265: begin
2266:
2259: )
2260:
2261: as
2262: ddp_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2263: ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
2264: ddindx binary_integer; indx binary_integer;
2265: begin
2266:
2267: -- copy data to the local IN or IN-OUT args, if any
2264: ddindx binary_integer; indx binary_integer;
2265: begin
2266:
2267: -- copy data to the local IN or IN-OUT args, if any
2268: csi_datastructures_pub_w.rosetta_table_copy_in_p52(ddp_instance_asset_tbl, p0_a0
2269: , p0_a1
2270: , p0_a2
2271: , p0_a3
2272: , p0_a4
2438: , x_error_message out nocopy VARCHAR2
2439: )
2440:
2441: as
2442: ddpx_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2443: ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
2444: ddindx binary_integer; indx binary_integer;
2445: begin
2446:
2439: )
2440:
2441: as
2442: ddpx_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2443: ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
2444: ddindx binary_integer; indx binary_integer;
2445: begin
2446:
2447: -- copy data to the local IN or IN-OUT args, if any
2444: ddindx binary_integer; indx binary_integer;
2445: begin
2446:
2447: -- copy data to the local IN or IN-OUT args, if any
2448: csi_datastructures_pub_w.rosetta_table_copy_in_p52(ddpx_instance_asset_tbl, p0_a0
2449: , p0_a1
2450: , p0_a2
2451: , p0_a3
2452: , p0_a4
2512: x_return_status,
2513: x_error_message);
2514:
2515: -- copy data back from the local variables to OUT or IN-OUT args, if any
2516: csi_datastructures_pub_w.rosetta_table_copy_out_p52(ddpx_instance_asset_tbl, p0_a0
2517: , p0_a1
2518: , p0_a2
2519: , p0_a3
2520: , p0_a4