APPS.VEA_PARAMETERS_SV dependencies on VEA_PARAMETERS

Line 1: PACKAGE VEA_PARAMETERS_SV AUTHID CURRENT_USER as

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: /*========================================================================

Line 4: /*====================== vea_parameters_sv =========================*/

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:

Line 23: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,

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: --

Line 24: p_program_unit_id IN vea_parameters.program_unit_id%TYPE

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

Line 31: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,

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;

Line 32: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,

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: --

Line 33: p_name IN vea_parameters.name%TYPE

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: --

Line 48: x_id OUT NOCOPY vea_parameters.parameter_id%TYPE,

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,

Line 49: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,

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,

Line 50: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,

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,

Line 51: p_parameter_type IN vea_parameters.parameter_type%TYPE,

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,

Line 52: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,

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,

Line 53: p_name IN vea_parameters.name%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,

Line 54: p_datatype IN vea_parameters.datatype%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

Line 55: p_default_value IN vea_parameters.default_value%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: );

Line 56: p_description IN vea_parameters.description%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: --

Line 57: p_id IN vea_parameters.parameter_id%TYPE := NULL,

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: --

Line 65: END VEA_PARAMETERS_SV;

61: --
62: --
63: --
64: --}
65: END VEA_PARAMETERS_SV;