APPS.AP_PBATCH_SET_HEADER_PKG SQL Statements

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

Line: 4

PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY   VARCHAR2,
                     X_Batch_Set_Name                   VARCHAR2,
                     X_Batch_Set_Id            IN OUT NOCOPY   NUMBER,
                     X_Last_Update_Date                 DATE,
                     X_Last_Updated_By                  NUMBER,
                     X_Last_Update_Login                NUMBER DEFAULT NULL,
                     X_Creation_Date                    DATE DEFAULT NULL,
                     X_Created_By                       NUMBER DEFAULT NULL,
                     X_Inactive_Date                    DATE DEFAULT NULL,
		     X_calling_sequence	      IN	VARCHAR2
  ) IS
    l_Batch_Set_Id           NUMBER;

Line: 16

    CURSOR C IS SELECT rowid FROM ap_pbatch_sets
                 WHERE batch_set_id = l_Batch_Set_Id;

Line: 25

       'AP_PBATCH_SET_HEADER_PKG.INSERT_ROW<-'||X_Calling_Sequence;

Line: 29

       select ap_pbatch_sets_s.nextval
       into l_batch_set_id
       from sys.dual;

Line: 33

       debug_info := 'Insert into ap_pbatch_sets';

Line: 34

       INSERT INTO ap_pbatch_sets(
              batch_set_name,
              batch_set_id,
              inactive_date,
              last_update_date,
              last_updated_by,
              last_update_login,
              creation_date,
              created_by
             ) VALUES (
              X_Batch_Set_Name,
              l_Batch_Set_Id,
              X_Inactive_Date,
              X_Last_Update_Date,
              X_Last_Updated_By,
              X_Last_Update_Login,
              X_Creation_Date,
              X_Created_By
              );

Line: 79

  END Insert_Row;

Line: 89

        SELECT *
        FROM   ap_pbatch_sets
        WHERE  rowid = X_Rowid
        FOR UPDATE of Batch_Set_Name NOWAIT;

Line: 109

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

Line: 143

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Batch_Set_Name                 VARCHAR2,
                       X_Batch_Set_Id                   NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER DEFAULT NULL,
                       X_Creation_Date                  DATE DEFAULT NULL,
                       X_Created_By                     NUMBER DEFAULT NULL,
                       X_Inactive_Date                  DATE DEFAULT NULL,
		       X_calling_sequence	IN	VARCHAR2

  ) IS
    current_calling_sequence VARCHAR2(2000);

Line: 161

     'AP_PBATCH_SET_HEADER_PKG.UPDATE_ROW<-'||X_Calling_Sequence;

Line: 163

    debug_info := 'Update ap_pbatch_sets';

Line: 164

    UPDATE ap_pbatch_sets
    SET
       batch_set_name                  =     X_Batch_Set_Name,
       batch_set_id                    =     X_Batch_Set_Id,
       inactive_date                   =     X_Inactive_Date,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By,
       last_update_login               =     X_Last_Update_Login
    WHERE rowid = X_Rowid;

Line: 189

  END Update_Row;

Line: 192

   PROCEDURE Delete_Row(X_Rowid 				VARCHAR2,
		       X_calling_sequence	IN	VARCHAR2) IS

    current_calling_sequence VARCHAR2(2000);

Line: 202

     'AP_PBATCH_SET_HEADER_PKG.DELETE_ROW<-'||X_Calling_Sequence;

Line: 204

    debug_info := 'Delete from ap_pbatch_sets';

Line: 205

    DELETE FROM ap_pbatch_sets
    WHERE rowid = X_Rowid;

Line: 222

  END Delete_Row;