APPS.IEX_WF_BAN_STATUS_PUB SQL Statements

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

Line: 18

    select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
      where party_id = c_party_id
        and nvl(attribute15,'A') <> 'ACCOUNT'
        and trunc(creation_date) <= c_date
        and nvl(disposition_code,'A') not in ('DISMISSED' , 'WITHDRAWN')

    UNION

      select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
        where party_id = c_party_id
          and nvl(attribute15,'A') <> 'ACCOUNT'
          and trunc(creation_date) <= c_date
          and nvl(disposition_code,'A') = 'DISMISSED'
          and trunc(nvl(dismissal_date,last_update_date)) > c_date

    UNION

      select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
        where party_id = c_party_id
          and nvl(attribute15,'A') <> 'ACCOUNT'
          and trunc(creation_date) <= c_date
          and nvl(disposition_code,'A') = 'WITHDRAWN'
          and trunc(nvl(withdraw_date,last_update_date)) > c_date

    order by bankruptcy_id desc;

Line: 47

    select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
      where party_id = c_party_id
        and nvl(cust_account_id,-1) = c_cust_account_id
        and nvl(attribute15,'A') = 'ACCOUNT'
        and trunc(creation_date) <= c_date
        and nvl(disposition_code,'A') not in ('DISMISSED' , 'WITHDRAWN')

    UNION

      select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
        where party_id = c_party_id
          and nvl(cust_account_id,-1) = c_cust_account_id
          and nvl(attribute15,'A') = 'ACCOUNT'
          and trunc(creation_date) <= c_date
          and nvl(disposition_code,'A') = 'DISMISSED'
          and trunc(nvl(dismissal_date,last_update_date)) > c_date

    UNION

      select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
        where party_id = c_party_id
          and nvl(cust_account_id,-1) = c_cust_account_id
          and nvl(attribute15,'A') = 'ACCOUNT'
          and trunc(creation_date) <= c_date
          and nvl(disposition_code,'A') = 'WITHDRAWN'
          and trunc(nvl(withdraw_date,last_update_date)) > c_date

    order by bankruptcy_id desc;

Line: 153

    select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
      where party_id = c_party_id
        and nvl(cust_account_id,c_cust_account_id) = c_cust_account_id
        and trunc(creation_date) <= c_date
        and nvl(disposition_code,'A') not in ('DISMISSED' , 'WITHDRAWN')
    UNION
      select  bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
        where party_id = c_party_id
          and nvl(cust_account_id,c_cust_account_id) = c_cust_account_id
          and trunc(creation_date) <= c_date
          and nvl(disposition_code,'A') = 'DISMISSED'
          and trunc(nvl(dismissal_date,last_update_date)) > c_date
    UNION
      select  bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
        where party_id = c_party_id
          and nvl(cust_account_id,c_cust_account_id) = c_cust_account_id
          and trunc(creation_date) <= c_date
          and nvl(disposition_code,'A') = 'WITHDRAWN'
          and trunc(nvl(withdraw_date,last_update_date)) > c_date
    UNION
      select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
        where party_id = c_party_id
          and trunc(creation_date) <= c_date
          and nvl(attribute15,'A') = 'PARTY'
          and nvl(disposition_code,'A') not in ('DISMISSED' , 'WITHDRAWN')
    UNION
      select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
        where party_id = c_party_id
          and trunc(creation_date) <= c_date
          and nvl(attribute15,'A') = 'PARTY'
          and nvl(disposition_code,'A') = 'DISMISSED'
          and trunc(nvl(dismissal_date,last_update_date)) > c_date
    UNION
      select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
        where party_id = c_party_id
          and trunc(creation_date) <= c_date
          and nvl(attribute15,'A') = 'PARTY'
          and NVL(disposition_code,'A') = 'WITHDRAWN'
          and trunc(nvl(withdraw_date,last_update_date)) > c_date
    order by bankruptcy_id desc;

