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.IGC_CC_ACTIONS_PKG SQL Statements

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

Line: 11


                         PROCEDURE Insert_Row
   ===============================================================================*/


  PROCEDURE Insert_Row(
                 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,
                 p_Rowid                  IN OUT NOCOPY   VARCHAR2,
                 p_CC_Header_Id                    IGC_CC_ACTIONS.CC_Header_Id%TYPE,
                 p_CC_Action_Version_Num           IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
                 p_CC_Action_Type                  IGC_CC_ACTIONS.CC_Action_Type %TYPE,
                 p_CC_Action_State                 IGC_CC_ACTIONS.CC_Action_State%TYPE,
                 p_CC_Action_Ctrl_Status           IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
                 p_CC_Action_Apprvl_Status         IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
                 p_CC_Action_Notes                 IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
                 p_Last_Update_Date                IGC_CC_ACTIONS.Last_Update_Date%TYPE,
	         p_Last_Updated_By                 IGC_CC_ACTIONS.Last_Updated_By%TYPE,
	         p_Last_Update_Login               IGC_CC_ACTIONS.Last_Update_Login%TYPE,
	         p_Creation_Date                   IGC_CC_ACTIONS.Creation_Date%TYPE,
                 p_Created_By                      IGC_CC_ACTIONS.Created_By%TYPE
                 ) IS

    l_api_name            CONSTANT VARCHAR2(30)   := 'Insert_Row';

Line: 42


       SELECT Rowid
       FROM IGC_CC_ACTIONS
       WHERE CC_Header_Id = p_CC_Header_Id;

Line: 47


       SELECT NVL(MAX(CC_Action_Num),0)
       FROM IGC_CC_ACTIONS
       WHERE CC_Header_Id = p_CC_Header_Id;

Line: 53


     SAVEPOINT Insert_Row_Pvt ;

Line: 78


       INSERT INTO IGC_CC_ACTIONS(
                       CC_Header_Id,
                       CC_Action_Num,
                       CC_Action_Version_Num,
                       CC_Action_Type,
                       CC_Action_State,
                       CC_Action_Ctrl_Status,
                       CC_Action_Apprvl_Status,
                       CC_Action_Notes,
		       Last_Update_Date,
		       Last_Updated_By,
		       Last_Update_Login,
		       Creation_Date,
                       Created_By

             ) VALUES (
                       p_CC_Header_Id,
                       l_CC_Action_Num + 1,
                       p_CC_Action_Version_Num,
                       p_CC_Action_Type,
                       p_CC_Action_State,
                       p_CC_Action_Ctrl_Status,
                       p_CC_Action_Apprvl_Status,
                       p_CC_Action_Notes,
		       p_Last_Update_Date,
		       p_Last_Updated_By,
		       p_Last_Update_Login,
		       p_Creation_Date,
                       p_Created_By

                      );

Line: 129


    ROLLBACK TO Insert_Row_Pvt ;

Line: 136


    ROLLBACK TO Insert_Row_Pvt ;

Line: 143


    ROLLBACK TO Insert_Row_Pvt ;

Line: 154


  END Insert_Row;

Line: 181


                 p_Last_Update_Date                IGC_CC_ACTIONS.Last_Update_Date%TYPE,
	         p_Last_Updated_By                 IGC_CC_ACTIONS.Last_Updated_By%TYPE,
	         p_Last_Update_Login               IGC_CC_ACTIONS.Last_Update_Login%TYPE,
	         p_Creation_Date                   IGC_CC_ACTIONS.Creation_Date%TYPE,
                 p_Created_By                      IGC_CC_ACTIONS.Created_By%TYPE,
                 X_row_locked                OUT NOCOPY   VARCHAR2
  ) IS

    l_api_name            CONSTANT VARCHAR2(30)   := 'Lock_Row';

Line: 194


        SELECT *
        FROM   IGC_CC_ACTIONS
        WHERE  Rowid = p_Rowid
        FOR UPDATE of CC_Header_Id NOWAIT;

