APPS.PV_REFERRALS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_REFERRAL_ID in NUMBER,
  X_ACTUAL_CURRENCY_CODE in VARCHAR2,
  X_BENEFIT_TYPE_CODE in VARCHAR2,
  X_CUSTOMER_CONTACT_PHONE_TYPE in VARCHAR2,
  X_CUSTOMER_CONTACT_EMAIL_ADDRE in VARCHAR2,
  X_CUSTOMER_CONTACT_PHONE_EXT in VARCHAR2,
  X_DECLINE_REASON_CODE in VARCHAR2,
  X_ENTITY_TYPE in VARCHAR2,
  X_ORDER_ID in NUMBER,
  X_CLAIM_ID in NUMBER,
  X_CLAIM_NUMBER in VARCHAR2,
  X_EST_COMPENSATION_AMT in NUMBER,
  X_CURRENCY_CODE in VARCHAR2,
  X_ACTUAL_COMPENSATION_AMT in NUMBER,
  X_STATUS_CHANGE_DATE in DATE,
  X_DUPLICATE_CUSTOMER_FLAG in VARCHAR2,
  X_PARTNER_CUST_ACCOUNT_ID in NUMBER,
  X_CUSTOMER_COUNTRY in VARCHAR2,
  X_CUSTOMER_CONTACT_TITLE in VARCHAR2,
  X_CUSTOMER_CONTACT_FIRST_NAME in VARCHAR2,
  X_CUSTOMER_CONTACT_LAST_NAME in VARCHAR2,
  X_CUSTOMER_CONTACT_CNTRY_CODE in VARCHAR2,
  X_CUSTOMER_CONTACT_AREA_CODE in VARCHAR2,
  X_CUSTOMER_CONTACT_PHONE_NO in VARCHAR2,
  X_CUSTOMER_PROVINCE in VARCHAR2,
  X_CUSTOMER_POSTAL_CODE in VARCHAR2,
  X_CUSTOMER_COUNTY in VARCHAR2,
  X_ENTITY_ID_LINKED_TO in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_BENEFIT_ID in NUMBER,
  X_REFERRAL_CODE in VARCHAR2,
  X_REFERRAL_STATUS in VARCHAR2,
  X_PARTNER_ID in NUMBER,
  X_PARTNER_CONTACT_RESOURCE_ID in NUMBER,
  X_CUSTOMER_PARTY_ID in NUMBER,
  X_CUSTOMER_ORG_CONTACT_ID in NUMBER,
  X_CUSTOMER_CONTACT_PARTY_ID in NUMBER,
  X_CUSTOMER_PARTY_SITE_ID in NUMBER,
  X_CUSTOMER_NAME in VARCHAR2,
  X_CUSTOMER_ADDRESS_TYPE in VARCHAR2,
  X_CUSTOMER_ADDRESS1 in VARCHAR2,
  X_CUSTOMER_ADDRESS2 in VARCHAR2,
  X_CUSTOMER_ADDRESS3 in VARCHAR2,
  X_CUSTOMER_ADDRESS4 in VARCHAR2,
  X_ADDRESS_LINES_PHONETIC in VARCHAR2,
  X_CUSTOMER_CITY in VARCHAR2,
  X_CUSTOMER_STATE in VARCHAR2,
  X_REFERRAL_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_ORG_ID in NUMBER,
  X_SECURITY_GROUP_ID in NUMBER,
  X_CUSTOMER_NAME_PRONOUNCIATION in VARCHAR2,
  X_RETURN_REASON_CODE in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1  in VARCHAR2,
  X_ATTRIBUTE2  in VARCHAR2,
  X_ATTRIBUTE3  in VARCHAR2,
  X_ATTRIBUTE4  in VARCHAR2,
  X_ATTRIBUTE5   in VARCHAR2,
  X_ATTRIBUTE6   in VARCHAR2,
  X_ATTRIBUTE7   in VARCHAR2,
  X_ATTRIBUTE8   in VARCHAR2,
  X_ATTRIBUTE9   in VARCHAR2,
  X_ATTRIBUTE10  in VARCHAR2,
  X_ATTRIBUTE11  in VARCHAR2,
  X_ATTRIBUTE12  in VARCHAR2,
  X_ATTRIBUTE13  in VARCHAR2,
  X_ATTRIBUTE14  in VARCHAR2,
  X_ATTRIBUTE15  in VARCHAR2,
  X_ATTRIBUTE16  in VARCHAR2,
  X_ATTRIBUTE17  in VARCHAR2,
  X_ATTRIBUTE18  in VARCHAR2,
  X_ATTRIBUTE19  in VARCHAR2,
  X_ATTRIBUTE20  in VARCHAR2,
  X_ATTRIBUTE21  in VARCHAR2,
  X_ATTRIBUTE22  in VARCHAR2,
  X_ATTRIBUTE23  in VARCHAR2,
  X_ATTRIBUTE24  in VARCHAR2
) is
  cursor C is select ROWID from PV_REFERRALS_B
    where REFERRAL_ID = X_REFERRAL_ID
    ;

