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.AMS_OBJECT_RULES_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_OBJECT_RULE_ID in NUMBER,
  X_PARAM15 in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_SECURITY_GROUP_ID in NUMBER,
  X_APPROVAL_TYPE in VARCHAR2,
  X_RULE_USED_BY in VARCHAR2,
  X_RULE_USED_BY_TYPE in VARCHAR2,
  X_RULE_TYPE in VARCHAR2,
  X_API_TYPE in VARCHAR2,
  X_PACKAGE_NAME in VARCHAR2,
  X_PROCEDURE_NAME in VARCHAR2,
  X_CLASS_NAME in VARCHAR2,
  X_METHOD_NAME in VARCHAR2,
  X_QUERY in VARCHAR2,
  X_RELATED_OBJECT in VARCHAR2,
  X_SEEDED_FLAG in VARCHAR2,
  X_PARAM1 in VARCHAR2,
  X_PARAM2 in VARCHAR2,
  X_PARAM3 in VARCHAR2,
  X_PARAM4 in VARCHAR2,
  X_PARAM5 in VARCHAR2,
  X_PARAM6 in VARCHAR2,
  X_PARAM7 in VARCHAR2,
  X_PARAM8 in VARCHAR2,
  X_PARAM9 in VARCHAR2,
  X_PARAM10 in VARCHAR2,
  X_PARAM11 in VARCHAR2,
  X_PARAM12 in VARCHAR2,
  X_PARAM13 in VARCHAR2,
  X_PARAM14 in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_OBJECT_RULE_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 AMS_OBJECT_RULES_B
    where OBJECT_RULE_ID = X_OBJECT_RULE_ID
    ;

