525: , x_msg_data out nocopy VARCHAR2
526: )
527:
528: as
529: ddp_instance_rec csi_datastructures_pub.instance_rec;
530: ddp_party_tbl csi_datastructures_pub.party_tbl;
531: ddp_account_tbl csi_datastructures_pub.party_account_tbl;
532: ddp_txn_rec csi_datastructures_pub.transaction_rec;
533: ddindx binary_integer; indx binary_integer;
526: )
527:
528: as
529: ddp_instance_rec csi_datastructures_pub.instance_rec;
530: ddp_party_tbl csi_datastructures_pub.party_tbl;
531: ddp_account_tbl csi_datastructures_pub.party_account_tbl;
532: ddp_txn_rec csi_datastructures_pub.transaction_rec;
533: ddindx binary_integer; indx binary_integer;
534: begin
527:
528: as
529: ddp_instance_rec csi_datastructures_pub.instance_rec;
530: ddp_party_tbl csi_datastructures_pub.party_tbl;
531: ddp_account_tbl csi_datastructures_pub.party_account_tbl;
532: ddp_txn_rec csi_datastructures_pub.transaction_rec;
533: ddindx binary_integer; indx binary_integer;
534: begin
535:
528: as
529: ddp_instance_rec csi_datastructures_pub.instance_rec;
530: ddp_party_tbl csi_datastructures_pub.party_tbl;
531: ddp_account_tbl csi_datastructures_pub.party_account_tbl;
532: ddp_txn_rec csi_datastructures_pub.transaction_rec;
533: ddindx binary_integer; indx binary_integer;
534: begin
535:
536: -- copy data to the local IN or IN-OUT args, if any
661: ddp_instance_rec.area_id := rosetta_g_miss_num_map(p4_a120);
662: ddp_instance_rec.owner_party_id := rosetta_g_miss_num_map(p4_a121);
663: ddp_instance_rec.source_code := p4_a122;
664:
665: csi_datastructures_pub_w.rosetta_table_copy_in_p9(ddp_party_tbl, p5_a0
666: , p5_a1
667: , p5_a2
668: , p5_a3
669: , p5_a4
696: , p5_a31
697: , p5_a32
698: );
699:
700: csi_datastructures_pub_w.rosetta_table_copy_in_p6(ddp_account_tbl, p6_a0
701: , p6_a1
702: , p6_a2
703: , p6_a3
704: , p6_a4
920: p4_a120 := rosetta_g_miss_num_map(ddp_instance_rec.area_id);
921: p4_a121 := rosetta_g_miss_num_map(ddp_instance_rec.owner_party_id);
922: p4_a122 := ddp_instance_rec.source_code;
923:
924: csi_datastructures_pub_w.rosetta_table_copy_out_p9(ddp_party_tbl, p5_a0
925: , p5_a1
926: , p5_a2
927: , p5_a3
928: , p5_a4
955: , p5_a31
956: , p5_a32
957: );
958:
959: csi_datastructures_pub_w.rosetta_table_copy_out_p6(ddp_account_tbl, p6_a0
960: , p6_a1
961: , p6_a2
962: , p6_a3
963: , p6_a4
1342: , x_msg_data out nocopy VARCHAR2
1343: )
1344:
1345: as
1346: ddp_source_instance_rec csi_datastructures_pub.instance_rec;
1347: ddp_txn_rec csi_datastructures_pub.transaction_rec;
1348: ddx_new_instance_rec csi_datastructures_pub.instance_rec;
1349: ddindx binary_integer; indx binary_integer;
1350: begin
1343: )
1344:
1345: as
1346: ddp_source_instance_rec csi_datastructures_pub.instance_rec;
1347: ddp_txn_rec csi_datastructures_pub.transaction_rec;
1348: ddx_new_instance_rec csi_datastructures_pub.instance_rec;
1349: ddindx binary_integer; indx binary_integer;
1350: begin
1351:
1344:
1345: as
1346: ddp_source_instance_rec csi_datastructures_pub.instance_rec;
1347: ddp_txn_rec csi_datastructures_pub.transaction_rec;
1348: ddx_new_instance_rec csi_datastructures_pub.instance_rec;
1349: ddindx binary_integer; indx binary_integer;
1350: begin
1351:
1352: -- copy data to the local IN or IN-OUT args, if any
2158: , x_msg_data out nocopy VARCHAR2
2159: )
2160:
2161: as
2162: ddp_source_instance_rec csi_datastructures_pub.instance_rec;
2163: ddp_txn_rec csi_datastructures_pub.transaction_rec;
2164: ddx_new_instance_tbl csi_datastructures_pub.instance_tbl;
2165: ddindx binary_integer; indx binary_integer;
2166: begin
2159: )
2160:
2161: as
2162: ddp_source_instance_rec csi_datastructures_pub.instance_rec;
2163: ddp_txn_rec csi_datastructures_pub.transaction_rec;
2164: ddx_new_instance_tbl csi_datastructures_pub.instance_tbl;
2165: ddindx binary_integer; indx binary_integer;
2166: begin
2167:
2160:
2161: as
2162: ddp_source_instance_rec csi_datastructures_pub.instance_rec;
2163: ddp_txn_rec csi_datastructures_pub.transaction_rec;
2164: ddx_new_instance_tbl csi_datastructures_pub.instance_tbl;
2165: ddindx binary_integer; indx binary_integer;
2166: begin
2167:
2168: -- copy data to the local IN or IN-OUT args, if any
2538: p11_a37 := ddp_txn_rec.split_reason_code;
2539: p11_a38 := ddp_txn_rec.src_txn_creation_date;
2540: p11_a39 := rosetta_g_miss_num_map(ddp_txn_rec.gl_interface_status_code);
2541:
2542: csi_datastructures_pub_w.rosetta_table_copy_out_p19(ddx_new_instance_tbl, p12_a0
2543: , p12_a1
2544: , p12_a2
2545: , p12_a3
2546: , p12_a4
2971: , p4_a122 VARCHAR2 := fnd_api.g_miss_char
2972: )
2973:
2974: as
2975: ddp_source_instance_rec csi_datastructures_pub.instance_rec;
2976: ddp_txn_rec csi_datastructures_pub.transaction_rec;
2977: ddx_new_instance_tbl csi_datastructures_pub.instance_tbl;
2978: ddindx binary_integer; indx binary_integer;
2979: begin
2972: )
2973:
2974: as
2975: ddp_source_instance_rec csi_datastructures_pub.instance_rec;
2976: ddp_txn_rec csi_datastructures_pub.transaction_rec;
2977: ddx_new_instance_tbl csi_datastructures_pub.instance_tbl;
2978: ddindx binary_integer; indx binary_integer;
2979: begin
2980:
2973:
2974: as
2975: ddp_source_instance_rec csi_datastructures_pub.instance_rec;
2976: ddp_txn_rec csi_datastructures_pub.transaction_rec;
2977: ddx_new_instance_tbl csi_datastructures_pub.instance_tbl;
2978: ddindx binary_integer; indx binary_integer;
2979: begin
2980:
2981: -- copy data to the local IN or IN-OUT args, if any
3234: p13_a37 := ddp_txn_rec.split_reason_code;
3235: p13_a38 := ddp_txn_rec.src_txn_creation_date;
3236: p13_a39 := rosetta_g_miss_num_map(ddp_txn_rec.gl_interface_status_code);
3237:
3238: csi_datastructures_pub_w.rosetta_table_copy_out_p19(ddx_new_instance_tbl, p14_a0
3239: , p14_a1
3240: , p14_a2
3241: , p14_a3
3242: , p14_a4
4208: , x_msg_data out nocopy VARCHAR2
4209: )
4210:
4211: as
4212: ddx_instance_history_tbl csi_datastructures_pub.instance_history_tbl;
4213: ddx_party_history_tbl csi_datastructures_pub.party_history_tbl;
4214: ddx_account_history_tbl csi_datastructures_pub.account_history_tbl;
4215: ddx_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
4216: ddx_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
4209: )
4210:
4211: as
4212: ddx_instance_history_tbl csi_datastructures_pub.instance_history_tbl;
4213: ddx_party_history_tbl csi_datastructures_pub.party_history_tbl;
4214: ddx_account_history_tbl csi_datastructures_pub.account_history_tbl;
4215: ddx_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
4216: ddx_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
4217: ddx_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
4210:
4211: as
4212: ddx_instance_history_tbl csi_datastructures_pub.instance_history_tbl;
4213: ddx_party_history_tbl csi_datastructures_pub.party_history_tbl;
4214: ddx_account_history_tbl csi_datastructures_pub.account_history_tbl;
4215: ddx_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
4216: ddx_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
4217: ddx_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
4218: ddx_version_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
4211: as
4212: ddx_instance_history_tbl csi_datastructures_pub.instance_history_tbl;
4213: ddx_party_history_tbl csi_datastructures_pub.party_history_tbl;
4214: ddx_account_history_tbl csi_datastructures_pub.account_history_tbl;
4215: ddx_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
4216: ddx_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
4217: ddx_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
4218: ddx_version_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
4219: ddx_rel_history_tbl csi_datastructures_pub.relationship_history_tbl;
4212: ddx_instance_history_tbl csi_datastructures_pub.instance_history_tbl;
4213: ddx_party_history_tbl csi_datastructures_pub.party_history_tbl;
4214: ddx_account_history_tbl csi_datastructures_pub.account_history_tbl;
4215: ddx_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
4216: ddx_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
4217: ddx_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
4218: ddx_version_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
4219: ddx_rel_history_tbl csi_datastructures_pub.relationship_history_tbl;
4220: ddindx binary_integer; indx binary_integer;
4213: ddx_party_history_tbl csi_datastructures_pub.party_history_tbl;
4214: ddx_account_history_tbl csi_datastructures_pub.account_history_tbl;
4215: ddx_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
4216: ddx_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
4217: ddx_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
4218: ddx_version_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
4219: ddx_rel_history_tbl csi_datastructures_pub.relationship_history_tbl;
4220: ddindx binary_integer; indx binary_integer;
4221: begin
4214: ddx_account_history_tbl csi_datastructures_pub.account_history_tbl;
4215: ddx_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
4216: ddx_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
4217: ddx_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
4218: ddx_version_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
4219: ddx_rel_history_tbl csi_datastructures_pub.relationship_history_tbl;
4220: ddindx binary_integer; indx binary_integer;
4221: begin
4222:
4215: ddx_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
4216: ddx_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
4217: ddx_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
4218: ddx_version_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
4219: ddx_rel_history_tbl csi_datastructures_pub.relationship_history_tbl;
4220: ddindx binary_integer; indx binary_integer;
4221: begin
4222:
4223: -- copy data to the local IN or IN-OUT args, if any
4263:
4264:
4265:
4266:
4267: csi_datastructures_pub_w.rosetta_table_copy_out_p61(ddx_instance_history_tbl, p6_a0
4268: , p6_a1
4269: , p6_a2
4270: , p6_a3
4271: , p6_a4
4559: , p6_a292
4560: , p6_a293
4561: );
4562:
4563: csi_datastructures_pub_w.rosetta_table_copy_out_p67(ddx_party_history_tbl, p7_a0
4564: , p7_a1
4565: , p7_a2
4566: , p7_a3
4567: , p7_a4
4649: , p7_a86
4650: , p7_a87
4651: );
4652:
4653: csi_datastructures_pub_w.rosetta_table_copy_out_p69(ddx_account_history_tbl, p8_a0
4654: , p8_a1
4655: , p8_a2
4656: , p8_a3
4657: , p8_a4
4743: , p8_a90
4744: , p8_a91
4745: );
4746:
4747: csi_datastructures_pub_w.rosetta_table_copy_out_p71(ddx_org_unit_history_tbl, p9_a0
4748: , p9_a1
4749: , p9_a2
4750: , p9_a3
4751: , p9_a4
4793: , p9_a46
4794: , p9_a47
4795: );
4796:
4797: csi_datastructures_pub_w.rosetta_table_copy_out_p63(ddx_ins_asset_hist_tbl, p10_a0
4798: , p10_a1
4799: , p10_a2
4800: , p10_a3
4801: , p10_a4
4851: , p10_a54
4852: , p10_a55
4853: );
4854:
4855: csi_datastructures_pub_w.rosetta_table_copy_out_p65(ddx_ext_attrib_val_hist_tbl, p11_a0
4856: , p11_a1
4857: , p11_a2
4858: , p11_a3
4859: , p11_a4
4896: , p11_a41
4897: , p11_a42
4898: );
4899:
4900: csi_datastructures_pub_w.rosetta_table_copy_out_p73(ddx_version_label_hist_tbl, p12_a0
4901: , p12_a1
4902: , p12_a2
4903: , p12_a3
4904: , p12_a4
4946: , p12_a46
4947: , p12_a47
4948: );
4949:
4950: csi_datastructures_pub_w.rosetta_table_copy_out_p34(ddx_rel_history_tbl, p13_a0
4951: , p13_a1
4952: , p13_a2
4953: , p13_a3
4954: , p13_a4
5034: , x_msg_data out nocopy VARCHAR2
5035: )
5036:
5037: as
5038: ddx_instance_link_rec csi_datastructures_pub.instance_link_rec;
5039: ddindx binary_integer; indx binary_integer;
5040: begin
5041:
5042: -- copy data to the local IN or IN-OUT args, if any
5116: , x_msg_data out nocopy VARCHAR2
5117: )
5118:
5119: as
5120: ddx_contact_details csi_datastructures_pub.contact_details_rec;
5121: ddindx binary_integer; indx binary_integer;
5122: begin
5123:
5124: -- copy data to the local IN or IN-OUT args, if any
5275: , x_msg_data out nocopy VARCHAR2
5276: )
5277:
5278: as
5279: ddp_txn_rec csi_datastructures_pub.transaction_rec;
5280: ddx_instance_id_lst csi_datastructures_pub.id_tbl;
5281: ddindx binary_integer; indx binary_integer;
5282: begin
5283:
5276: )
5277:
5278: as
5279: ddp_txn_rec csi_datastructures_pub.transaction_rec;
5280: ddx_instance_id_lst csi_datastructures_pub.id_tbl;
5281: ddindx binary_integer; indx binary_integer;
5282: begin
5283:
5284: -- copy data to the local IN or IN-OUT args, if any
5390: p5_a37 := ddp_txn_rec.split_reason_code;
5391: p5_a38 := ddp_txn_rec.src_txn_creation_date;
5392: p5_a39 := rosetta_g_miss_num_map(ddp_txn_rec.gl_interface_status_code);
5393:
5394: csi_datastructures_pub_w.rosetta_table_copy_out_p15(ddx_instance_id_lst, x_instance_id_lst);
5395:
5396:
5397:
5398: end;