eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMV_C_CHANNELS_PKG SQL Statements

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

Line: 78


	AMV_C_CHANNELS_PKG.UPDATE_ROW (
  		X_CHANNEL_ID => l_channel_id,
 		X_OBJECT_VERSION_NUMBER => l_object_version_number,
  		X_CHANNEL_TYPE => x_channel_type,
  		X_CHANNEL_CATEGORY_ID => l_channel_category_id,
  		X_STATUS => x_status,
  		X_OWNER_USER_ID => l_owner_user_id,
  		X_DEFAULT_APPROVER_USER_ID => l_default_approver_user_id,
  		X_EFFECTIVE_START_DATE => l_effective_start_date,
  		X_EXPIRATION_DATE => l_expiration_date,
  		X_ACCESS_LEVEL_TYPE => x_access_level_type,
  		X_PUB_NEED_APPROVAL_FLAG => x_pub_need_approval_flag,
  		X_SUB_NEED_APPROVAL_FLAG => x_sub_need_approval_flag,
  		X_MATCH_ON_ALL_CRITERIA_FLAG => x_match_on_all_criteria_flag,
  		X_MATCH_ON_KEYWORD_FLAG => x_match_on_keyword_flag,
  		X_MATCH_ON_AUTHOR_FLAG => x_match_on_author_flag,
  		X_MATCH_ON_PERSPECTIVE_FLAG => x_match_on_perspective_flag,
  		X_MATCH_ON_ITEM_TYPE_FLAG => x_match_on_item_type_flag,
  		X_MATCH_ON_CONTENT_TYPE_FLAG => x_match_on_content_type_flag,
  		X_MATCH_ON_TIME_FLAG => x_match_on_time_flag,
  		X_APPLICATION_ID => l_application_id,
  		X_EXTERNAL_ACCESS_FLAG => x_external_access_flag,
  		X_ITEM_MATCH_COUNT => l_item_match_count,
  		X_LAST_MATCH_TIME => l_last_match_time,
  		X_NOTIFICATION_INTERVAL_TYPE => x_notification_interval_type,
  		X_LAST_NOTIFICATION_TIME => l_last_notification_time,
  		X_ATTRIBUTE_CATEGORY => x_attribute_category,
  		X_ATTRIBUTE1 => x_attribute1,
  		X_ATTRIBUTE2 => x_attribute2,
 		X_ATTRIBUTE3 => x_attribute3,
 		X_ATTRIBUTE4 => x_attribute4,
  		X_ATTRIBUTE5 => x_attribute5,
  		X_ATTRIBUTE6 => x_attribute6,
  		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_ATTRIBUTE15 => x_attribute15,
  		X_CHANNEL_NAME => x_channel_name,
		X_DESCRIPTION       => x_description,
		X_LAST_UPDATE_DATE  => sysdate,
		X_LAST_UPDATED_BY   => l_user_id,
		X_LAST_UPDATE_LOGIN => 0
		);

