APPS.AMS_EVENT_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_EVENT_HEADER_ID in NUMBER,
  X_FUND_AMOUNT_TC in NUMBER,
  X_FUND_AMOUNT_FC in NUMBER,
  X_ATTRIBUTE4 in VARCHAR2,
  X_USER_STATUS_ID in NUMBER,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ORGANIZATION_ID in NUMBER,
  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_CURRENCY_CODE_TC in VARCHAR2,
  X_CURRENCY_CODE_FC in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_EMAIL in VARCHAR2,
  X_PHONE in VARCHAR2,
  X_ACTUAL_COST in NUMBER,
  X_COORDINATOR_ID in NUMBER,
  X_FUND_SOURCE_TYPE_CODE in VARCHAR2,
  X_FUND_SOURCE_ID in NUMBER,
  X_OWNER_USER_ID in NUMBER,
  X_URL in VARCHAR2,
  X_PRIORITY_TYPE_CODE in VARCHAR2,
  X_CANCELLATION_REASON_CODE in VARCHAR2,
  X_INBOUND_SCRIPT_NAME in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_FORECASTED_COST in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_EVENT_LEVEL in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_EVENT_TYPE_CODE in VARCHAR2,
  X_ACTIVE_FLAG in VARCHAR2,
  X_PRIVATE_FLAG in VARCHAR2,
  X_SYSTEM_STATUS_CODE in VARCHAR2,
  X_LAST_STATUS_DATE in DATE,
  X_STREAM_TYPE_CODE in VARCHAR2,
  X_SOURCE_CODE in VARCHAR2,
  X_ACTUAL_REVENUE in NUMBER,
  X_EVENT_STANDALONE_FLAG in VARCHAR2,
  X_DAY_OF_EVENT in VARCHAR2,
  X_AGENDA_START_TIME in DATE,
  X_AGENDA_END_TIME in DATE,
  X_REG_REQUIRED_FLAG in VARCHAR2,
  X_REG_CHARGE_FLAG in VARCHAR2,
  X_REG_INVITED_ONLY_FLAG in VARCHAR2,
  X_PARTNER_FLAG in VARCHAR2,
  X_OVERFLOW_FLAG in VARCHAR2,
  X_PARENT_EVENT_HEADER_ID in NUMBER,
  X_DURATION in NUMBER,
  X_DURATION_UOM_CODE in VARCHAR2,
  X_ACTIVE_FROM_DATE in DATE,
  X_ACTIVE_TO_DATE in DATE,
  X_REG_MAXIMUM_CAPACITY in NUMBER,
  X_REG_MINIMUM_CAPACITY in NUMBER,
  X_MAIN_LANGUAGE_CODE in VARCHAR2,
  X_CERT_CREDIT_TYPE_CODE in VARCHAR2,
  X_CERTIFICATION_CREDITS in NUMBER,
  X_INVENTORY_ITEM_ID in NUMBER,
  X_FORECASTED_REVENUE in NUMBER,
  X_EVENT_HEADER_NAME in VARCHAR2,
  X_EVENT_MKTG_MESSAGE 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
) is
  cursor C is select ROWID from AMS_EVENT_HEADERS_ALL_B
    where EVENT_HEADER_ID = X_EVENT_HEADER_ID
    ;