Line: 49


  insert into AMS_OBJECT_RULES_B (
      OBJECT_RULE_ID,
    PARAM15,
    OBJECT_VERSION_NUMBER,
    --SECURITY_GROUP_ID,
    APPROVAL_TYPE,
    RULE_USED_BY,
    RULE_USED_BY_TYPE,
    RULE_TYPE,
    API_TYPE,
    PACKAGE_NAME,
    PROCEDURE_NAME,
    CLASS_NAME,
    METHOD_NAME,
    QUERY,
    RELATED_OBJECT,
    SEEDED_FLAG,
    PARAM1,
    PARAM2,
    PARAM3,
    PARAM4,
    PARAM5,
    PARAM6,
    PARAM7,
    PARAM8,
    PARAM9,
    PARAM10,
    PARAM11,
    PARAM12,
    PARAM13,
    PARAM14,
    APPLICATION_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_OBJECT_RULE_ID,
    X_PARAM15,
    X_OBJECT_VERSION_NUMBER,
    --X_SECURITY_GROUP_ID,
    X_APPROVAL_TYPE,
    X_RULE_USED_BY,
    X_RULE_USED_BY_TYPE,
    X_RULE_TYPE,
    X_API_TYPE,
    X_PACKAGE_NAME,
    X_PROCEDURE_NAME,
    X_CLASS_NAME,
    X_METHOD_NAME,
    X_QUERY,
    X_RELATED_OBJECT,
    X_SEEDED_FLAG,
    X_PARAM1,
    X_PARAM2,
    X_PARAM3,
    X_PARAM4,
    X_PARAM5,
    X_PARAM6,
    X_PARAM7,
    X_PARAM8,
    X_PARAM9,
    X_PARAM10,
    X_PARAM11,
    X_PARAM12,
    X_PARAM13,
    X_PARAM14,
    X_APPLICATION_ID,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 125


  insert into AMS_OBJECT_RULES_TL (
    OBJECT_RULE_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    --SECURITY_GROUP_ID,
    OBJECT_RULE_NAME,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_OBJECT_RULE_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    --X_SECURITY_GROUP_ID,
    X_OBJECT_RULE_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 AMS_OBJECT_RULES_TL T
    where T.OBJECT_RULE_ID = X_OBJECT_RULE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 165


end INSERT_ROW;

Line: 200


  cursor c is select
      PARAM15,
      OBJECT_VERSION_NUMBER,
      SECURITY_GROUP_ID,
      APPROVAL_TYPE,
      RULE_USED_BY,
      RULE_USED_BY_TYPE,
      RULE_TYPE,
      API_TYPE,
      PACKAGE_NAME,
      PROCEDURE_NAME,
      CLASS_NAME,
      METHOD_NAME,
      QUERY,
      RELATED_OBJECT,
      SEEDED_FLAG,
      PARAM1,
      PARAM2,
      PARAM3,
      PARAM4,
      PARAM5,
      PARAM6,
      PARAM7,
      PARAM8,
      PARAM9,
      PARAM10,
      PARAM11,
      PARAM12,
      PARAM13,
      PARAM14,
      APPLICATION_ID
    from AMS_OBJECT_RULES_B
    where OBJECT_RULE_ID = X_OBJECT_RULE_ID
    for update of OBJECT_RULE_ID nowait;

Line: 236


  cursor c1 is select
      OBJECT_RULE_ID,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from AMS_OBJECT_RULES_TL
    where OBJECT_RULE_ID = X_OBJECT_RULE_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of OBJECT_RULE_ID nowait;

Line: 248


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

Line: 333


procedure UPDATE_ROW (
  X_OBJECT_RULE_ID in NUMBER,
  X_PARAM15 in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_SECURITY_GROUP_ID in NUMBER,
  X_APPROVAL_TYPE in VARCHAR2,
  X_RULE_USED_BY in VARCHAR2,
  X_RULE_USED_BY_TYPE in VARCHAR2,
  X_RULE_TYPE in VARCHAR2,
  X_API_TYPE in VARCHAR2,
  X_PACKAGE_NAME in VARCHAR2,
  X_PROCEDURE_NAME in VARCHAR2,
  X_CLASS_NAME in VARCHAR2,
  X_METHOD_NAME in VARCHAR2,
  X_QUERY in VARCHAR2,
  X_RELATED_OBJECT in VARCHAR2,
  X_SEEDED_FLAG in VARCHAR2,
  X_PARAM1 in VARCHAR2,
  X_PARAM2 in VARCHAR2,
  X_PARAM3 in VARCHAR2,
  X_PARAM4 in VARCHAR2,
  X_PARAM5 in VARCHAR2,
  X_PARAM6 in VARCHAR2,
  X_PARAM7 in VARCHAR2,
  X_PARAM8 in VARCHAR2,
  X_PARAM9 in VARCHAR2,
  X_PARAM10 in VARCHAR2,
  X_PARAM11 in VARCHAR2,
  X_PARAM12 in VARCHAR2,
  X_PARAM13 in VARCHAR2,
  X_PARAM14 in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_OBJECT_RULE_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 AMS_OBJECT_RULES_B set
    PARAM15 = X_PARAM15,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    --SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
    APPROVAL_TYPE = X_APPROVAL_TYPE,
    RULE_USED_BY = X_RULE_USED_BY,
    RULE_USED_BY_TYPE = X_RULE_USED_BY_TYPE,
    RULE_TYPE = X_RULE_TYPE,
    API_TYPE = X_API_TYPE,
    PACKAGE_NAME = X_PACKAGE_NAME,
    PROCEDURE_NAME = X_PROCEDURE_NAME,
    CLASS_NAME = X_CLASS_NAME,
    METHOD_NAME = X_METHOD_NAME,
    QUERY = X_QUERY,
    RELATED_OBJECT = X_RELATED_OBJECT,
    SEEDED_FLAG = X_SEEDED_FLAG,
    PARAM1 = X_PARAM1,
    PARAM2 = X_PARAM2,
    PARAM3 = X_PARAM3,
    PARAM4 = X_PARAM4,
    PARAM5 = X_PARAM5,
    PARAM6 = X_PARAM6,
    PARAM7 = X_PARAM7,
    PARAM8 = X_PARAM8,
    PARAM9 = X_PARAM9,
    PARAM10 = X_PARAM10,
    PARAM11 = X_PARAM11,
    PARAM12 = X_PARAM12,
    PARAM13 = X_PARAM13,
    PARAM14 = X_PARAM14,
    APPLICATION_ID = X_APPLICATION_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where OBJECT_RULE_ID = X_OBJECT_RULE_ID;

Line: 412


  update AMS_OBJECT_RULES_TL set
    OBJECT_RULE_ID = X_OBJECT_RULE_ID,
    OBJECT_RULE_NAME = X_OBJECT_RULE_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 OBJECT_RULE_ID = X_OBJECT_RULE_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 426


end UPDATE_ROW;

Line: 428


procedure DELETE_ROW (
  X_OBJECT_RULE_ID in NUMBER
) is
begin
  delete from AMS_OBJECT_RULES_TL
  where OBJECT_RULE_ID = X_OBJECT_RULE_ID;

Line: 439


  delete from AMS_OBJECT_RULES_B
  where OBJECT_RULE_ID = X_OBJECT_RULE_ID;

Line: 445


end DELETE_ROW;

Line: 454


     update AMS_OBJECT_RULES_TL set
     object_rule_name = nvl(x_object_rule_name, object_rule_name),
     description = nvl(x_description, description),
     source_lang = userenv('LANG'),
     last_update_date = sysdate,
     last_updated_by = decode(x_owner, 'SEED', 1, 0),
     last_update_login = 0
     where  OBJECT_RULE_ID = X_OBJECT_RULE_ID
     and      userenv('LANG') in (language, source_lang);

Line: 508


 select object_version_number
from    AMS_OBJECT_RULES_B
  where  OBJECT_RULE_ID =  X_OBJECT_RULE_ID;

Line: 513


  select 'x'
  from    AMS_OBJECT_RULES_B
  where  OBJECT_RULE_ID =  X_OBJECT_RULE_ID;

Line: 518


  select AMS_OBJECT_RULES_B_S.nextval
  from dual;

Line: 540


		AMS_OBJECT_RULES_PKG.INSERT_ROW (
			X_ROWID => l_row_id,
			X_OBJECT_RULE_ID => l_objrule_id,
			X_PARAM15 => X_PARAM15,
			X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
			X_SECURITY_GROUP_ID => X_SECURITY_GROUP_ID,
			X_APPROVAL_TYPE => X_APPROVAL_TYPE,
			X_RULE_USED_BY => X_RULE_USED_BY,
			X_RULE_USED_BY_TYPE => X_RULE_USED_BY_TYPE,
			X_RULE_TYPE => X_RULE_TYPE,
			X_API_TYPE => X_API_TYPE,
			X_PACKAGE_NAME => X_PACKAGE_NAME,
			X_PROCEDURE_NAME => X_PROCEDURE_NAME,
			X_CLASS_NAME => X_CLASS_NAME,
			X_METHOD_NAME => X_METHOD_NAME,
			X_QUERY => X_QUERY,
			X_RELATED_OBJECT => X_RELATED_OBJECT,
			X_SEEDED_FLAG => X_SEEDED_FLAG,
			X_PARAM1 => X_PARAM1,
			X_PARAM2 => X_PARAM2,
			X_PARAM3 => X_PARAM3,
			X_PARAM4 => X_PARAM4,
			X_PARAM5 => X_PARAM5,
			X_PARAM6 => X_PARAM6,
			X_PARAM7 => X_PARAM7,
			X_PARAM8 => X_PARAM8,
			X_PARAM9 => X_PARAM9,
			X_PARAM10 => X_PARAM10,
			X_PARAM11 => X_PARAM11,
			X_PARAM12 => X_PARAM12,
			X_PARAM13 => X_PARAM13,
			X_PARAM14 => X_PARAM14,
			X_APPLICATION_ID => X_APPLICATION_ID ,
			X_OBJECT_RULE_NAME => X_OBJECT_RULE_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: 589


		AMS_OBJECT_RULES_PKG.UPDATE_ROW(
			X_OBJECT_RULE_ID => X_OBJECT_RULE_ID,
			X_PARAM15 => X_PARAM15,
			X_OBJECT_VERSION_NUMBER => l_obj_verno,
			X_SECURITY_GROUP_ID => X_SECURITY_GROUP_ID,
			X_APPROVAL_TYPE => X_APPROVAL_TYPE,
			X_RULE_USED_BY => X_RULE_USED_BY,
			X_RULE_USED_BY_TYPE => X_RULE_USED_BY_TYPE,
			X_RULE_TYPE => X_RULE_TYPE,
			X_API_TYPE => X_API_TYPE,
			X_PACKAGE_NAME => X_PACKAGE_NAME,
			X_PROCEDURE_NAME => X_PROCEDURE_NAME,
			X_CLASS_NAME => X_CLASS_NAME,
			X_METHOD_NAME => X_METHOD_NAME,
			X_QUERY => X_QUERY,
			X_RELATED_OBJECT => X_RELATED_OBJECT,
			X_SEEDED_FLAG => X_SEEDED_FLAG,
			X_PARAM1 => X_PARAM1,
			X_PARAM2 => X_PARAM2,
			X_PARAM3 => X_PARAM3,
			X_PARAM4 => X_PARAM4,
			X_PARAM5 => X_PARAM5,
			X_PARAM6 => X_PARAM6,
			X_PARAM7 => X_PARAM7,
			X_PARAM8 => X_PARAM8,
			X_PARAM9 => X_PARAM9,
			X_PARAM10 => X_PARAM10,
			X_PARAM11 => X_PARAM11,
			X_PARAM12 => X_PARAM12,
			X_PARAM13 => X_PARAM13,
			X_PARAM14 => X_PARAM14,
			X_APPLICATION_ID => X_APPLICATION_ID,
			X_OBJECT_RULE_NAME => X_OBJECT_RULE_NAME,
			X_DESCRIPTION => X_DESCRIPTION,
			X_LAST_UPDATE_DATE => SYSDATE,
			X_LAST_UPDATED_BY => l_user_id,
			X_LAST_UPDATE_LOGIN => 0
			);

Line: 634


  delete from AMS_OBJECT_RULES_TL T
  where not exists
    (select NULL
    from AMS_OBJECT_RULES_B B
    where B.OBJECT_RULE_ID = T.OBJECT_RULE_ID
    );

Line: 641


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

Line: 660


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