APPS.PNT_PHONE_PKG SQL Statements

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

Line: 26

  SELECT  count(1)
  INTO    primary_count
  FROM    pn_phones_all ph
  WHERE   ph.contact_id    = p_contact_id
  AND     ph.primary_flag  = 'Y'
  AND     ((p_phone_id is null) or ph.phone_id <> p_phone_id )
  AND     org_id = p_org_id;

Line: 51

PROCEDURE Insert_Row ( X_Rowid                   IN OUT NOCOPY VARCHAR2,
                       X_Phone_Id                IN OUT NOCOPY NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Creation_Date                  DATE,
                       X_Created_By                     NUMBER,
                       X_Phone_Number                   VARCHAR2,
                       X_Status                         VARCHAR2,
                       X_Phone_Type                     VARCHAR2,
                       X_Last_Update_Login              NUMBER,
                       X_Contact_Id                     NUMBER,
                       X_Area_Code                      VARCHAR2,
                       X_Extension                      VARCHAR2,
                       X_Primary_Flag                   VARCHAR2,
                       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,
                       X_Org_id                         NUMBER default NULL
                     )
IS
   CURSOR C IS
   SELECT rowid
   FROM   pn_phones_all
   WHERE  phone_id = X_Phone_Id;

Line: 92

    SELECT org_id
    FROM pn_contacts_all
    WHERE contact_id = x_contact_id;

Line: 110

   SELECT pn_phones_s.nextval
   INTO   x_phone_id
   FROM  dual;

Line: 114

   INSERT INTO pn_phones_all
   (
      phone_id,
      last_update_date,
      last_updated_by,
      creation_date,
      created_by,
      phone_number,
      status,
      phone_type,
      last_update_login,
      contact_id,
      area_code,
      extension,
      primary_flag,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      org_id
   )
   VALUES
   (
      X_Phone_Id,
      X_Last_Update_Date,
      X_Last_Updated_By,
      X_Creation_Date,
      X_Created_By,
      X_Phone_Number,
      X_Status,
      X_Phone_Type,
      X_Last_Update_Login,
      X_Contact_Id,
      X_Area_Code,
      X_Extension,
      X_Primary_Flag,
      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,
      l_Org_id
    );

Line: 189

END Insert_Row;

Line: 224

      SELECT *
      FROM   pn_phones_all
      WHERE  rowid = X_Rowid
      FOR UPDATE of Phone_Id NOWAIT;

Line: 236

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

Line: 337

PROCEDURE Update_Row ( X_Rowid                          VARCHAR2,
                            X_phone_id                                NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Phone_Number                   VARCHAR2,
                       X_Status                         VARCHAR2,
                       X_Phone_Type                     VARCHAR2,
                       X_Last_Update_Login              NUMBER,
                       X_Contact_Id                     NUMBER,
                       X_Area_Code                      VARCHAR2,
                       X_Extension                      VARCHAR2,
                       X_Primary_Flag                   VARCHAR2,
                       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
  l_id NUMBER;

Line: 371

  UPDATE pn_phones_all
  SET
     last_update_date                =     X_Last_Update_Date,
     last_updated_by                 =     X_Last_Updated_By,
     phone_number                    =     X_Phone_Number,
     status                          =     X_Status,
     phone_type                      =     X_Phone_Type,
     last_update_login               =     X_Last_Update_Login,
     area_code                       =     X_Area_Code,
     extension                       =     X_Extension,
     primary_flag                    =     X_Primary_Flag,
     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 phone_id = X_phone_id;

Line: 403

END Update_Row;

Line: 412

PROCEDURE delete_row ( x_rowid   VARCHAR2)
IS
BEGIN

   DELETE FROM pn_phones_all
   WHERE  rowid = x_rowid;

Line: 423

END delete_row;

Line: 433

PROCEDURE delete_row (x_phone_id IN NUMBER)
IS
BEGIN

   DELETE FROM pn_phones_all
   WHERE phone_id = x_phone_id;

Line: 445

END delete_row;