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

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

Line: 4


/* procedure to insert INSERT_ROW */

PROCEDURE INSERT_ROW
(
  PX_ROWID              IN OUT NOCOPY /* file.sql.39 change */  VARCHAR2,
  PX_SECTION_ID         IN OUT NOCOPY /* file.sql.39 change */  NUMBER,
  P_created_by          IN NUMBER ,
  P_creation_date       IN DATE ,
  P_last_updated_by     IN NUMBER,
  P_last_update_date    IN DATE,
  P_last_update_login   IN NUMBER,
  P_SECTION_NAME       IN VARCHAR2,
  P_DESCRIPTION         IN VARCHAR2 := NULL,
  P_CONTEXT             IN VARCHAR2 := NULL,
  P_ATTRIBUTE1          IN VARCHAR2 := NULL,
  P_ATTRIBUTE2          IN VARCHAR2 := NULL,
  P_ATTRIBUTE3          IN VARCHAR2 := NULL,
  P_ATTRIBUTE4          IN VARCHAR2 := NULL,
  P_ATTRIBUTE5          IN VARCHAR2 := NULL,
  P_ATTRIBUTE6          IN VARCHAR2 := NULL,
  P_ATTRIBUTE7          IN VARCHAR2 := NULL,
  P_ATTRIBUTE8          IN VARCHAR2 := NULL,
  P_ATTRIBUTE9          IN VARCHAR2 := NULL,
  P_ATTRIBUTE10         IN VARCHAR2 := NULL,
  P_ATTRIBUTE11         IN VARCHAR2 := NULL,
  P_ATTRIBUTE12         IN VARCHAR2 := NULL,
  P_ATTRIBUTE13         IN VARCHAR2 := NULL,
  P_ATTRIBUTE14         IN VARCHAR2 := NULL,
  P_ATTRIBUTE15         IN VARCHAR2 := NULL,
  P_ATTRIBUTE16         IN VARCHAR2 := NULL,
  P_ATTRIBUTE17         IN VARCHAR2 := NULL,
  P_ATTRIBUTE18         IN VARCHAR2 := NULL,
  P_ATTRIBUTE19         IN VARCHAR2 := NULL,
  P_ATTRIBUTE20         IN VARCHAR2 := NULL
)

IS

  cursor c is
    select ROWID
    from  ASO_SUP_SECTION_B
    where  SECTION_ID = PX_SECTION_ID ;

Line: 48


    select ASO_SUP_SECTION_B_S.NEXTVAL from sys.dual;

Line: 59


  insert into ASO_SUP_SECTION_B (
  SECTION_ID,
  created_by  ,
  creation_date ,
  last_updated_by ,
  last_update_date ,
  last_update_login ,
  CONTEXT,
  ATTRIBUTE1 ,
  ATTRIBUTE2 ,
  ATTRIBUTE3 ,
  ATTRIBUTE4 ,
  ATTRIBUTE5 ,
  ATTRIBUTE6 ,
  ATTRIBUTE7 ,
  ATTRIBUTE8 ,
  ATTRIBUTE9 ,
  ATTRIBUTE10 ,
  ATTRIBUTE11 ,
  ATTRIBUTE12 ,
  ATTRIBUTE13 ,
  ATTRIBUTE14 ,
  ATTRIBUTE15,
  ATTRIBUTE16,
  ATTRIBUTE17,
  ATTRIBUTE18,
  ATTRIBUTE19,
  ATTRIBUTE20 )
values
  (
  PX_SECTION_ID,
  P_created_by  ,
  P_creation_date ,
  P_last_updated_by ,
  P_last_update_date ,
  P_last_update_login,
  P_CONTEXT,
  P_ATTRIBUTE1 ,
  P_ATTRIBUTE2 ,
  P_ATTRIBUTE3 ,
  P_ATTRIBUTE4 ,
  P_ATTRIBUTE5 ,
  P_ATTRIBUTE6 ,
  P_ATTRIBUTE7 ,
  P_ATTRIBUTE8 ,
  P_ATTRIBUTE9 ,
  P_ATTRIBUTE10 ,
  P_ATTRIBUTE11 ,
  P_ATTRIBUTE12 ,
  P_ATTRIBUTE13 ,
  P_ATTRIBUTE14 ,
  P_ATTRIBUTE15,
  P_ATTRIBUTE16,
  P_ATTRIBUTE17,
  P_ATTRIBUTE18,
  P_ATTRIBUTE19,
  P_ATTRIBUTE20
  );

