APPS.OZF_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_OBJECT_VERSION_NUMBER in NUMBER,
  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_REQUEST_ID in NUMBER,
  X_program_application_id in   NUMBER,
  X_program_update_date in   DATE,
  X_program_id  in  NUMBER,
  X_CREATE_FROM in VARCHAR2,
  X_REQUEST_NUMBER in VARCHAR2,
  X_SHIP_FROM_STOCK_FLAG in VARCHAR2,
  X_REQUEST_TYPE_CODE in VARCHAR2,
  X_REQUEST_CLASS in VARCHAR2,
  X_BENEFIT_ID in NUMBER,
  X_ACTIVITY_MEDIA_ID in NUMBER,
  X_SUBMITTED_BY in NUMBER,
  X_SUBMITTED_DATE in DATE,
  X_PARTNER_CONTACT_ID in NUMBER,
  X_PARTNER_CONTACT_PHONE_NUMBER in VARCHAR2,
  X_PARTNER_CONTACT_EMAIL_ADDRES in VARCHAR2,
  X_OFFER_ID in NUMBER,
  X_OFFER_TYPE in VARCHAR2,
  X_LINKED_REQUEST_HEADER_ID in NUMBER,
  X_ROOT_REQUEST_HEADER_ID in NUMBER,
  X_START_DATE in DATE,
  X_END_DATE in DATE,
  X_STATUS_CODE in VARCHAR2,
  X_REQUEST_OUTCOME in VARCHAR2,
  X_DECLINE_REASON_CODE in VARCHAR2,
  X_RETURN_REASON_CODE in  VARCHAR2,
  X_CURRENCY_CODE in VARCHAR2,
  X_PARTNER_AMOUNT in NUMBER,
  X_REQUESTED_AMOUNT in NUMBER,
  X_APPROVED_AMOUNT in NUMBER,
  X_EXCHANGE_RATE_TYPE in VARCHAR2,
  X_EXCHANGE_RATE_DATE in DATE,
  X_EXCHANGE_RATE in NUMBER,
  X_PARTNER_ACCTD_AMOUNT in NUMBER,
  X_REQUESTED_ACCTD_AMOUNT in NUMBER,
  X_APPROVED_ACCTD_AMOUNT in NUMBER,
  X_APPROVED_BY in NUMBER,
  X_APPROVED_DATE in DATE,
  X_AUTHORIZATION_CODE in VARCHAR2,
  X_AGREEMENT_NUMBER in VARCHAR2,
  X_PARTNER_ID in NUMBER,
  X_PARTNER_SITE_USE_ID in NUMBER,
  X_END_CUST_PARTY_ID in NUMBER,
  X_END_CUST_SITE_USE_ID in NUMBER,
  X_END_CUST_DUNS_NUMBER in NUMBER,
  X_END_CUST_NAME in VARCHAR2,
  X_END_CUST_ADDRESS1 in VARCHAR2,
  X_END_CUST_ADDRESS2 in VARCHAR2,
  X_END_CUST_ADDRESS3 in VARCHAR2,
  X_END_CUST_ADDRESS4 in VARCHAR2,
  X_END_CUST_PROVINCE in VARCHAR2,
  X_END_CUST_COUNTY in VARCHAR2,
  X_END_CUST_CITY in VARCHAR2,
  X_END_CUST_STATE in VARCHAR2,
  X_END_CUST_POSTAL_CODE in VARCHAR2,
  X_END_CUST_COUNTRY in VARCHAR2,
  X_END_CUST_ADDR_LINES_PHONETIC in VARCHAR2,
  X_END_CUST_CONTACT_FIRST_NAME in VARCHAR2,
  X_END_CUST_CONTACT_LAST_NAME in VARCHAR2,
  X_END_CUST_CONTACT_TITLE in VARCHAR2,
  X_END_CUST_CONTACT_EMAIL_ADDRE in VARCHAR2,
  X_END_CUST_CONTACT_PHONE_TYPE in VARCHAR2,
  X_END_CUST_CONTACT_PHONE_NUMBE in VARCHAR2,
  X_END_CUST_CONTACT_PHONE_EXTN in VARCHAR2,
  X_RESELLER_PARTY_ID in NUMBER,
  X_RESELLER_DUNS_NUMBER in NUMBER,
  X_RESELLER_SITE_USE_ID in NUMBER,
  X_RESELLER_NAME in VARCHAR2,
  X_RESELLER_ADDRESS1 in VARCHAR2,
  X_RESELLER_ADDRESS2 in VARCHAR2,
  X_RESELLER_ADDRESS3 in VARCHAR2,
  X_RESELLER_ADDRESS4 in VARCHAR2,
  X_RESELLER_PROVINCE in VARCHAR2,
  X_RESELLER_COUNTY in VARCHAR2,
  X_RESELLER_CITY in VARCHAR2,
  X_RESELLER_STATE in VARCHAR2,
  X_RESELLER_POSTAL_CODE in VARCHAR2,
  X_RESELLER_COUNTRY in VARCHAR2,
  X_RESELLER_ADDR_LINES_PHONETIC in VARCHAR2,
  X_RESELLER_CONTACT_FIRST_NAME in VARCHAR2,
  X_RESELLER_CONTACT_LAST_NAME in VARCHAR2,
  X_RESELLER_CONTACT_TITLE in VARCHAR2,
  X_RESELLER_CONTACT_EMAIL_ADDRE in VARCHAR2,
  X_RESELLER_CONTACT_PHONE_NUMBE in VARCHAR2,
  X_RESELLER_CONTACT_PHONE_TYPE in VARCHAR2,
  X_RESELLER_CONTACT_PHONE_EXTN in VARCHAR2,
  X_CUSTOMER_MERGE_FLAG 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_ORG_ID in NUMBER,
  X_SECURITY_GROUP_ID in NUMBER,
  X_REQUEST_NAME in VARCHAR2,
  X_REQUEST_DESCRIPTION in VARCHAR2, X_COMMENTS in VARCHAR2
) is
  cursor C is select ROWID from OZF_REQUEST_HEADERS_ALL_B
    where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
    ;

