[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Report_Header_Id NUMBER,
X_Employee_Id NUMBER DEFAULT NULL,
X_Week_End_Date DATE,
X_Creation_Date DATE,
X_Created_By NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Vouchno NUMBER,
X_Total NUMBER,
X_Vendor_Id NUMBER DEFAULT NULL,
X_Vendor_Site_Id NUMBER DEFAULT NULL,
X_Expense_Check_Address_Flag VARCHAR2 DEFAULT NULL,
X_Reference_1 NUMBER DEFAULT NULL,
X_Reference_2 VARCHAR2 DEFAULT NULL,
X_Invoice_Num VARCHAR2 DEFAULT NULL,
X_Expense_Report_Id NUMBER DEFAULT NULL,
X_Accts_Pay_Code_Combinat_Id NUMBER DEFAULT NULL,
X_Set_Of_Books_Id NUMBER DEFAULT NULL,
X_Source VARCHAR2 DEFAULT NULL,
X_Purgeable_Flag VARCHAR2 DEFAULT NULL,
X_Accounting_Date DATE DEFAULT NULL,
X_Employee_Ccid NUMBER DEFAULT NULL,
X_Description VARCHAR2 DEFAULT NULL,
X_Reject_Code VARCHAR2 DEFAULT NULL,
X_Hold_Lookup_Code VARCHAR2 DEFAULT NULL,
X_Attribute_Category VARCHAR2 DEFAULT NULL,
X_Attribute1 VARCHAR2 DEFAULT NULL,
X_Attribute2 VARCHAR2 DEFAULT NULL,
X_Attribute3 VARCHAR2 DEFAULT NULL,
X_Attribute4 VARCHAR2 DEFAULT NULL,
X_Attribute5 VARCHAR2 DEFAULT NULL,
X_Default_Currency_Code VARCHAR2,
X_Default_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
X_Default_Exchange_Rate NUMBER DEFAULT NULL,
X_Default_Exchange_Date DATE DEFAULT NULL,
X_Payment_Currency_Code VARCHAR2,
X_Payment_Cross_Rate_Type VARCHAR2,
X_Payment_Cross_Rate_Date DATE,
X_Payment_Cross_Rate NUMBER,
X_Apply_Advances_Flag VARCHAR2,
X_Prepay_Num VARCHAR2,
X_Prepay_Dist_Num NUMBER,
X_Maximum_Amount_To_Apply NUMBER,
X_Prepay_Gl_Date DATE,
X_Advance_Invoice_To_Apply NUMBER DEFAULT NULL,
X_Last_Update_Login NUMBER DEFAULT NULL,
X_Voucher_Num VARCHAR2 DEFAULT NULL,
X_Attribute11 VARCHAR2 DEFAULT NULL,
X_Attribute12 VARCHAR2 DEFAULT NULL,
X_Attribute13 VARCHAR2 DEFAULT NULL,
X_Attribute14 VARCHAR2 DEFAULT NULL,
X_Attribute6 VARCHAR2 DEFAULT NULL,
X_Attribute7 VARCHAR2 DEFAULT NULL,
X_Attribute8 VARCHAR2 DEFAULT NULL,
X_Attribute9 VARCHAR2 DEFAULT NULL,
X_Attribute10 VARCHAR2 DEFAULT NULL,
X_Attribute15 VARCHAR2 DEFAULT NULL,
X_Doc_Category_Code VARCHAR2 DEFAULT NULL,
X_Awt_Group_Id NUMBER DEFAULT NULL,
X_Org_Id NUMBER DEFAULT NULL,
X_Workflow_Approved_Flag VARCHAR2 DEFAULT NULL,
X_global_attribute_category VARCHAR2 DEFAULT NULL,
X_global_attribute1 VARCHAR2 DEFAULT NULL,
X_global_attribute2 VARCHAR2 DEFAULT NULL,
X_global_attribute3 VARCHAR2 DEFAULT NULL,
X_global_attribute4 VARCHAR2 DEFAULT NULL,
X_global_attribute5 VARCHAR2 DEFAULT NULL,
X_global_attribute6 VARCHAR2 DEFAULT NULL,
X_global_attribute7 VARCHAR2 DEFAULT NULL,
X_global_attribute8 VARCHAR2 DEFAULT NULL,
X_global_attribute9 VARCHAR2 DEFAULT NULL,
X_global_attribute10 VARCHAR2 DEFAULT NULL,
X_global_attribute11 VARCHAR2 DEFAULT NULL,
X_global_attribute12 VARCHAR2 DEFAULT NULL,
X_global_attribute13 VARCHAR2 DEFAULT NULL,
X_global_attribute14 VARCHAR2 DEFAULT NULL,
X_global_attribute15 VARCHAR2 DEFAULT NULL,
X_global_attribute16 VARCHAR2 DEFAULT NULL,
X_global_attribute17 VARCHAR2 DEFAULT NULL,
X_global_attribute18 VARCHAR2 DEFAULT NULL,
X_global_attribute19 VARCHAR2 DEFAULT NULL,
X_global_attribute20 VARCHAR2 DEFAULT NULL,
X_calling_sequence IN VARCHAR2
) IS
CURSOR C IS SELECT rowid FROM AP_EXPENSE_REPORT_HEADERS
WHERE report_header_id = X_Report_Header_Id;
current_calling_sequence := 'AP_EXPENSE_REPORT_HEADERS_PKG.INSERT_ROW<-' ||
X_calling_sequence;
debug_info := 'Insert into AP_EXPENSE_REPORT_HEADERS';
INSERT INTO AP_EXPENSE_REPORT_HEADERS(
report_header_id,
employee_id,
week_end_date,
creation_date,
created_by,
last_update_date,
last_updated_by,
vouchno,
total,
vendor_id,
vendor_site_id,
expense_check_address_flag,
reference_1,
reference_2,
invoice_num,
expense_report_id,
accts_pay_code_combination_id,
set_of_books_id,
source,
purgeable_flag,
accounting_date,
employee_ccid,
description,
reject_code,
hold_lookup_code,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
default_currency_code,
default_exchange_rate_type,
default_exchange_rate,
default_exchange_date,
payment_currency_code,
payment_cross_rate_type,
payment_cross_rate_date,
payment_cross_rate,
apply_advances_default,
prepay_num,
prepay_dist_num,
maximum_amount_to_apply,
prepay_gl_date,
advance_invoice_to_apply,
last_update_login,
voucher_num,
attribute11,
attribute12,
attribute13,
attribute14,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute15,
doc_category_code,
awt_group_id,
workflow_approved_flag,
global_attribute_category,
global_attribute1,
global_attribute2,
global_attribute3,
global_attribute4,
global_attribute5,
global_attribute6,
global_attribute7,
global_attribute8,
global_attribute9,
global_attribute10,
global_attribute11,
global_attribute12,
global_attribute13,
global_attribute14,
global_attribute15,
global_attribute16,
global_attribute17,
global_attribute18,
global_attribute19,
global_attribute20,
org_id
) VALUES (
X_Report_Header_Id,
X_Employee_Id,
X_Week_End_Date,
X_Creation_Date,
X_Created_By,
X_Last_Update_Date,
X_Last_Updated_By,
X_Vouchno,
X_Total,
X_Vendor_Id,
X_Vendor_Site_Id,
X_Expense_Check_Address_Flag,
X_Reference_1,
X_Reference_2,
X_Invoice_Num,
X_Expense_Report_Id,
X_Accts_Pay_Code_Combinat_Id,
X_Set_Of_Books_Id,
X_Source,
X_Purgeable_Flag,
X_Accounting_Date,
X_Employee_Ccid,
X_Description,
X_Reject_Code,
X_Hold_Lookup_Code,
X_Attribute_Category,
X_Attribute1,
X_Attribute2,
X_Attribute3,
X_Attribute4,
X_Attribute5,
X_Default_Currency_Code,
X_Default_Exchange_Rate_Type,
X_Default_Exchange_Rate,
X_Default_Exchange_Date,
X_Payment_Currency_Code,
X_Payment_Cross_Rate_Type,
X_Payment_Cross_Rate_Date,
X_Payment_Cross_Rate,
X_Apply_Advances_flag,
X_Prepay_Num,
X_Prepay_Dist_Num,
X_Maximum_Amount_To_Apply,
X_Prepay_Gl_Date,
X_Advance_Invoice_To_Apply,
X_Last_Update_Login,
X_Voucher_Num,
X_Attribute11,
X_Attribute12,
X_Attribute13,
X_Attribute14,
X_Attribute6,
X_Attribute7,
X_Attribute8,
X_Attribute9,
X_Attribute10,
X_Attribute15,
X_Doc_Category_Code,
X_Awt_Group_Id,
X_Workflow_Approved_Flag,
X_global_attribute_category,
X_global_attribute1,
X_global_attribute2,
X_global_attribute3,
X_global_attribute4,
X_global_attribute5,
X_global_attribute6,
X_global_attribute7,
X_global_attribute8,
X_global_attribute9,
X_global_attribute10,
X_global_attribute11,
X_global_attribute12,
X_global_attribute13,
X_global_attribute14,
X_global_attribute15,
X_global_attribute16,
X_global_attribute17,
X_global_attribute18,
X_global_attribute19,
X_global_attribute20,
X_org_id
);
END Insert_Row;
SELECT *
FROM AP_EXPENSE_REPORT_HEADERS
WHERE rowid = X_Rowid
FOR UPDATE of Report_Header_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Report_Header_Id NUMBER,
X_Employee_Id NUMBER DEFAULT NULL,
X_Week_End_Date DATE,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Vouchno NUMBER,
X_Total NUMBER,
X_Vendor_Id NUMBER DEFAULT NULL,
X_Vendor_Site_Id NUMBER DEFAULT NULL,
X_Expense_Check_Address_Flag VARCHAR2 DEFAULT NULL,
X_Reference_1 NUMBER DEFAULT NULL,
X_Reference_2 VARCHAR2 DEFAULT NULL,
X_Invoice_Num VARCHAR2 DEFAULT NULL,
X_Expense_Report_Id NUMBER DEFAULT NULL,
X_Accts_Pay_Code_Combinat_Id NUMBER DEFAULT NULL,
X_Set_Of_Books_Id NUMBER DEFAULT NULL,
X_Source VARCHAR2 DEFAULT NULL,
X_Purgeable_Flag VARCHAR2 DEFAULT NULL,
X_Accounting_Date DATE DEFAULT NULL,
X_Employee_Ccid NUMBER DEFAULT NULL,
X_Description VARCHAR2 DEFAULT NULL,
X_Reject_Code VARCHAR2 DEFAULT NULL,
X_Hold_Lookup_Code VARCHAR2 DEFAULT NULL,
X_Attribute_Category VARCHAR2 DEFAULT NULL,
X_Attribute1 VARCHAR2 DEFAULT NULL,
X_Attribute2 VARCHAR2 DEFAULT NULL,
X_Attribute3 VARCHAR2 DEFAULT NULL,
X_Attribute4 VARCHAR2 DEFAULT NULL,
X_Attribute5 VARCHAR2 DEFAULT NULL,
X_Default_Currency_Code VARCHAR2,
X_Default_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
X_Default_Exchange_Rate NUMBER DEFAULT NULL,
X_Default_Exchange_Date DATE DEFAULT NULL,
X_Payment_Currency_Code VARCHAR2,
X_Payment_Cross_Rate_Type VARCHAR2,
X_Payment_Cross_Rate_Date DATE,
X_Payment_Cross_Rate NUMBER,
X_Apply_Advances_Flag VARCHAR2,
X_Prepay_Num VARCHAR2,
X_Prepay_Dist_Num NUMBER,
X_Maximum_Amount_To_Apply NUMBER,
X_Prepay_Gl_Date DATE,
X_Advance_Invoice_To_Apply NUMBER DEFAULT NULL,
X_Last_Update_Login NUMBER DEFAULT NULL,
X_Voucher_Num VARCHAR2 DEFAULT NULL,
X_Attribute11 VARCHAR2 DEFAULT NULL,
X_Attribute12 VARCHAR2 DEFAULT NULL,
X_Attribute13 VARCHAR2 DEFAULT NULL,
X_Attribute14 VARCHAR2 DEFAULT NULL,
X_Attribute6 VARCHAR2 DEFAULT NULL,
X_Attribute7 VARCHAR2 DEFAULT NULL,
X_Attribute8 VARCHAR2 DEFAULT NULL,
X_Attribute9 VARCHAR2 DEFAULT NULL,
X_Attribute10 VARCHAR2 DEFAULT NULL,
X_Attribute15 VARCHAR2 DEFAULT NULL,
X_Doc_Category_Code VARCHAR2 DEFAULT NULL,
X_Awt_Group_Id NUMBER DEFAULT NULL,
X_Org_Id NUMBER DEFAULT NULL,
X_Workflow_Approved_Flag VARCHAR2 DEFAULT NULL,
X_global_attribute_category VARCHAR2 DEFAULT NULL,
X_global_attribute1 VARCHAR2 DEFAULT NULL,
X_global_attribute2 VARCHAR2 DEFAULT NULL,
X_global_attribute3 VARCHAR2 DEFAULT NULL,
X_global_attribute4 VARCHAR2 DEFAULT NULL,
X_global_attribute5 VARCHAR2 DEFAULT NULL,
X_global_attribute6 VARCHAR2 DEFAULT NULL,
X_global_attribute7 VARCHAR2 DEFAULT NULL,
X_global_attribute8 VARCHAR2 DEFAULT NULL,
X_global_attribute9 VARCHAR2 DEFAULT NULL,
X_global_attribute10 VARCHAR2 DEFAULT NULL,
X_global_attribute11 VARCHAR2 DEFAULT NULL,
X_global_attribute12 VARCHAR2 DEFAULT NULL,
X_global_attribute13 VARCHAR2 DEFAULT NULL,
X_global_attribute14 VARCHAR2 DEFAULT NULL,
X_global_attribute15 VARCHAR2 DEFAULT NULL,
X_global_attribute16 VARCHAR2 DEFAULT NULL,
X_global_attribute17 VARCHAR2 DEFAULT NULL,
X_global_attribute18 VARCHAR2 DEFAULT NULL,
X_global_attribute19 VARCHAR2 DEFAULT NULL,
X_global_attribute20 VARCHAR2 DEFAULT NULL,
X_calling_sequence IN VARCHAR2
) IS
current_calling_sequence VARCHAR2(2000);
current_calling_sequence := 'AP_EXPENSE_REPORT_HEADERS_PKG.UPDATE_ROW<-' ||
X_calling_sequence;
debug_info := 'Update AP_EXPENSE_REPORT_HEADERS';
UPDATE AP_EXPENSE_REPORT_HEADERS
SET
report_header_id = X_Report_Header_Id,
employee_id = X_Employee_Id,
week_end_date = X_Week_End_Date,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
vouchno = X_Vouchno,
total = X_Total,
vendor_id = X_Vendor_Id,
vendor_site_id = X_Vendor_Site_Id,
expense_check_address_flag = X_Expense_Check_Address_Flag,
reference_1 = X_Reference_1,
reference_2 = X_Reference_2,
invoice_num = X_Invoice_Num,
expense_report_id = X_Expense_Report_Id,
accts_pay_code_combination_id = X_Accts_Pay_Code_Combinat_Id,
set_of_books_id = X_Set_Of_Books_Id,
source = X_Source,
purgeable_flag = X_Purgeable_Flag,
accounting_date = X_Accounting_Date,
employee_ccid = X_Employee_Ccid,
description = X_Description,
reject_code = X_Reject_Code,
hold_lookup_code = X_Hold_Lookup_Code,
attribute_category = X_Attribute_Category,
attribute1 = X_Attribute1,
attribute2 = X_Attribute2,
attribute3 = X_Attribute3,
attribute4 = X_Attribute4,
attribute5 = X_Attribute5,
default_currency_code = X_Default_Currency_Code,
default_exchange_rate_type = X_Default_Exchange_Rate_Type,
default_exchange_rate = X_Default_Exchange_Rate,
default_exchange_date = X_Default_Exchange_Date,
payment_currency_code = X_Payment_Currency_Code,
payment_cross_rate_type = X_Payment_Cross_Rate_Type,
payment_cross_rate_date = X_Payment_Cross_Rate_Date,
payment_cross_rate = X_Payment_Cross_Rate,
apply_advances_default = X_Apply_Advances_Flag,
prepay_num = X_Prepay_Num,
prepay_dist_num = X_Prepay_Dist_Num,
maximum_amount_to_apply = X_Maximum_Amount_To_Apply,
prepay_gl_date = X_Prepay_Gl_Date,
advance_invoice_to_apply = X_Advance_Invoice_To_Apply,
last_update_login = X_Last_Update_Login,
voucher_num = X_Voucher_Num,
attribute11 = X_Attribute11,
attribute12 = X_Attribute12,
attribute13 = X_Attribute13,
attribute14 = X_Attribute14,
attribute6 = X_Attribute6,
attribute7 = X_Attribute7,
attribute8 = X_Attribute8,
attribute9 = X_Attribute9,
attribute10 = X_Attribute10,
attribute15 = X_Attribute15,
doc_category_code = X_Doc_Category_Code,
awt_group_id = X_Awt_Group_Id,
workflow_approved_flag = X_Workflow_Approved_Flag,
global_attribute_category = X_global_attribute_category,
global_attribute1 = X_global_attribute1,
global_attribute2 = X_global_attribute2,
global_attribute3 = X_global_attribute3,
global_attribute4 = X_global_attribute4,
global_attribute5 = X_global_attribute5,
global_attribute6 = X_global_attribute6,
global_attribute7 = X_global_attribute7,
global_attribute8 = X_global_attribute8,
global_attribute9 = X_global_attribute9,
global_attribute10 = X_global_attribute10,
global_attribute11 = X_global_attribute11,
global_attribute12 = X_global_attribute12,
global_attribute13 = X_global_attribute13,
global_attribute14 = X_global_attribute14,
global_attribute15 = X_global_attribute15,
global_attribute16 = X_global_attribute16,
global_attribute17 = X_global_attribute17,
global_attribute18 = X_global_attribute18,
global_attribute19 = X_global_attribute19,
global_attribute20 = X_global_attribute20
WHERE rowid = X_Rowid;
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2,
X_calling_sequence IN VARCHAR2
) IS
current_calling_sequence VARCHAR2(2000);
current_calling_sequence := 'AP_EXPENSE_REPORT_HEADERS_PKG.DELETE_ROW<-' ||
X_calling_sequence;
debug_info := 'Delete from AP_EXPENSE_REPORT_HEADERS';
DELETE FROM AP_EXPENSE_REPORT_HEADERS
WHERE rowid = X_Rowid;
END Delete_Row;