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.OE_PC_CONDITIONS_PKG SQL Statements

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

Line: 4


procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_CONDITION_ID in NUMBER,
  X_CONSTRAINT_ID in NUMBER,
  X_GROUP_NUMBER in NUMBER,
  X_SYSTEM_FLAG in VARCHAR2,
  X_MODIFIER_FLAG in VARCHAR2,
  X_VALIDATION_ENTITY_ID in NUMBER,
  X_VALIDATION_TMPLT_ID in NUMBER,
  X_RECORD_SET_ID in NUMBER,
  X_SCOPE_OP 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_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_ENABLED_FLAG in VARCHAR2 DEFAULT NULL,
  X_USER_MESSAGE 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 OE_PC_CONDITIONS
    where CONDITION_ID = X_CONDITION_ID
    ;

Line: 46


  insert into OE_PC_CONDITIONS (
    CONDITION_ID,
    CONSTRAINT_ID,
    GROUP_NUMBER,
    SYSTEM_FLAG,
    MODIFIER_FLAG,
    VALIDATION_ENTITY_ID,
    VALIDATION_TMPLT_ID,
    RECORD_SET_ID,
    SCOPE_OP,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    START_DATE_ACTIVE,
    END_DATE_ACTIVE,
    ENABLED_FLAG,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_CONDITION_ID,
    X_CONSTRAINT_ID,
    X_GROUP_NUMBER,
    X_SYSTEM_FLAG,
    X_MODIFIER_FLAG,
    X_VALIDATION_ENTITY_ID,
    X_VALIDATION_TMPLT_ID,
    X_RECORD_SET_ID,
    X_SCOPE_OP,
    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_START_DATE_ACTIVE,
    X_END_DATE_ACTIVE,
    X_ENABLED_FLAG,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 116


  insert into OE_PC_CONDITIONS_TL (
    CONDITION_ID,
    USER_MESSAGE,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_CONDITION_ID,
    X_USER_MESSAGE,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from OE_PC_CONDITIONS_TL T
    where T.CONDITION_ID = X_CONDITION_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 148


    fnd_message.set_name('ONT', 'INSERT_NO_DATA_FOUND');

Line: 154


end INSERT_ROW;

Line: 187


  cursor c is select
      CONSTRAINT_ID,
      GROUP_NUMBER,
      SYSTEM_FLAG,
      MODIFIER_FLAG,
      VALIDATION_ENTITY_ID,
      VALIDATION_TMPLT_ID,
      RECORD_SET_ID,
      SCOPE_OP,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      START_DATE_ACTIVE,
      END_DATE_ACTIVE,
      ENABLED_FLAG
    from OE_PC_CONDITIONS
    where CONDITION_ID = X_CONDITION_ID
    for update of CONDITION_ID nowait;

Line: 220


  cursor c1 is select
      USER_MESSAGE,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from OE_PC_CONDITIONS_TL
    where CONDITION_ID = X_CONDITION_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of CONDITION_ID nowait;

Line: 232


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

Line: 300


procedure UPDATE_ROW (
  X_CONDITION_ID in NUMBER,
  X_CONSTRAINT_ID in NUMBER,
  X_GROUP_NUMBER in NUMBER,
  X_SYSTEM_FLAG in VARCHAR2,
  X_MODIFIER_FLAG in VARCHAR2,
  X_VALIDATION_ENTITY_ID in NUMBER,
  X_VALIDATION_TMPLT_ID in NUMBER,
  X_RECORD_SET_ID in NUMBER,
  X_SCOPE_OP 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_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_ENABLED_FLAG in VARCHAR2 DEFAULT NULL,
  X_USER_MESSAGE in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin

  update OE_PC_CONDITIONS set
    CONSTRAINT_ID = X_CONSTRAINT_ID,
    GROUP_NUMBER = X_GROUP_NUMBER,
    SYSTEM_FLAG = X_SYSTEM_FLAG,
    MODIFIER_FLAG = X_MODIFIER_FLAG,
    VALIDATION_ENTITY_ID = X_VALIDATION_ENTITY_ID,
    VALIDATION_TMPLT_ID = X_VALIDATION_TMPLT_ID,
    RECORD_SET_ID = X_RECORD_SET_ID,
    SCOPE_OP = X_SCOPE_OP,
    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,
    START_DATE_ACTIVE = X_START_DATE_ACTIVE,
    END_DATE_ACTIVE = X_END_DATE_ACTIVE,
    ENABLED_FLAG = NVL(X_ENABLED_FLAG, ENABLED_FLAG),
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where CONDITION_ID = X_CONDITION_ID;

Line: 373


  update OE_PC_CONDITIONS_TL set
    USER_MESSAGE = X_USER_MESSAGE,
    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 CONDITION_ID = X_CONDITION_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 386


end UPDATE_ROW;

Line: 389


procedure DELETE_ROW (
  X_CONDITION_ID in NUMBER
) is
begin

  delete from OE_PC_CONDITIONS_TL
  where CONDITION_ID = X_CONDITION_ID;

Line: 401


  delete from OE_PC_CONDITIONS
  where CONDITION_ID = X_CONDITION_ID;

Line: 408


end DELETE_ROW;

Line: 413


  delete from OE_PC_CONDITIONS_TL T
  where not exists
    (select NULL
    from OE_PC_CONDITIONS B
    where B.CONDITION_ID = T.CONDITION_ID
    );

Line: 420


  update OE_PC_CONDITIONS_TL T set (
      USER_MESSAGE
    ) = (select
      B.USER_MESSAGE
    from OE_PC_CONDITIONS_TL B
    where B.CONDITION_ID = T.CONDITION_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.CONDITION_ID,
      T.LANGUAGE
  ) in (select
      SUBT.CONDITION_ID,
      SUBT.LANGUAGE
    from OE_PC_CONDITIONS_TL SUBB, OE_PC_CONDITIONS_TL SUBT
    where SUBB.CONDITION_ID = SUBT.CONDITION_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.USER_MESSAGE <> SUBT.USER_MESSAGE
  ));

Line: 439


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

Line: 478


  update OE_PC_CONDITIONS_TL set
    USER_MESSAGE = X_USER_MESSAGE,
    LAST_UPDATE_DATE = sysdate,
    --LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),
    LAST_UPDATED_BY =l_user_id ,
    LAST_UPDATE_LOGIN = 0,
    SOURCE_LANG = userenv('LANG')
  where CONDITION_ID = X_CONDITION_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 523


CURSOR CID IS SELECT oe_pc_conditions_s.nextval from dual;

Line: 539


      select last_updated_by
        into l_db_user_id
	from OE_PC_CONDITIONS
	where CONDITION_ID = X_CONDITION_ID;

Line: 553


    OE_PC_CONDITIONS_pkg.UPDATE_ROW(
      x_condition_id 		 => x_condition_id
	 ,x_group_number		 => x_group_number
      ,x_constraint_id		 => x_constraint_id
      ,x_system_flag	      => x_system_flag
	 ,x_modifier_flag		 => x_modifier_flag
      ,x_validation_entity_id		 => x_validation_entity_id
	 ,x_validation_tmplt_id		 => x_validation_tmplt_id
      ,x_record_set_id		 => x_record_set_id
      ,x_scope_op	      	 => x_scope_op
	 ,x_start_date_active	 => to_date(x_start_date_active,'YYYY/MM/DD')
	 ,x_end_date_active		 => to_date(x_end_date_active,'YYYY/MM/DD')
         ,x_enabled_flag                 => NULL
	 ,x_user_message		 => x_user_message
      ,x_last_updated_by 	 => user_id
      ,x_last_update_date      => sysdate
      ,x_last_update_login     => 0
      ,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
	 );

Line: 591


	 OE_PC_CONDITIONS_pkg.INSERT_ROW(
	 x_rowid				 => row_id
      ,x_condition_id 		 => x_condition_id
	 ,x_group_number		 => x_group_number
      ,x_constraint_id		 => x_constraint_id
      ,x_system_flag	      => x_system_flag
	 ,x_modifier_flag		 => x_modifier_flag
      ,x_validation_entity_id		 => x_validation_entity_id
	 ,x_validation_tmplt_id		 => x_validation_tmplt_id
      ,x_record_set_id		 => x_record_set_id
      ,x_scope_op	      	 => x_scope_op
	 ,x_start_date_active	 => to_date(x_start_date_active,'YYYY/MM/DD')
	 ,x_end_date_active		 => to_date(x_end_date_active,'YYYY/MM/DD')
	 ,x_user_message		 => x_user_message
      ,x_created_by            => user_id
      ,x_creation_date         => sysdate
      ,x_last_updated_by 	 => user_id
      ,x_last_update_date      => sysdate
      ,x_last_update_login     => 0
      ,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_enabled_flag              => x_enabled_flag
	 );