Line: 123

  insert into OZF_REQUEST_HEADERS_ALL_B (
    REQUEST_HEADER_ID,
    OBJECT_VERSION_NUMBER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_ID,
    program_application_id,
    program_update_date,
    program_id,
    CREATED_FROM,
    REQUEST_NUMBER,
    SHIP_FROM_STOCK_FLAG,
    REQUEST_TYPE_CODE,
    REQUEST_CLASS,
    BENEFIT_ID,
    ACTIVITY_MEDIA_ID,
    SUBMITTED_BY,
    SUBMITTED_DATE,
    PARTNER_CONTACT_ID,
    PARTNER_CONTACT_PHONE_NUMBER,
    PARTNER_CONTACT_EMAIL_ADDRESS,
    OFFER_ID,
    OFFER_TYPE,
    LINKED_REQUEST_HEADER_ID,
    ROOT_REQUEST_HEADER_ID,
    START_DATE,
    END_DATE,
    STATUS_CODE,
    REQUEST_OUTCOME,
    DECLINE_REASON_CODE,
    RETURN_REASON_CODE,
    CURRENCY_CODE,
    PARTNER_AMOUNT,
    REQUESTED_AMOUNT,
    APPROVED_AMOUNT,
    EXCHANGE_RATE_TYPE,
    EXCHANGE_RATE_DATE,
    EXCHANGE_RATE,
    PARTNER_ACCTD_AMOUNT,
    REQUESTED_ACCTD_AMOUNT,
    APPROVED_ACCTD_AMOUNT,
    APPROVED_BY,
    APPROVED_DATE,
    AUTHORIZATION_CODE,
    AGREEMENT_NUMBER,
    PARTNER_ID,
    PARTNER_SITE_USE_ID,
    END_CUST_PARTY_ID,
    END_CUST_SITE_USE_ID,
    END_CUST_DUNS_NUMBER,
    END_CUST_NAME,
    END_CUST_ADDRESS1,
    END_CUST_ADDRESS2,
    END_CUST_ADDRESS3,
    END_CUST_ADDRESS4,
    END_CUST_PROVINCE,
    END_CUST_COUNTY,
    END_CUST_CITY,
    END_CUST_STATE,
    END_CUST_POSTAL_CODE,
    END_CUST_COUNTRY,
    END_CUST_ADDR_LINES_PHONETIC,
    END_CUST_CONTACT_FIRST_NAME,
    END_CUST_CONTACT_LAST_NAME,
    END_CUST_CONTACT_TITLE,
    END_CUST_CONTACT_EMAIL_ADDRESS,
    END_CUST_CONTACT_PHONE_TYPE,
    END_CUST_CONTACT_PHONE_NUMBER,
    END_CUST_CONTACT_PHONE_EXTN,
    RESELLER_PARTY_ID,
    RESELLER_DUNS_NUMBER,
    RESELLER_SITE_USE_ID,
    RESELLER_NAME,
    RESELLER_ADDRESS1,
    RESELLER_ADDRESS2,
    RESELLER_ADDRESS3,
    RESELLER_ADDRESS4,
    RESELLER_PROVINCE,
    RESELLER_COUNTY,
    RESELLER_CITY,
    RESELLER_STATE,
    RESELLER_POSTAL_CODE,
    RESELLER_COUNTRY,
    RESELLER_ADDR_LINES_PHONETIC,
    RESELLER_CONTACT_FIRST_NAME,
    RESELLER_CONTACT_LAST_NAME,
    RESELLER_CONTACT_TITLE,
    RESELLER_CONTACT_EMAIL_ADDRESS,
    RESELLER_CONTACT_PHONE_NUMBER,
    RESELLER_CONTACT_PHONE_TYPE,
    RESELLER_CONTACT_PHONE_EXTN,
    CUSTOMER_MERGE_FLAG,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    ORG_ID,
    SECURITY_GROUP_ID
    ) values (
    X_REQUEST_HEADER_ID,
    X_OBJECT_VERSION_NUMBER,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_REQUEST_ID,
    X_program_application_id,
    X_program_update_date,
    X_program_id,
    X_CREATE_FROM,
    X_REQUEST_NUMBER,
    X_SHIP_FROM_STOCK_FLAG,
    X_REQUEST_TYPE_CODE,
    X_REQUEST_CLASS,
    X_BENEFIT_ID,
    X_ACTIVITY_MEDIA_ID,
    X_SUBMITTED_BY,
    X_SUBMITTED_DATE,
    X_PARTNER_CONTACT_ID,
    X_PARTNER_CONTACT_PHONE_NUMBER,
    X_PARTNER_CONTACT_EMAIL_ADDRES,
    X_OFFER_ID,X_OFFER_TYPE,
    X_LINKED_REQUEST_HEADER_ID,
    X_ROOT_REQUEST_HEADER_ID,
    X_START_DATE,
    X_END_DATE,
    X_STATUS_CODE,
    X_REQUEST_OUTCOME,
    X_DECLINE_REASON_CODE,
    X_RETURN_REASON_CODE,
    X_CURRENCY_CODE,
    X_PARTNER_AMOUNT,
    X_REQUESTED_AMOUNT,
    X_APPROVED_AMOUNT,
    X_EXCHANGE_RATE_TYPE,
    X_EXCHANGE_RATE_DATE,
    X_EXCHANGE_RATE,
    X_PARTNER_ACCTD_AMOUNT,
    X_REQUESTED_ACCTD_AMOUNT,
    X_APPROVED_ACCTD_AMOUNT,
    X_APPROVED_BY,
    X_APPROVED_DATE,
    X_AUTHORIZATION_CODE,
    X_AGREEMENT_NUMBER,
    X_PARTNER_ID,
    X_PARTNER_SITE_USE_ID,
    X_END_CUST_PARTY_ID,
    X_END_CUST_SITE_USE_ID,
    X_END_CUST_DUNS_NUMBER,
    X_END_CUST_NAME,
    X_END_CUST_ADDRESS1,
    X_END_CUST_ADDRESS2,
    X_END_CUST_ADDRESS3,
    X_END_CUST_ADDRESS4,
    X_END_CUST_PROVINCE,
    X_END_CUST_COUNTY,
    X_END_CUST_CITY,
    X_END_CUST_STATE,
    X_END_CUST_POSTAL_CODE,
    X_END_CUST_COUNTRY,
    X_END_CUST_ADDR_LINES_PHONETIC,
    X_END_CUST_CONTACT_FIRST_NAME,
    X_END_CUST_CONTACT_LAST_NAME,
    X_END_CUST_CONTACT_TITLE,
    X_END_CUST_CONTACT_EMAIL_ADDRE,
    X_END_CUST_CONTACT_PHONE_TYPE,
    X_END_CUST_CONTACT_PHONE_NUMBE,
    X_END_CUST_CONTACT_PHONE_EXTN,
    X_RESELLER_PARTY_ID,
    X_RESELLER_DUNS_NUMBER,
    X_RESELLER_SITE_USE_ID,
    X_RESELLER_NAME,
    X_RESELLER_ADDRESS1,
    X_RESELLER_ADDRESS2,
    X_RESELLER_ADDRESS3,
    X_RESELLER_ADDRESS4,
    X_RESELLER_PROVINCE,
    X_RESELLER_COUNTY,
    X_RESELLER_CITY,
    X_RESELLER_STATE,
    X_RESELLER_POSTAL_CODE,
    X_RESELLER_COUNTRY,
    X_RESELLER_ADDR_LINES_PHONETIC,
    X_RESELLER_CONTACT_FIRST_NAME,
    X_RESELLER_CONTACT_LAST_NAME,
    X_RESELLER_CONTACT_TITLE,
    X_RESELLER_CONTACT_EMAIL_ADDRE,
    X_RESELLER_CONTACT_PHONE_NUMBE,
    X_RESELLER_CONTACT_PHONE_TYPE,
    X_RESELLER_CONTACT_PHONE_EXTN,
    X_CUSTOMER_MERGE_FLAG,
    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_ORG_ID,
    X_SECURITY_GROUP_ID
  );

