8: --
9: PROCEDURE save_value_maps
10: ( p_value_map_def_id IN NUMBER ,
11: p_record_version_number IN NUMBER ,
12: p_source_value_arr IN system.pa_varchar2_240_tbl_type ,
13: p_dest_value_arr IN system.pa_varchar2_240_tbl_type ,
14: p_source_value_pk1_arr IN system.pa_varchar2_240_tbl_type ,
15: p_source_value_pk2_arr IN system.pa_varchar2_240_tbl_type ,
16: p_source_value_pk3_arr IN system.pa_varchar2_240_tbl_type ,
9: PROCEDURE save_value_maps
10: ( p_value_map_def_id IN NUMBER ,
11: p_record_version_number IN NUMBER ,
12: p_source_value_arr IN system.pa_varchar2_240_tbl_type ,
13: p_dest_value_arr IN system.pa_varchar2_240_tbl_type ,
14: p_source_value_pk1_arr IN system.pa_varchar2_240_tbl_type ,
15: p_source_value_pk2_arr IN system.pa_varchar2_240_tbl_type ,
16: p_source_value_pk3_arr IN system.pa_varchar2_240_tbl_type ,
17: p_source_value_pk4_arr IN system.pa_varchar2_240_tbl_type ,
10: ( p_value_map_def_id IN NUMBER ,
11: p_record_version_number IN NUMBER ,
12: p_source_value_arr IN system.pa_varchar2_240_tbl_type ,
13: p_dest_value_arr IN system.pa_varchar2_240_tbl_type ,
14: p_source_value_pk1_arr IN system.pa_varchar2_240_tbl_type ,
15: p_source_value_pk2_arr IN system.pa_varchar2_240_tbl_type ,
16: p_source_value_pk3_arr IN system.pa_varchar2_240_tbl_type ,
17: p_source_value_pk4_arr IN system.pa_varchar2_240_tbl_type ,
18: p_source_value_pk5_arr IN system.pa_varchar2_240_tbl_type ,
11: p_record_version_number IN NUMBER ,
12: p_source_value_arr IN system.pa_varchar2_240_tbl_type ,
13: p_dest_value_arr IN system.pa_varchar2_240_tbl_type ,
14: p_source_value_pk1_arr IN system.pa_varchar2_240_tbl_type ,
15: p_source_value_pk2_arr IN system.pa_varchar2_240_tbl_type ,
16: p_source_value_pk3_arr IN system.pa_varchar2_240_tbl_type ,
17: p_source_value_pk4_arr IN system.pa_varchar2_240_tbl_type ,
18: p_source_value_pk5_arr IN system.pa_varchar2_240_tbl_type ,
19: p_dest_value_pk1_arr IN system.pa_varchar2_240_tbl_type ,
12: p_source_value_arr IN system.pa_varchar2_240_tbl_type ,
13: p_dest_value_arr IN system.pa_varchar2_240_tbl_type ,
14: p_source_value_pk1_arr IN system.pa_varchar2_240_tbl_type ,
15: p_source_value_pk2_arr IN system.pa_varchar2_240_tbl_type ,
16: p_source_value_pk3_arr IN system.pa_varchar2_240_tbl_type ,
17: p_source_value_pk4_arr IN system.pa_varchar2_240_tbl_type ,
18: p_source_value_pk5_arr IN system.pa_varchar2_240_tbl_type ,
19: p_dest_value_pk1_arr IN system.pa_varchar2_240_tbl_type ,
20: p_dest_value_pk2_arr IN system.pa_varchar2_240_tbl_type ,
13: p_dest_value_arr IN system.pa_varchar2_240_tbl_type ,
14: p_source_value_pk1_arr IN system.pa_varchar2_240_tbl_type ,
15: p_source_value_pk2_arr IN system.pa_varchar2_240_tbl_type ,
16: p_source_value_pk3_arr IN system.pa_varchar2_240_tbl_type ,
17: p_source_value_pk4_arr IN system.pa_varchar2_240_tbl_type ,
18: p_source_value_pk5_arr IN system.pa_varchar2_240_tbl_type ,
19: p_dest_value_pk1_arr IN system.pa_varchar2_240_tbl_type ,
20: p_dest_value_pk2_arr IN system.pa_varchar2_240_tbl_type ,
21: p_dest_value_pk3_arr IN system.pa_varchar2_240_tbl_type ,
14: p_source_value_pk1_arr IN system.pa_varchar2_240_tbl_type ,
15: p_source_value_pk2_arr IN system.pa_varchar2_240_tbl_type ,
16: p_source_value_pk3_arr IN system.pa_varchar2_240_tbl_type ,
17: p_source_value_pk4_arr IN system.pa_varchar2_240_tbl_type ,
18: p_source_value_pk5_arr IN system.pa_varchar2_240_tbl_type ,
19: p_dest_value_pk1_arr IN system.pa_varchar2_240_tbl_type ,
20: p_dest_value_pk2_arr IN system.pa_varchar2_240_tbl_type ,
21: p_dest_value_pk3_arr IN system.pa_varchar2_240_tbl_type ,
22: p_dest_value_pk4_arr IN system.pa_varchar2_240_tbl_type ,
15: p_source_value_pk2_arr IN system.pa_varchar2_240_tbl_type ,
16: p_source_value_pk3_arr IN system.pa_varchar2_240_tbl_type ,
17: p_source_value_pk4_arr IN system.pa_varchar2_240_tbl_type ,
18: p_source_value_pk5_arr IN system.pa_varchar2_240_tbl_type ,
19: p_dest_value_pk1_arr IN system.pa_varchar2_240_tbl_type ,
20: p_dest_value_pk2_arr IN system.pa_varchar2_240_tbl_type ,
21: p_dest_value_pk3_arr IN system.pa_varchar2_240_tbl_type ,
22: p_dest_value_pk4_arr IN system.pa_varchar2_240_tbl_type ,
23: p_dest_value_pk5_arr IN system.pa_varchar2_240_tbl_type ,
16: p_source_value_pk3_arr IN system.pa_varchar2_240_tbl_type ,
17: p_source_value_pk4_arr IN system.pa_varchar2_240_tbl_type ,
18: p_source_value_pk5_arr IN system.pa_varchar2_240_tbl_type ,
19: p_dest_value_pk1_arr IN system.pa_varchar2_240_tbl_type ,
20: p_dest_value_pk2_arr IN system.pa_varchar2_240_tbl_type ,
21: p_dest_value_pk3_arr IN system.pa_varchar2_240_tbl_type ,
22: p_dest_value_pk4_arr IN system.pa_varchar2_240_tbl_type ,
23: p_dest_value_pk5_arr IN system.pa_varchar2_240_tbl_type ,
24: p_probability_list_id IN NUMBER := NULL ,
17: p_source_value_pk4_arr IN system.pa_varchar2_240_tbl_type ,
18: p_source_value_pk5_arr IN system.pa_varchar2_240_tbl_type ,
19: p_dest_value_pk1_arr IN system.pa_varchar2_240_tbl_type ,
20: p_dest_value_pk2_arr IN system.pa_varchar2_240_tbl_type ,
21: p_dest_value_pk3_arr IN system.pa_varchar2_240_tbl_type ,
22: p_dest_value_pk4_arr IN system.pa_varchar2_240_tbl_type ,
23: p_dest_value_pk5_arr IN system.pa_varchar2_240_tbl_type ,
24: p_probability_list_id IN NUMBER := NULL ,
25: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
18: p_source_value_pk5_arr IN system.pa_varchar2_240_tbl_type ,
19: p_dest_value_pk1_arr IN system.pa_varchar2_240_tbl_type ,
20: p_dest_value_pk2_arr IN system.pa_varchar2_240_tbl_type ,
21: p_dest_value_pk3_arr IN system.pa_varchar2_240_tbl_type ,
22: p_dest_value_pk4_arr IN system.pa_varchar2_240_tbl_type ,
23: p_dest_value_pk5_arr IN system.pa_varchar2_240_tbl_type ,
24: p_probability_list_id IN NUMBER := NULL ,
25: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
26: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
19: p_dest_value_pk1_arr IN system.pa_varchar2_240_tbl_type ,
20: p_dest_value_pk2_arr IN system.pa_varchar2_240_tbl_type ,
21: p_dest_value_pk3_arr IN system.pa_varchar2_240_tbl_type ,
22: p_dest_value_pk4_arr IN system.pa_varchar2_240_tbl_type ,
23: p_dest_value_pk5_arr IN system.pa_varchar2_240_tbl_type ,
24: p_probability_list_id IN NUMBER := NULL ,
25: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
26: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
27: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895