Line: 128


 	AMV_C_CHANNELS_PKG.INSERT_ROW (
  		X_ROWID => l_row_id,
  		X_CHANNEL_ID => l_channel_id,
 		X_OBJECT_VERSION_NUMBER => l_object_version_number,
  		X_CHANNEL_TYPE => x_channel_type,
  		X_CHANNEL_CATEGORY_ID => l_channel_category_id,
  		X_STATUS => x_status,
  		X_OWNER_USER_ID => l_owner_user_id,
  		X_DEFAULT_APPROVER_USER_ID => l_default_approver_user_id,
  		X_EFFECTIVE_START_DATE => l_effective_start_date,
  		X_EXPIRATION_DATE => l_expiration_date,
  		X_ACCESS_LEVEL_TYPE => x_access_level_type,
  		X_PUB_NEED_APPROVAL_FLAG => x_pub_need_approval_flag,
  		X_SUB_NEED_APPROVAL_FLAG => x_sub_need_approval_flag,
  		X_MATCH_ON_ALL_CRITERIA_FLAG => x_match_on_all_criteria_flag,
  		X_MATCH_ON_KEYWORD_FLAG => x_match_on_keyword_flag,
  		X_MATCH_ON_AUTHOR_FLAG => x_match_on_author_flag,
  		X_MATCH_ON_PERSPECTIVE_FLAG => x_match_on_perspective_flag,
  		X_MATCH_ON_ITEM_TYPE_FLAG => x_match_on_item_type_flag,
  		X_MATCH_ON_CONTENT_TYPE_FLAG => x_match_on_content_type_flag,
  		X_MATCH_ON_TIME_FLAG => x_match_on_time_flag,
  		X_APPLICATION_ID => l_application_id,
  		X_EXTERNAL_ACCESS_FLAG => x_external_access_flag,
  		X_ITEM_MATCH_COUNT => l_item_match_count,
  		X_LAST_MATCH_TIME => l_last_match_time,
  		X_NOTIFICATION_INTERVAL_TYPE => x_notification_interval_type,
  		X_LAST_NOTIFICATION_TIME => x_last_notification_time,
  		X_ATTRIBUTE_CATEGORY => x_attribute_category,
  		X_ATTRIBUTE1 => x_attribute1,
  		X_ATTRIBUTE2 => x_attribute2,
 		X_ATTRIBUTE3 => x_attribute3,
 		X_ATTRIBUTE4 => x_attribute4,
  		X_ATTRIBUTE5 => x_attribute5,
  		X_ATTRIBUTE6 => x_attribute6,
  		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_ATTRIBUTE15 => x_attribute15,
  		X_CHANNEL_NAME => x_channel_name,
		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: 188


	update AMV_C_CHANNELS_TL set
		CHANNEL_NAME = x_channel_name,
		DESCRIPTION       = x_description,
		LAST_UPDATE_DATE  = sysdate,
		LAST_UPDATED_BY   = decode(x_owner, 'SEED', 1, 0),
		LAST_UPDATE_LOGIN = 0,
		SOURCE_LANG = userenv('LANG')
	where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
	and CHANNEL_ID = x_channel_id;

Line: 199


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_CHANNEL_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_CHANNEL_TYPE in VARCHAR2,
  X_CHANNEL_CATEGORY_ID in NUMBER,
  X_STATUS in VARCHAR2,
  X_OWNER_USER_ID in NUMBER,
  X_DEFAULT_APPROVER_USER_ID in NUMBER,
  X_EFFECTIVE_START_DATE in DATE,
  X_EXPIRATION_DATE in DATE,
  X_ACCESS_LEVEL_TYPE in VARCHAR2,
  X_PUB_NEED_APPROVAL_FLAG in VARCHAR2,
  X_SUB_NEED_APPROVAL_FLAG in VARCHAR2,
  X_MATCH_ON_ALL_CRITERIA_FLAG in VARCHAR2,
  X_MATCH_ON_KEYWORD_FLAG in VARCHAR2,
  X_MATCH_ON_AUTHOR_FLAG in VARCHAR2,
  X_MATCH_ON_PERSPECTIVE_FLAG in VARCHAR2,
  X_MATCH_ON_ITEM_TYPE_FLAG in VARCHAR2,
  X_MATCH_ON_CONTENT_TYPE_FLAG in VARCHAR2,
  X_MATCH_ON_TIME_FLAG in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_EXTERNAL_ACCESS_FLAG in VARCHAR2,
  X_ITEM_MATCH_COUNT in NUMBER,
  X_LAST_MATCH_TIME in DATE,
  X_NOTIFICATION_INTERVAL_TYPE in VARCHAR2,
  X_LAST_NOTIFICATION_TIME in DATE,
  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_CHANNEL_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
) is
  cursor C is select ROWID from AMV_C_CHANNELS_B
    where CHANNEL_ID = X_CHANNEL_ID
    ;