Line: 349

  insert into OZF_REQUEST_HEADERS_ALL_TL (
    REQUEST_HEADER_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_NAME,
    REQUEST_DESCRIPTION,
    COMMENTS,
    SECURITY_GROUP_ID,
    ORG_ID,
    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_NAME,
    X_REQUEST_DESCRIPTION,
    X_COMMENTS,
    X_SECURITY_GROUP_ID,
    X_ORG_ID,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from OZF_REQUEST_HEADERS_ALL_TL T
    where T.REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 393

end INSERT_ROW;

Line: 504

  X_PROGRAM_UPDATE_DATE date,
  X_ORG_ID NUMBER
) is
  cursor c is select
      OBJECT_VERSION_NUMBER,
      REQUEST_ID,
      program_application_id,
      program_update_date,
      program_id,
      CREATED_FROM,
      REQUEST_NUMBER,
      SHIP_FROM_STOCK_FLAG,
      REQUEST_TYPE_CODE,
      REQUEST_CLASS,
      BENEFIT_ID,
      ACTIVITY_MEDIA_ID,
      SUBMITTED_BY,
      SUBMITTED_DATE,
      PARTNER_CONTACT_ID,
      PARTNER_CONTACT_PHONE_NUMBER,
      PARTNER_CONTACT_EMAIL_ADDRESS,
      OFFER_ID,
      OFFER_TYPE,
      LINKED_REQUEST_HEADER_ID,
      ROOT_REQUEST_HEADER_ID,
      START_DATE,
      END_DATE,
      STATUS_CODE,
      REQUEST_OUTCOME,
      DECLINE_REASON_CODE,
      RETURN_REASON_CODE,
      CURRENCY_CODE,
      PARTNER_AMOUNT,
      REQUESTED_AMOUNT,
      APPROVED_AMOUNT,
      EXCHANGE_RATE_TYPE,
      EXCHANGE_RATE_DATE,
      EXCHANGE_RATE,
      PARTNER_ACCTD_AMOUNT,
      REQUESTED_ACCTD_AMOUNT,
      APPROVED_ACCTD_AMOUNT,
      APPROVED_BY,
      APPROVED_DATE,
      AUTHORIZATION_CODE,
      AGREEMENT_NUMBER,
      PARTNER_ID,
      PARTNER_SITE_USE_ID,
      END_CUST_PARTY_ID,
      END_CUST_SITE_USE_ID,
      END_CUST_DUNS_NUMBER,
      END_CUST_NAME,
     END_CUST_ADDRESS1,
    END_CUST_ADDRESS2,
    END_CUST_ADDRESS3,
    END_CUST_ADDRESS4,
    END_CUST_PROVINCE,
    END_CUST_COUNTY,
       END_CUST_CITY,
      END_CUST_STATE,
      END_CUST_POSTAL_CODE,
      END_CUST_COUNTRY,
       END_CUST_ADDR_LINES_PHONETIC,
      END_CUST_CONTACT_FIRST_NAME,
      END_CUST_CONTACT_LAST_NAME,
      END_CUST_CONTACT_TITLE,
      END_CUST_CONTACT_EMAIL_ADDRESS,
      END_CUST_CONTACT_PHONE_TYPE,
      END_CUST_CONTACT_PHONE_NUMBER,
      END_CUST_CONTACT_PHONE_EXTN,
      RESELLER_PARTY_ID,
      RESELLER_DUNS_NUMBER,
      RESELLER_SITE_USE_ID,
      RESELLER_NAME,
      RESELLER_ADDRESS1,
    RESELLER_ADDRESS2,
    RESELLER_ADDRESS3,
    RESELLER_ADDRESS4,
    RESELLER_PROVINCE,
    RESELLER_COUNTY,
      RESELLER_CITY,
      RESELLER_STATE,
      RESELLER_POSTAL_CODE,
      RESELLER_COUNTRY,
       RESELLER_ADDR_LINES_PHONETIC,
      RESELLER_CONTACT_FIRST_NAME,
      RESELLER_CONTACT_LAST_NAME,
      RESELLER_CONTACT_TITLE,
      RESELLER_CONTACT_EMAIL_ADDRESS,
      RESELLER_CONTACT_PHONE_NUMBER,
      RESELLER_CONTACT_PHONE_TYPE,
      RESELLER_CONTACT_PHONE_EXTN,
      CUSTOMER_MERGE_FLAG,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      SECURITY_GROUP_ID,
     ORG_ID
    from OZF_REQUEST_HEADERS_ALL_B
    where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
    for update of REQUEST_HEADER_ID nowait;

