The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT measure_formula
FROM pji_mt_measure_sets_b
WHERE measure_source = p_measure_source
AND measure_set_type = 'CUSTOM_CALC'
ORDER BY measure_set_code;
SELECT db_column_name
FROM pji_mt_measure_sets_b
WHERE measure_source = p_measure_source
AND db_column_name IS NOT NULL
AND measure_set_type = 'SEEDED'
AND measure_set_code NOT IN ('PPF_MSR_ACWP')
ORDER BY measure_set_code;
,p_last_update_date IN pji_mt_measures_b.last_update_date%TYPE
,p_last_updated_by IN pji_mt_measures_b.last_updated_by%TYPE
,p_creation_date IN pji_mt_measures_b.creation_date%TYPE
,p_created_by IN pji_mt_measures_b.created_by%TYPE
,p_last_update_Login IN pji_mt_measures_b.last_update_Login%TYPE
,X_return_status OUT NOCOPY VARCHAR2
,X_msg_data OUT NOCOPY VARCHAR2
,X_msg_count OUT NOCOPY NUMBER
) AS
l_return_status VARCHAR2(1) :=Fnd_Api.G_RET_STS_SUCCESS;
UPDATE Pji_Mt_Measures_Tl
SET Name = p_itd_name,
Last_Update_Date =p_last_update_date,
Last_Updated_By = p_last_updated_by,
Last_Update_Login = p_last_update_login,
Source_Lang = USERENV('Lang')
WHERE Measure_Id = p_itd_measure_id
AND USERENV('Lang') IN (LANGUAGE, Source_Lang);
/* Commented out ,if delete functionality is added it can be uncommented
delete from PJI_MT_MEASURES_TL
where measure_id = l_itd_measure_id;
delete from PJI_MT_MEASURES_B
where measure_id = l_itd_measure_id;
Pji_Mt_Measures_Pkg.INSERT_ROW(
X_rowid =>l_rowid,
X_measure_id =>l_itd_measure_id ,
X_measure_set_code =>p_measure_set_code,
X_measure_code =>l_measure_set_code||'_ITD',
X_xtd_type =>'ITD',
X_pl_sql_api =>NULL,
X_object_version_number =>1,
X_name =>p_itd_name,
X_description =>p_itd_name,
X_last_update_date =>p_last_update_date,
X_last_updated_by =>p_last_updated_by,
X_creation_date =>p_creation_date,
X_created_by =>p_created_by,
X_last_update_Login =>p_last_update_Login,
X_return_status =>l_return_status,
X_msg_data =>l_msg_data,
X_msg_count =>l_msg_count);
UPDATE Pji_Mt_Measures_Tl
SET Name = p_ptd_name,
Last_Update_Date =p_last_update_date,
Last_Updated_By = p_last_updated_by,
Last_Update_Login = p_last_update_login,
Source_Lang = USERENV('Lang')
WHERE Measure_Id = p_ptd_measure_id
AND USERENV('Lang') IN (LANGUAGE, Source_Lang);
/* Commented out ,if delete functionality is added it can be uncommented
delete from PJI_MT_MEASURES_TL
where measure_id = l_ptd_measure_id;
delete from PJI_MT_MEASURES_B
where measure_id = l_ptd_measure_id;
Pji_Mt_Measures_Pkg.INSERT_ROW(
X_rowid =>l_rowid,
X_measure_id =>l_ptd_measure_id ,
X_measure_set_code =>p_measure_set_code,
X_measure_code =>l_measure_set_code||'_PTD',
X_xtd_type =>'PTD',
X_pl_sql_api =>NULL,
X_object_version_number =>1,
X_name =>p_ptd_name,
X_description =>p_ptd_name,
X_last_update_date =>p_last_update_date,
X_last_updated_by =>p_last_updated_by,
X_creation_date =>p_creation_date,
X_created_by =>p_created_by,
X_last_update_Login =>p_last_update_Login,
X_return_status =>l_return_status,
X_msg_data =>l_msg_data,
X_msg_count =>l_msg_count);
UPDATE Pji_Mt_Measures_Tl
SET Name = p_qtd_name,
Last_Update_Date =p_last_update_date,
Last_Updated_By = p_last_updated_by,
Last_Update_Login = p_last_update_login,
Source_Lang = USERENV('Lang')
WHERE Measure_Id = p_qtd_measure_id
AND USERENV('Lang') IN (LANGUAGE, Source_Lang);
Pji_Mt_Measures_Pkg.INSERT_ROW(
X_rowid =>l_rowid,
X_measure_id =>l_qtd_measure_id ,
X_measure_set_code =>p_measure_set_code,
X_measure_code =>l_measure_set_code||'_QTD',
X_xtd_type =>'QTD',
X_pl_sql_api =>NULL,
X_object_version_number =>1,
X_name =>p_qtd_name,
X_description =>p_qtd_name,
X_last_update_date =>p_last_update_date,
X_last_updated_by =>p_last_updated_by,
X_creation_date =>p_creation_date,
X_created_by =>p_created_by,
X_last_update_Login =>p_last_update_Login,
X_return_status =>l_return_status,
X_msg_data =>l_msg_data,
X_msg_count =>l_msg_count);
UPDATE Pji_Mt_Measures_Tl
SET Name = p_ytd_name,
Last_Update_Date =p_last_update_date,
Last_Updated_By = p_last_updated_by,
Last_Update_Login = p_last_update_login,
Source_Lang = USERENV('Lang')
WHERE Measure_Id = p_ytd_measure_id
AND USERENV('Lang') IN (LANGUAGE, Source_Lang);
Pji_Mt_Measures_Pkg.INSERT_ROW(
X_rowid =>l_rowid,
X_measure_id =>l_ytd_measure_id ,
X_measure_set_code =>p_measure_set_code,
X_measure_code =>l_measure_set_code||'_YTD',
X_xtd_type =>'YTD',
X_pl_sql_api =>NULL,
X_object_version_number =>1,
X_name =>p_ytd_name,
X_description =>p_ytd_name,
X_last_update_date =>p_last_update_date,
X_last_updated_by =>p_last_updated_by,
X_creation_date =>p_creation_date,
X_created_by =>p_created_by,
X_last_update_Login =>p_last_update_Login,
X_return_status =>l_return_status,
X_msg_data =>l_msg_data,
X_msg_count =>l_msg_count);