APPS.PJI_CM_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 77

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;

Line: 84

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;

Line: 153

		       ,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;

Line: 177

         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);

Line: 195

/* Commented out ,if delete functionality is added it can  be uncommented
       delete from PJI_MT_MEASURES_TL
  where measure_id = l_itd_measure_id;

Line: 199

  delete from PJI_MT_MEASURES_B
  where measure_id = l_itd_measure_id;

Line: 208

	       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);

Line: 232

       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);

Line: 250

/* Commented out ,if delete functionality is added it can  be uncommented
       delete from PJI_MT_MEASURES_TL
  where measure_id = l_ptd_measure_id;

Line: 254

  delete from PJI_MT_MEASURES_B
  where measure_id = l_ptd_measure_id;

Line: 263

	       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);

Line: 287

         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);

Line: 310

	       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);

Line: 335

         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);

Line: 358

	       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);