Line: 254


  insert into AMV_C_CHANNELS_B (
    CHANNEL_ID,
    OBJECT_VERSION_NUMBER,
    CHANNEL_TYPE,
    CHANNEL_CATEGORY_ID,
    STATUS,
    OWNER_USER_ID,
    DEFAULT_APPROVER_USER_ID,
    EFFECTIVE_START_DATE,
    EXPIRATION_DATE,
    ACCESS_LEVEL_TYPE,
    PUB_NEED_APPROVAL_FLAG,
    SUB_NEED_APPROVAL_FLAG,
    MATCH_ON_ALL_CRITERIA_FLAG,
    MATCH_ON_KEYWORD_FLAG,
    MATCH_ON_AUTHOR_FLAG,
    MATCH_ON_PERSPECTIVE_FLAG,
    MATCH_ON_ITEM_TYPE_FLAG,
    MATCH_ON_CONTENT_TYPE_FLAG,
    MATCH_ON_TIME_FLAG,
    APPLICATION_ID,
    EXTERNAL_ACCESS_FLAG,
    ITEM_MATCH_COUNT,
    LAST_MATCH_TIME,
    NOTIFICATION_INTERVAL_TYPE,
    LAST_NOTIFICATION_TIME,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_CHANNEL_ID,
    X_OBJECT_VERSION_NUMBER,
    X_CHANNEL_TYPE,
    X_CHANNEL_CATEGORY_ID,
    X_STATUS,
    X_OWNER_USER_ID,
    X_DEFAULT_APPROVER_USER_ID,
    X_EFFECTIVE_START_DATE,
    X_EXPIRATION_DATE,
    X_ACCESS_LEVEL_TYPE,
    X_PUB_NEED_APPROVAL_FLAG,
    X_SUB_NEED_APPROVAL_FLAG,
    X_MATCH_ON_ALL_CRITERIA_FLAG,
    X_MATCH_ON_KEYWORD_FLAG,
    X_MATCH_ON_AUTHOR_FLAG,
    X_MATCH_ON_PERSPECTIVE_FLAG,
    X_MATCH_ON_ITEM_TYPE_FLAG,
    X_MATCH_ON_CONTENT_TYPE_FLAG,
    X_MATCH_ON_TIME_FLAG,
    X_APPLICATION_ID,
    X_EXTERNAL_ACCESS_FLAG,
    X_ITEM_MATCH_COUNT,
    X_LAST_MATCH_TIME,
    X_NOTIFICATION_INTERVAL_TYPE,
    X_LAST_NOTIFICATION_TIME,
    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_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 350


  insert into AMV_C_CHANNELS_TL (
    CHANNEL_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    CHANNEL_NAME,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_CHANNEL_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_CHANNEL_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 AMV_C_CHANNELS_TL T
    where T.CHANNEL_ID = X_CHANNEL_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 388


end INSERT_ROW;

Line: 435


  cursor c is select
      OBJECT_VERSION_NUMBER,
      CHANNEL_TYPE,
      CHANNEL_CATEGORY_ID,
      STATUS,
      OWNER_USER_ID,
      DEFAULT_APPROVER_USER_ID,
      EFFECTIVE_START_DATE,
      EXPIRATION_DATE,
      ACCESS_LEVEL_TYPE,
      PUB_NEED_APPROVAL_FLAG,
      SUB_NEED_APPROVAL_FLAG,
      MATCH_ON_ALL_CRITERIA_FLAG,
      MATCH_ON_KEYWORD_FLAG,
      MATCH_ON_AUTHOR_FLAG,
      MATCH_ON_PERSPECTIVE_FLAG,
      MATCH_ON_ITEM_TYPE_FLAG,
      MATCH_ON_CONTENT_TYPE_FLAG,
      MATCH_ON_TIME_FLAG,
      APPLICATION_ID,
      EXTERNAL_ACCESS_FLAG,
      ITEM_MATCH_COUNT,
      LAST_MATCH_TIME,
      NOTIFICATION_INTERVAL_TYPE,
      LAST_NOTIFICATION_TIME,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15
    from AMV_C_CHANNELS_B
    where CHANNEL_ID = X_CHANNEL_ID
    for update of CHANNEL_ID nowait;

Line: 481


  cursor c1 is select
      CHANNEL_NAME,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from AMV_C_CHANNELS_TL
    where CHANNEL_ID = X_CHANNEL_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of CHANNEL_ID nowait;

Line: 494


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

Line: 584


procedure UPDATE_ROW (
  X_CHANNEL_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_CHANNEL_TYPE in VARCHAR2,
  X_CHANNEL_CATEGORY_ID in NUMBER,
  X_STATUS in VARCHAR2,
  X_OWNER_USER_ID in NUMBER,
  X_DEFAULT_APPROVER_USER_ID in NUMBER,
  X_EFFECTIVE_START_DATE in DATE,
  X_EXPIRATION_DATE in DATE,
  X_ACCESS_LEVEL_TYPE in VARCHAR2,
  X_PUB_NEED_APPROVAL_FLAG in VARCHAR2,
  X_SUB_NEED_APPROVAL_FLAG in VARCHAR2,
  X_MATCH_ON_ALL_CRITERIA_FLAG in VARCHAR2,
  X_MATCH_ON_KEYWORD_FLAG in VARCHAR2,
  X_MATCH_ON_AUTHOR_FLAG in VARCHAR2,
  X_MATCH_ON_PERSPECTIVE_FLAG in VARCHAR2,
  X_MATCH_ON_ITEM_TYPE_FLAG in VARCHAR2,
  X_MATCH_ON_CONTENT_TYPE_FLAG in VARCHAR2,
  X_MATCH_ON_TIME_FLAG in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_EXTERNAL_ACCESS_FLAG in VARCHAR2,
  X_ITEM_MATCH_COUNT in NUMBER,
  X_LAST_MATCH_TIME in DATE,
  X_NOTIFICATION_INTERVAL_TYPE in VARCHAR2,
  X_LAST_NOTIFICATION_TIME in DATE,
  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_CHANNEL_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
) is
begin
  update AMV_C_CHANNELS_B set
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    CHANNEL_TYPE = X_CHANNEL_TYPE,
    CHANNEL_CATEGORY_ID = X_CHANNEL_CATEGORY_ID,
    STATUS = X_STATUS,
    OWNER_USER_ID = X_OWNER_USER_ID,
    DEFAULT_APPROVER_USER_ID = X_DEFAULT_APPROVER_USER_ID,
    EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE,
    EXPIRATION_DATE = X_EXPIRATION_DATE,
    ACCESS_LEVEL_TYPE = X_ACCESS_LEVEL_TYPE,
    PUB_NEED_APPROVAL_FLAG = X_PUB_NEED_APPROVAL_FLAG,
    SUB_NEED_APPROVAL_FLAG = X_SUB_NEED_APPROVAL_FLAG,
    MATCH_ON_ALL_CRITERIA_FLAG = X_MATCH_ON_ALL_CRITERIA_FLAG,
    MATCH_ON_KEYWORD_FLAG = X_MATCH_ON_KEYWORD_FLAG,
    MATCH_ON_AUTHOR_FLAG = X_MATCH_ON_AUTHOR_FLAG,
    MATCH_ON_PERSPECTIVE_FLAG = X_MATCH_ON_PERSPECTIVE_FLAG,
    MATCH_ON_ITEM_TYPE_FLAG = X_MATCH_ON_ITEM_TYPE_FLAG,
    MATCH_ON_CONTENT_TYPE_FLAG = X_MATCH_ON_CONTENT_TYPE_FLAG,
    MATCH_ON_TIME_FLAG = X_MATCH_ON_TIME_FLAG,
    APPLICATION_ID = X_APPLICATION_ID,
    EXTERNAL_ACCESS_FLAG = X_EXTERNAL_ACCESS_FLAG,
    ITEM_MATCH_COUNT = X_ITEM_MATCH_COUNT,
    LAST_MATCH_TIME = X_LAST_MATCH_TIME,
    NOTIFICATION_INTERVAL_TYPE = X_NOTIFICATION_INTERVAL_TYPE,
    LAST_NOTIFICATION_TIME = X_LAST_NOTIFICATION_TIME,
    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,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where CHANNEL_ID = X_CHANNEL_ID;

Line: 683


  update AMV_C_CHANNELS_TL set
    CHANNEL_NAME = X_CHANNEL_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 CHANNEL_ID = X_CHANNEL_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 696


end UPDATE_ROW;

Line: 698


procedure DELETE_ROW (
  X_CHANNEL_ID in NUMBER
) is
begin
  delete from AMV_C_CHANNELS_TL
  where CHANNEL_ID = X_CHANNEL_ID;

Line: 709


  delete from AMV_C_CHANNELS_B
  where CHANNEL_ID = X_CHANNEL_ID;

Line: 715


end DELETE_ROW;

Line: 720


  delete from AMV_C_CHANNELS_TL T
  where not exists
    (select NULL
    from AMV_C_CHANNELS_B B
    where B.CHANNEL_ID = T.CHANNEL_ID
    );

Line: 727


  update AMV_C_CHANNELS_TL T set (
      CHANNEL_NAME,
      DESCRIPTION
    ) = (select
      B.CHANNEL_NAME,
      B.DESCRIPTION
    from AMV_C_CHANNELS_TL B
    where B.CHANNEL_ID = T.CHANNEL_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.CHANNEL_ID,
      T.LANGUAGE
  ) in (select
      SUBT.CHANNEL_ID,
      SUBT.LANGUAGE
    from AMV_C_CHANNELS_TL SUBB, AMV_C_CHANNELS_TL SUBT
    where SUBB.CHANNEL_ID = SUBT.CHANNEL_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.CHANNEL_NAME <> SUBT.CHANNEL_NAME
      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: 751


  insert into AMV_C_CHANNELS_TL (
    CHANNEL_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    CHANNEL_NAME,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.CHANNEL_ID,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.CHANNEL_NAME,
    B.DESCRIPTION,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from AMV_C_CHANNELS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from AMV_C_CHANNELS_TL T
    where T.CHANNEL_ID = B.CHANNEL_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);