APPS.IEX_WF_DEL_REQ_CREDIT_PUB SQL Statements

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

Line: 47

      SELECT b.user_id, b.user_name
      FROM JTF_RS_RESOURCE_EXTNS a
      ,    JTF_RS_RESOURCE_EXTNS b
      WHERE b.source_id = a.source_mgr_id
      AND a.user_id = p_user_id;

Line: 77

    SELECT TO_CHAR(IEX_DEL_WF_S.NEXTVAL) INTO itemkey FROM dual;

Line: 209

		SELECT user_name INTO l_user_name from JTF_RS_RESOURCE_EXTNS
		WHERE user_id = p_user_id;

Line: 301

PROCEDURE update_approval_status(
						itemtype    				IN VARCHAR2,
            itemkey     				IN VARCHAR2,
            actid								IN NUMBER,
            funcmode    				IN VARCHAR2,
            result      				OUT NOCOPY VARCHAR2
) is

  l_manager_name 				varchar2(60);

Line: 320

  l_api_name     				VARCHAR2(100) := 'update_approval_status';

Line: 367

     update IEX_DELINQUENCIES_ALL
     set CREDIT_HOLD_APPROVED_FLAG = 'Y'
     where delinquency_id = l_delinquency_id;

Line: 371

     update IEX_REPOSSESSIONS
     set CREDIT_HOLD_APPROVED_FLAG = 'Y'
     where repossession_id = l_repossession_id;

Line: 375

     update IEX_LITIGATIONS
     set CREDIT_HOLD_APPROVED_FLAG = 'Y'
     where litigation_id = l_litigation_id;

Line: 379

     update IEX_WRITEOFFS
     set CREDIT_HOLD_APPROVED_FLAG = 'Y'
     where writeoff_id = l_writeoff_id;

Line: 383

     update IEX_BANKRUPTCIES
     set CREDIT_HOLD_APPROVED_FLAG = 'Y'
     where bankruptcy_id = l_bankruptcy_id;

Line: 399

END update_approval_status;

Line: 402

procedure update_rejection_status(
						itemtype    				IN VARCHAR2,
            itemkey     				IN VARCHAR2,
            actid								IN NUMBER,
            funcmode    				IN VARCHAR2,
            result      				OUT NOCOPY VARCHAR2
) is

  l_manager_name 				varchar2(60);

Line: 420

  l_api_name     				VARCHAR2(100) := 'update_rejection_status';

Line: 461

     update IEX_DELINQUENCIES_ALL
     set CREDIT_HOLD_APPROVED_FLAG = 'N'
     where delinquency_id = l_delinquency_id;

Line: 465

     update IEX_REPOSSESSIONS
     set CREDIT_HOLD_APPROVED_FLAG = 'N'
     where repossession_id = l_repossession_id;

Line: 469

     update IEX_LITIGATIONS
     set CREDIT_HOLD_APPROVED_FLAG = 'N'
     where litigation_id = l_litigation_id;

Line: 473

     update IEX_WRITEOFFS
     set CREDIT_HOLD_APPROVED_FLAG = 'N'
     where writeoff_id = l_writeoff_id;

Line: 477

     update IEX_BANKRUPTCIES
     set CREDIT_HOLD_APPROVED_FLAG = 'N'
     where bankruptcy_id = l_bankruptcy_id;

Line: 494

END update_rejection_status;