Line: 93

  insert into PV_REFERRALS_B (
    ACTUAL_CURRENCY_CODE,
    BENEFIT_TYPE_CODE,
    REFERRAL_ID,
    CUSTOMER_CONTACT_PHONE_TYPE,
    CUSTOMER_CONTACT_EMAIL_ADDRESS,
    CUSTOMER_CONTACT_PHONE_EXT,
    DECLINE_REASON_CODE,
    ENTITY_TYPE,
    ORDER_ID,
    CLAIM_ID,
    CLAIM_NUMBER,
    EST_COMPENSATION_AMT,
    CURRENCY_CODE,
    ACTUAL_COMPENSATION_AMT,
    STATUS_CHANGE_DATE,
    DUPLICATE_CUSTOMER_FLAG,
    PARTNER_CUST_ACCOUNT_ID,
    CUSTOMER_COUNTRY,
    CUSTOMER_CONTACT_TITLE,
    CUSTOMER_CONTACT_FIRST_NAME,
    CUSTOMER_CONTACT_LAST_NAME,
    CUSTOMER_CONTACT_CNTRY_CODE,
    CUSTOMER_CONTACT_AREA_CODE,
    CUSTOMER_CONTACT_PHONE_NO,
    CUSTOMER_PROVINCE,
    CUSTOMER_POSTAL_CODE,
    CUSTOMER_COUNTY,
    ENTITY_ID_LINKED_TO,
    OBJECT_VERSION_NUMBER,
    BENEFIT_ID,
    REFERRAL_CODE,
    REFERRAL_STATUS,
    PARTNER_ID,
    PARTNER_CONTACT_RESOURCE_ID,
    CUSTOMER_PARTY_ID,
    CUSTOMER_ORG_CONTACT_ID,
    CUSTOMER_CONTACT_PARTY_ID,
    CUSTOMER_PARTY_SITE_ID,
    CUSTOMER_NAME,
    CUSTOMER_ADDRESS_TYPE,
    CUSTOMER_ADDRESS1,
    CUSTOMER_ADDRESS2,
    CUSTOMER_ADDRESS3,
    CUSTOMER_ADDRESS4,
    ADDRESS_LINES_PHONETIC,
    CUSTOMER_CITY,
    CUSTOMER_STATE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    ORG_ID,
    SECURITY_GROUP_ID,
    CUSTOMER_NAME_PRONOUNCIATION,
    RETURN_REASON_CODE,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    ATTRIBUTE16,
    ATTRIBUTE17,
    ATTRIBUTE18,
    ATTRIBUTE19,
    ATTRIBUTE20,
    ATTRIBUTE21,
    ATTRIBUTE22,
    ATTRIBUTE23,
    ATTRIBUTE24
  ) values (
    X_ACTUAL_CURRENCY_CODE,
    X_BENEFIT_TYPE_CODE,
    X_REFERRAL_ID,
    X_CUSTOMER_CONTACT_PHONE_TYPE,
    X_CUSTOMER_CONTACT_EMAIL_ADDRE,
    X_CUSTOMER_CONTACT_PHONE_EXT,
    X_DECLINE_REASON_CODE,
    X_ENTITY_TYPE,
    X_ORDER_ID,
    X_CLAIM_ID,
    X_CLAIM_NUMBER,
    X_EST_COMPENSATION_AMT,
    X_CURRENCY_CODE,
    X_ACTUAL_COMPENSATION_AMT,
    X_STATUS_CHANGE_DATE,
    X_DUPLICATE_CUSTOMER_FLAG,
    X_PARTNER_CUST_ACCOUNT_ID,
    X_CUSTOMER_COUNTRY,
    X_CUSTOMER_CONTACT_TITLE,
    X_CUSTOMER_CONTACT_FIRST_NAME,
    X_CUSTOMER_CONTACT_LAST_NAME,
    X_CUSTOMER_CONTACT_CNTRY_CODE,
    X_CUSTOMER_CONTACT_AREA_CODE,
    X_CUSTOMER_CONTACT_PHONE_NO,
    X_CUSTOMER_PROVINCE,
    X_CUSTOMER_POSTAL_CODE,
    X_CUSTOMER_COUNTY,
    X_ENTITY_ID_LINKED_TO,
    X_OBJECT_VERSION_NUMBER,
    X_BENEFIT_ID,
    X_REFERRAL_CODE,
    X_REFERRAL_STATUS,
    X_PARTNER_ID,
    X_PARTNER_CONTACT_RESOURCE_ID,
    X_CUSTOMER_PARTY_ID,
    X_CUSTOMER_ORG_CONTACT_ID,
    X_CUSTOMER_CONTACT_PARTY_ID,
    X_CUSTOMER_PARTY_SITE_ID,
    X_CUSTOMER_NAME,
    X_CUSTOMER_ADDRESS_TYPE,
    X_CUSTOMER_ADDRESS1,
    X_CUSTOMER_ADDRESS2,
    X_CUSTOMER_ADDRESS3,
    X_CUSTOMER_ADDRESS4,
    X_ADDRESS_LINES_PHONETIC,
    X_CUSTOMER_CITY,
    X_CUSTOMER_STATE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_ORG_ID,
    X_SECURITY_GROUP_ID,
    X_CUSTOMER_NAME_PRONOUNCIATION,
    X_RETURN_REASON_CODE,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_ATTRIBUTE16,
    X_ATTRIBUTE17,
    X_ATTRIBUTE18,
    X_ATTRIBUTE19,
    X_ATTRIBUTE20,
    X_ATTRIBUTE21,
    X_ATTRIBUTE22,
    X_ATTRIBUTE23,
    X_ATTRIBUTE24
  );

