[Home] [Help]
PACKAGE: APPS.PA_VALUE_MAPS_PKG
Source
1 PACKAGE PA_VALUE_MAPS_PKG as
2 /* $Header: PAYMPKGS.pls 120.1 2005/08/19 17:23:23 mwasowic noship $ */
3
4 --
5 -- Procedure : Insert_rows
6 -- Purpose : Create Rows in PA_VALUE_MAPS.
7 --
8 --
9 PROCEDURE insert_rows
10 ( p_value_map_def_id IN NUMBER ,
11 p_source_value_arr IN PA_PLSQL_DATATYPES.Char240TabTyp ,
12 p_dest_value_arr IN PA_PLSQL_DATATYPES.Char240TabTyp ,
13 p_source_value_pk1_arr IN PA_PLSQL_DATATYPES.Char240TabTyp ,
14 p_source_value_pk2_arr IN PA_PLSQL_DATATYPES.Char240TabTyp ,
15 p_source_value_pk3_arr IN PA_PLSQL_DATATYPES.Char240TabTyp ,
16 p_source_value_pk4_arr IN PA_PLSQL_DATATYPES.Char240TabTyp ,
17 p_source_value_pk5_arr IN PA_PLSQL_DATATYPES.Char240TabTyp ,
18 p_dest_value_pk1_arr IN PA_PLSQL_DATATYPES.Char240TabTyp ,
19 p_dest_value_pk2_arr IN PA_PLSQL_DATATYPES.Char240TabTyp ,
20 p_dest_value_pk3_arr IN PA_PLSQL_DATATYPES.Char240TabTyp ,
21 p_dest_value_pk4_arr IN PA_PLSQL_DATATYPES.Char240TabTyp ,
22 p_dest_value_pk5_arr IN PA_PLSQL_DATATYPES.Char240TabTyp ,
23 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
24 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
25 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
26
27
28 --
29 -- Procedure : delete_rows
30 -- Purpose : Delete rows in pa_value_maps.
31 --
32 --
33 PROCEDURE delete_rows
34 ( p_value_map_def_id IN NUMBER ,
35 p_value_map_def_type IN VARCHAR2 ,
36 p_probability_list_id IN NUMBER := NULL ,
37 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
38 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
39 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
40
41
42 END PA_VALUE_MAPS_PKG;