DBA Data[Home] [Help]

APPS.OZF_SD_REQUEST_HEADERS_ALL_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_REQUEST_HEADER_ID in NUMBER,
  X_USER_STATUS_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_REQUEST_ID in NUMBER,
  X_CREATED_FROM in VARCHAR2,
  X_REQUEST_NUMBER in VARCHAR2,
  X_REQUEST_CLASS in VARCHAR2,
  X_OFFER_TYPE in VARCHAR2,
  X_OFFER_ID in NUMBER,
  X_ROOT_REQUEST_HEADER_ID in NUMBER,
  X_LINKED_REQUEST_HEADER_ID in NUMBER,
  X_REQUEST_START_DATE in DATE,
  X_REQUEST_END_DATE in DATE,
  X_REQUEST_OUTCOME in VARCHAR2,
  X_DECLINE_REASON_CODE in VARCHAR2,
  X_RETURN_REASON_CODE in VARCHAR2,
  X_REQUEST_CURRENCY_CODE in VARCHAR2,
  X_AUTHORIZATION_NUMBER in VARCHAR2,
  X_REQUESTED_BUDGET_AMOUNT in NUMBER,
  X_APPROVED_BUDGET_AMOUNT in NUMBER,
  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_SUPPLIER_ID in NUMBER,
  X_SUPPLIER_SITE_ID in NUMBER,
  X_SUPPLIER_CONTACT_ID in NUMBER,
  X_REQUEST_BASIS in VARCHAR2,
  X_SUPPLIER_RESPONSE_DATE in DATE,
  X_SUPPLIER_SUBMISSION_DATE in DATE,
  X_REQUESTOR_ID in NUMBER,
  X_SUPPLIER_QUOTE_NUMBER in VARCHAR2,
  X_INTERNAL_ORDER_NUMBER in NUMBER,
  X_SALES_ORDER_CURRENCY in VARCHAR2,
  X_REQUEST_SOURCE in VARCHAR2,
  X_ASIGNEE_RESOURCE_ID in NUMBER,
  X_ACCRUAL_TYPE in VARCHAR2,
  X_CUST_ACCOUNT_ID in NUMBER,
  X_SUPPLIER_CONTACT_EMAIL_ADDRE in VARCHAR2,
  X_SUPPLIER_CONTACT_PHONE_NUMBE in VARCHAR2,
  X_REQUEST_TYPE_SETUP_ID in NUMBER,
  X_SUPPLIER_RESPONSE_BY_DATE in DATE,
  X_INTERNAL_SUBMISSION_DATE in DATE,
  X_ASIGNEE_RESPONSE_BY_DATE in DATE,
  X_ASIGNEE_RESPONSE_DATE in DATE,
  X_SUBMTD_BY_FOR_SUPP_APPROVAL in NUMBER,
  X_REQUEST_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
) is
  cursor C is select ROWID from OZF_SD_REQUEST_HEADERS_ALL_B
    where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
    ;