Line: 259

  insert into PV_REFERRALS_TL (
    CREATION_DATE,
    CREATED_BY,
    REFERRAL_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER,
    REFERRAL_NAME,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_CREATION_DATE,
    X_CREATED_BY,
    X_REFERRAL_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_OBJECT_VERSION_NUMBER,
    X_REFERRAL_NAME,
    X_DESCRIPTION,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from PV_REFERRALS_TL T
    where T.REFERRAL_ID = X_REFERRAL_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 299

end INSERT_ROW;

Line: 381

  cursor c is select
      ACTUAL_CURRENCY_CODE,
      BENEFIT_TYPE_CODE,
      CUSTOMER_CONTACT_PHONE_TYPE,
      CUSTOMER_CONTACT_EMAIL_ADDRESS,
      CUSTOMER_CONTACT_PHONE_EXT,
      DECLINE_REASON_CODE,
      ENTITY_TYPE,
      ORDER_ID,
      CLAIM_ID,
      CLAIM_NUMBER,
      EST_COMPENSATION_AMT,
      CURRENCY_CODE,
      ACTUAL_COMPENSATION_AMT,
      STATUS_CHANGE_DATE,
      DUPLICATE_CUSTOMER_FLAG,
      PARTNER_CUST_ACCOUNT_ID,
      CUSTOMER_COUNTRY,
      CUSTOMER_CONTACT_TITLE,
      CUSTOMER_CONTACT_FIRST_NAME,
      CUSTOMER_CONTACT_LAST_NAME,
      CUSTOMER_CONTACT_CNTRY_CODE,
      CUSTOMER_CONTACT_AREA_CODE,
      CUSTOMER_CONTACT_PHONE_NO,
      CUSTOMER_PROVINCE,
      CUSTOMER_POSTAL_CODE,
      CUSTOMER_COUNTY,
      ENTITY_ID_LINKED_TO,
      OBJECT_VERSION_NUMBER,
      BENEFIT_ID,
      REFERRAL_CODE,
      REFERRAL_STATUS,
      PARTNER_ID,
      PARTNER_CONTACT_RESOURCE_ID,
      CUSTOMER_PARTY_ID,
      CUSTOMER_ORG_CONTACT_ID,
      CUSTOMER_CONTACT_PARTY_ID,
      CUSTOMER_PARTY_SITE_ID,
      CUSTOMER_NAME,
      CUSTOMER_ADDRESS_TYPE,
      CUSTOMER_ADDRESS1,
      CUSTOMER_ADDRESS2,
      CUSTOMER_ADDRESS3,
      CUSTOMER_ADDRESS4,
      ADDRESS_LINES_PHONETIC,
      CUSTOMER_CITY,
      CUSTOMER_STATE,
      ORG_ID,
      SECURITY_GROUP_ID,
      CUSTOMER_NAME_PRONOUNCIATION,
      RETURN_REASON_CODE,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20,
      ATTRIBUTE21,
      ATTRIBUTE22,
      ATTRIBUTE23,
      ATTRIBUTE24
    from PV_REFERRALS_B
    where REFERRAL_ID = X_REFERRAL_ID
    for update of REFERRAL_ID nowait;

Line: 462

  cursor c1 is select
      REFERRAL_NAME,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from PV_REFERRALS_TL
    where REFERRAL_ID = X_REFERRAL_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of REFERRAL_ID nowait;

Line: 475

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 640

procedure UPDATE_ROW (
  X_REFERRAL_ID in NUMBER,
  X_ACTUAL_CURRENCY_CODE in VARCHAR2,
  X_BENEFIT_TYPE_CODE in VARCHAR2,
  X_CUSTOMER_CONTACT_PHONE_TYPE in VARCHAR2,
  X_CUSTOMER_CONTACT_EMAIL_ADDRE in VARCHAR2,
  X_CUSTOMER_CONTACT_PHONE_EXT in VARCHAR2,
  X_DECLINE_REASON_CODE in VARCHAR2,
  X_ENTITY_TYPE in VARCHAR2,
  X_ORDER_ID in NUMBER,
  X_CLAIM_ID in NUMBER,
  X_CLAIM_NUMBER in VARCHAR2,
  X_EST_COMPENSATION_AMT in NUMBER,
  X_CURRENCY_CODE in VARCHAR2,
  X_ACTUAL_COMPENSATION_AMT in NUMBER,
  X_STATUS_CHANGE_DATE in DATE,
  X_DUPLICATE_CUSTOMER_FLAG in VARCHAR2,
  X_PARTNER_CUST_ACCOUNT_ID in NUMBER,
  X_CUSTOMER_COUNTRY in VARCHAR2,
  X_CUSTOMER_CONTACT_TITLE in VARCHAR2,
  X_CUSTOMER_CONTACT_FIRST_NAME in VARCHAR2,
  X_CUSTOMER_CONTACT_LAST_NAME in VARCHAR2,
  X_CUSTOMER_CONTACT_CNTRY_CODE in VARCHAR2,
  X_CUSTOMER_CONTACT_AREA_CODE in VARCHAR2,
  X_CUSTOMER_CONTACT_PHONE_NO in VARCHAR2,
  X_CUSTOMER_PROVINCE in VARCHAR2,
  X_CUSTOMER_POSTAL_CODE in VARCHAR2,
  X_CUSTOMER_COUNTY in VARCHAR2,
  X_ENTITY_ID_LINKED_TO in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_BENEFIT_ID in NUMBER,
  X_REFERRAL_CODE in VARCHAR2,
  X_REFERRAL_STATUS in VARCHAR2,
  X_PARTNER_ID in NUMBER,
  X_PARTNER_CONTACT_RESOURCE_ID in NUMBER,
  X_CUSTOMER_PARTY_ID in NUMBER,
  X_CUSTOMER_ORG_CONTACT_ID in NUMBER,
  X_CUSTOMER_CONTACT_PARTY_ID in NUMBER,
  X_CUSTOMER_PARTY_SITE_ID in NUMBER,
  X_CUSTOMER_NAME in VARCHAR2,
  X_CUSTOMER_ADDRESS_TYPE in VARCHAR2,
  X_CUSTOMER_ADDRESS1 in VARCHAR2,
  X_CUSTOMER_ADDRESS2 in VARCHAR2,
  X_CUSTOMER_ADDRESS3 in VARCHAR2,
  X_CUSTOMER_ADDRESS4 in VARCHAR2,
  X_ADDRESS_LINES_PHONETIC in VARCHAR2,
  X_CUSTOMER_CITY in VARCHAR2,
  X_CUSTOMER_STATE in VARCHAR2,
  X_REFERRAL_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_ORG_ID in NUMBER,
  X_SECURITY_GROUP_ID in NUMBER,
  X_CUSTOMER_NAME_PRONOUNCIATION in VARCHAR2,
  X_RETURN_REASON_CODE in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1  in VARCHAR2,
  X_ATTRIBUTE2  in VARCHAR2,
  X_ATTRIBUTE3  in VARCHAR2,
  X_ATTRIBUTE4  in VARCHAR2,
  X_ATTRIBUTE5   in VARCHAR2,
  X_ATTRIBUTE6   in VARCHAR2,
  X_ATTRIBUTE7   in VARCHAR2,
  X_ATTRIBUTE8   in VARCHAR2,
  X_ATTRIBUTE9   in VARCHAR2,
  X_ATTRIBUTE10  in VARCHAR2,
  X_ATTRIBUTE11  in VARCHAR2,
  X_ATTRIBUTE12  in VARCHAR2,
  X_ATTRIBUTE13  in VARCHAR2,
  X_ATTRIBUTE14  in VARCHAR2,
  X_ATTRIBUTE15  in VARCHAR2,
  X_ATTRIBUTE16  in VARCHAR2,
  X_ATTRIBUTE17  in VARCHAR2,
  X_ATTRIBUTE18  in VARCHAR2,
  X_ATTRIBUTE19  in VARCHAR2,
  X_ATTRIBUTE20  in VARCHAR2,
  X_ATTRIBUTE21  in VARCHAR2,
  X_ATTRIBUTE22  in VARCHAR2,
  X_ATTRIBUTE23  in VARCHAR2,
  X_ATTRIBUTE24  in VARCHAR2
) is
begin
  update PV_REFERRALS_B set
    ACTUAL_CURRENCY_CODE = X_ACTUAL_CURRENCY_CODE,
    BENEFIT_TYPE_CODE = X_BENEFIT_TYPE_CODE,
    CUSTOMER_CONTACT_PHONE_TYPE = X_CUSTOMER_CONTACT_PHONE_TYPE,
    CUSTOMER_CONTACT_EMAIL_ADDRESS = X_CUSTOMER_CONTACT_EMAIL_ADDRE,
    CUSTOMER_CONTACT_PHONE_EXT = X_CUSTOMER_CONTACT_PHONE_EXT,
    DECLINE_REASON_CODE = X_DECLINE_REASON_CODE,
    ENTITY_TYPE = X_ENTITY_TYPE,
    ORDER_ID = X_ORDER_ID,
    CLAIM_ID = X_CLAIM_ID,
    CLAIM_NUMBER = X_CLAIM_NUMBER,
    EST_COMPENSATION_AMT = X_EST_COMPENSATION_AMT,
    CURRENCY_CODE = X_CURRENCY_CODE,
    ACTUAL_COMPENSATION_AMT = X_ACTUAL_COMPENSATION_AMT,
    STATUS_CHANGE_DATE = X_STATUS_CHANGE_DATE,
    DUPLICATE_CUSTOMER_FLAG = X_DUPLICATE_CUSTOMER_FLAG,
    PARTNER_CUST_ACCOUNT_ID = X_PARTNER_CUST_ACCOUNT_ID,
    CUSTOMER_COUNTRY = X_CUSTOMER_COUNTRY,
    CUSTOMER_CONTACT_TITLE = X_CUSTOMER_CONTACT_TITLE,
    CUSTOMER_CONTACT_FIRST_NAME = X_CUSTOMER_CONTACT_FIRST_NAME,
    CUSTOMER_CONTACT_LAST_NAME = X_CUSTOMER_CONTACT_LAST_NAME,
    CUSTOMER_CONTACT_CNTRY_CODE = X_CUSTOMER_CONTACT_CNTRY_CODE,
    CUSTOMER_CONTACT_AREA_CODE = X_CUSTOMER_CONTACT_AREA_CODE,
    CUSTOMER_CONTACT_PHONE_NO = X_CUSTOMER_CONTACT_PHONE_NO,
    CUSTOMER_PROVINCE = X_CUSTOMER_PROVINCE,
    CUSTOMER_POSTAL_CODE = X_CUSTOMER_POSTAL_CODE,
    CUSTOMER_COUNTY = X_CUSTOMER_COUNTY,
    ENTITY_ID_LINKED_TO = X_ENTITY_ID_LINKED_TO,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    BENEFIT_ID = X_BENEFIT_ID,
    REFERRAL_CODE = X_REFERRAL_CODE,
    REFERRAL_STATUS = X_REFERRAL_STATUS,
    PARTNER_ID = X_PARTNER_ID,
    PARTNER_CONTACT_RESOURCE_ID = X_PARTNER_CONTACT_RESOURCE_ID,
    CUSTOMER_PARTY_ID = X_CUSTOMER_PARTY_ID,
    CUSTOMER_ORG_CONTACT_ID = X_CUSTOMER_ORG_CONTACT_ID,
    CUSTOMER_CONTACT_PARTY_ID = X_CUSTOMER_CONTACT_PARTY_ID,
    CUSTOMER_PARTY_SITE_ID = X_CUSTOMER_PARTY_SITE_ID,
    CUSTOMER_NAME = X_CUSTOMER_NAME,
    CUSTOMER_NAME_PRONOUNCIATION = X_CUSTOMER_NAME_PRONOUNCIATION,
    RETURN_REASON_CODE = X_RETURN_REASON_CODE,
    CUSTOMER_ADDRESS_TYPE = X_CUSTOMER_ADDRESS_TYPE,
    CUSTOMER_ADDRESS1 = X_CUSTOMER_ADDRESS1,
    CUSTOMER_ADDRESS2 = X_CUSTOMER_ADDRESS2,
    CUSTOMER_ADDRESS3 = X_CUSTOMER_ADDRESS3,
    CUSTOMER_ADDRESS4 = X_CUSTOMER_ADDRESS4,
    ADDRESS_LINES_PHONETIC = X_ADDRESS_LINES_PHONETIC,
    CUSTOMER_CITY = X_CUSTOMER_CITY,
    CUSTOMER_STATE = X_CUSTOMER_STATE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    ORG_ID = X_ORG_ID ,
    SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
    ATTRIBUTE_CATEGORY  = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1  = X_ATTRIBUTE1,
    ATTRIBUTE2  = X_ATTRIBUTE2,
    ATTRIBUTE3  = X_ATTRIBUTE3,
    ATTRIBUTE4  = X_ATTRIBUTE4,
    ATTRIBUTE5  = X_ATTRIBUTE5,
    ATTRIBUTE6  = X_ATTRIBUTE6,
    ATTRIBUTE7  = X_ATTRIBUTE7,
    ATTRIBUTE8  = X_ATTRIBUTE8,
    ATTRIBUTE9  = X_ATTRIBUTE9,
    ATTRIBUTE10  = X_ATTRIBUTE10,
    ATTRIBUTE11  = X_ATTRIBUTE11,
    ATTRIBUTE12  = X_ATTRIBUTE12,
    ATTRIBUTE13  = X_ATTRIBUTE13,
    ATTRIBUTE14  = X_ATTRIBUTE14,
    ATTRIBUTE15  = X_ATTRIBUTE15,
    ATTRIBUTE16  = X_ATTRIBUTE16,
    ATTRIBUTE17  = X_ATTRIBUTE17,
    ATTRIBUTE18  = X_ATTRIBUTE18,
    ATTRIBUTE19  = X_ATTRIBUTE19,
    ATTRIBUTE20  = X_ATTRIBUTE20,
    ATTRIBUTE21  = X_ATTRIBUTE21,
    ATTRIBUTE22  = X_ATTRIBUTE22,
    ATTRIBUTE23  = X_ATTRIBUTE23,
    ATTRIBUTE24  = X_ATTRIBUTE24
  where REFERRAL_ID = X_REFERRAL_ID;

Line: 809

  update PV_REFERRALS_TL set
    REFERRAL_NAME = X_REFERRAL_NAME,
    DESCRIPTION = X_DESCRIPTION,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where REFERRAL_ID = X_REFERRAL_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 822

end UPDATE_ROW;

Line: 824

procedure DELETE_ROW (
  X_REFERRAL_ID in NUMBER
) is
begin
  delete from PV_REFERRALS_TL
  where REFERRAL_ID = X_REFERRAL_ID;

Line: 835

  delete from PV_REFERRALS_B
  where REFERRAL_ID = X_REFERRAL_ID;

Line: 841

end DELETE_ROW;

Line: 846

  delete from PV_REFERRALS_TL T
  where not exists
    (select NULL
    from PV_REFERRALS_B B
    where B.REFERRAL_ID = T.REFERRAL_ID
    );

Line: 853

  update PV_REFERRALS_TL T set (
      REFERRAL_NAME,
      DESCRIPTION
    ) = (select
      B.REFERRAL_NAME,
      B.DESCRIPTION
    from PV_REFERRALS_TL B
    where B.REFERRAL_ID = T.REFERRAL_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.REFERRAL_ID,
      T.LANGUAGE
  ) in (select
      SUBT.REFERRAL_ID,
      SUBT.LANGUAGE
    from PV_REFERRALS_TL SUBB, PV_REFERRALS_TL SUBT
    where SUBB.REFERRAL_ID = SUBT.REFERRAL_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.REFERRAL_NAME <> SUBT.REFERRAL_NAME
      or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
  ));

Line: 875

  insert into PV_REFERRALS_TL (
    CREATION_DATE,
    CREATED_BY,
    REFERRAL_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER,
    REFERRAL_NAME,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select /*+ ORDERED */
    B.CREATION_DATE,
    B.CREATED_BY,
    B.REFERRAL_ID,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.OBJECT_VERSION_NUMBER,
    B.REFERRAL_NAME,
    B.DESCRIPTION,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from PV_REFERRALS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from PV_REFERRALS_TL T
    where T.REFERRAL_ID = B.REFERRAL_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);