APPS.IEX_WF_DEL_REQ_SERVICE_PUB SQL Statements

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

Line: 48

      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: 78

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

Line: 217

		SELECT user_name INTO l_user_name from JTF_RS_RESOURCE_EXTNS
		WHERE user_id = p_user_id;

Line: 320

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: 338

  l_api_name     				VARCHAR2(100) := 'update_approval_status';

Line: 386

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

Line: 390

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

Line: 394

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

Line: 398

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

Line: 402

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

Line: 418

END update_approval_status;

Line: 421

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: 438

  l_api_name     				VARCHAR2(100) := 'update rejection Status';

Line: 465

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

Line: 474

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

Line: 483

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

Line: 492

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

Line: 501

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

Line: 518

END update_rejection_status;

Line: 521

procedure select_type(
            itemtype            IN VARCHAR2,
            itemkey             IN VARCHAR2,
            actid	              IN NUMBER,
            funcmode            IN VARCHAR2,
            result              OUT NOCOPY VARCHAR2
) is
  l_responder           varchar2(100);

Line: 535

  l_api_name     				VARCHAR2(100) := 'select type';

Line: 542

     update IEX_DELINQUENCIES_ALL
     set SERVICE_HOLD_APPROVED_FLAG = 'N'
     where delinquency_id = TO_NUMBER(substr(itemkey, 3));

Line: 546

     update IEX_REPOSSESSIONS
     set SERVICE_HOLD_APPROVED_FLAG = 'N'
     where repossession_id = TO_NUMBER(substr(itemkey, 3));

Line: 550

     update IEX_LITIGATIONS
     set SERVICE_HOLD_APPROVED_FLAG = 'N'
     where litigation_id = TO_NUMBER(substr(itemkey, 3));

Line: 554

     update IEX_WRITEOFFS
     set SERVICE_HOLD_APPROVED_FLAG = 'N'
     where writeoff_id = TO_NUMBER(substr(itemkey, 3));

Line: 558

     update IEX_BANKRUPTCIES
     set SERVICE_HOLD_APPROVED_FLAG = 'Y'
     where bankruptcy_id = TO_NUMBER(substr(itemkey, 4));

Line: 571

      WF_CORE.Context('IEX_WF_DEL_REQ_SERVICE_PUB', 'Select Type',
		      itemtype, itemkey, actid, funcmode);

Line: 574

END select_type;