DBA Data[Home] [Help]

APPS.VEA_PARAMETER_MAPPINGS_SV dependencies on VEA_PARAMETER_MAPPINGS

Line 1: PACKAGE VEA_PARAMETER_MAPPINGS_SV AUTHID CURRENT_USER as

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

Line 4: /*====================== vea_parameter_mappings_sv =========================*/

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:

Line 23: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,

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

Line 24: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE

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

Line 38: x_id OUT NOCOPY vea_parameter_mappings.parameter_mapping_id%TYPE,

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,

Line 39: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,

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,

Line 40: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,

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,

Line 41: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,

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,

Line 42: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,

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,

Line 43: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_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,

Line 44: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_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

Line 45: p_description IN vea_parameter_mappings.description%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: );

Line 46: p_id IN vea_parameter_mappings.parameter_mapping_id%TYPE := NULL,

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

Line 55: END VEA_PARAMETER_MAPPINGS_SV;

51: --
52: --
53: --
54: --}
55: END VEA_PARAMETER_MAPPINGS_SV;