[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE NAME: insert_row
PURPOSE: Inserts a record into VEA_PARAMETER_MAPPINGS table
========================================================================*/
PROCEDURE
insert_row
(
p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
p_description IN vea_parameter_mappings.description%TYPE
)
IS
--{
l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
INSERT INTO vea_parameter_mappings
(
layer_provider_code, parameter_mapping_id,
layer_header_id,
program_unit_parameter_id, program_unit_param_lp_code,
tps_parameter_id, tps_parameter_lp_code,
description,
created_by, creation_date,
last_updated_by, last_update_date,
last_update_login
)
VALUES
(
p_layer_provider_code, p_parameter_mapping_id,
p_layer_header_id,
p_program_unit_parameter_id, p_program_unit_param_lp_code,
p_tps_parameter_id, p_tps_parameter_lp_code,
p_description,
l_user_id, SYSDATE,
l_user_id, SYSDATE,
l_login_id
);
END insert_row;
PROCEDURE NAME: update_row
PURPOSE: Updates a record into VEA_PARAMETER_MAPPINGS table
========================================================================*/
PROCEDURE
update_row
(
p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
p_description IN vea_parameter_mappings.description%TYPE
)
IS
--{
l_api_name CONSTANT VARCHAR2(30) := 'update_row';
UPDATE vea_parameter_mappings
SET program_unit_parameter_id = p_program_unit_parameter_id,
program_unit_param_lp_code = p_program_unit_param_lp_code,
layer_header_id = p_layer_header_id,
tps_parameter_id = p_tps_parameter_id,
tps_parameter_lp_code = p_tps_parameter_lp_code,
description = p_description,
last_updated_by = l_user_id,
last_update_date = SYSDATE,
last_update_login = l_login_id
WHERE layer_provider_code = p_layer_provider_code
AND parameter_mapping_id = p_parameter_mapping_id;
END update_row;
PROCEDURE NAME: delete_rows
PURPOSE: Deletes all parameter mappings for the specified layer header.
========================================================================*/
PROCEDURE
delete_rows
(
p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE
)
IS
--{
l_api_name CONSTANT VARCHAR2(30) := 'delete_rows';
DELETE vea_parameter_mappings
WHERE layer_provider_code = p_layer_provider_code
AND layer_header_id = p_layer_header_id;
END delete_rows;
It inserts/updates a record in VEA_PARAMETER_MAPPINGS table.
========================================================================*/
PROCEDURE
process
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_id OUT NOCOPY vea_parameter_mappings.parameter_mapping_id%TYPE,
p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
p_description IN vea_parameter_mappings.description%TYPE,
p_id IN vea_parameter_mappings.parameter_mapping_id%TYPE := NULL,
p_program_unit_parameter_name IN vea_parameters.name%TYPE,
p_tps_parameter_name IN vea_parameters.name%TYPE
)
IS
--{
l_api_name CONSTANT VARCHAR2(30) := 'process';
SELECT parameter_mapping_id
FROM vea_parameter_mappings
WHERE layer_provider_code = p_layer_provider_code
--AND parameter_mapping_id = p_parameter_mapping_id;
SELECT NVL( p_id, vea_parameter_mappings_s.NEXTVAL )
INTO l_parameter_mapping_id
FROM DUAL;
SELECT vea_parameter_mappings_s.NEXTVAL
INTO l_parameter_mapping_id
FROM DUAL;
insert_row
(
p_layer_provider_code => p_layer_provider_code,
p_parameter_mapping_id => l_parameter_mapping_id,
p_layer_header_id => l_layer_header_id,
p_program_unit_parameter_id => l_program_unit_parameter_id,
p_program_unit_param_lp_code => p_program_unit_param_lp_code,
p_tps_parameter_id => l_tps_parameter_id,
p_tps_parameter_lp_code => p_tps_parameter_lp_code,
p_description => p_description
);
update_row
(
p_layer_provider_code => p_layer_provider_code,
p_parameter_mapping_id => l_parameter_mapping_id,
p_layer_header_id => l_layer_header_id,
p_program_unit_parameter_id => l_program_unit_parameter_id,
p_program_unit_param_lp_code => p_program_unit_param_lp_code,
p_tps_parameter_id => l_tps_parameter_id,
p_tps_parameter_lp_code => p_tps_parameter_lp_code,
p_description => p_description
);