Help on Automatic Row Processing (DML)
joelsMar 2 2009 — edited Mar 4 2009Hi guys,
I need some help again :(
I created a Form on a Table with Report.
my table (EMP_DEPENDANTS) has the following structure.
EMPLOYEE_ID
SEQ_NO
FULL_NAME
So this table basically will have the EMPLOYEE_ID of the person who enter's his/her dependants data, and SEQ_NO is just a running number that retreve using GET_NEXT_DEPENDANT_SEQNO(p_employee_id).
1. I have problem in adding/creating new record with the Primary Key (EMPLOYEE_ID and SEQ_NO)
2. I have an item called P0_EMPLOYEE_ID which I currently hardcode to '1'
My question :
----------------------------------------------
1. How do I make the Insert process (when I click 'Create' button) to take the EMPLOYEE_ID from P0_EMPLOYEE_ID and SEQ_NO to get the return value of my function GET_NEXT_DEPENDANT_SEQ_NO(:P0_EMPLOYEE_ID)
2. I kinda noticed that I probably should create a seperate process for the INSERT because the built-in process that the wizard create should still get the PK from the original item (Px_EMPLOYEE_ID and Px_SEQ_NO) for UPDATE and DELETE process.
Am I right?
Can anyone help to let me know how to do this please? I am totally confused :(
I tried everything that I could think of.