Line: 619

  cursor c1 is select
      REQUEST_NAME,
      REQUEST_DESCRIPTION,COMMENTS,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from OZF_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: 632

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

Line: 837

procedure UPDATE_ROW (
     X_REQUEST_HEADER_ID in NUMBER,
  X_REQUEST_CLASS in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_REQUEST_ID in NUMBER,
  X_CREATE_FROM in VARCHAR2,
  X_REQUEST_NUMBER in VARCHAR2,
  X_SHIP_FROM_STOCK_FLAG in VARCHAR2,
  X_REQUEST_TYPE_CODE in VARCHAR2,
  X_BENEFIT_ID in NUMBER,
  X_ACTIVITY_MEDIA_ID in NUMBER,
  X_SUBMITTED_BY in NUMBER,
  X_SUBMITTED_DATE in DATE,
  X_PARTNER_CONTACT_ID in NUMBER,
  X_PARTNER_CONTACT_PHONE_NUMBER in VARCHAR2,
  X_PARTNER_CONTACT_EMAIL_ADDRES in VARCHAR2,
  X_OFFER_ID in NUMBER,
  X_OFFER_TYPE in VARCHAR2,
  X_LINKED_REQUEST_HEADER_ID in NUMBER,
  X_ROOT_REQUEST_HEADER_ID in NUMBER,
  X_START_DATE in DATE,
  X_END_DATE in DATE,
  X_STATUS_CODE in VARCHAR2,
  X_REQUEST_OUTCOME in VARCHAR2,
  X_DECLINE_REASON_CODE in VARCHAR2,
  X_RETURN_REASON_CODE in VARCHAR2,
  X_CURRENCY_CODE in VARCHAR2,
  X_PARTNER_AMOUNT in NUMBER,
  X_REQUESTED_AMOUNT in NUMBER,
  X_APPROVED_AMOUNT in NUMBER,
  X_EXCHANGE_RATE_TYPE in VARCHAR2,
  X_EXCHANGE_RATE_DATE in DATE,
  X_EXCHANGE_RATE in NUMBER,
  X_PARTNER_ACCTD_AMOUNT in NUMBER,
  X_REQUESTED_ACCTD_AMOUNT in NUMBER,
  X_APPROVED_ACCTD_AMOUNT in NUMBER,
  X_APPROVED_BY in NUMBER,
  X_APPROVED_DATE in DATE,
  X_AUTHORIZATION_CODE in VARCHAR2,
  X_AGREEMENT_NUMBER in VARCHAR2,
  X_PARTNER_ID in NUMBER,
  X_PARTNER_SITE_USE_ID in NUMBER,
  X_END_CUST_PARTY_ID in NUMBER,
  X_END_CUST_SITE_USE_ID in NUMBER,
  X_END_CUST_DUNS_NUMBER in NUMBER,
  X_END_CUST_NAME in VARCHAR2,
  X_END_CUST_ADDRESS1 in VARCHAR2,
  X_END_CUST_ADDRESS2 in VARCHAR2,
  X_END_CUST_ADDRESS3 in VARCHAR2,
  X_END_CUST_ADDRESS4 in VARCHAR2,
  X_END_CUST_PROVINCE in VARCHAR2,
  X_END_CUST_COUNTY  in VARCHAR2,
  X_END_CUST_CITY in VARCHAR2,
  X_END_CUST_STATE in VARCHAR2,
  X_END_CUST_POSTAL_CODE in VARCHAR2,
  X_END_CUST_COUNTRY in VARCHAR2,
  X_END_CUST_ADDR_LINES_PHONETIC in VARCHAR2,
  X_END_CUST_CONTACT_FIRST_NAME in VARCHAR2,
  X_END_CUST_CONTACT_LAST_NAME in VARCHAR2,
  X_END_CUST_CONTACT_TITLE in VARCHAR2,
  X_END_CUST_CONTACT_EMAIL_ADDRE in VARCHAR2,
  X_END_CUST_CONTACT_PHONE_TYPE in VARCHAR2,
  X_END_CUST_CONTACT_PHONE_NUMBE in VARCHAR2,
  X_END_CUST_CONTACT_PHONE_EXTN in VARCHAR2,
  X_RESELLER_PARTY_ID in NUMBER,
  X_RESELLER_DUNS_NUMBER in NUMBER,
  X_RESELLER_SITE_USE_ID in NUMBER,
  X_RESELLER_NAME in VARCHAR2,
  X_RESELLER_ADDRESS1 in VARCHAR2,
  X_RESELLER_ADDRESS2 in VARCHAR2,
  X_RESELLER_ADDRESS3 in VARCHAR2,
  X_RESELLER_ADDRESS4 in VARCHAR2,
  X_RESELLER_PROVINCE in VARCHAR2,
  X_RESELLER_COUNTY in VARCHAR2,
  X_RESELLER_CITY in VARCHAR2,
  X_RESELLER_STATE in VARCHAR2,
  X_RESELLER_POSTAL_CODE in VARCHAR2,
  X_RESELLER_COUNTRY in VARCHAR2,
  X_RESELLER_ADDR_LINES_PHONETIC in VARCHAR2,
  X_RESELLER_CONTACT_FIRST_NAME in VARCHAR2,
  X_RESELLER_CONTACT_LAST_NAME in VARCHAR2,
  X_RESELLER_CONTACT_TITLE in VARCHAR2,
  X_RESELLER_CONTACT_EMAIL_ADDRE in VARCHAR2,
  X_RESELLER_CONTACT_PHONE_NUMBE in VARCHAR2,
  X_RESELLER_CONTACT_PHONE_TYPE in VARCHAR2,
  X_RESELLER_CONTACT_PHONE_EXTN in VARCHAR2,
  X_CUSTOMER_MERGE_FLAG 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_SECURITY_GROUP_ID in NUMBER,
  X_REQUEST_NAME in VARCHAR2,
  X_REQUEST_DESCRIPTION in VARCHAR2,
  X_COMMENTS in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
   X_PROGRAM_ID NUMBER,
  X_PROGRAM_APPLICATION_ID NUMBER,
  X_PROGRAM_UPDATE_DATE date,
  X_ORG_ID NUMBER
) is
begin
  update OZF_REQUEST_HEADERS_ALL_B set
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    REQUEST_ID = X_REQUEST_ID,
    program_application_id = X_program_application_id,
    program_update_date = X_program_update_date,
    program_id = X_program_id,
    CREATED_FROM = X_CREATE_FROM,
    REQUEST_NUMBER = X_REQUEST_NUMBER,
    SHIP_FROM_STOCK_FLAG = X_SHIP_FROM_STOCK_FLAG,
    REQUEST_TYPE_CODE = X_REQUEST_TYPE_CODE,
    BENEFIT_ID = X_BENEFIT_ID,
    ACTIVITY_MEDIA_ID = X_ACTIVITY_MEDIA_ID,
    SUBMITTED_BY = X_SUBMITTED_BY,
    SUBMITTED_DATE = X_SUBMITTED_DATE,
    PARTNER_CONTACT_ID = X_PARTNER_CONTACT_ID,
    PARTNER_CONTACT_PHONE_NUMBER = X_PARTNER_CONTACT_PHONE_NUMBER,
    PARTNER_CONTACT_EMAIL_ADDRESS = X_PARTNER_CONTACT_EMAIL_ADDRES,
    OFFER_ID = X_OFFER_ID,
    OFFER_TYPE = X_OFFER_TYPE,
    LINKED_REQUEST_HEADER_ID = X_LINKED_REQUEST_HEADER_ID,
    ROOT_REQUEST_HEADER_ID = X_ROOT_REQUEST_HEADER_ID,
    START_DATE = X_START_DATE,
    END_DATE = X_END_DATE,
    STATUS_CODE = X_STATUS_CODE,
    REQUEST_OUTCOME = X_REQUEST_OUTCOME,
    DECLINE_REASON_CODE = X_DECLINE_REASON_CODE,
    RETURN_REASON_CODE = X_RETURN_REASON_CODE,
    CURRENCY_CODE = X_CURRENCY_CODE,
    PARTNER_AMOUNT = X_PARTNER_AMOUNT,
    REQUESTED_AMOUNT = X_REQUESTED_AMOUNT,
    APPROVED_AMOUNT = X_APPROVED_AMOUNT,
    EXCHANGE_RATE_TYPE = X_EXCHANGE_RATE_TYPE,
    EXCHANGE_RATE_DATE = X_EXCHANGE_RATE_DATE,
    EXCHANGE_RATE = X_EXCHANGE_RATE,
    PARTNER_ACCTD_AMOUNT = X_PARTNER_ACCTD_AMOUNT,
    REQUESTED_ACCTD_AMOUNT = X_REQUESTED_ACCTD_AMOUNT,
    APPROVED_ACCTD_AMOUNT = X_APPROVED_ACCTD_AMOUNT,
    APPROVED_BY = X_APPROVED_BY,
    APPROVED_DATE = X_APPROVED_DATE,
    AUTHORIZATION_CODE = X_AUTHORIZATION_CODE,
    AGREEMENT_NUMBER = X_AGREEMENT_NUMBER,
    PARTNER_ID = X_PARTNER_ID,
    PARTNER_SITE_USE_ID = X_PARTNER_SITE_USE_ID,
    END_CUST_PARTY_ID = X_END_CUST_PARTY_ID,
    END_CUST_SITE_USE_ID = X_END_CUST_SITE_USE_ID,
    END_CUST_DUNS_NUMBER = X_END_CUST_DUNS_NUMBER,
    END_CUST_NAME = X_END_CUST_NAME,
    END_CUST_ADDRESS1 = X_END_CUST_ADDRESS1,
    END_CUST_ADDRESS2 = X_END_CUST_ADDRESS2,
    END_CUST_ADDRESS3 = X_END_CUST_ADDRESS3,
    END_CUST_ADDRESS4 = X_END_CUST_ADDRESS4,
    END_CUST_PROVINCE = X_END_CUST_PROVINCE,
    END_CUST_COUNTY = X_END_CUST_COUNTY,
    END_CUST_CITY = X_END_CUST_CITY,
    END_CUST_STATE = X_END_CUST_STATE,
    END_CUST_POSTAL_CODE = X_END_CUST_POSTAL_CODE,
    END_CUST_COUNTRY = X_END_CUST_COUNTRY,
    END_CUST_ADDR_LINES_PHONETIC = X_END_CUST_ADDR_LINES_PHONETIC,
    END_CUST_CONTACT_FIRST_NAME = X_END_CUST_CONTACT_FIRST_NAME,
    END_CUST_CONTACT_LAST_NAME = X_END_CUST_CONTACT_LAST_NAME,
    END_CUST_CONTACT_TITLE = X_END_CUST_CONTACT_TITLE,
    END_CUST_CONTACT_EMAIL_ADDRESS = X_END_CUST_CONTACT_EMAIL_ADDRE,
    END_CUST_CONTACT_PHONE_TYPE = X_END_CUST_CONTACT_PHONE_TYPE,
    END_CUST_CONTACT_PHONE_NUMBER = X_END_CUST_CONTACT_PHONE_NUMBE,
    END_CUST_CONTACT_PHONE_EXTN = X_END_CUST_CONTACT_PHONE_EXTN,
    RESELLER_PARTY_ID = X_RESELLER_PARTY_ID,
    RESELLER_DUNS_NUMBER = X_RESELLER_DUNS_NUMBER,
    RESELLER_SITE_USE_ID = X_RESELLER_SITE_USE_ID,
    RESELLER_NAME = X_RESELLER_NAME,
    RESELLER_ADDRESS1 = X_RESELLER_ADDRESS1,
    RESELLER_ADDRESS2 = X_RESELLER_ADDRESS2,
    RESELLER_ADDRESS3 = X_RESELLER_ADDRESS3,
    RESELLER_ADDRESS4 = X_RESELLER_ADDRESS4,
    RESELLER_PROVINCE = X_RESELLER_PROVINCE,
    RESELLER_COUNTY = X_RESELLER_COUNTY,
    RESELLER_CITY = X_RESELLER_CITY,
    RESELLER_STATE = X_RESELLER_STATE,
    RESELLER_POSTAL_CODE = X_RESELLER_POSTAL_CODE,
    RESELLER_COUNTRY = X_RESELLER_COUNTRY,
    RESELLER_ADDR_LINES_PHONETIC = X_RESELLER_ADDR_LINES_PHONETIC,
    RESELLER_CONTACT_FIRST_NAME = X_RESELLER_CONTACT_FIRST_NAME,
    RESELLER_CONTACT_LAST_NAME = X_RESELLER_CONTACT_LAST_NAME,
    RESELLER_CONTACT_TITLE = X_RESELLER_CONTACT_TITLE,
    RESELLER_CONTACT_EMAIL_ADDRESS = X_RESELLER_CONTACT_EMAIL_ADDRE,
    RESELLER_CONTACT_PHONE_NUMBER = X_RESELLER_CONTACT_PHONE_NUMBE,
    RESELLER_CONTACT_PHONE_TYPE = X_RESELLER_CONTACT_PHONE_TYPE,
    RESELLER_CONTACT_PHONE_EXTN = X_RESELLER_CONTACT_PHONE_EXTN,
    CUSTOMER_MERGE_FLAG = X_CUSTOMER_MERGE_FLAG,
    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,
    SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    REQUEST_CLASS = X_REQUEST_CLASS
  where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID;

