APPS.ARP_CPC_PKG SQL Statements

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

Line: 62

PROCEDURE Insert_Row  (X_Row_Id                         IN OUT NOCOPY VARCHAR2,
                       X_Customer_Profile_Class_Id      IN OUT NOCOPY NUMBER,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Update_Login              NUMBER,
                       X_Created_By                     NUMBER,
                       X_Creation_Date                  DATE,
                       X_Profile_Class_Name             VARCHAR2,
                       X_Profile_Class_Description      VARCHAR2,
                       X_Status                         VARCHAR2,
                       X_Collector_Id                   NUMBER,
                       X_Credit_Checking                VARCHAR2,
                       X_Tolerance                      NUMBER,
                       X_Interest_Charges               VARCHAR2,
                       X_Charge_On_Finance_Charge_Flg   VARCHAR2,
                       X_Interest_Period_Days           NUMBER,
                       X_Discount_Terms                 VARCHAR2,
                       X_Discount_Grace_Days            NUMBER,
                       X_Statements                     VARCHAR2,
                       X_Statement_Cycle_Id             NUMBER,
                       X_Credit_Balance_Statements      VARCHAR2,
                       X_Standard_Terms                 NUMBER,
                       X_Override_Terms                 VARCHAR2,
                       X_Payment_Grace_Days             NUMBER,
                       X_Dunning_Letters                VARCHAR2,
                       X_Dunning_Letter_Set_Id          NUMBER,
                       X_Autocash_Hierarchy_Id          NUMBER,
                       X_Copy_Method                    VARCHAR2,
                       X_Auto_Rec_Incl_Disputed_Flag    VARCHAR2,
                       X_Tax_Printing_Option            VARCHAR2,
                       X_Tax_Printing_Option_Meaning    VARCHAR2,
                       X_Grouping_Rule_Id               NUMBER,
                       X_Cons_Inv_Flag                  VARCHAR2,
                       X_Cons_Inv_Type                  VARCHAR2,
                       X_Request_Id                     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,
                       X_Jgzz_attribute_Category        VARCHAR2,
                       X_Jgzz_attribute1                VARCHAR2,
                       X_Jgzz_attribute2                VARCHAR2,
                       X_Jgzz_attribute3                VARCHAR2,
                       X_Jgzz_attribute4                VARCHAR2,
                       X_Jgzz_attribute5                VARCHAR2,
                       X_Jgzz_attribute6                VARCHAR2,
                       X_Jgzz_attribute7                VARCHAR2,
                       X_Jgzz_attribute8                VARCHAR2,
                       X_Jgzz_attribute9                VARCHAR2,
                       X_Jgzz_attribute10               VARCHAR2,
                       X_Jgzz_attribute11               VARCHAR2,
                       X_Jgzz_attribute12               VARCHAR2,
                       X_Jgzz_attribute13               VARCHAR2,
                       X_Jgzz_attribute14               VARCHAR2,
                       X_Jgzz_attribute15               VARCHAR2,
                       X_global_attribute_category        VARCHAR2,
                       X_global_attribute1                VARCHAR2,
                       X_global_attribute2                VARCHAR2,
                       X_global_attribute3                VARCHAR2,
                       X_global_attribute4                VARCHAR2,
                       X_global_attribute5                VARCHAR2,
                       X_global_attribute6                VARCHAR2,
                       X_global_attribute7                VARCHAR2,
                       X_global_attribute8                VARCHAR2,
                       X_global_attribute9                VARCHAR2,
                       X_global_attribute10               VARCHAR2,
                       X_global_attribute11               VARCHAR2,
                       X_global_attribute12               VARCHAR2,
                       X_global_attribute13               VARCHAR2,
                       X_global_attribute14               VARCHAR2,
                       X_global_attribute15               VARCHAR2,
                       X_global_attribute16               VARCHAR2,
                       X_global_attribute17               VARCHAR2,
                       X_global_attribute18               VARCHAR2,
                       X_global_attribute19               VARCHAR2,
                       X_global_attribute20               VARCHAR2,
                       X_lockbox_matching_option          VARCHAR2,
                       X_autocash_hierarchy_id_adr        NUMBER

   )
IS
BEGIN
  NULL;

Line: 157

END Insert_Row;

Line: 253

