APPS.IEX_WF_BAN_STATUS_PUB SQL Statements

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

Line: 46

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

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

Line: 105

		SELECT user_name INTO l_user_name from JTF_RS_RESOURCE_EXTNS
		WHERE user_id = p_user_id;

Line: 117

            SELECT party_name INTO l_party_name from hz_parties
              where party_id = p_party_id;

Line: 144

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

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

Line: 285

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

  l_api_name             := 'update_approval_status';

Line: 329

	iex_debug_pub.logmessage ('update_approval_status start');

Line: 357

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

Line: 367

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

Line: 371

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

Line: 372

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

Line: 373

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

Line: 390

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

Line: 422

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

Line: 425

END update_approval_status;

Line: 428

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

  l_api_name  := 'update_rejection_status';

Line: 473

    update IEX_BANKRUPTCIES
      set DISPOSITION_CODE = 'WITHDRAWN'
           where party_id = l_party_id
             --and delinquency_id = l_delinquency_id
             and disposition_code is null;

Line: 490

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

Line: 494

END update_rejection_status;

Line: 523

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

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

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

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

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

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

Line: 714

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

  SELECT cas_id
  FROM iex_cases_all_b
  WHERE party_id = p_party_id;

Line: 828

  SELECT delinquency_id
  FROM iex_delinquencies
  WHERE case_id = p_case_id ;

Line: 1009

  SELECT cas_id
  FROM iex_cases_all_b
  WHERE party_id = p_party_id;

Line: 1014

  SELECT delinquency_id
  FROM iex_delinquencies
  WHERE case_id = p_case_id;

Line: 1232

    select disposition_code
    into l_disposition_code
    from iex_bankruptcies
    where bankruptcy_id = p_bankruptcy_id;

Line: 1296

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

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

Line: 1314

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

Line: 1360

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

Line: 1363

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