eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_MT_MEASURE_SETS_PKG SQL Statements

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

Line: 18


    SELECT object_version_number
    FROM   pji_mt_measure_sets_B
    WHERE  measure_set_code = p_measure_set_code
    FOR UPDATE OF measure_set_code NOWAIT;

Line: 31


    Fnd_Message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 47


PROCEDURE DELETE_ROW (
  p_measure_set_code IN 	pji_mt_measure_sets_b.measure_set_code%TYPE
) IS
BEGIN
  DELETE FROM pji_mt_measure_sets_TL
  WHERE measure_set_code = p_measure_set_code;

Line: 58


  DELETE FROM pji_mt_measure_sets_b
  WHERE measure_set_code = p_measure_set_code;

Line: 64


END DELETE_ROW;

Line: 67


PROCEDURE Insert_Row (
 X_Rowid                           IN  OUT NOCOPY  ROWID,
 X_Measure_Set_Code                IN      pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
 X_Measure_Set_Type                IN      pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
 X_Measure_Format                  IN      pji_mt_measure_sets_b.Measure_Format%TYPE,
 X_DB_Column_Name                  IN      pji_mt_measure_sets_b.DB_Column_Name%TYPE,
 X_Object_Version_Number           IN      pji_mt_measure_sets_b.Object_Version_Number%TYPE,
 X_Name                            IN      pji_mt_measure_sets_Tl.Name%TYPE,
 X_Description                     IN      pji_mt_measure_sets_Tl.Description%TYPE,
 X_Last_Update_Date                IN      pji_mt_measure_sets_b.Last_Update_Date%TYPE,
 X_Last_Updated_by                 IN      pji_mt_measure_sets_b.Last_Updated_by%TYPE,
 X_Creation_Date                   IN      pji_mt_measure_sets_b.Creation_Date%TYPE,
 X_Created_By                      IN      pji_mt_measure_sets_b.Created_By%TYPE,
 X_Last_Update_Login               IN      pji_mt_measure_sets_b.Last_Update_Login%TYPE,
 X_Measure_Formula				   IN	   pji_mt_measure_sets_b.Measure_Formula%TYPE,
 X_Measure_Source				   IN	   pji_mt_measure_sets_b.Measure_Source%TYPE,
 X_Return_Status	           OUT NOCOPY      VARCHAR2,
 X_Msg_Data                        OUT NOCOPY      VARCHAR2,
 X_Msg_Count                       OUT NOCOPY      NUMBER
)IS

   CURSOR C IS SELECT ROWID FROM pji_mt_measure_sets_b
    WHERE measure_set_code = x_measure_set_code;

Line: 108


        Pa_Debug.g_err_stage:= 'Inserting record in pji_mt_measure_sets_B '||X_Measure_Set_Code;

Line: 113


   INSERT INTO pji_mt_measure_sets_B
   (
    Measure_Set_Code
    , Measure_Set_Type
    , Measure_Format
    , Db_Column_Name
    , Object_Version_Number
    , Creation_Date
    , Last_Update_Date
    , Last_Updated_By
    , Created_By
    , Last_Update_Login
	, Measure_Formula
	, Measure_Source )
   VALUES
   (
    X_Measure_Set_Code
    , X_Measure_Set_Type
    , X_Measure_Format
    , X_Db_Column_Name
    , X_Object_Version_Number
    , X_Creation_Date
    , X_Last_Update_Date
    , X_Last_Updated_By
    , X_Created_By
    , X_Last_Update_Login
	, X_Measure_Formula
	, X_Measure_Source
   );

Line: 144


        Pa_Debug.g_err_stage:= 'Inserting record in pji_mt_measure_sets_tl '||X_Measure_Set_Code;

Line: 148


   INSERT INTO pji_mt_measure_sets_tl
   (
       Measure_Set_Code,
       Name,
       Description,
       Last_Update_Date,
       Last_Updated_By,
       Creation_Date,
       Created_By,
       Last_Update_Login,
       LANGUAGE,
       Source_Lang
   )
   SELECT
       X_Measure_Set_Code,
       X_Name,
       X_Description,
       X_Last_Update_Date,
       X_Last_Updated_By,
       X_Creation_Date,
       X_Created_By,
       X_Last_Update_Login,
       L.Language_Code,
       USERENV('Lang')
   FROM  Fnd_Languages L
   WHERE L.Installed_Flag IN ('I', 'B')
   AND NOT EXISTS
       (SELECT NULL FROM pji_mt_measure_sets_tl T
        WHERE T.measure_set_code = X_Measure_Set_Code
        AND T.LANGUAGE = L.Language_Code);

