Update Flag in another table when record is inserted
742134Jan 3 2010 — edited Jan 3 2010Hi All,
I am new to oracle form and working on my aasignment.
I have created 2 form 1.Requisiton 2.Purchase Order
I have created one 'find' form which will find requisition number form requisition table and once I click on 'AutocreateButton'. It will open Purchase order form and will default all values form selected requisition number and will create Purchase order.
Problem statement.
Currently I have insured one more Column PO_CREATED_FLAG in 'Requisition header' column once i click on save button on purchase order form i want to update 'Y' Value in PO_CREATED_FLAG in Requisition header table.
Table Names
PO_REQUISITION_HEADERS (COLUMN 'PO_CREATED_FLAG')
PO_REQUISITION_LINES
PO_HEADERS
PO_LINES
Please help
Archana