APPS.IGC_CC_MC_ACCT_LINE_HST_PKG SQL Statements

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

Line: 8

                       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_Acct_Line_Id                 IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
                p_Set_Of_Books_Id                 IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
                p_CC_Acct_Func_Amt                IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
                p_CC_Acct_Encmbrnc_Amt            IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
                p_cc_acct_version_num             IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
                p_cc_acct_version_action          IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
                p_Conversion_Type                 IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
                p_Conversion_Date                 IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
                p_Conversion_Rate                 IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE ,
                p_cc_func_withheld_amt            IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE
              )

 IS

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

Line: 38

        IS SELECT Rowid
           FROM   IGC_CC_MC_ACCT_LINE_HISTORY
           WHERE  CC_Acct_Line_Id = p_CC_Acct_Line_Id;

Line: 44

     SAVEPOINT Insert_Row_Pvt ;

Line: 66

     INSERT INTO IGC_CC_MC_ACCT_LINE_HISTORY (
               CC_Acct_Line_Id,
               Set_Of_Books_Id,
               CC_Acct_Func_Amt,
               CC_Acct_Encmbrnc_Amt,
               CC_Acct_version_num,
               CC_Acct_version_action,
               Conversion_Type,
               Conversion_Date,
               Conversion_Rate,
               cc_func_withheld_amt
           ) VALUES (
               p_CC_Acct_Line_Id,
               p_Set_Of_Books_Id,
               p_CC_Acct_Func_Amt,
               p_CC_Acct_Encmbrnc_Amt,
               p_CC_Acct_version_num,
               p_CC_Acct_version_action,
               p_Conversion_Type,
               p_Conversion_Date,
               p_Conversion_Rate,
               p_cc_func_withheld_amt
         );

Line: 121

     ROLLBACK TO Insert_Row_Pvt ;

Line: 132

     ROLLBACK TO Insert_Row_Pvt ;

Line: 142

     ROLLBACK TO Insert_Row_Pvt ;

Line: 155

END Insert_Row;

Line: 187

      SELECT *
      FROM   IGC_CC_MC_ACCT_LINE_HISTORY
      WHERE  rowid = p_Rowid
      FOR UPDATE of CC_Acct_Line_Id NOWAIT;

Line: 217

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

Line: 306

                       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_Acct_Line_Id                 IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
                p_Set_Of_Books_Id                 IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
                p_CC_Acct_Func_Amt                IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
                p_CC_Acct_Encmbrnc_Amt            IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
                p_cc_acct_version_num             IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
                p_cc_acct_version_action          IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
                p_Conversion_Type                 IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
                p_Conversion_Date                 IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
                p_Conversion_Rate                 IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE,
                p_cc_func_withheld_amt            IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE
) IS

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

Line: 335

  SAVEPOINT Update_Row_Pvt ;

Line: 352

  UPDATE IGC_CC_MC_ACCT_LINE_HISTORY
  SET
                     CC_Acct_Line_Id              =      p_CC_Acct_Line_Id,
                     Set_Of_Books_Id              =      p_Set_Of_Books_Id,
		     CC_Acct_Func_Amt             =      p_CC_Acct_Func_Amt,
                     CC_Acct_Encmbrnc_Amt         =      p_Cc_Acct_Encmbrnc_Amt,
                     CC_Acct_version_num          =      p_CC_Acct_version_num,
                     CC_Acct_version_action          =      p_CC_Acct_version_action,
                     Conversion_Type              =      p_Conversion_Type,
		     Conversion_Date              =      p_Conversion_Date,
		     Conversion_Rate              =      p_Conversion_Rate,
		     cc_func_withheld_amt         =      p_cc_func_withheld_amt
  WHERE rowid = p_Rowid;

Line: 380

  ROLLBACK TO Update_Row_Pvt ;

Line: 387

  ROLLBACK TO Update_Row_Pvt ;

Line: 394

  ROLLBACK TO Update_Row_Pvt ;

Line: 405

END Update_Row;

Line: 408

                       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                   IN OUT NOCOPY     VARCHAR2

 ) IS

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

Line: 431

SAVEPOINT Delete_Row_Pvt ;

Line: 448

DELETE FROM IGC_CC_MC_ACCT_LINE_HISTORY
WHERE rowid = p_Rowid;

Line: 466

  ROLLBACK TO Delete_Row_Pvt ;

Line: 473

  ROLLBACK TO Delete_Row_Pvt ;

Line: 480

  ROLLBACK TO Delete_Row_Pvt ;

Line: 492

END Delete_Row;