Line: 179


Hr_Utility.trace('after inserting t row');

Line: 189


           Pa_Debug.g_err_stage:= 'Rowid could not be fetched after Inserting for '||X_Measure_Set_Code;

Line: 232


         ,p_procedure_name  => 'Insert Row'
         ,p_error_text      => x_msg_data);

Line: 244


 END Insert_Row;

Line: 247


 PROCEDURE Update_Row (
     X_Measure_Set_Code                IN      pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
     X_Measure_Set_Type                IN      pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
     X_Measure_Format                  IN      pji_mt_measure_sets_b.Measure_Format%TYPE,
     X_DB_Column_Name                  IN      pji_mt_measure_sets_b.DB_Column_Name%TYPE,
     X_Object_Version_Number           IN      pji_mt_measure_sets_b.Object_Version_Number%TYPE,
     X_Name                            IN      pji_mt_measure_sets_Tl.Name%TYPE,
     X_Description                     IN      pji_mt_measure_sets_Tl.Description%TYPE,
     X_Last_Update_Date                IN      pji_mt_measure_sets_b.Last_Update_Date%TYPE,
     X_Last_Updated_by                 IN      pji_mt_measure_sets_b.Last_Updated_by%TYPE,
     X_Last_Update_Login               IN      pji_mt_measure_sets_b.Last_Update_Login%TYPE,
	 X_Measure_Formula				   IN	   pji_mt_measure_sets_b.Measure_Formula%TYPE,
	 X_Measure_Source				   IN	   pji_mt_measure_sets_b.Measure_Source%TYPE,
     X_Return_Status	               OUT NOCOPY     VARCHAR2,
     X_Msg_Data                        OUT NOCOPY     VARCHAR2,
     X_Msg_Count                       OUT NOCOPY     NUMBER
  ) IS

     l_return_status          VARCHAR2(1) := NULL;

Line: 271


	 l_update_conflict EXCEPTION;

Line: 288


		 SELECT object_version_number
		 INTO l_object_version_number
		 FROM pji_mt_measure_sets_B
		 WHERE measure_set_code = X_measure_set_code FOR UPDATE;

Line: 295


             Pa_Debug.g_err_stage:= 'select error while checking object version number in pji_mt_measure_sets_B '||X_measure_set_code;

Line: 303


		 	Fnd_Message.set_name('PJI', 'PJI_CM_UPDATE_CONFLICT');

Line: 305


		 	RAISE l_update_conflict;

Line: 311


     UPDATE pji_mt_measure_sets_B
     SET
            Measure_Set_Code = X_Measure_Set_Code
            , Measure_Set_Type = X_Measure_Set_Type
            , Measure_Format = X_Measure_Format
            , Db_Column_Name = X_Db_Column_Name
            , Object_Version_Number = l_object_version_number
            , Last_Update_Date = X_Last_Update_Date
            , Last_Updated_By = X_Last_Updated_By
            , Last_Update_Login = X_Last_Update_Login
			, Measure_Formula = X_Measure_Formula
			, Measure_Source = X_Measure_Source
            WHERE measure_set_code = X_measure_set_code;

Line: 339


     UPDATE pji_mt_measure_sets_tl
     SET    Name = X_Name,
            Description = X_Description,
            Last_Update_Date = X_Last_Update_Date,
            Last_Updated_By = X_Last_Updated_By,
            Last_Update_Login = X_Last_Update_Login,
            Source_Lang = USERENV('Lang')
     WHERE  Measure_Set_Code = X_Measure_Set_Code
     AND    USERENV('Lang') IN (LANGUAGE, Source_Lang);

Line: 392


       ,p_procedure_name  => 'UPDATE_ROW'
       ,p_error_text      => x_msg_data);

Line: 404


END Update_Row;

