APPS.PA_PROJECT_CONTACTS_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, --File.Sql.39 bug 4440895

                       X_Project_Id                     NUMBER,
                       X_Customer_Id                    NUMBER,
		       X_Bill_Ship_Customer_Id          NUMBER,
                       X_Contact_Id                     NUMBER,
                       X_Project_Contact_Type_Code      VARCHAR2,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Creation_Date                  DATE,
                       X_Created_By                     NUMBER,
                       X_Last_Update_Login              NUMBER,
                       X_Record_Version_Number          NUMBER
  ) IS
    CURSOR C IS SELECT rowid FROM pa_project_contacts
                 WHERE project_id = X_Project_Id
                 AND   customer_id = X_Customer_Id
                 AND   contact_id = X_Contact_Id;

Line: 26

       INSERT INTO pa_project_contacts(

              project_id,
              customer_id,
	      bill_ship_customer_id,
              contact_id,
              project_contact_type_code,
              last_update_date,
              last_updated_by,
              creation_date,
              created_by,
              last_update_login,
              record_version_number
             ) VALUES (

              X_Project_Id,
              X_Customer_Id,
	      X_Bill_Ship_Customer_Id,
              X_Contact_Id,
              X_Project_Contact_Type_Code,
              X_Last_Update_Date,
              X_Last_Updated_By,
              X_Creation_Date,
              X_Created_By,
              X_Last_Update_Login,
              X_Record_Version_Number
             );

Line: 61

  END Insert_Row;

Line: 73

        SELECT *
        FROM   pa_project_contacts
        WHERE  rowid = X_Rowid
        FOR UPDATE of Project_Id NOWAIT;

Line: 85

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

Line: 111

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,

                       X_Project_Id                     NUMBER,
                       X_Customer_Id                    NUMBER,
		       X_Bill_Ship_Customer_Id          NUMBER,
                       X_Contact_Id                     NUMBER,
                       X_Project_Contact_Type_Code      VARCHAR2,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER,
                       X_Record_Version_Number          NUMBER

  ) IS
    CURSOR C IS
        SELECT *
        FROM   pa_project_contacts
        WHERE  rowid = X_Rowid;

Line: 134

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

Line: 143

    UPDATE pa_project_contacts
    SET
       project_id                      =     X_Project_Id,
       customer_id                     =     X_Customer_Id,
       bill_ship_customer_id           =     X_Bill_Ship_Customer_Id,
       contact_id                      =     X_Contact_Id,
       project_contact_type_code       =     X_Project_Contact_Type_Code,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By,
       last_update_login               =     X_Last_Update_Login,
       record_Version_number           =     X_Record_Version_Number + 1
    WHERE rowid = X_Rowid;

Line: 159

  END Update_Row;

Line: 160

  PROCEDURE Delete_Row(X_Rowid VARCHAR2,
                       x_record_version_number number) IS
    CURSOR C IS
        SELECT *
        FROM   pa_project_contacts
        WHERE  rowid = X_Rowid;

Line: 173

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

Line: 182

    DELETE FROM pa_project_contacts
    WHERE rowid = X_Rowid;

Line: 188

  END Delete_Row;