[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Standing_Charge_Id IN OUT NOCOPY NUMBER,
X_Charge_Reference VARCHAR2,
X_Set_Of_Books_Id NUMBER,
X_Standing_Charge_Date DATE,
X_Status VARCHAR2,
X_Bill_To_Customer_Id NUMBER,
X_Bill_To_Site_Use_Id NUMBER,
X_Batch_Source_Id NUMBER,
X_Cust_Trx_Type_Id NUMBER,
X_Salesrep_Id NUMBER,
X_Advance_Arrears_Ind VARCHAR2,
X_Period_Name VARCHAR2,
X_Start_Date DATE,
X_Next_Due_Date DATE,
X_Creation_Date DATE,
X_Created_By NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Last_Update_Login NUMBER,
X_Bill_To_Contact_Id NUMBER,
X_Ship_To_Customer_Id NUMBER,
X_Ship_To_Site_Use_Id NUMBER,
X_Ship_To_Contact_Id NUMBER,
X_Reminder_Days NUMBER,
X_Receipt_Method_Id NUMBER,
X_Bank_Account_Id NUMBER,
X_Generate_Sequence NUMBER,
X_End_Date DATE,
X_Review_Date DATE,
X_Previous_Due_Date DATE,
X_Suppress_Inv_Print VARCHAR2,
X_Comments VARCHAR2,
X_Description VARCHAR2,
X_Ship_To_Address_Id NUMBER,
X_Bill_To_Address_Id NUMBER,
X_term_id NUMBER,
X_Currency_code VARCHAR2,
X_Default_Invoicing_Rule VARCHAR2,
/*Added for MOAC Impact Bug No 5905216 - Start*/
X_Org_Id NUMBER,
X_Legal_Entity_Id NUMBER,
X_Payment_Trxn_Extension_Id NUMBER
/*MOAC Impact Bug No 5905216 - End*/
) IS
CURSOR C IS SELECT rowid FROM IGI_RPI_STANDING_CHARGES
WHERE standing_charge_id = X_Standing_Charge_Id;
CURSOR C2 IS SELECT igi_rpi_standing_charges_s.nextval FROM sys.dual;
INSERT INTO IGI_RPI_STANDING_CHARGES(
standing_charge_id,
charge_reference,
set_of_books_id,
standing_charge_date,
status,
bill_to_customer_id,
bill_to_site_use_id,
batch_source_id,
cust_trx_type_id,
salesrep_id,
advance_arrears_ind,
period_name,
start_date,
next_due_date,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
bill_to_contact_id,
ship_to_customer_id,
ship_to_site_use_id,
ship_to_contact_id,
reminder_days,
receipt_method_id,
bank_account_id,
generate_sequence,
end_date,
review_date,
previous_due_date,
suppress_inv_print,
comments,
description,
ship_to_address_id,
bill_to_address_id,
term_id,
currency_code,
default_invoicing_rule,
/*MOAC Impact Bug No 5905216 - Start*/
org_id,
legal_entity_id,
payment_trxn_extension_id
/*MOAC Impact Bug No 5905216 - End*/
) VALUES (
X_Standing_Charge_Id,
X_Charge_Reference,
X_Set_Of_Books_Id,
X_Standing_Charge_Date,
X_Status,
X_Bill_To_Customer_Id,
X_Bill_To_Site_Use_Id,
X_Batch_Source_Id,
X_Cust_Trx_Type_Id,
X_Salesrep_Id,
X_Advance_Arrears_Ind,
X_Period_Name,
X_Start_Date,
X_Next_Due_Date,
X_Creation_Date,
X_Created_By,
X_Last_Update_Date,
X_Last_Updated_By,
X_Last_Update_Login,
X_Bill_To_Contact_Id,
X_Ship_To_Customer_Id,
X_Ship_To_Site_Use_Id,
X_Ship_To_Contact_Id,
X_Reminder_Days,
X_Receipt_Method_Id,
X_Bank_Account_Id,
X_Generate_Sequence,
X_End_Date,
X_Review_Date,
X_Previous_Due_Date,
X_Suppress_Inv_Print,
X_Comments,
X_Description,
X_Ship_To_Address_Id,
X_Bill_To_Address_Id,
X_term_id,
X_currency_code,
X_Default_Invoicing_Rule,
/*MOAC Impact Bug No 5905216 - Start*/
X_Org_id,
X_Legal_Entity_Id,
X_Payment_Trxn_Extension_Id
/*MOAC Impact bug No 5905216 - End*/
);
END Insert_Row;
SELECT *
FROM IGI_RPI_STANDING_CHARGES
WHERE rowid = X_Rowid
FOR UPDATE of Standing_Charge_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Standing_Charge_Id NUMBER,
X_Charge_Reference VARCHAR2,
X_Set_Of_Books_Id NUMBER,
X_Standing_Charge_Date DATE,
X_Status VARCHAR2,
X_Bill_To_Customer_Id NUMBER,
X_Bill_To_Site_Use_Id NUMBER,
X_Batch_Source_Id NUMBER,
X_Cust_Trx_Type_Id NUMBER,
X_Salesrep_Id NUMBER,
X_Advance_Arrears_Ind VARCHAR2,
X_Period_Name VARCHAR2,
X_Start_Date DATE,
X_Next_Due_Date DATE,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Last_Update_Login NUMBER,
X_Bill_To_Contact_Id NUMBER,
X_Ship_To_Customer_Id NUMBER,
X_Ship_To_Site_Use_Id NUMBER,
X_Ship_To_Contact_Id NUMBER,
X_Reminder_Days NUMBER,
X_Receipt_Method_Id NUMBER,
X_Bank_Account_Id NUMBER,
X_Generate_Sequence NUMBER,
X_End_Date DATE,
X_Review_Date DATE,
X_Previous_Due_Date DATE,
X_Suppress_Inv_Print VARCHAR2,
X_Comments VARCHAR2,
X_Description VARCHAR2,
X_Ship_To_Address_Id NUMBER,
X_Bill_To_Address_Id NUMBER,
X_term_id NUMBER,
X_Currency_code VARCHAR2,
X_Default_Invoicing_Rule VARCHAR2,
/*MOAC Impact Bug No 5905216 - Start*/
X_Legal_Entity_Id NUMBER,
X_Payment_Trxn_Extension_Id NUMBER
/*MOAC Impact Bug No 5905216 - End*/
) IS
BEGIN
UPDATE IGI_RPI_STANDING_CHARGES
SET
standing_charge_id = X_Standing_Charge_Id,
charge_reference = X_Charge_Reference,
set_of_books_id = X_Set_Of_Books_Id,
standing_charge_date = X_Standing_Charge_Date,
status = X_Status,
bill_to_customer_id = X_Bill_To_Customer_Id,
bill_to_site_use_id = X_Bill_To_Site_Use_Id,
batch_source_id = X_Batch_Source_Id,
cust_trx_type_id = X_Cust_Trx_Type_Id,
salesrep_id = X_Salesrep_Id,
advance_arrears_ind = X_Advance_Arrears_Ind,
period_name = X_Period_Name,
start_date = X_Start_Date,
next_due_date = X_Next_Due_Date,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
last_update_login = X_Last_Update_Login,
bill_to_contact_id = X_Bill_To_Contact_Id,
ship_to_customer_id = X_Ship_To_Customer_Id,
ship_to_site_use_id = X_Ship_To_Site_Use_Id,
ship_to_contact_id = X_Ship_To_Contact_Id,
reminder_days = X_Reminder_Days,
receipt_method_id = X_Receipt_Method_Id,
bank_account_id = X_Bank_Account_Id,
generate_sequence = X_Generate_Sequence,
end_date = X_End_Date,
review_date = X_Review_Date,
previous_due_date = X_Previous_Due_Date,
suppress_inv_print = X_Suppress_Inv_Print,
comments = X_Comments,
description = X_Description,
ship_to_address_id = X_Ship_To_Address_Id,
bill_to_address_id = X_Bill_To_Address_Id,
Currency_code = X_currency_code,
term_id = X_term_id,
default_invoicing_rule = X_Default_Invoicing_Rule,
/*MOAC Impact Bug No 5905216 - Start*/
legal_entity_id = X_Legal_Entity_Id,
payment_trxn_extension_id = X_Payment_Trxn_Extension_Id
/*MOAC Impact Bug No 5905216 - End*/
WHERE rowid = X_Rowid;
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
BEGIN
DELETE FROM IGI_RPI_STANDING_CHARGES
WHERE rowid = X_Rowid;
END Delete_Row;