APPS.IEX_WF_DEL_REQ_CREDIT_PUB SQL Statements

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

Line: 51

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

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

Line: 111

         select party_id,party_name into l_party_id,l_party_name from hz_parties
           where party_id = (select party_id from iex_delinquencies_all where delinquency_id = p_delinquency_id);

Line: 114

         select account_number into l_account_number from hz_cust_accounts
           where cust_account_id = (select cust_account_id from iex_delinquencies_all where delinquency_id = p_delinquency_id);

Line: 161

         select party_id,party_name into l_party_id,l_party_name from hz_parties
           where party_id = (select party_id from iex_repossessions where repossession_id = p_repossession_id);

Line: 164

         select account_number into l_account_number from hz_cust_accounts
           where cust_account_id = (select cust_account_id from iex_repossessions where repossession_id = p_repossession_id);

Line: 211

         select party_id,party_name into l_party_id,l_party_name from hz_parties
           where party_id = (select party_id from iex_litigations where litigation_id = p_litigation_id);

Line: 214

         select account_number into l_account_number from hz_cust_accounts
           where cust_account_id = (select cust_account_id from iex_litigations where litigation_id = p_litigation_id);

Line: 261

         select party_id,party_name into l_party_id,l_party_name from hz_parties
           where party_id = (select party_id from iex_writeoffs where writeoff_id = p_writeoff_id);

Line: 264

         select account_number into l_account_number from hz_cust_accounts
           where cust_account_id = (select cust_account_id from iex_writeoffs where writeoff_id = p_writeoff_id);

Line: 312

         select party_id,party_name into l_party_id,l_party_name from hz_parties
           where party_id = (select party_id from iex_bankruptcies where bankruptcy_id = p_bankruptcy_id);

Line: 315

        select account_number into l_account_number from hz_cust_accounts hc
          where exists (select 1 from iex_bankruptcies bk where bankruptcy_id = p_bankruptcy_id
                         and attribute15 = 'ACCOUNT' and hc.cust_account_id = bk.cust_account_id);

Line: 344

		SELECT user_name INTO l_user_name from JTF_RS_RESOURCE_EXTNS
		WHERE user_id = p_user_id;

Line: 436

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

  l_api_name     				VARCHAR2(100) := 'update_approval_status';

Line: 461

     select cust_account_id
       from hz_cust_accounts hz
      where party_id = (select party_id from iex_bankruptcies
                          where bankruptcy_id = in_bankruptcy_id)
        and hz.cust_account_id = (select decode(bc.attribute15,'ACCOUNT',bc.cust_account_id,hz.cust_account_id) from iex_bankruptcies bc
                                where bankruptcy_id = in_bankruptcy_id)  -- add by bug 15935812
        and status = 'A';

Line: 480

  iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: Starting update_approval_status......= ');

Line: 525

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

Line: 529

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

Line: 533

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

Line: 537

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

Line: 542

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

Line: 570

                IEX_CREDIT_HOLD_API.UPDATE_CREDIT_HOLD
                           (p_api_version      => 1.0,
                            p_init_msg_list    => 'T',
                            p_commit           => 'T',
                            p_account_id       => l_acct_id_tbl(i),
                            p_site_id          => null  ,
                            p_credit_hold      => 'Y',
                            x_return_status    => l_return_status,
                            x_msg_count        => l_msg_count,
                            x_msg_data         => l_msg_data);

Line: 607

END update_approval_status;

Line: 610

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

  l_api_name     				VARCHAR2(100) := 'update_rejection_status';

Line: 669

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

Line: 673

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

Line: 677

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

Line: 681

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

Line: 685

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

Line: 702

END update_rejection_status;