APPS.OKE_FUNDING_POOLS_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_Funding_Pool_Id		      NUMBER,
                     X_Name			      VARCHAR2,
                     X_Description                    VARCHAR2,
                     X_Currency_Code	  	      VARCHAR2,
                     X_Contact_Person_Id              NUMBER,
                     X_Program_Id		      NUMBER,
                     X_Last_Update_Date               DATE,
                     X_Last_Updated_By                NUMBER,
                     X_Creation_Date                  DATE,
                     X_Created_By                     NUMBER,
                     X_Last_Update_Login              NUMBER,
                     X_Attribute_Category             VARCHAR2,
                     X_Attribute1                     VARCHAR2,
                     X_Attribute2                     VARCHAR2,
                     X_Attribute3                     VARCHAR2,
                     X_Attribute4                     VARCHAR2,
                     X_Attribute5                     VARCHAR2,
                     X_Attribute6                     VARCHAR2,
                     X_Attribute7                     VARCHAR2,
                     X_Attribute8                     VARCHAR2,
                     X_Attribute9                     VARCHAR2,
                     X_Attribute10                    VARCHAR2,
                     X_Attribute11                    VARCHAR2,
                     X_Attribute12                    VARCHAR2,
                     X_Attribute13                    VARCHAR2,
                     X_Attribute14                    VARCHAR2,
                     X_Attribute15                    VARCHAR2
  ) is

    cursor C is
    select rowid
    from   OKE_FUNDING_POOLS
    where  funding_pool_id = X_Funding_Pool_Id;

Line: 41

       insert into OKE_FUNDING_POOLS(
              funding_pool_id,
              name,
              description,
              contact_person_id,
              program_id,
              currency_code,
              last_update_date,
              last_updated_by,
              creation_date,
              created_by,
              last_update_login,
              attribute_category,
              attribute1,
              attribute2,
              attribute3,
              attribute4,
              attribute5,
              attribute6,
              attribute7,
              attribute8,
              attribute9,
              attribute10,
              attribute11,
              attribute12,
              attribute13,
              attribute14,
              attribute15
             ) VALUES (
              X_Funding_Pool_Id,
              X_Name,
              X_Description,
              X_Contact_Person_Id,
              X_Program_Id,
              X_Currency_Code,
              X_Last_Update_Date,
              X_Last_Updated_By,
              X_Creation_Date,
              X_Created_By,
              X_Last_Update_Login,
              X_Attribute_Category,
              X_Attribute1,
              X_Attribute2,
              X_Attribute3,
              X_Attribute4,
              X_Attribute5,
              X_Attribute6,
              X_Attribute7,
              X_Attribute8,
              X_Attribute9,
              X_Attribute10,
              X_Attribute11,
              X_Attribute12,
              X_Attribute13,
              X_Attribute14,
              X_Attribute15
             );

Line: 107

end Insert_Row;

Line: 135

    select funding_pool_id,
    	   name,
           description,
           contact_person_id,
           program_id,
           currency_code,
           attribute_category,
           attribute1,
           attribute2,
           attribute3,
           attribute4,
           attribute5,
           attribute6,
           attribute7,
           attribute8,
           attribute9,
           attribute10,
           attribute11,
           attribute12,
           attribute13,
           attribute14,
           attribute15
    from   OKE_FUNDING_POOLS
    where  funding_pool_id = X_Funding_Pool_Id
    for update of funding_pool_id nowait;

Line: 169

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

Line: 225

PROCEDURE Update_Row(X_Funding_Pool_Id		      NUMBER,
                     X_Name			      VARCHAR2,
                     X_Description                    VARCHAR2,
                     X_Contact_Person_Id              NUMBER,
                     X_Program_Id		      NUMBER,
                     X_Last_Update_Date               DATE,
                     X_Last_Updated_By                NUMBER,
                     X_Last_Update_Login              NUMBER,
                     X_Attribute_Category             VARCHAR2,
                     X_Attribute1                     VARCHAR2,
                     X_Attribute2                     VARCHAR2,
                     X_Attribute3                     VARCHAR2,
                     X_Attribute4                     VARCHAR2,
                     X_Attribute5                     VARCHAR2,
                     X_Attribute6                     VARCHAR2,
                     X_Attribute7                     VARCHAR2,
                     X_Attribute8                     VARCHAR2,
                     X_Attribute9                     VARCHAR2,
                     X_Attribute10                    VARCHAR2,
                     X_Attribute11                    VARCHAR2,
                     X_Attribute12                    VARCHAR2,
                     X_Attribute13                    VARCHAR2,
                     X_Attribute14                    VARCHAR2,
                     X_Attribute15                    VARCHAR2
  ) is

begin

    update OKE_FUNDING_POOLS
    set
       name			       =     X_Name,
       description		       =     X_Description,
       contact_person_id	       =     X_Contact_Person_Id,
       program_id		       =     X_Program_Id,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By,
       last_update_login               =     X_Last_Update_Login,
       attribute_Category              =     X_Attribute_Category,
       attribute1                      =     X_Attribute1,
       attribute2                      =     X_Attribute2,
       attribute3                      =     X_Attribute3,
       attribute4                      =     X_Attribute4,
       attribute5                      =     X_Attribute5,
       attribute6                      =     X_Attribute6,
       attribute7                      =     X_Attribute7,
       attribute8                      =     X_Attribute8,
       attribute9                      =     X_Attribute9,
       attribute10                     =     X_Attribute10,
       attribute11                     =     X_Attribute11,
       attribute12                     =     X_Attribute12,
       attribute13                     =     X_Attribute13,
       attribute14                     =     X_Attribute14,
       attribute15                     =     X_Attribute15
    where funding_pool_id = X_Funding_Pool_Id;

Line: 284

end Update_Row;

Line: 287

PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
BEGIN

   DELETE FROM OKE_FUNDING_POOLS
   WHERE rowid = X_Rowid;

Line: 301

END Delete_Row;