The following lines contain the word 'select', 'insert', 'update' or 'delete':
insert_process_parameter
Description
This particular procedure is used to insert parameter for an resource
Parameters
p_process_param_rec.batchstep_resource_id OR
(p_plant_code,p_batch_no,p_batchstep_no,p_activity,p_resource,p_parameter ) to uniquely
identify an process parameter
p_process_param_rec gme_process_parameters%ROWTYPE - details of the process parameter
x_return_status reflects return status of the API
=============================================================================================*/
PROCEDURE insert_process_parameter (
p_batch_no IN VARCHAR2
,p_org_code IN VARCHAR2
,p_validate_flexfields IN VARCHAR2
,p_batchstep_no IN NUMBER
,p_activity IN VARCHAR2
,p_parameter IN VARCHAR2
,p_process_param_rec IN gme_process_parameters%ROWTYPE
,x_process_param_rec OUT NOCOPY gme_process_parameters%ROWTYPE
,x_return_status OUT NOCOPY VARCHAR2)
IS
CURSOR cur_validate_batch_type (v_resource_id NUMBER)
IS
SELECT 1
FROM gme_batch_header b, gme_batch_step_resources r
WHERE b.batch_id = r.batch_id
AND r.batchstep_resource_id = v_resource_id
AND b.batch_type = 10;
SELECT parameter_id, parameter_type, minimum_value, maximum_value
,units
FROM gmp_process_parameters
WHERE parameter_name = v_parameter AND delete_mark = 0;
SELECT 1
FROM gmp_parameter_values
WHERE parameter_id = v_parameter_id AND parameter_value = v_value;
l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_PROCESS_PARAMETER';
gme_debug.put_line ('Calling public Insert process parameters Row');
gme_debug.put_line ('call insert ' || x_return_status);
Replaced the call to gme_api_process_parameters.insert_process_param
with gme_process_parameters_dbl.insert_row
*/
IF NOT gme_process_parameters_dbl.insert_row
(p_process_parameters => l_process_param_rec
,x_process_parameters => x_process_param_rec) THEN
RAISE fnd_api.g_exc_error;
END insert_process_parameter;
update_process_parameter
Description
This particular procedure is used to insert parameter for an resource
Parameters
p_process_param_rec.batchstep_resource_id OR
(p_plant_code,p_batch_no,p_batchstep_no,p_activity,p_parameter ) to uniquely
identify an process parameter
p_process_param_rec gme_process_parameters%ROWTYPE - details of the process parameter
x_return_status reflects return status of the API
=============================================================================================*/
PROCEDURE update_process_parameter (
p_batch_no IN VARCHAR2 := NULL
,p_org_code IN VARCHAR2 := NULL
,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
,p_batchstep_no IN NUMBER := NULL
,p_activity IN VARCHAR2 := NULL
,p_parameter IN VARCHAR2 := NULL
,p_process_param_rec IN gme_process_parameters%ROWTYPE
,x_process_param_rec OUT NOCOPY gme_process_parameters%ROWTYPE
,x_return_status OUT NOCOPY VARCHAR2)
IS
CURSOR cur_validate_parameter (v_proc_param_id NUMBER)
IS
SELECT batchstep_id, batch_id
FROM gme_process_parameters
WHERE process_param_id = v_proc_param_id;
SELECT 1
FROM gme_batch_header b, gme_process_parameters p
WHERE b.batch_id = p.batch_id
AND p.process_param_id = v_proc_param_id
AND b.batch_type = 10;
SELECT parameter_type
FROM gmp_process_parameters
WHERE parameter_id = v_parameter_id AND delete_mark = 0;
SELECT parameter_value
FROM gmp_parameter_values
WHERE parameter_id = v_parameter_id;
update_param_failed EXCEPTION;
l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_PROCESS_PARAMETER';
l_field_updated BOOLEAN := FALSE;
gme_debug.put_line ('Calling public update process parameters Row');
l_field_updated := TRUE;
l_field_updated := TRUE;
IF NOT (l_field_updated) THEN
gme_common_pvt.log_message ('GME_NO_CHANGE_TO_UPD');
/* Replace the call to gme_api_process_parameters.update_process_param
with gme_process_parameters_dbl.update_row
*/
IF NOT gme_process_parameters_dbl.update_row
(p_process_parameters => l_process_param_rec) THEN
RAISE fnd_api.g_exc_error;
WHEN val_pro_param_failed OR update_param_failed THEN
x_return_status := l_return_status;
END update_process_parameter;
delete_process_parameter
Description
This particular procedure is used to insert parameter for an resource
Parameters
p_process_param_rec.batchstep_resource_id OR
(p_plant_code,p_batch_no,p_batchstep_no,p_activity,p_parameter ) to uniquely
identify an process parameter
p_process_param_rec gme_process_parameters%ROWTYPE - details of the process parameter
x_return_status reflects return status of the API
=============================================================================================*/
PROCEDURE delete_process_parameter (
p_batch_no IN VARCHAR2
,p_org_code IN VARCHAR2
,p_batchstep_no IN NUMBER
,p_activity IN VARCHAR2
,p_parameter IN VARCHAR2
,p_process_param_rec IN gme_process_parameters%ROWTYPE
,x_return_status OUT NOCOPY VARCHAR2)
IS
CURSOR cur_validate_parameter (v_proc_param_id NUMBER)
IS
SELECT batchstep_id, batch_id
FROM gme_process_parameters
WHERE process_param_id = v_proc_param_id;
SELECT 1
FROM gme_batch_header b, gme_process_parameters p
WHERE b.batch_id = p.batch_id
AND p.process_param_id = v_proc_param_id
AND b.batch_type = 10;
SELECT batch_status
FROM gme_batch_header
WHERE batch_id = v_batch_id;
delete_param_failed EXCEPTION;
l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_PROCESS_PARAMETER';
gme_debug.put_line ('Calling public delete process parameters Row');
/* Replace the call to gme_api_process_parameters.delete_process_param
with gme_process_parameters_dbl.delete_row
*/
IF NOT gme_process_parameters_dbl.delete_row
(p_process_parameters => l_process_param_rec) THEN
RAISE fnd_api.g_exc_error;
WHEN val_pro_param_failed OR delete_param_failed THEN
x_return_status := l_return_status;
END delete_process_parameter;
SELECT COUNT (*)
FROM gme_batch_step_activities a, gme_batch_step_resources r
WHERE a.batch_id = r.batch_id
AND a.batchstep_id = r.batchstep_id
AND a.batchstep_activity_id = r.batchstep_activity_id
AND a.batch_id = v_batch_id
AND a.batchstep_id = v_step_id
AND a.activity = v_activity
AND r.resources = v_resource;
SELECT batchstep_activity_id
FROM gme_batch_step_activities
WHERE batchstep_id = v_step_id
AND batch_id = v_batch_id
AND activity = v_activity;
SELECT batchstep_resource_id
FROM gme_batch_step_resources
WHERE batchstep_activity_id = v_activity_id
AND resources = v_resource;
SELECT parameter_id
FROM gmp_process_parameters
WHERE parameter_name = v_parameter AND delete_mark = 0;
SELECT process_param_id
FROM gme_process_parameters p, gmp_process_parameters l
WHERE p.parameter_id = l.parameter_id
AND p.batchstep_resource_id = v_resource_id
AND l.parameter_name = v_parameter
AND l.delete_mark = 0;