Line: 1068

  update OZF_REQUEST_HEADERS_ALL_TL set
    REQUEST_NAME = X_REQUEST_NAME,
    REQUEST_DESCRIPTION = X_REQUEST_DESCRIPTION,
    COMMENTS = X_COMMENTS,
    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: 1082

end UPDATE_ROW;

Line: 1084

procedure DELETE_ROW (
  X_REQUEST_HEADER_ID in NUMBER
) is
begin
  delete from OZF_REQUEST_HEADERS_ALL_TL
  where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID;

Line: 1095

  delete from OZF_REQUEST_HEADERS_ALL_B
  where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID;

Line: 1101

end DELETE_ROW;

Line: 1106

  delete from OZF_REQUEST_HEADERS_ALL_TL T
  where not exists
    (select NULL
    from OZF_REQUEST_HEADERS_ALL_B B
    where B.REQUEST_HEADER_ID = T.REQUEST_HEADER_ID
    );

Line: 1113

  update OZF_REQUEST_HEADERS_ALL_TL T set (
      REQUEST_NAME,
      REQUEST_DESCRIPTION,COMMENTS
    ) = (select
      B.REQUEST_NAME,
      B.REQUEST_DESCRIPTION,B.COMMENTS
    from OZF_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_REQUEST_HEADERS_ALL_TL SUBB, OZF_REQUEST_HEADERS_ALL_TL SUBT
    where SUBB.REQUEST_HEADER_ID = SUBT.REQUEST_HEADER_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.REQUEST_NAME <> SUBT.REQUEST_NAME
      or (SUBB.REQUEST_NAME is null and SUBT.REQUEST_NAME is not null)
      or (SUBB.REQUEST_NAME is not null and SUBT.REQUEST_NAME is null)
      or 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)
      or SUBB.COMMENTS <> SUBT.COMMENTS
      or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)
      or (SUBB.COMMENTS is not null and SUBT.COMMENTS is null)
  ));

Line: 1142

  insert into OZF_REQUEST_HEADERS_ALL_TL (
    REQUEST_HEADER_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_NAME,
    REQUEST_DESCRIPTION,
    COMMENTS,
    SECURITY_GROUP_ID,
    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_NAME,
    B.REQUEST_DESCRIPTION,
    B.COMMENTS,
    B.SECURITY_GROUP_ID,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from OZF_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_REQUEST_HEADERS_ALL_TL T
    where T.REQUEST_HEADER_ID = B.REQUEST_HEADER_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);