APPS.IGC_CC_MC_ACCT_LINES_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_LINES.CC_Acct_Line_Id%TYPE,
               p_Set_Of_Books_Id                 IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
               p_CC_Acct_Func_Amt                IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
               p_CC_Acct_Encmbrnc_Amt            IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
               p_Conversion_Type                 IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
               p_Conversion_Date                 IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
               p_Conversion_Rate                 IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,
               p_CC_Func_Withheld_Amt            IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE

              )

 IS

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

Line: 36

  CURSOR C IS SELECT Rowid FROM IGC_CC_MC_ACCT_LINES
               WHERE CC_Acct_Line_Id = p_CC_Acct_Line_Id;

Line: 41

     SAVEPOINT Insert_Row_Pvt ;

Line: 58

     INSERT INTO IGC_CC_MC_ACCT_LINES (
               CC_Acct_Line_Id,
               Set_Of_Books_Id,
               CC_Acct_Func_Amt,
               CC_Acct_Encmbrnc_Amt,
               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_Conversion_Type,
               p_Conversion_Date,
               p_Conversion_Rate,
               p_cc_func_withheld_amt
         );

Line: 97

  ROLLBACK TO Insert_Row_Pvt ;

Line: 104

  ROLLBACK TO Insert_Row_Pvt ;

Line: 111

  ROLLBACK TO Insert_Row_Pvt ;

Line: 122

END Insert_Row;

Line: 152

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

Line: 182

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

Line: 265

                       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_LINES.CC_Acct_Line_Id%TYPE,
                p_Set_Of_Books_Id                 IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
                p_CC_Acct_Func_Amt                IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
                p_CC_Acct_Encmbrnc_Amt            IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
                p_Conversion_Type                 IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
                p_Conversion_Date                 IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
                p_Conversion_Rate                 IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,
                p_CC_Func_Withheld_Amt            IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE
) IS

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

Line: 292

  SAVEPOINT Update_Row_Pvt ;

Line: 309

  UPDATE IGC_CC_MC_ACCT_LINES
  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,
                     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: 335

  ROLLBACK TO Update_Row_Pvt ;

Line: 342

  ROLLBACK TO Update_Row_Pvt ;

Line: 349

  ROLLBACK TO Update_Row_Pvt ;

Line: 360

END Update_Row;

Line: 363

                       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: 386

SAVEPOINT Delete_Row_Pvt ;

Line: 403

DELETE FROM IGC_CC_MC_ACCT_LINES
WHERE rowid = p_Rowid;

Line: 421

  ROLLBACK TO Delete_Row_Pvt ;

Line: 428

  ROLLBACK TO Delete_Row_Pvt ;

Line: 435

  ROLLBACK TO Delete_Row_Pvt ;

Line: 447

END Delete_Row;