Line: 438


  Pji_Mt_Measure_Sets_Pkg.Update_Row (
     X_Measure_Set_Code                   => X_Measure_Set_Code
     , X_Measure_Set_Type                 => X_Measure_Set_Type
     , X_Measure_Format                   => X_Measure_Format
     , X_DB_Column_Name                   => X_DB_Column_Name
     , X_Object_Version_Number            => NULL
     , X_Name                             => X_Name
     , X_Description                      => X_Description
     , X_Last_Update_Date                 => SYSDATE
     , X_Last_Updated_By                  => User_Id
     , X_Last_Update_Login                => 0
	 , X_Measure_Formula				  => X_Measure_Formula
	 , X_Measure_Source					  => X_Measure_Source
     , X_Return_Status	                  => l_Return_Status
     , X_Msg_Data                         => l_Msg_Data
     , X_Msg_Count                        => l_Msg_Count);

Line: 457


	Hr_Utility.trace('Calling Insert row');

Line: 458


      Pji_Mt_Measure_Sets_Pkg.Insert_Row (
            X_Rowid                            => X_Rowid
          , X_Measure_Set_Code                 => X_Measure_Set_Code
          , X_Measure_Set_Type                 => X_Measure_Set_Type
          , X_Measure_Format                   => X_Measure_Format
          , X_DB_Column_Name                   => X_DB_Column_Name
          , X_Object_Version_Number            => 1
          , X_Name                             => X_Name
          , X_Description                      => X_Description
          , X_Last_Update_Date                 => SYSDATE
          , X_Last_Updated_By                  => User_Id
          , X_Creation_Date                    => SYSDATE
          , X_Created_By                       => User_Id
          , X_Last_Update_Login                => 0
		  , X_Measure_Formula				   => X_Measure_Formula
	 	  , X_Measure_Source				   => X_Measure_Source
          , X_Return_Status	                   => l_Return_Status
          , X_Msg_Data                         => l_Msg_Data
          , X_Msg_Count                        => l_Msg_Count);

Line: 486


        ,p_procedure_name  => 'UPDATE_ROW'
        ,p_error_text      => l_msg_data);

Line: 505


  DELETE FROM pji_mt_measure_sets_tl T
  WHERE NOT EXISTS
    (SELECT NULL
    FROM pji_mt_measure_sets_b B
    WHERE B.measure_set_code  = T.measure_set_code
    );

Line: 512


  UPDATE pji_mt_measure_sets_tl T SET (
      NAME,
      DESCRIPTION
    ) = (SELECT
      B.NAME,
      B.DESCRIPTION
    FROM pji_mt_measure_sets_tl B
    WHERE B.measure_set_code = T.measure_set_code
    AND B.LANGUAGE = T.SOURCE_LANG)
    WHERE (
      T.measure_set_code,
      T.LANGUAGE
  ) IN (SELECT
      SUBT.measure_set_code,
      SUBT.LANGUAGE
    FROM pji_mt_measure_sets_tl SUBB, pji_mt_measure_sets_tl SUBT
    WHERE SUBB.measure_set_code = SUBT.measure_set_code
    AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
    AND (SUBB.NAME <> SUBT.NAME
      OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION
      OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
      OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
  ));

Line: 536


   INSERT INTO pji_mt_measure_sets_tl(
    LAST_UPDATE_LOGIN,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    measure_set_code,
    NAME,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  )SELECT
    B.LAST_UPDATE_LOGIN,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.measure_set_code,
    B.NAME,
    B.DESCRIPTION,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  FROM pji_mt_measure_sets_tl B, FND_LANGUAGES L
  WHERE L.INSTALLED_FLAG IN ('I', 'B')
  AND B.LANGUAGE = USERENV('LANG')
  AND NOT EXISTS
    (SELECT NULL
    FROM pji_mt_measure_sets_tl T
    WHERE T.measure_set_code = B.measure_set_code
    AND T.LANGUAGE = L.LANGUAGE_CODE);

Line: 579


  UPDATE pji_mt_measure_sets_tl SET
    NAME = X_NAME,
    DESCRIPTION = X_DESCRIPTION,
    LAST_UPDATE_DATE  = SYSDATE,
    LAST_UPDATED_BY   = DECODE(X_OWNER, 'SEED', 1, 0),
    LAST_UPDATE_LOGIN = 0,
    SOURCE_LANG = USERENV('LANG')
  WHERE measure_set_code = x_measure_set_code
  AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG) ;