Line: 226


      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 256


           AND (   (Recinfo.Last_Update_Date =  p_Last_Update_Date)
                OR (    (Recinfo.Last_Update_Date IS NULL)
                    AND (p_Last_Update_Date IS NULL)))
           AND (   (Recinfo.Last_Updated_By =  p_Last_Updated_By)
                OR (    (Recinfo.Last_Updated_BY IS NULL)
                    AND (p_Last_Updated_By IS NULL)))
           AND (   (Recinfo.Last_Update_Login =  p_Last_Update_Login)
                OR (    (Recinfo.Last_Update_Login IS NULL)
                    AND (p_Last_Update_Login IS NULL)))
           AND (   (Recinfo.Created_By =  p_Created_By)
                OR (    (Recinfo.Created_By IS NULL)
                    AND (p_Created_By IS NULL)))
           AND (   (Recinfo.Creation_Date =  p_Creation_Date)
                OR (    (Recinfo.Creation_Date IS NULL)
                    AND (p_Creation_Date IS NULL)))
      ) then
           null;

Line: 328


                         PROCEDURE Update_Row
   ===============================================================================*/


  PROCEDURE Update_Row(
                 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,
                 p_Rowid                  IN OUT NOCOPY   VARCHAR2,
                 p_CC_Header_Id                    IGC_CC_ACTIONS.CC_Header_Id%TYPE,
                 p_CC_Action_Num                   IGC_CC_ACTIONS.CC_Action_Num%TYPE,
                 p_CC_Action_Version_Num           IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
                 p_CC_Action_Type                  IGC_CC_ACTIONS.CC_Action_Type %TYPE,
                 p_CC_Action_State                 IGC_CC_ACTIONS.CC_Action_State%TYPE,
                 p_CC_Action_Ctrl_Status           IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
                 p_CC_Action_Apprvl_Status         IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
                 p_CC_Action_Notes                 IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
	         p_Last_Update_Date                IGC_CC_ACTIONS.Last_Update_Date%TYPE,
	         p_Last_Updated_By                 IGC_CC_ACTIONS.Last_Updated_By%TYPE,
	         p_Last_Update_Login               IGC_CC_ACTIONS.Last_Update_Login%TYPE,
	         p_Creation_Date                   IGC_CC_ACTIONS.Creation_Date%TYPE,
                 p_Created_By                      IGC_CC_ACTIONS.Created_By%TYPE
            ) IS

  l_api_name            CONSTANT VARCHAR2(30)   := 'Update_Row';

Line: 361


    SAVEPOINT Update_Row_Pvt ;

Line: 378


    UPDATE IGC_CC_ACTIONS
    SET

                       CC_Header_Id              =       p_CC_Header_Id,
                       CC_Action_Num             =       p_CC_Action_Num,
                       CC_Action_Version_Num     =       p_CC_Action_Version_Num,
                       CC_Action_Type            =       p_CC_Action_Type,
                       CC_Action_State           =       p_CC_Action_State,
                       CC_Action_Ctrl_Status     =       p_CC_Action_Ctrl_Status,
                       CC_Action_Apprvl_Status   =       p_CC_Action_Apprvl_Status,
                       CC_Action_Notes           =       p_CC_Action_Notes,
		       Last_Update_Date          =       p_Last_Update_Date,
		       Last_Updated_By           =       p_Last_Updated_By,
		       Last_Update_Login         =       p_Last_Update_Login,
		       Creation_Date             =       p_Creation_Date,
                       Created_By                =       p_Created_By
    WHERE rowid = p_Rowid;

Line: 410


    ROLLBACK TO Update_Row_Pvt ;

Line: 417


    ROLLBACK TO Update_Row_Pvt ;

Line: 424


    ROLLBACK TO Update_Row_Pvt ;

Line: 435


  END Update_Row;

Line: 439


                         PROCEDURE Delete_Row
   ===============================================================================*/

  PROCEDURE Delete_Row(
                      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,
                      p_Rowid                              VARCHAR2
) IS

  l_api_name                CONSTANT VARCHAR2(30)   := 'Delete_Row';

Line: 462


    SAVEPOINT Delete_Row_Pvt ;

Line: 479


    DELETE FROM IGC_CC_ACTIONS
    WHERE rowid = p_Rowid;

Line: 496


    ROLLBACK TO Delete_Row_Pvt ;

Line: 503


    ROLLBACK TO Delete_Row_Pvt ;

Line: 510


    ROLLBACK TO Delete_Row_Pvt ;

Line: 521


  END Delete_Row;