Line: 118


  insert into ASO_SUP_SECTION_TL (
    SECTION_ID,
    LANGUAGE,
    SOURCE_LANG,
    SECTION_NAME,
    DESCRIPTION,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN
  ) select
    PX_SECTION_ID,
    L.LANGUAGE_CODE,
    userenv('LANG'),
    P_SECTION_NAME,
    P_DESCRIPTION,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATED_BY,
    P_CREATION_DATE,
    P_CREATED_BY,
    P_LAST_UPDATE_LOGIN
  from  FND_LANGUAGES  L
  where  L.INSTALLED_FLAG in ('I', 'B')
  and  not exists
         ( select 'x'
           from  ASO_SUP_SECTION_TL  T
           where  T.SECTION_ID = PX_SECTION_ID
             and  T.LANGUAGE = L.LANGUAGE_CODE );

Line: 156


end INSERT_ROW;

Line: 159


PROCEDURE UPDATE_ROW
(
  P_SECTION_ID        IN NUMBER,
  P_last_updated_by     IN NUMBER,
  P_last_update_date    IN DATE,
  P_last_update_login   IN NUMBER,
  P_SECTION_NAME        IN VARCHAR2,
  P_DESCRIPTION         IN VARCHAR2,
  P_CONTEXT             IN VARCHAR2,
  P_ATTRIBUTE1          IN VARCHAR2,
  P_ATTRIBUTE2          IN VARCHAR2,
  P_ATTRIBUTE3          IN VARCHAR2,
  P_ATTRIBUTE4          IN VARCHAR2,
  P_ATTRIBUTE5          IN VARCHAR2,
  P_ATTRIBUTE6          IN VARCHAR2,
  P_ATTRIBUTE7          IN VARCHAR2,
  P_ATTRIBUTE8          IN VARCHAR2,
  P_ATTRIBUTE9          IN VARCHAR2,
  P_ATTRIBUTE10         IN VARCHAR2,
  P_ATTRIBUTE11         IN VARCHAR2,
  P_ATTRIBUTE12         IN VARCHAR2,
  P_ATTRIBUTE13         IN VARCHAR2,
  P_ATTRIBUTE14         IN VARCHAR2,
  P_ATTRIBUTE15         IN VARCHAR2,
  P_ATTRIBUTE16         IN VARCHAR2,
  P_ATTRIBUTE17         IN VARCHAR2,
  P_ATTRIBUTE18         IN VARCHAR2,
  P_ATTRIBUTE19         IN VARCHAR2,
  P_ATTRIBUTE20         IN VARCHAR2

)

IS

Begin

  update ASO_SUP_SECTION_B
  set
  last_updated_by = P_last_updated_by,
  last_update_date = P_last_update_date,
  last_update_login = P_last_update_login,
  context = P_context,
  ATTRIBUTE1 = P_ATTRIBUTE1,
  ATTRIBUTE2 = P_ATTRIBUTE2,
  ATTRIBUTE3 = P_ATTRIBUTE3,
  ATTRIBUTE4 = P_ATTRIBUTE4,
  ATTRIBUTE5 = P_ATTRIBUTE5,
  ATTRIBUTE6 = P_ATTRIBUTE6,
  ATTRIBUTE7 = P_ATTRIBUTE7,
  ATTRIBUTE8 = P_ATTRIBUTE8,
  ATTRIBUTE9 = P_ATTRIBUTE9,
  ATTRIBUTE10 = P_ATTRIBUTE10,
  ATTRIBUTE11 = P_ATTRIBUTE11,
  ATTRIBUTE12 = P_ATTRIBUTE12,
  ATTRIBUTE13 = P_ATTRIBUTE13,
  ATTRIBUTE14 = P_ATTRIBUTE14,
  ATTRIBUTE15 = P_ATTRIBUTE15,
  ATTRIBUTE16 = P_ATTRIBUTE16,
  ATTRIBUTE17 = P_ATTRIBUTE17,
  ATTRIBUTE18 = P_ATTRIBUTE18,
  ATTRIBUTE19 = P_ATTRIBUTE19,
  ATTRIBUTE20 = P_ATTRIBUTE20
