Hi All,
If I modify the data from Oracle form.
this is inserting data into a table TMSSRT.
There is only one procedure(P_INS_TMSSRT) which is inserting data into the table TMSSRT.
The procedure P_INS_TMSSRT is calling in 3 packages.
I want to know when I modify the data from the form
how data is being inserting in the the table TMSSRT.
Is that form directly calling this P_INS_TMSSRT (or) calling through any one of the 3 packages.
I queried v$sql from there I am able to find only the text INSERT INTO TMSSRT.
I am not able to find the text for procedure P_INS_TMSSRT (or) any of the 3 packages.
I though its a direct insert statement and dropped the procedure P_INS_TMSSRT
and tried modifying the data from the form and got the error program unit not found.
Then I confirmed data is inserting through the procedure P_INS_TMSSRT.
Please help me to find how the data is inserting in the table TMSSRT through the form
by the procedure P_INS_TMSSRT.
I want to know the program unit being called by the form when I modify the data through the form.
Thanks in advance.