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.AHL_APPROVAL_RULES_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_APPROVAL_RULE_ID         IN        NUMBER,
  X_OBJECT_VERSION_NUMBER    IN        NUMBER,
  X_APPROVAL_OBJECT_CODE     IN        VARCHAR2,
  X_APPROVAL_PRIORITY_CODE   IN        VARCHAR2,
  X_APPROVAL_TYPE_CODE       IN        VARCHAR2,
  X_OPERATING_UNIT_ID        IN        NUMBER,
  X_ACTIVE_START_DATE        IN        DATE,
  X_ACTIVE_END_DATE          IN        DATE,
  X_STATUS_CODE              IN        VARCHAR2,
  X_SEEDED_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_APPROVAL_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,
  X_APPLICATION_USG_CODE     IN        VARCHAR2

)

is

cursor C is Select ROWID from AHL_APPROVAL_RULES_B where

            APPROVAL_RULE_ID = X_APPROVAL_RULE_ID ;

Line: 53


insert into AHL_APPROVAL_RULES_B

(
  APPROVAL_RULE_ID,
  OBJECT_VERSION_NUMBER,
  APPROVAL_OBJECT_CODE,
  APPROVAL_PRIORITY_CODE,
  APPROVAL_TYPE_CODE,
  APPLICATION_USG_CODE,
  OPERATING_UNIT_ID,
  ACTIVE_START_DATE,
  ACTIVE_END_DATE,
  STATUS_CODE,
  SEEDED_FLAG,
  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_APPROVAL_RULE_ID,
  X_OBJECT_VERSION_NUMBER,
  X_APPROVAL_OBJECT_CODE,
  X_APPROVAL_PRIORITY_CODE,
  X_APPROVAL_TYPE_CODE,
  X_APPLICATION_USG_CODE,
  X_OPERATING_UNIT_ID,
  X_ACTIVE_START_DATE,
  X_ACTIVE_END_DATE,
  X_STATUS_CODE,
  X_SEEDED_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_CREATION_DATE,
  X_CREATED_BY,
  X_LAST_UPDATE_DATE,
  X_LAST_UPDATED_BY,
  X_LAST_UPDATE_LOGIN
);

Line: 129


insert into AHL_APPROVAL_RULES_TL

