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
4206: , x_msg_data out nocopy VARCHAR2
4207: )
4208:
4209: as
4210: ddx_instance_history_tbl csi_datastructures_pub.instance_history_tbl;
4211: ddx_party_history_tbl csi_datastructures_pub.party_history_tbl;
4212: ddx_account_history_tbl csi_datastructures_pub.account_history_tbl;
4213: ddx_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
4214: ddx_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
4207: )
4208:
4209: as
4210: ddx_instance_history_tbl csi_datastructures_pub.instance_history_tbl;
4211: ddx_party_history_tbl csi_datastructures_pub.party_history_tbl;
4212: ddx_account_history_tbl csi_datastructures_pub.account_history_tbl;
4213: ddx_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
4214: ddx_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
4215: ddx_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
4208:
4209: as
4210: ddx_instance_history_tbl csi_datastructures_pub.instance_history_tbl;
4211: ddx_party_history_tbl csi_datastructures_pub.party_history_tbl;
4212: ddx_account_history_tbl csi_datastructures_pub.account_history_tbl;
4213: ddx_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
4214: ddx_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
4215: ddx_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
4216: ddx_version_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
4209: as
4210: ddx_instance_history_tbl csi_datastructures_pub.instance_history_tbl;
4211: ddx_party_history_tbl csi_datastructures_pub.party_history_tbl;
4212: ddx_account_history_tbl csi_datastructures_pub.account_history_tbl;
4213: ddx_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
4214: ddx_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
4215: ddx_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
4216: ddx_version_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
4217: ddx_rel_history_tbl csi_datastructures_pub.relationship_history_tbl;
4210: ddx_instance_history_tbl csi_datastructures_pub.instance_history_tbl;
4211: ddx_party_history_tbl csi_datastructures_pub.party_history_tbl;
4212: ddx_account_history_tbl csi_datastructures_pub.account_history_tbl;
4213: ddx_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
4214: ddx_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
4215: ddx_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
4216: ddx_version_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
4217: ddx_rel_history_tbl csi_datastructures_pub.relationship_history_tbl;
4218: ddindx binary_integer; indx binary_integer;
4211: ddx_party_history_tbl csi_datastructures_pub.party_history_tbl;
4212: ddx_account_history_tbl csi_datastructures_pub.account_history_tbl;
4213: ddx_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
4214: ddx_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
4215: ddx_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
4216: ddx_version_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
4217: ddx_rel_history_tbl csi_datastructures_pub.relationship_history_tbl;
4218: ddindx binary_integer; indx binary_integer;
4219: begin
4212: ddx_account_history_tbl csi_datastructures_pub.account_history_tbl;
4213: ddx_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
4214: ddx_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
4215: ddx_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
4216: ddx_version_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
4217: ddx_rel_history_tbl csi_datastructures_pub.relationship_history_tbl;
4218: ddindx binary_integer; indx binary_integer;
4219: begin
4220:
4213: ddx_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
4214: ddx_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
4215: ddx_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
4216: ddx_version_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
4217: ddx_rel_history_tbl csi_datastructures_pub.relationship_history_tbl;
4218: ddindx binary_integer; indx binary_integer;
4219: begin
4220:
4221: -- copy data to the local IN or IN-OUT args, if any
4261:
4262:
4263:
4264:
4265: csi_datastructures_pub_w.rosetta_table_copy_out_p61(ddx_instance_history_tbl, p6_a0
4266: , p6_a1
4267: , p6_a2
4268: , p6_a3
4269: , p6_a4
4555: , p6_a290
4556: , p6_a291
4557: );
4558:
4559: csi_datastructures_pub_w.rosetta_table_copy_out_p67(ddx_party_history_tbl, p7_a0
4560: , p7_a1
4561: , p7_a2
4562: , p7_a3
4563: , p7_a4
4645: , p7_a86
4646: , p7_a87
4647: );
4648:
4649: csi_datastructures_pub_w.rosetta_table_copy_out_p69(ddx_account_history_tbl, p8_a0
4650: , p8_a1
4651: , p8_a2
4652: , p8_a3
4653: , p8_a4
4739: , p8_a90
4740: , p8_a91
4741: );
4742:
4743: csi_datastructures_pub_w.rosetta_table_copy_out_p71(ddx_org_unit_history_tbl, p9_a0
4744: , p9_a1
4745: , p9_a2
4746: , p9_a3
4747: , p9_a4
4789: , p9_a46
4790: , p9_a47
4791: );
4792:
4793: csi_datastructures_pub_w.rosetta_table_copy_out_p63(ddx_ins_asset_hist_tbl, p10_a0
4794: , p10_a1
4795: , p10_a2
4796: , p10_a3
4797: , p10_a4
4847: , p10_a54
4848: , p10_a55
4849: );
4850:
4851: csi_datastructures_pub_w.rosetta_table_copy_out_p65(ddx_ext_attrib_val_hist_tbl, p11_a0
4852: , p11_a1
4853: , p11_a2
4854: , p11_a3
4855: , p11_a4
4892: , p11_a41
4893: , p11_a42
4894: );
4895:
4896: csi_datastructures_pub_w.rosetta_table_copy_out_p73(ddx_version_label_hist_tbl, p12_a0
4897: , p12_a1
4898: , p12_a2
4899: , p12_a3
4900: , p12_a4
4942: , p12_a46
4943: , p12_a47
4944: );
4945:
4946: csi_datastructures_pub_w.rosetta_table_copy_out_p34(ddx_rel_history_tbl, p13_a0
4947: , p13_a1
4948: , p13_a2
4949: , p13_a3
4950: , p13_a4
5030: , x_msg_data out nocopy VARCHAR2
5031: )
5032:
5033: as
5034: ddx_instance_link_rec csi_datastructures_pub.instance_link_rec;
5035: ddindx binary_integer; indx binary_integer;
5036: begin
5037:
5038: -- copy data to the local IN or IN-OUT args, if any
5112: , x_msg_data out nocopy VARCHAR2
5113: )
5114:
5115: as
5116: ddx_contact_details csi_datastructures_pub.contact_details_rec;
5117: ddindx binary_integer; indx binary_integer;
5118: begin
5119:
5120: -- copy data to the local IN or IN-OUT args, if any
5271: , x_msg_data out nocopy VARCHAR2
5272: )
5273:
5274: as
5275: ddp_txn_rec csi_datastructures_pub.transaction_rec;
5276: ddx_instance_id_lst csi_datastructures_pub.id_tbl;
5277: ddindx binary_integer; indx binary_integer;
5278: begin
5279:
5272: )
5273:
5274: as
5275: ddp_txn_rec csi_datastructures_pub.transaction_rec;
5276: ddx_instance_id_lst csi_datastructures_pub.id_tbl;
5277: ddindx binary_integer; indx binary_integer;
5278: begin
5279:
5280: -- copy data to the local IN or IN-OUT args, if any
5386: p5_a37 := ddp_txn_rec.split_reason_code;
5387: p5_a38 := ddp_txn_rec.src_txn_creation_date;
5388: p5_a39 := rosetta_g_miss_num_map(ddp_txn_rec.gl_interface_status_code);
5389:
5390: csi_datastructures_pub_w.rosetta_table_copy_out_p15(ddx_instance_id_lst, x_instance_id_lst);
5391:
5392:
5393:
5394: end;