APPS.ARP_CONT_PKG SQL Statements

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

Line: 70

  PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
                       X_Contact_Id              IN OUT NOCOPY NUMBER,
                       X_Created_By                     NUMBER,
                       X_Creation_Date                  DATE,
                       X_Customer_Id                    NUMBER,
                       X_Last_Name                      VARCHAR2,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Orig_System_Reference   IN OUT NOCOPY VARCHAR2,
                       X_Status                         VARCHAR2,
                       X_Address_Id                     NUMBER,
                       X_Contact_Key                    VARCHAR2,
                       X_First_Name                     VARCHAR2,
                       X_Job_Title                      VARCHAR2,
                       X_Last_Update_Login              NUMBER,
                       X_Mail_Stop                      VARCHAR2,
                       X_Title                          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_Attribute16                    VARCHAR2,
                       X_Attribute17                    VARCHAR2,
                       X_Attribute18                    VARCHAR2,
                       X_Attribute19                    VARCHAR2,
                       X_Attribute20                    VARCHAR2,
                       X_Attribute21                    VARCHAR2,
                       X_Attribute22                    VARCHAR2,
                       X_Attribute23                    VARCHAR2,
                       X_Attribute24                    VARCHAR2,
                       X_Attribute25                    VARCHAR2,
                       X_Email_Address                  VARCHAR2,
                       X_Last_Name_Alt                  VARCHAR2 default null,
                       X_First_Name_Alt                 VARCHAR2 default null
  ) IS

BEGIN
  NULL;

Line: 120

END Insert_Row;

Line: 168

PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
		       X_contact_id			number,
                       X_Last_Name                      VARCHAR2,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Status                         VARCHAR2,
                       X_Contact_Key                    VARCHAR2,
                       X_First_Name                     VARCHAR2,
                       X_Job_Title                      VARCHAR2,
                       X_Last_Update_Login              NUMBER,
                       X_Mail_Stop                      VARCHAR2,
                       X_Title                          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_Attribute16                    VARCHAR2,
                       X_Attribute17                    VARCHAR2,
                       X_Attribute18                    VARCHAR2,
                       X_Attribute19                    VARCHAR2,
                       X_Attribute20                    VARCHAR2,
                       X_Attribute21                    VARCHAR2,
                       X_Attribute22                    VARCHAR2,
                       X_Attribute23                    VARCHAR2,
                       X_Attribute24                    VARCHAR2,
                       X_Attribute25                    VARCHAR2,
                       X_Email_Address                  VARCHAR2,
                       X_Last_Name_Alt                  VARCHAR2 default g_varchar2,
                       X_First_Name_Alt                 VARCHAR2 default g_varchar2
  ) IS
BEGIN
  NULL;

Line: 212

END Update_Row;