Hope every thing is going fine with you..
Here I got a requirement : Maker - Checker option
MY DB Details:
Code: Select all
Oracle Database 10g Release 10.2.0.1.0 - Production
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
Front-end : Oracle forms and Reports 6i
I need a suggestion..
There is an application already developed, now they need an enhancement of Maker-Checker policy. It means one (Maker) should initiate an issue, and another (Checker) should approve it. After Checker approval only it will be available for all other users to see the values. Before there was not Checker option, they were working directly.
For this Need to add one column to table or to draw a new table for the same. In Oracle Applications, there is an option like "Workflows" available to handle these type of issues. So, Is there any such option to handle directly from Backend or I need to write any Pl/SQL Code / or to handlr from front-end itself..
Thanks in Advance,