[Home] [Help]
PACKAGE: APPS.VEA_PARAMETERS_SV
Source
1 PACKAGE VEA_PARAMETERS_SV AUTHID CURRENT_USER as
2 /* $Header: VEAVAPAS.pls 115.9 2004/07/27 00:06:18 rvishnuv ship $ */
3 --{
4 /*====================== vea_parameters_sv =========================*/
5 /*========================================================================
6 PURPOSE:
7
8 NOTES: To run the script:
9
10 sql> start VEAVAPKS.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_parameters.layer_provider_code%TYPE,
24 p_program_unit_id IN vea_parameters.program_unit_id%TYPE
25 );
26 --
27 --
28 FUNCTION
29 getId
30 (
31 p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
32 p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
33 p_name IN vea_parameters.name%TYPE
34 )
35 RETURN NUMBER;
36 --
37 --
38 PROCEDURE
39 process
40 (
41 p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
43 p_commit IN VARCHAR2 := FND_API.G_FALSE,
44 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 x_id OUT NOCOPY vea_parameters.parameter_id%TYPE,
49 p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
50 p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
51 p_parameter_type IN vea_parameters.parameter_type%TYPE,
52 p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
53 p_name IN vea_parameters.name%TYPE,
54 p_datatype IN vea_parameters.datatype%TYPE,
55 p_default_value IN vea_parameters.default_value%TYPE,
56 p_description IN vea_parameters.description%TYPE,
57 p_id IN vea_parameters.parameter_id%TYPE := NULL,
58 p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL
59 );
60 --
61 --
62 --
63 --
64 --}
65 END VEA_PARAMETERS_SV;