APPS.AMS_GENERIC_NTFY_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 236

PROCEDURE Update_Gen_Status(itemtype IN varchar2,
                        itemkey  IN varchar2,
                        actid           in  number,
                        funcmode        in  varchar2,
                        resultout       OUT NOCOPY varchar2    )
IS
l_stat      varchar2(80);

Line: 254

                                 aname    => 'UPDATE_STATUS' );

Line: 261

                             aname      =>  'UPDATE_GEN_STATUS',
                             avalue     =>   l_stat  );

Line: 284

END Update_Gen_Status;