Line: 74

  insert into OZF_SD_REQUEST_HEADERS_ALL_B (
    USER_STATUS_ID,
    REQUEST_HEADER_ID,
    OBJECT_VERSION_NUMBER,
    REQUEST_ID,
    CREATED_FROM,
    REQUEST_NUMBER,
    REQUEST_CLASS,
    OFFER_TYPE,
    OFFER_ID,
    ROOT_REQUEST_HEADER_ID,
    LINKED_REQUEST_HEADER_ID,
    REQUEST_START_DATE,
    REQUEST_END_DATE,
    REQUEST_OUTCOME,
    DECLINE_REASON_CODE,
    RETURN_REASON_CODE,
    REQUEST_CURRENCY_CODE,
    AUTHORIZATION_NUMBER,
    REQUESTED_BUDGET_AMOUNT,
    APPROVED_BUDGET_AMOUNT,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    SUPPLIER_ID,
    SUPPLIER_SITE_ID,
    SUPPLIER_CONTACT_ID,
    REQUEST_BASIS,
    SUPPLIER_RESPONSE_DATE,
    SUPPLIER_SUBMISSION_DATE,
    REQUESTOR_ID,
    SUPPLIER_QUOTE_NUMBER,
    INTERNAL_ORDER_NUMBER,
    SALES_ORDER_CURRENCY,
    REQUEST_SOURCE,
    ASIGNEE_RESOURCE_ID,
    ACCRUAL_TYPE,
    CUST_ACCOUNT_ID,
    SUPPLIER_CONTACT_EMAIL_ADDRESS,
    SUPPLIER_CONTACT_PHONE_NUMBER,
    REQUEST_TYPE_SETUP_ID,
    SUPPLIER_RESPONSE_BY_DATE,
    INTERNAL_SUBMISSION_DATE,
    ASIGNEE_RESPONSE_BY_DATE,
    ASIGNEE_RESPONSE_DATE,
    SUBMTD_BY_FOR_SUPP_APPROVAL,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_USER_STATUS_ID,
    X_REQUEST_HEADER_ID,
    X_OBJECT_VERSION_NUMBER,
    X_REQUEST_ID,
    X_CREATED_FROM,
    X_REQUEST_NUMBER,
    X_REQUEST_CLASS,
    X_OFFER_TYPE,
    X_OFFER_ID,
    X_ROOT_REQUEST_HEADER_ID,
    X_LINKED_REQUEST_HEADER_ID,
    X_REQUEST_START_DATE,
    X_REQUEST_END_DATE,
    X_REQUEST_OUTCOME,
    X_DECLINE_REASON_CODE,
    X_RETURN_REASON_CODE,
    X_REQUEST_CURRENCY_CODE,
    X_AUTHORIZATION_NUMBER,
    X_REQUESTED_BUDGET_AMOUNT,
    X_APPROVED_BUDGET_AMOUNT,
    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_SUPPLIER_ID,
    X_SUPPLIER_SITE_ID,
    X_SUPPLIER_CONTACT_ID,
    X_REQUEST_BASIS,
    X_SUPPLIER_RESPONSE_DATE,
    X_SUPPLIER_SUBMISSION_DATE,
    X_REQUESTOR_ID,
    X_SUPPLIER_QUOTE_NUMBER,
    X_INTERNAL_ORDER_NUMBER,
    X_SALES_ORDER_CURRENCY,
    X_REQUEST_SOURCE,
    X_ASIGNEE_RESOURCE_ID,
    X_ACCRUAL_TYPE,
    X_CUST_ACCOUNT_ID,
    X_SUPPLIER_CONTACT_EMAIL_ADDRE,
    X_SUPPLIER_CONTACT_PHONE_NUMBE,
    X_REQUEST_TYPE_SETUP_ID,
    X_SUPPLIER_RESPONSE_BY_DATE,
    X_INTERNAL_SUBMISSION_DATE,
    X_ASIGNEE_RESPONSE_BY_DATE,
    X_ASIGNEE_RESPONSE_DATE,
    X_SUBMTD_BY_FOR_SUPP_APPROVAL,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );
Line: 204

  insert into OZF_SD_REQUEST_HEADERS_ALL_TL (
    REQUEST_HEADER_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_DESCRIPTION,
    REQUEST_ID,
    CREATED_FROM,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_REQUEST_HEADER_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_REQUEST_DESCRIPTION,
    X_REQUEST_ID,
    X_CREATED_FROM,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from OZF_SD_REQUEST_HEADERS_ALL_TL T
    where T.REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);
Line: 244

end INSERT_ROW;
Line: 307

  cursor c is select
      USER_STATUS_ID,
      OBJECT_VERSION_NUMBER,
      REQUEST_ID,
      CREATED_FROM,
      REQUEST_NUMBER,
      REQUEST_CLASS,
      OFFER_TYPE,
      OFFER_ID,
      ROOT_REQUEST_HEADER_ID,
      LINKED_REQUEST_HEADER_ID,
      REQUEST_START_DATE,
      REQUEST_END_DATE,
      REQUEST_OUTCOME,
      DECLINE_REASON_CODE,
      RETURN_REASON_CODE,
      REQUEST_CURRENCY_CODE,
      AUTHORIZATION_NUMBER,
      REQUESTED_BUDGET_AMOUNT,
      APPROVED_BUDGET_AMOUNT,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      SUPPLIER_ID,
      SUPPLIER_SITE_ID,
      SUPPLIER_CONTACT_ID,
      REQUEST_BASIS,
      SUPPLIER_RESPONSE_DATE,
      SUPPLIER_SUBMISSION_DATE,
      REQUESTOR_ID,
      SUPPLIER_QUOTE_NUMBER,
      INTERNAL_ORDER_NUMBER,
      SALES_ORDER_CURRENCY,
      REQUEST_SOURCE,
      ASIGNEE_RESOURCE_ID,
      ACCRUAL_TYPE,
      CUST_ACCOUNT_ID,
      SUPPLIER_CONTACT_EMAIL_ADDRESS,
      SUPPLIER_CONTACT_PHONE_NUMBER,
      REQUEST_TYPE_SETUP_ID,
      SUPPLIER_RESPONSE_BY_DATE,
      INTERNAL_SUBMISSION_DATE,
      ASIGNEE_RESPONSE_BY_DATE,
      ASIGNEE_RESPONSE_DATE,
      SUBMTD_BY_FOR_SUPP_APPROVAL
    from OZF_SD_REQUEST_HEADERS_ALL_B
    where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
    for update of REQUEST_HEADER_ID nowait;
