69: , p4_a3 NUMBER := 0-1962.0724
70: )
71:
72: as
73: ddp_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
74: ddp_time_stamp date;
75: ddx_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
76: ddindx binary_integer; indx binary_integer;
77: begin
71:
72: as
73: ddp_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
74: ddp_time_stamp date;
75: ddx_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
76: ddindx binary_integer; indx binary_integer;
77: begin
78:
79: -- copy data to the local IN or IN-OUT args, if any
116:
117:
118:
119:
120: csi_datastructures_pub_w.rosetta_table_copy_out_p32(ddx_relationship_tbl, p8_a0
121: , p8_a1
122: , p8_a2
123: , p8_a3
124: , p8_a4
234: , x_msg_data out nocopy VARCHAR2
235: )
236:
237: as
238: ddp_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
239: ddp_txn_rec csi_datastructures_pub.transaction_rec;
240: ddindx binary_integer; indx binary_integer;
241: begin
242:
235: )
236:
237: as
238: ddp_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
239: ddp_txn_rec csi_datastructures_pub.transaction_rec;
240: ddindx binary_integer; indx binary_integer;
241: begin
242:
243: -- copy data to the local IN or IN-OUT args, if any
244:
245:
246:
247:
248: csi_datastructures_pub_w.rosetta_table_copy_in_p32(ddp_relationship_tbl, p4_a0
249: , p4_a1
250: , p4_a2
251: , p4_a3
252: , p4_a4
337:
338:
339:
340:
341: csi_datastructures_pub_w.rosetta_table_copy_out_p32(ddp_relationship_tbl, p4_a0
342: , p4_a1
343: , p4_a2
344: , p4_a3
345: , p4_a4
496: , x_msg_data out nocopy VARCHAR2
497: )
498:
499: as
500: ddp_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
501: ddp_txn_rec csi_datastructures_pub.transaction_rec;
502: ddindx binary_integer; indx binary_integer;
503: begin
504:
497: )
498:
499: as
500: ddp_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
501: ddp_txn_rec csi_datastructures_pub.transaction_rec;
502: ddindx binary_integer; indx binary_integer;
503: begin
504:
505: -- copy data to the local IN or IN-OUT args, if any
506:
507:
508:
509:
510: csi_datastructures_pub_w.rosetta_table_copy_in_p32(ddp_relationship_tbl, p4_a0
511: , p4_a1
512: , p4_a2
513: , p4_a3
514: , p4_a4
727: , p4_a30 VARCHAR2 := fnd_api.g_miss_char
728: )
729:
730: as
731: ddp_relationship_rec csi_datastructures_pub.ii_relationship_rec;
732: ddp_txn_rec csi_datastructures_pub.transaction_rec;
733: ddx_instance_id_lst csi_datastructures_pub.id_tbl;
734: ddindx binary_integer; indx binary_integer;
735: begin
728: )
729:
730: as
731: ddp_relationship_rec csi_datastructures_pub.ii_relationship_rec;
732: ddp_txn_rec csi_datastructures_pub.transaction_rec;
733: ddx_instance_id_lst csi_datastructures_pub.id_tbl;
734: ddindx binary_integer; indx binary_integer;
735: begin
736:
729:
730: as
731: ddp_relationship_rec csi_datastructures_pub.ii_relationship_rec;
732: ddp_txn_rec csi_datastructures_pub.transaction_rec;
733: ddx_instance_id_lst csi_datastructures_pub.id_tbl;
734: ddindx binary_integer; indx binary_integer;
735: begin
736:
737: -- copy data to the local IN or IN-OUT args, if any
874: p5_a37 := ddp_txn_rec.split_reason_code;
875: p5_a38 := ddp_txn_rec.src_txn_creation_date;
876: p5_a39 := rosetta_g_miss_num_map(ddp_txn_rec.gl_interface_status_code);
877:
878: csi_datastructures_pub_w.rosetta_table_copy_out_p15(ddx_instance_id_lst, x_instance_id_lst);
879:
880:
881:
882: end;