(
    APPROVAL_RULE_NAME,
    DESCRIPTION,
    APPROVAL_RULE_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_APPROVAL_RULE_NAME,
    X_DESCRIPTION,
    X_APPROVAL_RULE_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    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 AHL_APPROVAL_RULES_TL T
    where T.APPROVAL_RULE_ID = X_APPROVAL_RULE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 180


end INSERT_ROW;

Line: 247


  cursor c is select

      OBJECT_VERSION_NUMBER,

      APPROVAL_OBJECT_CODE,

      APPROVAL_PRIORITY_CODE,

      APPROVAL_TYPE_CODE,

      APPLICATION_USG_CODE,

      OPERATING_UNIT_ID,

      ACTIVE_START_DATE,

      ACTIVE_END_DATE,

      STATUS_CODE,

      SEEDED_FLAG,

--      SECURITY_GROUP_ID,

      ATTRIBUTE_CATEGORY,

      ATTRIBUTE1,

      ATTRIBUTE2,

      ATTRIBUTE3,

      ATTRIBUTE4,

      ATTRIBUTE5,

      ATTRIBUTE6,

      ATTRIBUTE7,

      ATTRIBUTE8,

      ATTRIBUTE9,

      ATTRIBUTE10,

      ATTRIBUTE11,

      ATTRIBUTE12,

      ATTRIBUTE13,

      ATTRIBUTE14,

      ATTRIBUTE15

    from AHL_APPROVAL_RULES_B

    where APPROVAL_RULE_ID = X_APPROVAL_RULE_ID

    for update of APPROVAL_RULE_ID nowait;

Line: 311


  cursor c1 is select

      APPROVAL_RULE_NAME,

      DESCRIPTION,

      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG

    from AHL_APPROVAL_RULES_TL

    where APPROVAL_RULE_ID = X_APPROVAL_RULE_ID

    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

    for update of APPROVAL_RULE_ID nowait;

Line: 337


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

Line: 479


procedure UPDATE_ROW

(

  X_APPROVAL_RULE_ID in NUMBER,

  X_OBJECT_VERSION_NUMBER in NUMBER,

  X_APPROVAL_OBJECT_CODE in VARCHAR2,

  X_APPROVAL_PRIORITY_CODE in VARCHAR2,

  X_APPROVAL_TYPE_CODE in VARCHAR2,

  X_OPERATING_UNIT_ID in NUMBER,

  X_ACTIVE_START_DATE in DATE,

  X_ACTIVE_END_DATE in DATE,

  X_STATUS_CODE in VARCHAR2,

  X_SEEDED_FLAG in VARCHAR2,

--  X_SECURITY_GROUP_ID in NUMBER,

  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_APPROVAL_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,

  X_APPLICATION_USG_CODE IN VARCHAR2

) is

begin



update AHL_APPROVAL_RULES_B set

    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

    APPROVAL_OBJECT_CODE = X_APPROVAL_OBJECT_CODE,

    APPROVAL_PRIORITY_CODE = X_APPROVAL_PRIORITY_CODE,

    APPROVAL_TYPE_CODE = X_APPROVAL_TYPE_CODE,

    APPLICATION_USG_CODE = X_APPLICATION_USG_CODE,

    OPERATING_UNIT_ID = X_OPERATING_UNIT_ID,

    ACTIVE_START_DATE = X_ACTIVE_START_DATE,

    ACTIVE_END_DATE = X_ACTIVE_END_DATE,

    STATUS_CODE = X_STATUS_CODE,

    SEEDED_FLAG = X_SEEDED_FLAG,

--    SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,

    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 APPROVAL_RULE_ID = X_APPROVAL_RULE_ID

  and OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER-1;

Line: 631


 update AHL_APPROVAL_RULES_TL set

    APPROVAL_RULE_NAME = X_APPROVAL_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 APPROVAL_RULE_ID = X_APPROVAL_RULE_ID

  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 657


end UPDATE_ROW;

Line: 661


procedure DELETE_ROW(

  X_APPROVAL_RULE_ID in NUMBER

)

is

begin

  delete from AHL_APPROVAL_RULES_TL

  where APPROVAL_RULE_ID = X_APPROVAL_RULE_ID;

Line: 685


  delete from AHL_APPROVAL_RULES_B

  where APPROVAL_RULE_ID = X_APPROVAL_RULE_ID;

Line: 697


end DELETE_ROW;

Line: 707


  delete from AHL_APPROVAL_RULES_TL T

  where not exists

    (select NULL

    from AHL_APPROVAL_RULES_B B

    where B.APPROVAL_RULE_ID = T.APPROVAL_RULE_ID

    );

Line: 721


  update AHL_APPROVAL_RULES_TL T set (

      APPROVAL_RULE_NAME,

      DESCRIPTION

    ) = (select

      B.APPROVAL_RULE_NAME,

      B.DESCRIPTION

    from AHL_APPROVAL_RULES_TL B

    where B.APPROVAL_RULE_ID = T.APPROVAL_RULE_ID

    and B.LANGUAGE = T.SOURCE_LANG)

  where (

      T.APPROVAL_RULE_ID,

      T.LANGUAGE

  ) in (select

      SUBT.APPROVAL_RULE_ID,

      SUBT.LANGUAGE

    from AHL_APPROVAL_RULES_TL SUBB, AHL_APPROVAL_RULES_TL SUBT

    where SUBB.APPROVAL_RULE_ID = SUBT.APPROVAL_RULE_ID

    and SUBB.LANGUAGE = SUBT.SOURCE_LANG

    and (SUBB.APPROVAL_RULE_NAME <> SUBT.APPROVAL_RULE_NAME

      or (SUBB.APPROVAL_RULE_NAME is null and SUBT.APPROVAL_RULE_NAME is not null)

      or (SUBB.APPROVAL_RULE_NAME is not null and SUBT.APPROVAL_RULE_NAME 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: 773


  insert into AHL_APPROVAL_RULES_TL (

    APPROVAL_RULE_NAME,

    DESCRIPTION,

--    SECURITY_GROUP_ID,

    APPROVAL_RULE_ID,

    LAST_UPDATE_DATE,

    LAST_UPDATED_BY,

    CREATION_DATE,

    CREATED_BY,

    LAST_UPDATE_LOGIN,

    LANGUAGE,

    SOURCE_LANG

  ) select

    B.APPROVAL_RULE_NAME,

    B.DESCRIPTION,

--    B.SECURITY_GROUP_ID,

    B.APPROVAL_RULE_ID,

    B.LAST_UPDATE_DATE,

    B.LAST_UPDATED_BY,

    B.CREATION_DATE,

    B.CREATED_BY,

    B.LAST_UPDATE_LOGIN,

    L.LANGUAGE_CODE,

    B.SOURCE_LANG

  from AHL_APPROVAL_RULES_TL B, FND_LANGUAGES L

  where L.INSTALLED_FLAG in ('I', 'B')

  and B.LANGUAGE = userenv('LANG')

  and not exists

    (select NULL

    from AHL_APPROVAL_RULES_TL T

    where T.APPROVAL_RULE_ID = B.APPROVAL_RULE_ID

    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 848


    update AHL_APPROVAL_RULES_TL set
       approval_rule_name = nvl(x_approval_rule_name, approval_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  approval_rule_id = x_approval_rule_id
    and      userenv('LANG') in (language, source_lang);

Line: 899


  select  object_version_number
  from    AHL_APPROVAL_RULES_B
  where   approval_rule_id =  X_APPROVAL_RULE_ID;

Line: 904


  select 'x'
  from   AHL_APPROVAL_RULES_B
  where  approval_rule_id = X_APPROVAL_RULE_ID;

Line: 909


   select ahl_approval_rules_b_s.nextval
   from dual;

Line: 935


 AHL_APPROVAL_RULES_PKG.INSERT_ROW (
  X_ROWID                       => l_row_id,
  X_APPROVAL_RULE_ID 		=> l_rule_id,
  X_OBJECT_VERSION_NUMBER 	=> l_obj_verno,
  X_APPROVAL_OBJECT_CODE        => l_approval_object_code,
  X_APPROVAL_PRIORITY_CODE      => l_approval_priority_code,
  X_APPROVAL_TYPE_CODE          => l_approval_type_code,
  X_APPLICATION_USG_CODE        => X_APPLICATION_USG_CODE,
  X_OPERATING_UNIT_ID           => l_operating_unit_id,
  X_ACTIVE_END_DATE             => l_active_end_date,
  X_STATUS_CODE 		=> X_STATUS_CODE ,
  X_ACTIVE_START_DATE 		=> X_ACTIVE_START_DATE ,
  X_SEEDED_FLAG 		=> X_SEEDED_FLAG ,
  X_APPROVAL_RULE_NAME 		=> X_APPROVAL_RULE_NAME ,
  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_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: 980


AHL_APPROVAL_RULES_PKG.UPDATE_ROW (

  X_APPROVAL_RULE_ID 		=> X_APPROVAL_RULE_ID,
  X_OBJECT_VERSION_NUMBER 	=> l_obj_verno + 1,
  X_STATUS_CODE			=> X_STATUS_CODE ,
  X_APPLICATION_USG_CODE        => X_APPLICATION_USG_CODE,
  X_ACTIVE_START_DATE 		=> X_ACTIVE_START_DATE ,
  X_SEEDED_FLAG 		=> X_SEEDED_FLAG,
  X_APPROVAL_OBJECT_CODE        => l_approval_object_code,
  X_APPROVAL_PRIORITY_CODE      => l_approval_priority_code,
  X_APPROVAL_TYPE_CODE          => l_approval_type_code,
  X_OPERATING_UNIT_ID           => l_operating_unit_id,
  X_ACTIVE_END_DATE             => l_active_end_date,
  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_APPROVAL_RULE_NAME 		=> X_APPROVAL_RULE_NAME ,
  X_DESCRIPTION 		=> X_DESCRIPTION ,
  X_LAST_UPDATE_DATE            => SYSDATE,
  X_LAST_UPDATED_BY             => l_user_id,
  X_LAST_UPDATE_LOGIN           => 0



);