Line: 370

  cursor c1 is select
      REQUEST_DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from OZF_SD_REQUEST_HEADERS_ALL_TL
    where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of REQUEST_HEADER_ID nowait;
Line: 382

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
Line: 518

procedure UPDATE_ROW (
  X_REQUEST_HEADER_ID in NUMBER,
  X_USER_STATUS_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_REQUEST_ID in NUMBER,
  X_CREATED_FROM in VARCHAR2,
  X_REQUEST_NUMBER in VARCHAR2,
  X_REQUEST_CLASS in VARCHAR2,
  X_OFFER_TYPE in VARCHAR2,
  X_OFFER_ID in NUMBER,
  X_ROOT_REQUEST_HEADER_ID in NUMBER,
  X_LINKED_REQUEST_HEADER_ID in NUMBER,
  X_REQUEST_START_DATE in DATE,
  X_REQUEST_END_DATE in DATE,
  X_REQUEST_OUTCOME in VARCHAR2,
  X_DECLINE_REASON_CODE in VARCHAR2,
  X_RETURN_REASON_CODE in VARCHAR2,
  X_REQUEST_CURRENCY_CODE in VARCHAR2,
  X_AUTHORIZATION_NUMBER in VARCHAR2,
  X_REQUESTED_BUDGET_AMOUNT in NUMBER,
  X_APPROVED_BUDGET_AMOUNT in NUMBER,
  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_SUPPLIER_ID in NUMBER,
  X_SUPPLIER_SITE_ID in NUMBER,
  X_SUPPLIER_CONTACT_ID in NUMBER,
  X_REQUEST_BASIS in VARCHAR2,
  X_SUPPLIER_RESPONSE_DATE in DATE,
  X_SUPPLIER_SUBMISSION_DATE in DATE,
  X_REQUESTOR_ID in NUMBER,
  X_SUPPLIER_QUOTE_NUMBER in VARCHAR2,
  X_INTERNAL_ORDER_NUMBER in NUMBER,
  X_SALES_ORDER_CURRENCY in VARCHAR2,
  X_REQUEST_SOURCE in VARCHAR2,
  X_ASIGNEE_RESOURCE_ID in NUMBER,
  X_ACCRUAL_TYPE in VARCHAR2,
  X_CUST_ACCOUNT_ID in NUMBER,
  X_SUPPLIER_CONTACT_EMAIL_ADDRE in VARCHAR2,
  X_SUPPLIER_CONTACT_PHONE_NUMBE in VARCHAR2,
  X_REQUEST_TYPE_SETUP_ID in NUMBER,
  X_SUPPLIER_RESPONSE_BY_DATE in DATE,
  X_INTERNAL_SUBMISSION_DATE in DATE,
  X_ASIGNEE_RESPONSE_BY_DATE in DATE,
  X_ASIGNEE_RESPONSE_DATE in DATE,
  X_SUBMTD_BY_FOR_SUPP_APPROVAL in NUMBER,
  X_REQUEST_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update OZF_SD_REQUEST_HEADERS_ALL_B set
    USER_STATUS_ID = X_USER_STATUS_ID,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    REQUEST_ID = X_REQUEST_ID,
    CREATED_FROM = X_CREATED_FROM,
    REQUEST_NUMBER = X_REQUEST_NUMBER,
    REQUEST_CLASS = X_REQUEST_CLASS,
    OFFER_TYPE = X_OFFER_TYPE,
    OFFER_ID = X_OFFER_ID,
    ROOT_REQUEST_HEADER_ID = X_ROOT_REQUEST_HEADER_ID,
    LINKED_REQUEST_HEADER_ID = X_LINKED_REQUEST_HEADER_ID,
    REQUEST_START_DATE = X_REQUEST_START_DATE,
    REQUEST_END_DATE = X_REQUEST_END_DATE,
    REQUEST_OUTCOME = X_REQUEST_OUTCOME,
    DECLINE_REASON_CODE = X_DECLINE_REASON_CODE,
    RETURN_REASON_CODE = X_RETURN_REASON_CODE,
    REQUEST_CURRENCY_CODE = X_REQUEST_CURRENCY_CODE,
    AUTHORIZATION_NUMBER = X_AUTHORIZATION_NUMBER,
    REQUESTED_BUDGET_AMOUNT = X_REQUESTED_BUDGET_AMOUNT,
    APPROVED_BUDGET_AMOUNT = X_APPROVED_BUDGET_AMOUNT,
    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,
    SUPPLIER_ID = X_SUPPLIER_ID,
    SUPPLIER_SITE_ID = X_SUPPLIER_SITE_ID,
    SUPPLIER_CONTACT_ID = X_SUPPLIER_CONTACT_ID,
    REQUEST_BASIS = X_REQUEST_BASIS,
    SUPPLIER_RESPONSE_DATE = X_SUPPLIER_RESPONSE_DATE,
    SUPPLIER_SUBMISSION_DATE = X_SUPPLIER_SUBMISSION_DATE,
    REQUESTOR_ID = X_REQUESTOR_ID,
    SUPPLIER_QUOTE_NUMBER = X_SUPPLIER_QUOTE_NUMBER,
    INTERNAL_ORDER_NUMBER = X_INTERNAL_ORDER_NUMBER,
    SALES_ORDER_CURRENCY = X_SALES_ORDER_CURRENCY,
    REQUEST_SOURCE = X_REQUEST_SOURCE,
    ASIGNEE_RESOURCE_ID = X_ASIGNEE_RESOURCE_ID,
    ACCRUAL_TYPE = X_ACCRUAL_TYPE,
    CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID,
    SUPPLIER_CONTACT_EMAIL_ADDRESS = X_SUPPLIER_CONTACT_EMAIL_ADDRE,
    SUPPLIER_CONTACT_PHONE_NUMBER = X_SUPPLIER_CONTACT_PHONE_NUMBE,
    REQUEST_TYPE_SETUP_ID = X_REQUEST_TYPE_SETUP_ID,
    SUPPLIER_RESPONSE_BY_DATE = X_SUPPLIER_RESPONSE_BY_DATE,
    INTERNAL_SUBMISSION_DATE = X_INTERNAL_SUBMISSION_DATE,
    ASIGNEE_RESPONSE_BY_DATE = X_ASIGNEE_RESPONSE_BY_DATE,
    ASIGNEE_RESPONSE_DATE = X_ASIGNEE_RESPONSE_DATE,
    SUBMTD_BY_FOR_SUPP_APPROVAL = X_SUBMTD_BY_FOR_SUPP_APPROVAL,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID;
Line: 650

  update OZF_SD_REQUEST_HEADERS_ALL_TL set
    REQUEST_DESCRIPTION = X_REQUEST_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 REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
Line: 662

end UPDATE_ROW;
Line: 664

procedure DELETE_ROW (
  X_REQUEST_HEADER_ID in NUMBER
) is
begin
  delete from OZF_SD_REQUEST_HEADERS_ALL_TL
  where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID;
Line: 675

  delete from OZF_SD_REQUEST_HEADERS_ALL_B
  where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID;
Line: 681

end DELETE_ROW;
Line: 686

  delete from OZF_SD_REQUEST_HEADERS_ALL_TL T
  where not exists
    (select NULL
    from OZF_SD_REQUEST_HEADERS_ALL_B B
    where B.REQUEST_HEADER_ID = T.REQUEST_HEADER_ID
    );
Line: 693

  update OZF_SD_REQUEST_HEADERS_ALL_TL T set (
      REQUEST_DESCRIPTION
    ) = (select
      B.REQUEST_DESCRIPTION
    from OZF_SD_REQUEST_HEADERS_ALL_TL B
    where B.REQUEST_HEADER_ID = T.REQUEST_HEADER_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.REQUEST_HEADER_ID,
      T.LANGUAGE
  ) in (select
      SUBT.REQUEST_HEADER_ID,
      SUBT.LANGUAGE
    from OZF_SD_REQUEST_HEADERS_ALL_TL SUBB, OZF_SD_REQUEST_HEADERS_ALL_TL SUBT
    where SUBB.REQUEST_HEADER_ID = SUBT.REQUEST_HEADER_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.REQUEST_DESCRIPTION <> SUBT.REQUEST_DESCRIPTION
      or (SUBB.REQUEST_DESCRIPTION is null and SUBT.REQUEST_DESCRIPTION is not null)
      or (SUBB.REQUEST_DESCRIPTION is not null and SUBT.REQUEST_DESCRIPTION is null)
  ));
Line: 714

  insert into OZF_SD_REQUEST_HEADERS_ALL_TL (
    REQUEST_HEADER_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_DESCRIPTION,
    REQUEST_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE,
    PROGRAM_ID,
    CREATED_FROM,
    LANGUAGE,
    SOURCE_LANG
  ) select /*+ ORDERED */
    B.REQUEST_HEADER_ID,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.REQUEST_DESCRIPTION,
    B.REQUEST_ID,
    B.PROGRAM_APPLICATION_ID,
    B.PROGRAM_UPDATE_DATE,
    B.PROGRAM_ID,
    B.CREATED_FROM,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from OZF_SD_REQUEST_HEADERS_ALL_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from OZF_SD_REQUEST_HEADERS_ALL_TL T
    where T.REQUEST_HEADER_ID = B.REQUEST_HEADER_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);