APPS.ARP_CSU_PKG SQL Statements

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

Line: 41

PROCEDURE delete_customer_alt_names(p_rowid in varchar2,
                                    p_status in varchar2,
                                    p_customer_id in number,
                                    p_site_use_id in number
                                    ) is
begin
  NULL;

Line: 48

end delete_customer_alt_names;

Line: 107

PROCEDURE update_su_status (	p_customer_id in number,
				p_address_id in number,
				p_site_use_id in number,
				p_site_use_code in varchar2,
				p_status in varchar2 ) is
begin
  NULL;

Line: 114

end update_su_status;

Line: 222

PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
                       X_Site_Use_Id             IN OUT NOCOPY NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Creation_Date                  DATE,
                       X_Created_By                     NUMBER,
                       X_Site_Use_Code                  VARCHAR2,
		       X_customer_id			NUMBER,
                       X_Address_Id                     NUMBER,
                       X_Primary_Flag                   VARCHAR2,
                       X_Status                         VARCHAR2,
                       X_Location               IN OUT  NOCOPY VARCHAR2,
                       X_Last_Update_Login              NUMBER,
                       X_Contact_Id                     NUMBER,
                       X_Bill_To_Site_Use_Id            NUMBER,
                       X_Sic_Code                       VARCHAR2,
                       X_Payment_Term_Id                NUMBER,
                       X_Gsa_Indicator                  VARCHAR2,
                       X_Ship_Partial                   VARCHAR2,
                       X_Ship_Via                       VARCHAR2,
                       X_Fob_Point                      VARCHAR2,
                       X_Order_Type_Id                  NUMBER,
                       X_Price_List_Id                  NUMBER,
                       X_Freight_Term                   VARCHAR2,
                       X_Warehouse_Id                   NUMBER,
                       X_Territory_Id                   NUMBER,
                       X_Tax_Code                       VARCHAR2,
                       X_Tax_Reference                  VARCHAR2,
                       X_Demand_Class_Code              VARCHAR2,
                       x_inventory_location_id		NUMBER,
		       x_inventory_organization_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_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_Tax_Classification             VARCHAR2,
                       X_Tax_Header_Level_Flag          VARCHAR2,
                       X_Tax_Rounding_Rule              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_Primary_Salesrep_Id            NUMBER  DEFAULT NULL,
                       X_Finchrg_Receivables_Trx_Id     NUMBER  DEFAULT NULL,
 		       X_GL_ID_Rec			NUMBER,
		       X_GL_ID_Rev			NUMBER,
		       X_GL_ID_Tax			NUMBER,
		       X_GL_ID_Freight			NUMBER,
		       X_GL_ID_Clearing			NUMBER,
		       X_GL_ID_Unbilled			NUMBER,
		       X_GL_ID_Unearned 		NUMBER
 		  ) IS
BEGIN
   NULL;

Line: 315

END Insert_Row;

Line: 319

PROCEDURE Update_Row(X_Rowid                  IN OUT  NOCOPY VARCHAR2 ,
                       X_Site_Use_Id            IN OUT  NOCOPY NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Site_Use_Code                  VARCHAR2,
		       X_customer_id			NUMBER,
                       X_Address_Id                     NUMBER,
                       X_Primary_Flag                   VARCHAR2,
                       X_Status                         VARCHAR2,
                       X_Location                       VARCHAR2,
                       X_Last_Update_Login              NUMBER,
                       X_Contact_Id                     NUMBER,
                       X_Bill_To_Site_Use_Id            NUMBER,
                       X_Sic_Code                       VARCHAR2,
                       X_Payment_Term_Id                NUMBER,
                       X_Gsa_Indicator                  VARCHAR2,
                       X_Ship_Partial                   VARCHAR2,
                       X_Ship_Via                       VARCHAR2,
                       X_Fob_Point                      VARCHAR2,
                       X_Order_Type_Id                  NUMBER,
                       X_Price_List_Id                  NUMBER,
                       X_Freight_Term                   VARCHAR2,
                       X_Warehouse_Id                   NUMBER,
                       X_Territory_Id                   NUMBER,
                       X_Tax_Code                       VARCHAR2,
                       X_Tax_Reference                  VARCHAR2,
                       X_Demand_Class_Code              VARCHAR2,
		       x_inventory_location_id		NUMBER,
		       x_inventory_organization_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_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_Tax_Classification             VARCHAR2,
                       X_Tax_Header_Level_Flag          VARCHAR2,
                       X_Tax_Rounding_Rule              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_Primary_Salesrep_Id            NUMBER  DEFAULT NULL,
                       X_Finchrg_Receivables_Trx_Id     NUMBER  DEFAULT NULL,
  		       X_GL_ID_Rec			NUMBER,
		       X_GL_ID_Rev			NUMBER,
		       X_GL_ID_Tax			NUMBER,
		       X_GL_ID_Freight			NUMBER,
		       X_GL_ID_Clearing			NUMBER,
		       X_GL_ID_Unbilled			NUMBER,
		       X_GL_ID_Unearned 		NUMBER

  ) IS
BEGIN
   NULL;

Line: 411

END Update_Row;