PROCEDURE Update_Row  (X_Row_Id                         IN OUT NOCOPY VARCHAR2,
                       X_Customer_Profile_Class_Id      IN OUT NOCOPY NUMBER,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Update_Login              NUMBER,
                       X_Profile_Class_Name             VARCHAR2,
                       X_Profile_Class_Description      VARCHAR2,
                       X_Status                         VARCHAR2,
                       X_Collector_Id                   NUMBER,
                       X_Credit_Checking                VARCHAR2,
                       X_Tolerance                      NUMBER,
                       X_Interest_Charges               VARCHAR2,
                       X_Charge_On_Finance_Charge_Flg  VARCHAR2,
                       X_Interest_Period_Days           NUMBER,
                       X_Discount_Terms                 VARCHAR2,
                       X_Discount_Grace_Days            NUMBER,
                       X_Statements                     VARCHAR2,
                       X_Statement_Cycle_Id             NUMBER,
                       X_Credit_Balance_Statements      VARCHAR2,
                       X_Standard_Terms                 NUMBER,
                       X_Override_Terms                 VARCHAR2,
                       X_Payment_Grace_Days             NUMBER,
                       X_Dunning_Letters                VARCHAR2,
                       X_Dunning_Letter_Set_Id          NUMBER,
                       X_Autocash_Hierarchy_Id          NUMBER,
                       X_Copy_Method                    VARCHAR2,
                       X_Auto_Rec_Incl_Disputed_Flag    VARCHAR2,
                       X_Tax_Printing_Option            VARCHAR2,
                       X_Tax_Printing_Option_Meaning    VARCHAR2,
                       X_Grouping_Rule_Id               NUMBER,
                       X_Cons_Inv_Flag                  VARCHAR2,
                       X_Cons_Inv_Type                  VARCHAR2,
                       X_Request_Id                     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,
                     X_Jgzz_attribute_Category          VARCHAR2,
                     X_Jgzz_attribute1                  VARCHAR2,
                     X_Jgzz_attribute2                  VARCHAR2,
                     X_Jgzz_attribute3                  VARCHAR2,
                     X_Jgzz_attribute4                  VARCHAR2,
                     X_Jgzz_attribute5                  VARCHAR2,
                     X_Jgzz_attribute6                  VARCHAR2,
                     X_Jgzz_attribute7                  VARCHAR2,
                     X_Jgzz_attribute8                  VARCHAR2,
                     X_Jgzz_attribute9                  VARCHAR2,
                     X_Jgzz_attribute10                 VARCHAR2,
                     X_Jgzz_attribute11                 VARCHAR2,
                     X_Jgzz_attribute12                 VARCHAR2,
                     X_Jgzz_attribute13                 VARCHAR2,
                     X_Jgzz_attribute14                 VARCHAR2,
                     X_Jgzz_attribute15                 VARCHAR2,
                       X_global_attribute_category        VARCHAR2,
                       X_global_attribute1                VARCHAR2,
                       X_global_attribute2                VARCHAR2,
                       X_global_attribute3                VARCHAR2,
                       X_global_attribute4                VARCHAR2,
                       X_global_attribute5                VARCHAR2,
                       X_global_attribute6                VARCHAR2,
                       X_global_attribute7                VARCHAR2,
                       X_global_attribute8                VARCHAR2,
                       X_global_attribute9                VARCHAR2,
                       X_global_attribute10               VARCHAR2,
                       X_global_attribute11               VARCHAR2,
                       X_global_attribute12               VARCHAR2,
                       X_global_attribute13               VARCHAR2,
                       X_global_attribute14               VARCHAR2,
                       X_global_attribute15               VARCHAR2,
                       X_global_attribute16               VARCHAR2,
                       X_global_attribute17               VARCHAR2,
                       X_global_attribute18               VARCHAR2,
                       X_global_attribute19               VARCHAR2,
                       X_global_attribute20               VARCHAR2,
                       X_lockbox_matching_option          VARCHAR2,
                       X_autocash_hierarchy_id_adr        NUMBER

  ) IS
BEGIN
   NULL;

Line: 345

END Update_Row;

Line: 347

PROCEDURE Delete_Row(X_Row_Id VARCHAR2) IS
BEGIN
  NULL;

Line: 350

END Delete_Row;

Line: 362

PROCEDURE insert_negative_row  (X_Customer_Profile_Class_Id Number,
                                X_Negative_Id               Number,
                                X_Update_Options            Varchar2)
IS
BEGIN
  NULL;

Line: 368

END insert_negative_row;