[Home] [Help]
PACKAGE: APPS.VEA_PARAMETER_MAPPINGS_SV
Source
1 PACKAGE VEA_PARAMETER_MAPPINGS_SV AUTHID CURRENT_USER as
2 /* $Header: VEAVAPMS.pls 115.7 2004/07/27 00:05:41 rvishnuv ship $ */
3 --{
4 /*====================== vea_parameter_mappings_sv =========================*/
5 /*========================================================================
6 PURPOSE:
7
8 NOTES: To run the script:
9
10 sql> start VEAVALHS.pls
11
12 HISTORY
13 Created N PARIKH 09/09/99 10:00 AM
14
15 =========================================================================*/
16 --
17 --
18 --
19 --
20 PROCEDURE
21 delete_rows
22 (
23 p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
24 p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE
25 );
26 --
27 --
28 PROCEDURE
29 process
30 (
31 p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33 p_commit IN VARCHAR2 := FND_API.G_FALSE,
34 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 x_id OUT NOCOPY vea_parameter_mappings.parameter_mapping_id%TYPE,
39 p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
40 p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
41 p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
42 p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
43 p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
44 p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
45 p_description IN vea_parameter_mappings.description%TYPE,
46 p_id IN vea_parameter_mappings.parameter_mapping_id%TYPE := NULL,
47 p_program_unit_parameter_name IN vea_parameters.name%TYPE DEFAULT NULL,
48 p_tps_parameter_name IN vea_parameters.name%TYPE DEFAULT NULL
49 );
50 --
51 --
52 --
53 --
54 --}
55 END VEA_PARAMETER_MAPPINGS_SV;