where  SECTION_ID = P_SECTION_ID;

Line: 227


update ASO_SUP_SECTION_TL
 set
  SECTION_NAME = P_SECTION_NAME,
  DESCRIPTION    = P_DESCRIPTION,
  LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
  LAST_UPDATED_BY = P_LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,
  SOURCE_LANG = userenv('LANG')
where  SECTION_ID = P_SECTION_ID
    and  userenv('LANG') in (LANGUAGE, SOURCE_LANG) ;

Line: 243


End UPDATE_ROW;

Line: 246


procedure DELETE_ROW (
  P_SECTION_ID IN NUMBER

)

IS

Begin

 delete from ASO_SUP_SECTION_TL
  where  SECTION_ID = P_SECTION_ID;

Line: 263


  delete from ASO_SUP_SECTION_B
  where  SECTION_ID = P_SECTION_ID;

Line: 270


End Delete_row;

Line: 277


  P_last_updated_by     IN NUMBER,
  P_last_update_date    IN DATE,
  P_last_update_login   IN NUMBER,
  P_SECTION_NAME      IN VARCHAR2,
  P_DESCRIPTION         IN VARCHAR2,
  P_CONTEXT             IN VARCHAR2,
  P_ATTRIBUTE1          IN VARCHAR2,
  P_ATTRIBUTE2          IN VARCHAR2,
  P_ATTRIBUTE3          IN VARCHAR2,
  P_ATTRIBUTE4          IN VARCHAR2,
  P_ATTRIBUTE5          IN VARCHAR2,
  P_ATTRIBUTE6          IN VARCHAR2,
  P_ATTRIBUTE7          IN VARCHAR2,
  P_ATTRIBUTE8          IN VARCHAR2,
  P_ATTRIBUTE9          IN VARCHAR2,
  P_ATTRIBUTE10         IN VARCHAR2,
  P_ATTRIBUTE11         IN VARCHAR2,
  P_ATTRIBUTE12         IN VARCHAR2,
  P_ATTRIBUTE13         IN VARCHAR2,
  P_ATTRIBUTE14         IN VARCHAR2,
  P_ATTRIBUTE15         IN VARCHAR2

)

IS

CURSOR i_csr is
SELECT
  a.SECTION_ID ,
  created_by  ,
  creation_date ,
  last_updated_by ,
  last_update_date ,
  last_update_login ,
  context,
  ATTRIBUTE1 ,
  ATTRIBUTE2 ,
  ATTRIBUTE3 ,
  ATTRIBUTE4 ,
  ATTRIBUTE5 ,
  ATTRIBUTE6 ,
  ATTRIBUTE7 ,
  ATTRIBUTE8 ,
  ATTRIBUTE9 ,
  ATTRIBUTE10 ,
  ATTRIBUTE11 ,
  ATTRIBUTE12 ,
  ATTRIBUTE13 ,
  ATTRIBUTE14 ,
  ATTRIBUTE15

 from  ASO_SUP_SECTION_B a
 where a.SECTION_ID = P_SECTION_ID
 for update of a.SECTION_ID nowait;

Line: 335


    select
      SECTION_NAME,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from  ASO_SUP_SECTION_TL
    where SECTION_ID = P_SECTION_ID
    for update of SECTION_ID nowait;

Line: 359


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

