[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Purge_Name VARCHAR2,
X_Creation_Date DATE,
X_Created_By NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Last_Update_Login NUMBER,
X_Category VARCHAR2,
X_Status VARCHAR2,
X_Activity_Date DATE DEFAULT NULL,
X_Ap_Checks NUMBER DEFAULT NULL,
X_Ap_Invoice_Payments NUMBER DEFAULT NULL,
X_Ap_Payment_Schedules NUMBER DEFAULT NULL,
X_Ap_Recurring_Payments NUMBER DEFAULT NULL,
X_Ap_Trial_Balance NUMBER DEFAULT NULL,
X_Ap_Holds NUMBER DEFAULT NULL,
X_Ap_Invoice_Distributions NUMBER DEFAULT NULL,
X_Ap_Batches NUMBER DEFAULT NULL,
X_Ap_Invoices NUMBER DEFAULT NULL,
X_Po_Requisition_Headers NUMBER DEFAULT NULL,
X_Po_Requisition_Lines NUMBER DEFAULT NULL,
X_Po_Req_Distributions NUMBER DEFAULT NULL,
X_Po_Approvals NUMBER DEFAULT NULL,
X_Po_Headers NUMBER DEFAULT NULL,
X_Po_Lines NUMBER DEFAULT NULL,
X_Po_Line_Locations NUMBER DEFAULT NULL,
X_Po_Distributions NUMBER DEFAULT NULL,
X_Po_Releases NUMBER DEFAULT NULL,
X_Po_Item_History NUMBER DEFAULT NULL,
X_Po_Acceptances NUMBER DEFAULT NULL,
X_Po_Notes NUMBER DEFAULT NULL,
X_Po_Note_References NUMBER DEFAULT NULL,
X_Po_Receipts NUMBER DEFAULT NULL,
X_Po_Deliveries NUMBER DEFAULT NULL,
X_Po_Quality_Inspections NUMBER DEFAULT NULL,
X_Po_Vendors NUMBER DEFAULT NULL,
X_Po_Vendor_Sites NUMBER DEFAULT NULL,
X_Po_Vendor_Contacts NUMBER DEFAULT NULL,
X_Po_Headers_Archive NUMBER DEFAULT NULL,
X_Po_Lines_Archive NUMBER DEFAULT NULL,
X_Po_Line_Locations_Archive NUMBER DEFAULT NULL,
X_Po_Vendor_List_Headers NUMBER DEFAULT NULL,
X_Po_Vendor_List_Entries NUMBER DEFAULT NULL,
X_Po_Notifications NUMBER DEFAULT NULL,
X_Po_Accrual_Reconcile_Temp NUMBER DEFAULT NULL,
X_Po_Blanket_Items NUMBER DEFAULT NULL,
X_Po_Receipt_Headers NUMBER DEFAULT NULL,
X_Organization_Id NUMBER DEFAULT NULL,
X_Po_Approved_Supplier_List NUMBER DEFAULT NULL,
X_Po_Asl_Attributes NUMBER DEFAULT NULL,
X_Po_Asl_Documents NUMBER DEFAULT NULL,
X_Chv_Authorizations NUMBER DEFAULT NULL,
X_Chv_Cum_Adjustments NUMBER DEFAULT NULL,
X_Chv_Cum_Periods NUMBER DEFAULT NULL,
X_Chv_Cum_Period_Items NUMBER DEFAULT NULL,
X_Chv_Horizontal_Schedules NUMBER DEFAULT NULL,
X_Chv_Item_Orders NUMBER DEFAULT NULL,
X_Chv_Schedule_Headers NUMBER DEFAULT NULL,
X_Chv_Schedule_Items NUMBER DEFAULT NULL,
X_Mrp_Sr_Source_Org NUMBER DEFAULT NULL,
X_Mrp_Item_Sourcing NUMBER DEFAULT NULL,
X_Action VARCHAR2 DEFAULT NULL,
X_calling_sequence IN VARCHAR2,
X_Org_Id NUMBER
) IS
CURSOR C IS SELECT rowid FROM FINANCIALS_PURGES
WHERE purge_name = X_Purge_Name;
current_calling_sequence := 'FINANCIALS_PURGES_PKG.INSERT_ROW<-' ||
X_calling_sequence;
debug_info := 'Insert into FINANCIALS_PURGES';
INSERT INTO FINANCIALS_PURGES(
purge_name,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
category,
status,
activity_date,
ap_checks,
ap_invoice_payments,
ap_payment_schedules,
ap_recurring_payments,
ap_trial_balance,
ap_holds,
ap_invoice_distributions,
ap_batches,
ap_invoices,
po_requisition_headers,
po_requisition_lines,
po_req_distributions,
po_approvals,
po_headers,
po_lines,
po_line_locations,
po_distributions,
po_releases,
po_item_history,
po_acceptances,
po_notes,
po_note_references,
po_receipts,
po_deliveries,
po_quality_inspections,
po_vendors,
po_vendor_sites,
po_vendor_contacts,
po_headers_archive,
po_lines_archive,
po_line_locations_archive,
po_vendor_list_headers,
po_vendor_list_entries,
po_notifications,
po_accrual_reconcile_temp,
po_blanket_items,
po_receipt_headers,
Organization_Id,
Po_Approved_Supplier_List,
Po_Asl_Attributes,
Po_Asl_Documents,
Chv_Authorizations,
Chv_Cum_Adjustments,
Chv_Cum_Periods,
Chv_Cum_Period_Items,
Chv_Horizontal_Schedules,
Chv_Item_Orders,
Chv_Schedule_Headers,
Chv_Schedule_Items,
Mrp_Sr_Source_Org,
Mrp_Item_Sourcing,
action,
org_id
) VALUES (
X_Purge_Name,
X_Creation_Date,
X_Created_By,
X_Last_Update_Date,
X_Last_Updated_By,
X_Last_Update_Login,
X_Category,
X_Status,
X_Activity_Date,
X_Ap_Checks,
X_Ap_Invoice_Payments,
X_Ap_Payment_Schedules,
X_Ap_Recurring_Payments,
X_Ap_Trial_Balance,
X_Ap_Holds,
X_Ap_Invoice_Distributions,
X_Ap_Batches,
X_Ap_Invoices,
X_Po_Requisition_Headers,
X_Po_Requisition_Lines,
X_Po_Req_Distributions,
X_Po_Approvals,
X_Po_Headers,
X_Po_Lines,
X_Po_Line_Locations,
X_Po_Distributions,
X_Po_Releases,
X_Po_Item_History,
X_Po_Acceptances,
X_Po_Notes,
X_Po_Note_References,
X_Po_Receipts,
X_Po_Deliveries,
X_Po_Quality_Inspections,
X_Po_Vendors,
X_Po_Vendor_Sites,
X_Po_Vendor_Contacts,
X_Po_Headers_Archive,
X_Po_Lines_Archive,
X_Po_Line_Locations_Archive,
X_Po_Vendor_List_Headers,
X_Po_Vendor_List_Entries,
X_Po_Notifications,
X_Po_Accrual_Reconcile_Temp,
X_Po_Blanket_Items,
X_Po_Receipt_Headers,
X_Organization_Id,
X_Po_Approved_Supplier_List,
X_Po_Asl_Attributes,
X_Po_Asl_Documents,
X_Chv_Authorizations,
X_Chv_Cum_Adjustments,
X_Chv_Cum_Periods,
X_Chv_Cum_Period_Items,
X_Chv_Horizontal_Schedules,
X_Chv_Item_Orders,
X_Chv_Schedule_Headers,
X_Chv_Schedule_Items,
X_Mrp_Sr_Source_Org,
X_Mrp_Item_Sourcing,
X_Action,
X_Org_Id
);
END Insert_Row;
SELECT *
FROM FINANCIALS_PURGES
WHERE rowid = X_Rowid
FOR UPDATE of Purge_Name NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Delete_Row(X_Rowid VARCHAR2,
X_calling_sequence IN VARCHAR2
) IS
current_calling_sequence VARCHAR2(2000);
current_calling_sequence := 'FINANCIALS_PURGES_PKG.DELETE_ROW<-' ||
X_calling_sequence;
debug_info := 'Delete from FINANCIALS_PURGES';
DELETE FROM FINANCIALS_PURGES
WHERE rowid = X_Rowid;
END Delete_Row;