[Home] [Help]
PACKAGE: APPS.PA_MAPPING_PVT
Source
1 PACKAGE PA_MAPPING_PVT AUTHID CURRENT_USER as
2 /* $Header: PAYMPVTS.pls 120.1 2005/08/19 17:23:32 mwasowic noship $ */
3
4 --
5 -- Procedure : Save_value_maps
6 -- Purpose : Save value map records to PA_VALUE_MAPS.
7 --
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 ,
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
26 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
27 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
28
29
30 --
31 -- Procedure : Get_dest_values
32 -- Purpose : Get the corresponding destination values given an array of source
33 -- values and a value map definition.
34 --
35 --
36 PROCEDURE get_dest_values
37 ( p_value_map_def_type IN VARCHAR2 ,
38 p_def_subtype IN VARCHAR2 ,
39 p_source_value IN VARCHAR2 ,
40 p_source_value_pk1 IN VARCHAR2 ,
41 p_source_value_pk2 IN VARCHAR2 ,
42 p_source_value_pk3 IN VARCHAR2 ,
43 p_source_value_pk4 IN VARCHAR2 ,
44 p_source_value_pk5 IN VARCHAR2 ,
45 p_probability_list_id IN NUMBER := NULL,
46 x_dest_value OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
47 x_dest_value_pk1 OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
48 x_dest_value_pk2 OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
49 x_dest_value_pk3 OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
50 x_dest_value_pk4 OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
51 x_dest_value_pk5 OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
52 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
53 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
54 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
55
56
57 PROCEDURE debug(p_msg IN VARCHAR2);
58
59 END PA_MAPPING_PVT;