Line: 375


      AND ((recinfo.LAST_UPDATED_BY = P_LAST_UPDATED_BY)
           OR ((recinfo.LAST_UPDATED_BY is null) AND (P_LAST_UPDATED_BY is null)))
      AND ((recinfo.LAST_UPDATE_DATE = P_LAST_UPDATE_DATE)
           OR ((recinfo.LAST_UPDATE_DATE is null) AND (P_LAST_UPDATE_DATE is null)))
      AND ((recinfo.LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN)
           OR ((recinfo.LAST_UPDATE_LOGIN is null) AND (P_LAST_UPDATE_LOGIN is null)))
      AND ((recinfo.CONTEXT = P_CONTEXT)
           OR ((recinfo.CONTEXT is null) AND (P_CONTEXT is null)))
      AND ((recinfo.ATTRIBUTE1 = P_ATTRIBUTE1)
           OR ((recinfo.ATTRIBUTE1 is null) AND (P_ATTRIBUTE1 is null)))
      AND ((recinfo.ATTRIBUTE2 = P_ATTRIBUTE2)
           OR ((recinfo.ATTRIBUTE2 is null) AND (P_ATTRIBUTE2 is null)))
      AND ((recinfo.ATTRIBUTE3 = P_ATTRIBUTE3)
           OR ((recinfo.ATTRIBUTE3 is null) AND (P_ATTRIBUTE3 is null)))
      AND ((recinfo.ATTRIBUTE4 = P_ATTRIBUTE4)
           OR ((recinfo.ATTRIBUTE4 is null) AND (P_ATTRIBUTE4 is null)))
      AND ((recinfo.ATTRIBUTE5 = P_ATTRIBUTE5)
           OR ((recinfo.ATTRIBUTE5 is null) AND (P_ATTRIBUTE5 is null)))
      AND ((recinfo.ATTRIBUTE6 = P_ATTRIBUTE6)
           OR ((recinfo.ATTRIBUTE6 is null) AND (P_ATTRIBUTE6 is null)))
      AND ((recinfo.ATTRIBUTE7 = P_ATTRIBUTE7)
           OR ((recinfo.ATTRIBUTE7 is null) AND (P_ATTRIBUTE7 is null)))
      AND ((recinfo.ATTRIBUTE8 = P_ATTRIBUTE8)
           OR ((recinfo.ATTRIBUTE8 is null) AND (P_ATTRIBUTE8 is null)))
      AND ((recinfo.ATTRIBUTE9 = P_ATTRIBUTE9)
           OR ((recinfo.ATTRIBUTE9 is null) AND (P_ATTRIBUTE9 is null)))
      AND ((recinfo.ATTRIBUTE10 = P_ATTRIBUTE10)
           OR ((recinfo.ATTRIBUTE10 is null) AND (P_ATTRIBUTE10 is null)))
      AND ((recinfo.ATTRIBUTE11 = P_ATTRIBUTE11)
           OR ((recinfo.ATTRIBUTE11 is null) AND (P_ATTRIBUTE11 is null)))
      AND ((recinfo.ATTRIBUTE12 = P_ATTRIBUTE12)
           OR ((recinfo.ATTRIBUTE12 is null) AND (P_ATTRIBUTE12 is null)))
      AND ((recinfo.ATTRIBUTE13 = P_ATTRIBUTE13)
           OR ((recinfo.ATTRIBUTE13 is null) AND (P_ATTRIBUTE13 is null)))
      AND ((recinfo.ATTRIBUTE14 = P_ATTRIBUTE14)
           OR ((recinfo.ATTRIBUTE14 is null) AND (P_ATTRIBUTE14 is null)))
      AND ((recinfo.ATTRIBUTE15 = P_ATTRIBUTE15)
           OR ((recinfo.ATTRIBUTE15 is null) AND (P_ATTRIBUTE15 is null)))
  ) then
    null;

Line: 447


  delete from ASO_SUP_SECTION_TL T
  where not exists
        ( select NULL
          from  ASO_SUP_SECTION_B  B
          where  B.SECTION_ID = T.SECTION_ID
        );

