APPS.IEX_WF_DEL_STATUS_PUB SQL Statements

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

Line: 156

PROCEDURE update_approval_status(itemtype  IN  varchar2,
                                 itemkey   IN  varchar2,
                                 actid     IN  number,
                                 funcmode  IN  varchar2,
                                 result    OUT NOCOPY  varchar2) is

  l_responder           varchar2(100);

Line: 168

  l_api_name            VARCHAR2(100) := 'update_approval_status';

Line: 182

     update IEX_WRITEOFFS
     set SUGGESTION_APPROVED_FLAG = 'Y',
         WRITEOFF_DATE = sysdate
     where WRITEOFF_ID = to_number(substr(itemkey, 2));

Line: 187

     update IEX_REPOSSESSIONS
     set SUGGESTION_APPROVED_FLAG = 'Y',
         REPOSSESSION_DATE = sysdate
     where REPOSSESSION_ID = to_number(substr(itemkey, 2));

Line: 192

     update IEX_LITIGATIONS
     set SUGGESTION_APPROVED_FLAG = 'Y'
     where LITIGATION_ID = to_number(substr(itemkey, 2));

Line: 208

END update_approval_status;

Line: 211

procedure update_rejection_status(
        itemtype  IN  varchar2,
        itemkey   IN  varchar2,
        actid     IN  number,
        funcmode  IN  varchar2,
        result    OUT NOCOPY varchar2) is

  l_responder           varchar2(100);

Line: 221

  l_api_name            VARCHAR2(100) := 'update_rejection_status';

Line: 235

     update IEX_WRITEOFFS
     set SUGGESTION_APPROVED_FLAG = 'N',
         WRITEOFF_DATE = sysdate
     where WRITEOFF_ID = to_number(substr(itemkey, 2));

Line: 240

     update IEX_REPOSSESSIONS
     set SUGGESTION_APPROVED_FLAG = 'N',
         REPOSSESSION_DATE = sysdate
     where REPOSSESSION_ID = to_number(substr(itemkey, 2));

Line: 245

     update IEX_LITIGATIONS
     set SUGGESTION_APPROVED_FLAG = 'N'
     where LITIGATION_ID = to_number(substr(itemkey, 2));

Line: 261

END update_rejection_status;