[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure delete_customer_alt_names(p_rowid in varchar2,
p_status in varchar2,
p_customer_id in number
) is
begin
--{BUG 4504905 - R12 this code is obsolete - stubbed out for compilation only
NULL;
end delete_customer_alt_names;
procedure insert_Row (X_Rowid IN OUT NOCOPY VARCHAR2,
X_Customer_Id IN OUT NOCOPY NUMBER,
X_Customer_Name IN OUT NOCOPY VARCHAR2,
X_Customer_Number IN OUT NOCOPY VARCHAR2,
X_Customer_Key VARCHAR2,
X_Status VARCHAR2,
X_Orig_System_Reference IN OUT NOCOPY VARCHAR2,
X_Customer_Prospect_code VARCHAR2,
X_Customer_Category_Code VARCHAR2,
X_Customer_Class_Code VARCHAR2,
X_Customer_Type VARCHAR2,
X_Primary_Salesrep_Id NUMBER,
X_Sic_Code VARCHAR2,
X_Tax_Reference VARCHAR2,
X_Tax_Code VARCHAR2,
X_Fob_Point VARCHAR2,
X_Ship_Via VARCHAR2,
X_Gsa_Indicator VARCHAR2,
X_Ship_Partial VARCHAR2,
X_Taxpayer_Id VARCHAR2,
X_Price_List_Id NUMBER,
X_Freight_Term VARCHAR2,
X_Order_Type_Id NUMBER,
X_Sales_Channel_Code VARCHAR2,
X_Warehouse_Id NUMBER,
X_Mission_Statement VARCHAR2,
X_Num_Of_Employees NUMBER,
X_Potential_Revenue_Curr_Fy NUMBER,
X_Potential_Revenue_Next_Fy NUMBER,
X_Fiscal_Yearend_Month VARCHAR2,
X_Year_Established NUMBER,
X_Analysis_Fy VARCHAR2,
X_Competitor_Flag VARCHAR2,
X_Reference_Use_Flag VARCHAR2,
X_Third_Party_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_Last_Updated_By NUMBER,
X_Last_Update_Date DATE,
X_Last_Update_Login NUMBER,
X_Created_By NUMBER,
X_Creation_Date DATE,
X_Customer_Name_Phonetic 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
) IS
--
begin
--{BUG 4504905 - R12 this code is obsolete - stubbed out for compilation only
NULL;
END Insert_Row;
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Customer_Id NUMBER,
X_Customer_Name VARCHAR2,
X_Customer_Number VARCHAR2,
X_Customer_Key VARCHAR2,
X_Status VARCHAR2,
X_Orig_System_Reference VARCHAR2,
X_Customer_Prospect_Code VARCHAR2,
X_Customer_Category_Code VARCHAR2,
X_Customer_Class_Code VARCHAR2,
X_Customer_Type VARCHAR2,
X_Primary_Salesrep_Id NUMBER,
X_Sic_Code VARCHAR2,
X_Tax_Reference VARCHAR2,
X_Tax_Code VARCHAR2,
X_Fob_Point VARCHAR2,
X_Ship_Via VARCHAR2,
X_Gsa_Indicator VARCHAR2,
X_Ship_Partial VARCHAR2,
X_Taxpayer_Id VARCHAR2,
X_Price_List_Id NUMBER,
X_Freight_Term VARCHAR2,
X_Order_Type_Id NUMBER,
X_Sales_Channel_Code VARCHAR2,
X_Warehouse_Id NUMBER,
X_Mission_Statement VARCHAR2,
X_Num_Of_Employees NUMBER,
X_Potential_Revenue_Curr_Fy NUMBER,
X_Potential_Revenue_Next_Fy NUMBER,
X_Fiscal_Yearend_Month VARCHAR2,
X_Year_Established NUMBER,
X_Analysis_Fy VARCHAR2,
X_Competitor_Flag VARCHAR2,
X_Reference_Use_Flag VARCHAR2,
X_Third_Party_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_Last_Updated_By NUMBER,
X_Last_Update_Date DATE,
X_Last_Update_Login NUMBER,
X_Customer_Name_Phonetic 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
) IS
--
begin
--{BUG 4504905 - R12 this code is obsolete - stubbed out for compilation only
NULL;
END Update_Row;
| staged_dunning_level field of ar_payment_schedules is updateable |
| or not. |
| |
| MODIFICATION HISTORY |
| |
| 30-JUN-1997 Neeraj Tandon Created |
| |
+===========================================================================+*/
--
FUNCTION get_current_dunning_type (p_customer_id IN NUMBER,
p_bill_to_site_id IN NUMBER DEFAULT NULL
)
return varchar2 is
BEGIN
--{BUG 4504905 - R12 this code is obsolete - stubbed out for compilation only
RETURN NULL;