Line: 454


  update ASO_SUP_SECTION_TL T set (
      SECTION_NAME,
      DESCRIPTION
    ) = ( select
      B.SECTION_NAME,
      B.DESCRIPTION
    from  ASO_SUP_SECTION_TL  B
    where  B.SECTION_ID = T.SECTION_ID
      and  B.LANGUAGE = T.SOURCE_LANG )
  where (
      T.SECTION_ID,
      T.LANGUAGE
  ) in ( select
      SUBT.SECTION_ID,
      SUBT.LANGUAGE
    from  ASO_SUP_SECTION_TL  SUBB,
          ASO_SUP_SECTION_TL  SUBT
    where  SUBB.SECTION_ID = SUBT.SECTION_ID
      and  SUBB.LANGUAGE = SUBT.SOURCE_LANG
      and  ( SUBB.SECTION_NAME <> SUBT.SECTION_NAME
           or ( SUBB.SECTION_NAME is null     and SUBT.SECTION_NAME is not null )
           or ( SUBB.SECTION_NAME is not null and SUBT.SECTION_NAME is null ) )
      and  ( 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: 482


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

Line: 523


  P_last_updated_by     IN NUMBER,
  P_last_update_date    IN DATE,
  P_last_update_login   IN NUMBER,
  P_SECTION_NAME        IN VARCHAR2,
  P_DESCRIPTION         IN VARCHAR2,
  P_CONTEXT             IN VARCHAR2,
  P_ATTRIBUTE1          IN VARCHAR2,
  P_ATTRIBUTE2          IN VARCHAR2,
  P_ATTRIBUTE3          IN VARCHAR2,
  P_ATTRIBUTE4          IN VARCHAR2,
  P_ATTRIBUTE5          IN VARCHAR2,
  P_ATTRIBUTE6          IN VARCHAR2,
  P_ATTRIBUTE7          IN VARCHAR2,
  P_ATTRIBUTE8          IN VARCHAR2,
  P_ATTRIBUTE9          IN VARCHAR2,
  P_ATTRIBUTE10         IN VARCHAR2,
  P_ATTRIBUTE11         IN VARCHAR2,
  P_ATTRIBUTE12         IN VARCHAR2,
  P_ATTRIBUTE13         IN VARCHAR2,
  P_ATTRIBUTE14         IN VARCHAR2,
  P_ATTRIBUTE15         IN VARCHAR2,
  P_ATTRIBUTE16         IN VARCHAR2,
  P_ATTRIBUTE17         IN VARCHAR2,
  P_ATTRIBUTE18         IN VARCHAR2,
  P_ATTRIBUTE19         IN VARCHAR2,
  P_ATTRIBUTE20         IN VARCHAR2,
  X_OWNER               IN VARCHAR2)

IS

begin

  declare
     user_id            number := 0;

Line: 566


ASO_SUP_SECTION_PKG.UPDATE_ROW (
  P_SECTION_ID => P_SECTION_ID,
  P_LAST_UPDATE_DATE => sysdate,
  P_LAST_UPDATED_BY => user_id,
  P_LAST_UPDATE_LOGIN => 0,
  P_SECTION_NAME => P_SECTION_NAME,
  P_DESCRIPTION    => P_DESCRIPTION,
  p_context    => P_context,
  P_ATTRIBUTE1 => P_ATTRIBUTE1,
  P_ATTRIBUTE2 => P_ATTRIBUTE2,
  P_ATTRIBUTE3 => P_ATTRIBUTE3,
  P_ATTRIBUTE4 => P_ATTRIBUTE4,
  P_ATTRIBUTE5 => P_ATTRIBUTE5,
  P_ATTRIBUTE6 => P_ATTRIBUTE6,
  P_ATTRIBUTE7 => P_ATTRIBUTE7,
  P_ATTRIBUTE8 => P_ATTRIBUTE8,
  P_ATTRIBUTE9 => P_ATTRIBUTE9,
  P_ATTRIBUTE10 => P_ATTRIBUTE10,
  P_ATTRIBUTE11 => P_ATTRIBUTE11,
  P_ATTRIBUTE12 => P_ATTRIBUTE12,
  P_ATTRIBUTE13 => P_ATTRIBUTE13,
  P_ATTRIBUTE14 => P_ATTRIBUTE14,
  P_ATTRIBUTE15 => P_ATTRIBUTE15,
  P_ATTRIBUTE16 => P_ATTRIBUTE16,
  P_ATTRIBUTE17 => P_ATTRIBUTE17,
  P_ATTRIBUTE18 => P_ATTRIBUTE18,
  P_ATTRIBUTE19 => P_ATTRIBUTE19,
  P_ATTRIBUTE20 => P_ATTRIBUTE20
  );

Line: 600


 ASO_SUP_SECTION_PKG.INSERT_ROW (
  PX_ROWID => row_id,
  PX_SECTION_ID => L_SECTION_ID,
  P_CREATION_DATE => sysdate,
  P_CREATED_BY => user_id,
  P_LAST_UPDATE_DATE => sysdate,
  P_LAST_UPDATED_BY => user_id,
  P_LAST_UPDATE_LOGIN => 0,
  P_SECTION_NAME  => P_SECTION_NAME,
  P_DESCRIPTION     => P_DESCRIPTION,
  p_context    => P_context,
  P_ATTRIBUTE1 => P_ATTRIBUTE1,
  P_ATTRIBUTE2 => P_ATTRIBUTE2,
  P_ATTRIBUTE3 => P_ATTRIBUTE3,
  P_ATTRIBUTE4 => P_ATTRIBUTE4,
  P_ATTRIBUTE5 => P_ATTRIBUTE5,
  P_ATTRIBUTE6 => P_ATTRIBUTE6,
  P_ATTRIBUTE7 => P_ATTRIBUTE7,
  P_ATTRIBUTE8 => P_ATTRIBUTE8,
  P_ATTRIBUTE9 => P_ATTRIBUTE9,
  P_ATTRIBUTE10 => P_ATTRIBUTE10,
  P_ATTRIBUTE11 => P_ATTRIBUTE11,
  P_ATTRIBUTE12 => P_ATTRIBUTE12,
  P_ATTRIBUTE13 => P_ATTRIBUTE13,
  P_ATTRIBUTE14 => P_ATTRIBUTE14,
  P_ATTRIBUTE15 => P_ATTRIBUTE15,
  P_ATTRIBUTE16 => P_ATTRIBUTE16,
  P_ATTRIBUTE17 => P_ATTRIBUTE17,
  P_ATTRIBUTE18 => P_ATTRIBUTE18,
  P_ATTRIBUTE19 => P_ATTRIBUTE19,
  P_ATTRIBUTE20 => P_ATTRIBUTE20
  );

Line: 651


    update ASO_SUP_SECTION_TL
    set  SECTION_NAME = P_SECTION_NAME,
         DESCRIPTION = P_DESCRIPTION,
         source_lang = userenv('LANG'),
         last_update_date = sysdate,
         last_updated_by = l_user_id,
         last_update_login = 0
  where SECTION_ID = P_SECTION_ID
    and userenv('LANG') in (language, source_lang);

Line: 702


   SELECT SECTION_ID
   FROM ASO_SUP_SECTION_TL
   WHERE SECTION_ID = P_SECTION_ID;

Line: 707


  select template_section_map_id
  from aso_sup_tmpl_sect_map
  where section_id = P_SECTION_ID
  and template_id = P_SECT_TMPL_ID;

Line: 729


           ASO_SUP_SECTION_PKG.UPDATE_ROW (
             P_SECTION_ID              => P_SECTION_ID,
             P_LAST_UPDATE_DATE         => sysdate ,
             P_LAST_UPDATED_BY          => l_user_id ,
             P_LAST_UPDATE_LOGIN        => l_user_id ,
             P_SECTION_NAME             => P_SECTION_NAME,
             P_DESCRIPTION              => P_DESCRIPTION,
             p_context                  => P_CONTEXT,
             P_ATTRIBUTE1               => P_ATTRIBUTE1,
             P_ATTRIBUTE2               => P_ATTRIBUTE2,
             P_ATTRIBUTE3               => P_ATTRIBUTE3,
             P_ATTRIBUTE4               => P_ATTRIBUTE4,
             P_ATTRIBUTE5               => P_ATTRIBUTE5,
             P_ATTRIBUTE6               => P_ATTRIBUTE6,
             P_ATTRIBUTE7               => P_ATTRIBUTE7,
             P_ATTRIBUTE8               => P_ATTRIBUTE8,
             P_ATTRIBUTE9               => P_ATTRIBUTE9,
             P_ATTRIBUTE10              => P_ATTRIBUTE10,
             P_ATTRIBUTE11              => P_ATTRIBUTE11,
             P_ATTRIBUTE12              => P_ATTRIBUTE12,
             P_ATTRIBUTE13              => P_ATTRIBUTE13,
             P_ATTRIBUTE14              => P_ATTRIBUTE14,
             P_ATTRIBUTE15              => P_ATTRIBUTE15,
             P_ATTRIBUTE16              => P_ATTRIBUTE16,
             P_ATTRIBUTE17              => P_ATTRIBUTE17,
             P_ATTRIBUTE18              => P_ATTRIBUTE18,
             P_ATTRIBUTE19              => P_ATTRIBUTE19,
             P_ATTRIBUTE20              => P_ATTRIBUTE20
              );

Line: 762


           ASO_SUP_SECTION_PKG.INSERT_ROW (
             PX_ROWID                   => row_id,
             PX_SECTION_ID              => L_SECTION_ID,
             P_CREATION_DATE            => sysdate ,
             P_CREATED_BY               => l_user_id ,
             P_LAST_UPDATE_DATE         => sysdate ,
             P_LAST_UPDATED_BY          => l_user_id ,
             P_LAST_UPDATE_LOGIN        => l_user_id ,
             P_SECTION_NAME             => P_SECTION_NAME,
             P_DESCRIPTION              => P_DESCRIPTION,
             p_context                  => P_CONTEXT,
             P_ATTRIBUTE1               => P_ATTRIBUTE1,
             P_ATTRIBUTE2               => P_ATTRIBUTE2,
             P_ATTRIBUTE3               => P_ATTRIBUTE3,
             P_ATTRIBUTE4               => P_ATTRIBUTE4,
             P_ATTRIBUTE5               => P_ATTRIBUTE5,
             P_ATTRIBUTE6               => P_ATTRIBUTE6,
             P_ATTRIBUTE7               => P_ATTRIBUTE7,
             P_ATTRIBUTE8               => P_ATTRIBUTE8,
             P_ATTRIBUTE9               => P_ATTRIBUTE9,
             P_ATTRIBUTE10              => P_ATTRIBUTE10,
             P_ATTRIBUTE11              => P_ATTRIBUTE11,
             P_ATTRIBUTE12              => P_ATTRIBUTE12,
             P_ATTRIBUTE13              => P_ATTRIBUTE13,
             P_ATTRIBUTE14              => P_ATTRIBUTE14,
             P_ATTRIBUTE15              => P_ATTRIBUTE15,
             P_ATTRIBUTE16              => P_ATTRIBUTE16,
             P_ATTRIBUTE17              => P_ATTRIBUTE17,
             P_ATTRIBUTE18              => P_ATTRIBUTE18,
             P_ATTRIBUTE19              => P_ATTRIBUTE19,
             P_ATTRIBUTE20              => P_ATTRIBUTE20
              );

Line: 804


                      ASO_SUP_TMPL_SECT_MAP_PKG.UPDATE_ROW (
                            P_TEMPLATE_SECTION_MAP_ID => l_TEMPLATE_SECTION_MAP_ID,
                            P_LAST_UPDATE_DATE         => sysdate ,
                            P_LAST_UPDATED_BY          => l_user_id ,
                            P_LAST_UPDATE_LOGIN        => l_user_id ,
                            P_TEMPLATE_ID              => P_SECT_TMPL_ID,
                            P_SECTION_ID               => P_SECTION_ID,
                            P_DISPLAY_SEQUENCE         => P_DISPLAY_SEQUENCE,
                            p_context                  => P_CONTEXT,
                            P_ATTRIBUTE1               => P_ATTRIBUTE1,
                            P_ATTRIBUTE2               => P_ATTRIBUTE2,
                            P_ATTRIBUTE3               => P_ATTRIBUTE3,
                            P_ATTRIBUTE4               => P_ATTRIBUTE4,
                            P_ATTRIBUTE5               => P_ATTRIBUTE5,
                            P_ATTRIBUTE6               => P_ATTRIBUTE6,
                            P_ATTRIBUTE7               => P_ATTRIBUTE7,
                            P_ATTRIBUTE8               => P_ATTRIBUTE8,
                            P_ATTRIBUTE9               => P_ATTRIBUTE9,
                            P_ATTRIBUTE10              => P_ATTRIBUTE10,
                            P_ATTRIBUTE11              => P_ATTRIBUTE11,
                            P_ATTRIBUTE12              => P_ATTRIBUTE12,
                            P_ATTRIBUTE13              => P_ATTRIBUTE13,
                            P_ATTRIBUTE14              => P_ATTRIBUTE14,
                            P_ATTRIBUTE15              => P_ATTRIBUTE15,
                            P_ATTRIBUTE16              => P_ATTRIBUTE16,
                            P_ATTRIBUTE17              => P_ATTRIBUTE17,
                            P_ATTRIBUTE18              => P_ATTRIBUTE18,
                            P_ATTRIBUTE19              => P_ATTRIBUTE19,
                            P_ATTRIBUTE20              => P_ATTRIBUTE20
                            );

Line: 837


                      ASO_SUP_TMPL_SECT_MAP_PKG.INSERT_ROW (
                            PX_ROWID                   => row_id1,
                            PX_TEMPLATE_SECTION_MAP_ID => l_TEMPLATE_SECTION_MAP_ID,
                            P_CREATION_DATE            => sysdate ,
                            P_CREATED_BY               => l_user_id ,
                            P_LAST_UPDATE_DATE         => sysdate ,
                            P_LAST_UPDATED_BY          => l_user_id ,
                            P_LAST_UPDATE_LOGIN        => l_user_id ,
                            P_TEMPLATE_ID              => P_SECT_TMPL_ID,
                            P_SECTION_ID               => P_SECTION_ID,
                            P_DISPLAY_SEQUENCE         => P_DISPLAY_SEQUENCE,
                            p_context                  => P_CONTEXT,
                            P_ATTRIBUTE1               => P_ATTRIBUTE1,
                            P_ATTRIBUTE2               => P_ATTRIBUTE2,
                            P_ATTRIBUTE3               => P_ATTRIBUTE3,
                            P_ATTRIBUTE4               => P_ATTRIBUTE4,
                            P_ATTRIBUTE5               => P_ATTRIBUTE5,
                            P_ATTRIBUTE6               => P_ATTRIBUTE6,
                            P_ATTRIBUTE7               => P_ATTRIBUTE7,
                            P_ATTRIBUTE8               => P_ATTRIBUTE8,
                            P_ATTRIBUTE9               => P_ATTRIBUTE9,
                            P_ATTRIBUTE10              => P_ATTRIBUTE10,
                            P_ATTRIBUTE11              => P_ATTRIBUTE11,
                            P_ATTRIBUTE12              => P_ATTRIBUTE12,
                            P_ATTRIBUTE13              => P_ATTRIBUTE13,
                            P_ATTRIBUTE14              => P_ATTRIBUTE14,
                            P_ATTRIBUTE15              => P_ATTRIBUTE15,
                            P_ATTRIBUTE16              => P_ATTRIBUTE16,
                            P_ATTRIBUTE17              => P_ATTRIBUTE17,
                            P_ATTRIBUTE18              => P_ATTRIBUTE18,
                            P_ATTRIBUTE19              => P_ATTRIBUTE19,
                            P_ATTRIBUTE20              => P_ATTRIBUTE20
                            );