Line: 85

  insert into AMS_EVENT_HEADERS_ALL_B (
    FUND_AMOUNT_TC,
    FUND_AMOUNT_FC,
    ATTRIBUTE4,
    USER_STATUS_ID,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ORGANIZATION_ID,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    CURRENCY_CODE_TC,
    CURRENCY_CODE_FC,
    ATTRIBUTE15,
    EMAIL,
    PHONE,
    ACTUAL_COST,
    COORDINATOR_ID,
    FUND_SOURCE_TYPE_CODE,
    FUND_SOURCE_ID,
    OWNER_USER_ID,
    URL,
    PRIORITY_TYPE_CODE,
    CANCELLATION_REASON_CODE,
    INBOUND_SCRIPT_NAME,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    FORECASTED_COST,
    EVENT_HEADER_ID,
    OBJECT_VERSION_NUMBER,
    EVENT_LEVEL,
    APPLICATION_ID,
    EVENT_TYPE_CODE,
    ACTIVE_FLAG,
    PRIVATE_FLAG,
    SYSTEM_STATUS_CODE,
    LAST_STATUS_DATE,
    STREAM_TYPE_CODE,
    SOURCE_CODE,
    ACTUAL_REVENUE,
    EVENT_STANDALONE_FLAG,
    DAY_OF_EVENT,
    AGENDA_START_TIME,
    AGENDA_END_TIME,
    REG_REQUIRED_FLAG,
    REG_CHARGE_FLAG,
    REG_INVITED_ONLY_FLAG,
    PARTNER_FLAG,
    OVERFLOW_FLAG,
    PARENT_EVENT_HEADER_ID,
    DURATION,
    DURATION_UOM_CODE,
    ACTIVE_FROM_DATE,
    ACTIVE_TO_DATE,
    REG_MAXIMUM_CAPACITY,
    REG_MINIMUM_CAPACITY,
    MAIN_LANGUAGE_CODE,
    CERT_CREDIT_TYPE_CODE,
    CERTIFICATION_CREDITS,
    INVENTORY_ITEM_ID,
    FORECASTED_REVENUE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_FUND_AMOUNT_TC,
    X_FUND_AMOUNT_FC,
    X_ATTRIBUTE4,
    X_USER_STATUS_ID,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ORGANIZATION_ID,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_CURRENCY_CODE_TC,
    X_CURRENCY_CODE_FC,
    X_ATTRIBUTE15,
    X_EMAIL,
    X_PHONE,
    X_ACTUAL_COST,
    X_COORDINATOR_ID,
    X_FUND_SOURCE_TYPE_CODE,
    X_FUND_SOURCE_ID,
    X_OWNER_USER_ID,
    X_URL,
    X_PRIORITY_TYPE_CODE,
    X_CANCELLATION_REASON_CODE,
    X_INBOUND_SCRIPT_NAME,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_FORECASTED_COST,
    X_EVENT_HEADER_ID,
    X_OBJECT_VERSION_NUMBER,
    X_EVENT_LEVEL,
    X_APPLICATION_ID,
    X_EVENT_TYPE_CODE,
    X_ACTIVE_FLAG,
    X_PRIVATE_FLAG,
    X_SYSTEM_STATUS_CODE,
    X_LAST_STATUS_DATE,
    X_STREAM_TYPE_CODE,
    X_SOURCE_CODE,
    X_ACTUAL_REVENUE,
    X_EVENT_STANDALONE_FLAG,
    X_DAY_OF_EVENT,
    X_AGENDA_START_TIME,
    X_AGENDA_END_TIME,
    X_REG_REQUIRED_FLAG,
    X_REG_CHARGE_FLAG,
    X_REG_INVITED_ONLY_FLAG,
    X_PARTNER_FLAG,
    X_OVERFLOW_FLAG,
    X_PARENT_EVENT_HEADER_ID,
    X_DURATION,
    X_DURATION_UOM_CODE,
    X_ACTIVE_FROM_DATE,
    X_ACTIVE_TO_DATE,
    X_REG_MAXIMUM_CAPACITY,
    X_REG_MINIMUM_CAPACITY,
    X_MAIN_LANGUAGE_CODE,
    X_CERT_CREDIT_TYPE_CODE,
    X_CERTIFICATION_CREDITS,
    X_INVENTORY_ITEM_ID,
    X_FORECASTED_REVENUE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 233

  insert into AMS_EVENT_HEADERS_ALL_TL (
    EVENT_HEADER_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    EVENT_HEADER_NAME,
    EVENT_MKTG_MESSAGE,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_EVENT_HEADER_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_EVENT_HEADER_NAME,
    X_EVENT_MKTG_MESSAGE,
    X_DESCRIPTION,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AMS_EVENT_HEADERS_ALL_TL T
    where T.EVENT_HEADER_ID = X_EVENT_HEADER_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 273

end INSERT_ROW;

Line: 347

  cursor c is select
      FUND_AMOUNT_TC,
      FUND_AMOUNT_FC,
      ATTRIBUTE4,
      USER_STATUS_ID,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ORGANIZATION_ID,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      CURRENCY_CODE_TC,
      CURRENCY_CODE_FC,
      ATTRIBUTE15,
      EMAIL,
      PHONE,
      ACTUAL_COST,
      COORDINATOR_ID,
      FUND_SOURCE_TYPE_CODE,
      FUND_SOURCE_ID,
      OWNER_USER_ID,
      URL,
      PRIORITY_TYPE_CODE,
      CANCELLATION_REASON_CODE,
      INBOUND_SCRIPT_NAME,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      FORECASTED_COST,
      OBJECT_VERSION_NUMBER,
      EVENT_LEVEL,
      APPLICATION_ID,
      EVENT_TYPE_CODE,
      ACTIVE_FLAG,
      PRIVATE_FLAG,
      SYSTEM_STATUS_CODE,
      LAST_STATUS_DATE,
      STREAM_TYPE_CODE,
      SOURCE_CODE,
      ACTUAL_REVENUE,
      EVENT_STANDALONE_FLAG,
      DAY_OF_EVENT,
      AGENDA_START_TIME,
      AGENDA_END_TIME,
      REG_REQUIRED_FLAG,
      REG_CHARGE_FLAG,
      REG_INVITED_ONLY_FLAG,
      PARTNER_FLAG,
      OVERFLOW_FLAG,
      PARENT_EVENT_HEADER_ID,
      DURATION,
      DURATION_UOM_CODE,
      ACTIVE_FROM_DATE,
      ACTIVE_TO_DATE,
      REG_MAXIMUM_CAPACITY,
      REG_MINIMUM_CAPACITY,
      MAIN_LANGUAGE_CODE,
      CERT_CREDIT_TYPE_CODE,
      CERTIFICATION_CREDITS,
      INVENTORY_ITEM_ID,
      FORECASTED_REVENUE
    from AMS_EVENT_HEADERS_ALL_B
    where EVENT_HEADER_ID = X_EVENT_HEADER_ID
    for update of EVENT_HEADER_ID nowait;

Line: 419

  cursor c1 is select
      EVENT_HEADER_NAME,
      EVENT_MKTG_MESSAGE,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from AMS_EVENT_HEADERS_ALL_TL
    where EVENT_HEADER_ID = X_EVENT_HEADER_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of EVENT_HEADER_ID nowait;

Line: 433

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

Line: 586

procedure UPDATE_ROW (
  X_EVENT_HEADER_ID in NUMBER,
  X_FUND_AMOUNT_TC in NUMBER,
  X_FUND_AMOUNT_FC in NUMBER,
  X_ATTRIBUTE4 in VARCHAR2,
  X_USER_STATUS_ID in NUMBER,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ORGANIZATION_ID in NUMBER,
  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_CURRENCY_CODE_TC in VARCHAR2,
  X_CURRENCY_CODE_FC in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_EMAIL in VARCHAR2,
  X_PHONE in VARCHAR2,
  X_ACTUAL_COST in NUMBER,
  X_COORDINATOR_ID in NUMBER,
  X_FUND_SOURCE_TYPE_CODE in VARCHAR2,
  X_FUND_SOURCE_ID in NUMBER,
  X_OWNER_USER_ID in NUMBER,
  X_URL in VARCHAR2,
  X_PRIORITY_TYPE_CODE in VARCHAR2,
  X_CANCELLATION_REASON_CODE in VARCHAR2,
  X_INBOUND_SCRIPT_NAME in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_FORECASTED_COST in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_EVENT_LEVEL in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_EVENT_TYPE_CODE in VARCHAR2,
  X_ACTIVE_FLAG in VARCHAR2,
  X_PRIVATE_FLAG in VARCHAR2,
  X_SYSTEM_STATUS_CODE in VARCHAR2,
  X_LAST_STATUS_DATE in DATE,
  X_STREAM_TYPE_CODE in VARCHAR2,
  X_SOURCE_CODE in VARCHAR2,
  X_ACTUAL_REVENUE in NUMBER,
  X_EVENT_STANDALONE_FLAG in VARCHAR2,
  X_DAY_OF_EVENT in VARCHAR2,
  X_AGENDA_START_TIME in DATE,
  X_AGENDA_END_TIME in DATE,
  X_REG_REQUIRED_FLAG in VARCHAR2,
  X_REG_CHARGE_FLAG in VARCHAR2,
  X_REG_INVITED_ONLY_FLAG in VARCHAR2,
  X_PARTNER_FLAG in VARCHAR2,
  X_OVERFLOW_FLAG in VARCHAR2,
  X_PARENT_EVENT_HEADER_ID in NUMBER,
  X_DURATION in NUMBER,
  X_DURATION_UOM_CODE in VARCHAR2,
  X_ACTIVE_FROM_DATE in DATE,
  X_ACTIVE_TO_DATE in DATE,
  X_REG_MAXIMUM_CAPACITY in NUMBER,
  X_REG_MINIMUM_CAPACITY in NUMBER,
  X_MAIN_LANGUAGE_CODE in VARCHAR2,
  X_CERT_CREDIT_TYPE_CODE in VARCHAR2,
  X_CERTIFICATION_CREDITS in NUMBER,
  X_INVENTORY_ITEM_ID in NUMBER,
  X_FORECASTED_REVENUE in NUMBER,
  X_EVENT_HEADER_NAME in VARCHAR2,
  X_EVENT_MKTG_MESSAGE in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AMS_EVENT_HEADERS_ALL_B set
    FUND_AMOUNT_TC = X_FUND_AMOUNT_TC,
    FUND_AMOUNT_FC = X_FUND_AMOUNT_FC,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    USER_STATUS_ID = X_USER_STATUS_ID,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ORGANIZATION_ID = X_ORGANIZATION_ID,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    CURRENCY_CODE_TC = X_CURRENCY_CODE_TC,
    CURRENCY_CODE_FC = X_CURRENCY_CODE_FC,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    EMAIL = X_EMAIL,
    PHONE = X_PHONE,
    ACTUAL_COST = X_ACTUAL_COST,
    COORDINATOR_ID = X_COORDINATOR_ID,
    FUND_SOURCE_TYPE_CODE = X_FUND_SOURCE_TYPE_CODE,
    FUND_SOURCE_ID = X_FUND_SOURCE_ID,
    OWNER_USER_ID = X_OWNER_USER_ID,
    URL = X_URL,
    PRIORITY_TYPE_CODE = X_PRIORITY_TYPE_CODE,
    CANCELLATION_REASON_CODE = X_CANCELLATION_REASON_CODE,
    INBOUND_SCRIPT_NAME = X_INBOUND_SCRIPT_NAME,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    FORECASTED_COST = X_FORECASTED_COST,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    EVENT_LEVEL = X_EVENT_LEVEL,
    APPLICATION_ID = X_APPLICATION_ID,
    EVENT_TYPE_CODE = X_EVENT_TYPE_CODE,
    ACTIVE_FLAG = X_ACTIVE_FLAG,
    PRIVATE_FLAG = X_PRIVATE_FLAG,
    SYSTEM_STATUS_CODE = X_SYSTEM_STATUS_CODE,
    LAST_STATUS_DATE = X_LAST_STATUS_DATE,
    STREAM_TYPE_CODE = X_STREAM_TYPE_CODE,
    SOURCE_CODE = X_SOURCE_CODE,
    ACTUAL_REVENUE = X_ACTUAL_REVENUE,
    EVENT_STANDALONE_FLAG = X_EVENT_STANDALONE_FLAG,
    DAY_OF_EVENT = X_DAY_OF_EVENT,
    AGENDA_START_TIME = X_AGENDA_START_TIME,
    AGENDA_END_TIME = X_AGENDA_END_TIME,
    REG_REQUIRED_FLAG = X_REG_REQUIRED_FLAG,
    REG_CHARGE_FLAG = X_REG_CHARGE_FLAG,
    REG_INVITED_ONLY_FLAG = X_REG_INVITED_ONLY_FLAG,
    PARTNER_FLAG = X_PARTNER_FLAG,
    OVERFLOW_FLAG = X_OVERFLOW_FLAG,
    PARENT_EVENT_HEADER_ID = X_PARENT_EVENT_HEADER_ID,
    DURATION = X_DURATION,
    DURATION_UOM_CODE = X_DURATION_UOM_CODE,
    ACTIVE_FROM_DATE = X_ACTIVE_FROM_DATE,
    ACTIVE_TO_DATE = X_ACTIVE_TO_DATE,
    REG_MAXIMUM_CAPACITY = X_REG_MAXIMUM_CAPACITY,
    REG_MINIMUM_CAPACITY = X_REG_MINIMUM_CAPACITY,
    MAIN_LANGUAGE_CODE = X_MAIN_LANGUAGE_CODE,
    CERT_CREDIT_TYPE_CODE = X_CERT_CREDIT_TYPE_CODE,
    CERTIFICATION_CREDITS = X_CERTIFICATION_CREDITS,
    INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
    FORECASTED_REVENUE = X_FORECASTED_REVENUE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where EVENT_HEADER_ID = X_EVENT_HEADER_ID;

Line: 738

  update AMS_EVENT_HEADERS_ALL_TL set
    EVENT_HEADER_NAME = X_EVENT_HEADER_NAME,
    EVENT_MKTG_MESSAGE = X_EVENT_MKTG_MESSAGE,
    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 EVENT_HEADER_ID = X_EVENT_HEADER_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 752

end UPDATE_ROW;

Line: 754

procedure DELETE_ROW (
  X_EVENT_HEADER_ID in NUMBER
) is
begin
  delete from AMS_EVENT_HEADERS_ALL_TL
  where EVENT_HEADER_ID = X_EVENT_HEADER_ID;

Line: 765

  delete from AMS_EVENT_HEADERS_ALL_B
  where EVENT_HEADER_ID = X_EVENT_HEADER_ID;

Line: 771

end DELETE_ROW;

Line: 776

  delete from AMS_EVENT_HEADERS_ALL_TL T
  where not exists
    (select NULL
    from AMS_EVENT_HEADERS_ALL_B B
    where B.EVENT_HEADER_ID = T.EVENT_HEADER_ID
    );

Line: 783

  update AMS_EVENT_HEADERS_ALL_TL T set (
      EVENT_HEADER_NAME,
      EVENT_MKTG_MESSAGE,
      DESCRIPTION
    ) = (select
      B.EVENT_HEADER_NAME,
      B.EVENT_MKTG_MESSAGE,
      B.DESCRIPTION
    from AMS_EVENT_HEADERS_ALL_TL B
    where B.EVENT_HEADER_ID = T.EVENT_HEADER_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.EVENT_HEADER_ID,
      T.LANGUAGE
  ) in (select
      SUBT.EVENT_HEADER_ID,
      SUBT.LANGUAGE
    from AMS_EVENT_HEADERS_ALL_TL SUBB, AMS_EVENT_HEADERS_ALL_TL SUBT
    where SUBB.EVENT_HEADER_ID = SUBT.EVENT_HEADER_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.EVENT_HEADER_NAME <> SUBT.EVENT_HEADER_NAME
      or SUBB.EVENT_MKTG_MESSAGE <> SUBT.EVENT_MKTG_MESSAGE
      or (SUBB.EVENT_MKTG_MESSAGE is null and SUBT.EVENT_MKTG_MESSAGE is not null)
      or (SUBB.EVENT_MKTG_MESSAGE is not null and SUBT.EVENT_MKTG_MESSAGE is null)
      or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
      or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
      or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
  ));

Line: 812

  insert into AMS_EVENT_HEADERS_ALL_TL (
    EVENT_HEADER_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    EVENT_HEADER_NAME,
    EVENT_MKTG_MESSAGE,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.EVENT_HEADER_ID,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.EVENT_HEADER_NAME,
    B.EVENT_MKTG_MESSAGE,
    B.DESCRIPTION,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from AMS_EVENT_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 AMS_EVENT_HEADERS_ALL_TL T
    where T.EVENT_HEADER_ID = B.EVENT_HEADER_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 856

    update AMS_EVENT_HEADERS_ALL_TL set
	EVENT_HEADER_NAME = nvl(X_EVENT_HEADER_NAME,EVENT_HEADER_NAME),
	EVENT_MKTG_MESSAGE = nvl(X_EVENT_MKTG_MESSAGE,EVENT_MKTG_MESSAGE),
	DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
	LAST_UPDATE_DATE = SYSDATE,
	LAST_UPDATED_BY = decode(x_owner, 'SEED', 1, 0),
	LAST_UPDATE_LOGIN = 0,
	SOURCE_LANG = userenv('LANG')
	where EVENT_HEADER_ID = X_EVENT_HEADER_ID
	and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 949

  select object_version_number
  from   ams_event_headers_all_b
  where  event_header_id = X_EVENT_HEADER_ID;

Line: 954

  select 'x'
  from   ams_event_headers_all_b
  where  event_header_id = X_EVENT_HEADER_ID;

Line: 959

  select ams_event_headers_all_b_s.nextval
  from   dual;

Line: 982

    AMS_EVENT_HEADERS_ALL_PKG.INSERT_ROW(
    X_ROWID => l_row_id,
    X_EVENT_HEADER_ID => l_evh_id,
    X_OBJECT_VERSION_NUMBER => l_version,
    X_FUND_AMOUNT_TC => X_FUND_AMOUNT_TC,
    X_FUND_AMOUNT_FC => X_FUND_AMOUNT_FC,
    X_ATTRIBUTE4 => X_ATTRIBUTE4,
    X_USER_STATUS_ID => X_USER_STATUS_ID,
    X_ATTRIBUTE5 => X_ATTRIBUTE5,
    X_ATTRIBUTE6 => X_ATTRIBUTE6,
    X_ORGANIZATION_ID => X_ORGANIZATION_ID,
    X_ATTRIBUTE7 => X_ATTRIBUTE7,
    X_ATTRIBUTE8 => X_ATTRIBUTE8,
    X_ATTRIBUTE9 => X_ATTRIBUTE9,
    X_ATTRIBUTE10 => X_ATTRIBUTE10,
    X_ATTRIBUTE11 => X_ATTRIBUTE11,
    X_ATTRIBUTE12 => X_ATTRIBUTE12,
    X_ATTRIBUTE13 => X_ATTRIBUTE13,
    X_ATTRIBUTE14 => X_ATTRIBUTE14,
    X_CURRENCY_CODE_TC => X_CURRENCY_CODE_TC,
    X_CURRENCY_CODE_FC => X_CURRENCY_CODE_FC,
    X_ATTRIBUTE15 => X_ATTRIBUTE15,
    X_EMAIL => X_EMAIL,
    X_PHONE => X_PHONE,
    X_ACTUAL_COST => X_ACTUAL_COST,
    X_COORDINATOR_ID => X_COORDINATOR_ID,
    X_FUND_SOURCE_TYPE_CODE => X_FUND_SOURCE_TYPE_CODE,
    X_FUND_SOURCE_ID => X_FUND_SOURCE_ID,
    X_OWNER_USER_ID => X_OWNER_USER_ID,
    X_URL => X_URL,
    X_PRIORITY_TYPE_CODE => X_PRIORITY_TYPE_CODE,
    X_CANCELLATION_REASON_CODE => X_CANCELLATION_REASON_CODE,
    X_INBOUND_SCRIPT_NAME => X_INBOUND_SCRIPT_NAME,
    X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1 => X_ATTRIBUTE1,
    X_ATTRIBUTE2 => X_ATTRIBUTE2,
    X_ATTRIBUTE3 => X_ATTRIBUTE3,
    X_FORECASTED_COST => X_FORECASTED_COST,
    X_EVENT_LEVEL => X_EVENT_LEVEL,
    X_APPLICATION_ID => X_APPLICATION_ID,
    X_EVENT_TYPE_CODE => X_EVENT_TYPE_CODE,
    X_ACTIVE_FLAG => X_ACTIVE_FLAG,
    X_PRIVATE_FLAG => X_PRIVATE_FLAG,
    X_SYSTEM_STATUS_CODE => X_SYSTEM_STATUS_CODE,
    X_LAST_STATUS_DATE => X_LAST_STATUS_DATE,
    X_STREAM_TYPE_CODE => X_STREAM_TYPE_CODE,
    X_SOURCE_CODE => X_SOURCE_CODE,
    X_ACTUAL_REVENUE => X_ACTUAL_REVENUE,
    X_EVENT_STANDALONE_FLAG => X_EVENT_STANDALONE_FLAG,
    X_DAY_OF_EVENT => X_DAY_OF_EVENT,
    X_AGENDA_START_TIME => X_AGENDA_START_TIME,
    X_AGENDA_END_TIME => X_AGENDA_END_TIME,
    X_REG_REQUIRED_FLAG => X_REG_REQUIRED_FLAG,
    X_REG_CHARGE_FLAG => X_REG_CHARGE_FLAG,
    X_REG_INVITED_ONLY_FLAG => X_REG_INVITED_ONLY_FLAG,
    X_PARTNER_FLAG => X_PARTNER_FLAG,
    X_OVERFLOW_FLAG => X_OVERFLOW_FLAG,
    X_PARENT_EVENT_HEADER_ID => X_PARENT_EVENT_HEADER_ID,
    X_DURATION => X_DURATION,
    X_DURATION_UOM_CODE => X_DURATION_UOM_CODE,
    X_ACTIVE_FROM_DATE => X_ACTIVE_FROM_DATE,
    X_ACTIVE_TO_DATE => X_ACTIVE_TO_DATE,
    X_REG_MAXIMUM_CAPACITY => X_REG_MAXIMUM_CAPACITY,
    X_REG_MINIMUM_CAPACITY => X_REG_MINIMUM_CAPACITY,
    X_MAIN_LANGUAGE_CODE => X_MAIN_LANGUAGE_CODE,
    X_CERT_CREDIT_TYPE_CODE => X_CERT_CREDIT_TYPE_CODE,
    X_CERTIFICATION_CREDITS => X_CERTIFICATION_CREDITS,
    X_INVENTORY_ITEM_ID => X_INVENTORY_ITEM_ID,
    X_FORECASTED_REVENUE => X_FORECASTED_REVENUE,
    X_EVENT_HEADER_NAME => X_EVENT_HEADER_NAME,
    X_EVENT_MKTG_MESSAGE => X_EVENT_MKTG_MESSAGE,
    X_DESCRIPTION => X_DESCRIPTION,
      X_CREATION_DATE		=>  SYSDATE,
      X_CREATED_BY		=>  l_user_id,
      X_LAST_UPDATE_DATE	=>  SYSDATE,
      X_LAST_UPDATED_BY		=>  l_user_id,
      X_LAST_UPDATE_LOGIN	=>  0);

Line: 1066

     AMS_EVENT_HEADERS_ALL_PKG.UPDATE_ROW(
    X_EVENT_HEADER_ID => l_evh_id,
    X_OBJECT_VERSION_NUMBER => l_version+1,
    X_FUND_AMOUNT_TC => X_FUND_AMOUNT_TC,
    X_FUND_AMOUNT_FC => X_FUND_AMOUNT_FC,
    X_ATTRIBUTE4 => X_ATTRIBUTE4,
    X_USER_STATUS_ID => X_USER_STATUS_ID,
    X_ATTRIBUTE5 => X_ATTRIBUTE5,
    X_ATTRIBUTE6 => X_ATTRIBUTE6,
    X_ORGANIZATION_ID => X_ORGANIZATION_ID,
    X_ATTRIBUTE7 => X_ATTRIBUTE7,
    X_ATTRIBUTE8 => X_ATTRIBUTE8,
    X_ATTRIBUTE9 => X_ATTRIBUTE9,
    X_ATTRIBUTE10 => X_ATTRIBUTE10,
    X_ATTRIBUTE11 => X_ATTRIBUTE11,
    X_ATTRIBUTE12 => X_ATTRIBUTE12,
    X_ATTRIBUTE13 => X_ATTRIBUTE13,
    X_ATTRIBUTE14 => X_ATTRIBUTE14,
    X_CURRENCY_CODE_TC => X_CURRENCY_CODE_TC,
    X_CURRENCY_CODE_FC => X_CURRENCY_CODE_FC,
    X_ATTRIBUTE15 => X_ATTRIBUTE15,
    X_EMAIL => X_EMAIL,
    X_PHONE => X_PHONE,
    X_ACTUAL_COST => X_ACTUAL_COST,
    X_COORDINATOR_ID => X_COORDINATOR_ID,
    X_FUND_SOURCE_TYPE_CODE => X_FUND_SOURCE_TYPE_CODE,
    X_FUND_SOURCE_ID => X_FUND_SOURCE_ID,
    X_OWNER_USER_ID => X_OWNER_USER_ID,
    X_URL => X_URL,
    X_PRIORITY_TYPE_CODE => X_PRIORITY_TYPE_CODE,
    X_CANCELLATION_REASON_CODE => X_CANCELLATION_REASON_CODE,
    X_INBOUND_SCRIPT_NAME => X_INBOUND_SCRIPT_NAME,
    X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1 => X_ATTRIBUTE1,
    X_ATTRIBUTE2 => X_ATTRIBUTE2,
    X_ATTRIBUTE3 => X_ATTRIBUTE3,
    X_FORECASTED_COST => X_FORECASTED_COST,
    X_EVENT_LEVEL => X_EVENT_LEVEL,
    X_APPLICATION_ID => X_APPLICATION_ID,
    X_EVENT_TYPE_CODE => X_EVENT_TYPE_CODE,
    X_ACTIVE_FLAG => X_ACTIVE_FLAG,
    X_PRIVATE_FLAG => X_PRIVATE_FLAG,
    X_SYSTEM_STATUS_CODE => X_SYSTEM_STATUS_CODE,
    X_LAST_STATUS_DATE => X_LAST_STATUS_DATE,
    X_STREAM_TYPE_CODE => X_STREAM_TYPE_CODE,
    X_SOURCE_CODE => X_SOURCE_CODE,
    X_ACTUAL_REVENUE => X_ACTUAL_REVENUE,
    X_EVENT_STANDALONE_FLAG => X_EVENT_STANDALONE_FLAG,
    X_DAY_OF_EVENT => X_DAY_OF_EVENT,
    X_AGENDA_START_TIME => X_AGENDA_START_TIME,
    X_AGENDA_END_TIME => X_AGENDA_END_TIME,
    X_REG_REQUIRED_FLAG => X_REG_REQUIRED_FLAG,
    X_REG_CHARGE_FLAG => X_REG_CHARGE_FLAG,
    X_REG_INVITED_ONLY_FLAG => X_REG_INVITED_ONLY_FLAG,
    X_PARTNER_FLAG => X_PARTNER_FLAG,
    X_OVERFLOW_FLAG => X_OVERFLOW_FLAG,
    X_PARENT_EVENT_HEADER_ID => X_PARENT_EVENT_HEADER_ID,
    X_DURATION => X_DURATION,
    X_DURATION_UOM_CODE => X_DURATION_UOM_CODE,
    X_ACTIVE_FROM_DATE => X_ACTIVE_FROM_DATE,
    X_ACTIVE_TO_DATE => X_ACTIVE_TO_DATE,
    X_REG_MAXIMUM_CAPACITY => X_REG_MAXIMUM_CAPACITY,
    X_REG_MINIMUM_CAPACITY => X_REG_MINIMUM_CAPACITY,
    X_MAIN_LANGUAGE_CODE => X_MAIN_LANGUAGE_CODE,
    X_CERT_CREDIT_TYPE_CODE => X_CERT_CREDIT_TYPE_CODE,
    X_CERTIFICATION_CREDITS => X_CERTIFICATION_CREDITS,
    X_INVENTORY_ITEM_ID => X_INVENTORY_ITEM_ID,
    X_FORECASTED_REVENUE => X_FORECASTED_REVENUE,
    X_EVENT_HEADER_NAME => X_EVENT_HEADER_NAME,
    X_EVENT_MKTG_MESSAGE => X_EVENT_MKTG_MESSAGE,
    X_DESCRIPTION => X_DESCRIPTION,
      X_LAST_UPDATE_DATE => SYSDATE,
      X_LAST_UPDATED_BY => l_user_id,
      X_LAST_UPDATE_LOGIN => 0);