Line: 261

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

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

Line: 320

		SELECT user_name INTO l_user_name from JTF_RS_RESOURCE_EXTNS
		WHERE user_id = p_user_id;

Line: 332

            SELECT party_name INTO l_party_name from hz_parties
              where party_id = p_party_id;

Line: 359

    select b.bankruptcy_id bankruptcy_id
    into l_bankruptcy_id
    from iex_delinquencies d, iex_bankruptcies b
    where d.delinquency_id = b.delinquency_id
    and d.delinquency_id = p_delinquency_id;

Line: 370

    select bankruptcy_id bankruptcy_id
    into l_bankruptcy_id
    from iex_bankruptcies
    where party_id= p_party_id
    and DISPOSITION_CODE is NULL;

Line: 379

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

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

  l_api_version      	  number;

Line: 550

  l_api_name             := 'update_approval_status';

Line: 560

	iex_debug_pub.logmessage ('update_approval_status start');

Line: 566

    select collections_methods into l_collections_methods from iex_questionnaire_items;

Line: 598

	iex_debug_pub.logmessage ('update_approval_status start, before getting the bankruptcy id');

Line: 608

        	iex_debug_pub.logmessage ('update_approval_status start, after getting the bankruptcy id');

Line: 612

	    iex_debug_pub.logmessage ('update_approval_status: ' || 'l_delinquency_id : '||l_delinquency_id);

Line: 613

	    iex_debug_pub.logmessage ('update_approval_status: ' || 'l_bankruptcy_id : '||l_bankruptcy_id);

Line: 614

	    iex_debug_pub.logmessage ('update_approval_status: ' || 'l_party_id : '||l_party_id);

Line: 631

        	iex_debug_pub.logmessage ('update_approval_status:'||l_return_status);

Line: 661

    update IEX_BANKRUPTCIES set approval_date = sysdate
      where bankruptcy_id = l_bankruptcy_id;

Line: 674

      WF_CORE.Context('IEX_WF_BAN_STATUS_PUB', 'update_approval_status',
		      itemtype, itemkey, actid, funcmode);

Line: 677

END update_approval_status;

Line: 680

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

  l_api_name  := 'update_rejection_status';

Line: 733

      select attribute15,cust_account_id into l_att15,l_cust_account_id from iex_bankruptcies where bankruptcy_id = l_bankruptcy_id;

Line: 743

       update IEX_BANKRUPTCIES set DISPOSITION_CODE = 'WITHDRAWN',WITHDRAW_DATE = sysdate
         where bankruptcy_id = l_bankruptcy_id;

Line: 746

       update IEX_BANKRUPTCIES
          set DISPOSITION_CODE = 'WITHDRAWN',WITHDRAW_DATE = sysdate
           where party_id = l_party_id;

Line: 764

      WF_CORE.Context('IEX_WF_BAN_STATUS_PUB', 'update_rejection_status',
		      itemtype, itemkey, actid, funcmode);

Line: 768

END update_rejection_status;

Line: 797

  SELECT contact_preference_id FROM HZ_CONTACT_PREFERENCES
  WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
  AND CONTACT_LEVEL_TABLE_ID = P_PERSON_ID
  AND PREFERENCE_CODE = 'DO';

Line: 803

  SELECT contact_preference_id FROM HZ_CONTACT_PREFERENCES
  WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
  AND CONTACT_LEVEL_TABLE_ID = P_PERSON_ID
  AND PREFERENCE_CODE = 'DO_NOT';

Line: 812

  SELECT
    P.PARTY_ID
--  , P.PARTY_NAME
  FROM
    HZ_RELATIONSHIPS   REL
  , HZ_PARTIES               C
  , HZ_PARTIES               P
  , HZ_PARTIES               O
  WHERE O.PARTY_TYPE = 'ORGANIZATION'
  AND O.PARTY_ID = REL.OBJECT_ID
  AND P.PARTY_TYPE = 'PERSON'
  AND P.PARTY_ID = REL.SUBJECT_ID
  AND C.PARTY_TYPE = 'PARTY_RELATIONSHIP'
  AND REL.PARTY_ID = C.PARTY_ID
  AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
  AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
  AND REL.DIRECTIONAL_FLAG = 'F'
  AND O.PARTY_ID = p_org_party_id;

Line: 833

  SELECT
    P.PARTY_ID
--  , P.PARTY_NAME
  FROM
    HZ_PARTY_RELATIONSHIPS   REL
  , HZ_PARTIES               C
  , HZ_PARTIES               P
  , HZ_PARTIES               O
  WHERE O.PARTY_TYPE = 'ORGANIZATION'
  AND O.PARTY_ID = REL.OBJECT_ID
  AND P.PARTY_TYPE = 'PERSON'
  AND P.PARTY_ID = REL.SUBJECT_ID
  AND C.PARTY_TYPE = 'PARTY_RELATIONSHIP'
  AND REL.PARTY_ID = C.PARTY_ID
  AND O.PARTY_ID = p_org_party_id;*/

Line: 903

         HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference (
           p_init_msg_list            =>  l_init_msg_list,
           p_contact_preference_rec   =>  l_contact_preference_rec,
           p_object_version_number    =>  l_object_version_number,
           x_return_status            =>  l_return_status,
           x_msg_count                =>  l_msg_count,
           x_msg_data                 =>  l_msg_data);

Line: 914

          iex_debug_pub.logmessage ('set_no_contact_in_tca: ' || 'Update Contact Preference:'||l_return_status);

Line: 988

  HZ_contact_perference_v2pub.update_contact_preference (
    p_init_msg_list                         IN      VARCHAR2:= FND_API.G_FALSE,
    p_contact_preference_rec                IN      CONTACT_PREFERENCE_REC_TYPE,
    p_object_version_number                 IN OUT NOCOPY  NUMBER,
    x_return_status                         OUT NOCOPY     VARCHAR2,
    x_msg_count                             OUT NOCOPY     NUMBER,
    x_msg_data                              OUT NOCOPY     VARCHAR2);

Line: 1097

  SELECT cas_id
  FROM iex_cases_all_b
  WHERE party_id = p_party_id;

Line: 1102

  SELECT delinquency_id
  FROM iex_delinquencies
  WHERE case_id = p_case_id ;

Line: 1283

  SELECT cas_id
  FROM iex_cases_all_b
  WHERE party_id = p_party_id;

Line: 1288

  SELECT delinquency_id
  FROM iex_delinquencies
  WHERE case_id = p_case_id;

Line: 1506

    select disposition_code
    into l_disposition_code
    from iex_bankruptcies
    where bankruptcy_id = p_bankruptcy_id;

Line: 1570

select st.strategy_id
from iex_strategies st
where st.status_code = 'OPEN'
and st.jtf_object_type = 'IEX_BANKRUPTCY'
and st.jtf_object_id = l_bkrid;

Line: 1585

       select distinct item_key from wf_item_attr_values_ondemand
         where name = 'BANKRUPTCY_ID' and number_value = c_id and item_type = 'IEXDELCR';

Line: 1588

       select distinct item_key from wf_item_attr_values_ondemand
         where name = 'BANKRUPTCY_ID' and number_value = c_id and item_type = 'IEXDELCS';

Line: 1634

			Update iex_strategies set status_code =  'CANCELLED'
			 where  strategy_id = l_startegy_id;

Line: 1637

			update iex_strategy_work_items
			set status_code =  'CANCELLED'
			where  strategy_id = l_startegy_id
			and status_code in ('PRE-WAIT','OPEN');

Line: 1756

           SELECT nvl(TURN_OFF_INVOICING_YN,'N') FROM iex_bankruptcies
            WHERE bankruptcy_id = p_bankruptcy_id;