APPS.ASO_SUP_TEMPLATE_DATA_PVT SQL Statements

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

Line: 29

         SELECT LOOKUP_CODE
         from ASO_LOOKUPS
         where LOOKUP_TYPE = 'ASO_SUP_TEMPLATE_CONTEXT'
         AND    lookup_code = p_templ_context
	    and enabled_flag = 'Y'
         and sysdate between nvl(start_date_active, sysdate)
	    and nvl(end_date_active,sysdate);

Line: 38

	SELECT  lookup_code
     FROM   fnd_lookup_values
     WHERE  lookup_type = 'ASO_SUP_TEMPLATE_CONTEXT'
     AND    lookup_code = p_templ_context
     AND    view_application_id = 697
     AND    LANGUAGE = userenv('LANG')
     and    ENABLED_FLAG = 'Y';

Line: 48

     SELECT  'X'
     FROM   fnd_lookup_values
     WHERE  lookup_type = p_lookup_type
     AND    lookup_code = p_templ_level
     AND    view_application_id = 697
     AND    LANGUAGE = userenv('LANG')
     and    ENABLED_FLAG = 'Y';

Line: 172

 ASO_SUP_TEMPLATE_PKG.INSERT_ROW (
  PX_ROWID => row_id,
  PX_TEMPLATE_ID             => L_TEMPLATE_ID,
  P_CREATION_DATE            => P_TEMPLATE_REC.CREATION_DATE ,
  P_CREATED_BY               => P_TEMPLATE_REC.CREATED_BY ,
  P_LAST_UPDATE_DATE         => P_TEMPLATE_REC.LAST_UPDATE_DATE ,
  P_LAST_UPDATED_BY          => P_TEMPLATE_REC.LAST_UPDATED_BY ,
  P_LAST_UPDATE_LOGIN        => P_TEMPLATE_REC.LAST_UPDATE_LOGIN ,
  P_TEMPLATE_NAME            => P_TEMPLATE_REC.TEMPLATE_NAME,
  P_DESCRIPTION              => P_TEMPLATE_REC.DESCRIPTION,
  P_TEMPLATE_LEVEL           => P_TEMPLATE_REC.TEMPLATE_LEVEL,
  P_TEMPLATE_CONTEXT         => P_TEMPLATE_REC.TEMPLATE_CONTEXT,
  p_context                  => P_TEMPLATE_REC.context,
  P_ATTRIBUTE1               => P_TEMPLATE_REC.ATTRIBUTE1,
  P_ATTRIBUTE2               => P_TEMPLATE_REC.ATTRIBUTE2,
  P_ATTRIBUTE3               => P_TEMPLATE_REC.ATTRIBUTE3,
  P_ATTRIBUTE4               => P_TEMPLATE_REC.ATTRIBUTE4,
  P_ATTRIBUTE5               => P_TEMPLATE_REC.ATTRIBUTE5,
  P_ATTRIBUTE6               => P_TEMPLATE_REC.ATTRIBUTE6,
  P_ATTRIBUTE7               => P_TEMPLATE_REC.ATTRIBUTE7,
  P_ATTRIBUTE8               => P_TEMPLATE_REC.ATTRIBUTE8,
  P_ATTRIBUTE9               => P_TEMPLATE_REC.ATTRIBUTE9,
  P_ATTRIBUTE10              => P_TEMPLATE_REC.ATTRIBUTE10,
  P_ATTRIBUTE11              => P_TEMPLATE_REC.ATTRIBUTE11,
  P_ATTRIBUTE12              => P_TEMPLATE_REC.ATTRIBUTE12,
  P_ATTRIBUTE13              => P_TEMPLATE_REC.ATTRIBUTE13,
  P_ATTRIBUTE14              => P_TEMPLATE_REC.ATTRIBUTE14,
  P_ATTRIBUTE15              => P_TEMPLATE_REC.ATTRIBUTE15,
  P_ATTRIBUTE16              => P_TEMPLATE_REC.ATTRIBUTE16,
  P_ATTRIBUTE17              => P_TEMPLATE_REC.ATTRIBUTE17,
  P_ATTRIBUTE18              => P_TEMPLATE_REC.ATTRIBUTE18,
  P_ATTRIBUTE19              => P_TEMPLATE_REC.ATTRIBUTE19,
  P_ATTRIBUTE20              => P_TEMPLATE_REC.ATTRIBUTE20
  );

Line: 260

PROCEDURE Update_Template
(
 P_Api_Version_Number          IN         NUMBER,
 P_Init_Msg_List               IN         VARCHAR2     := FND_API.G_FALSE,
 P_Commit                      IN         VARCHAR2     := FND_API.G_FALSE,
 P_TEMPLATE_REC     IN          ASO_SUP_TEMPLATE_DATA_PVT.TEMPLATE_REC_TYPE,
 X_Return_Status               OUT NOCOPY /* file.sql.39 change */           VARCHAR2,
 X_Msg_Count                   OUT NOCOPY /* file.sql.39 change */           VARCHAR2,
 X_Msg_Data                    OUT NOCOPY /* file.sql.39 change */           VARCHAR2 )

IS

l_api_name                    VARCHAR2 ( 150 ) := 'UPDATE_TEMPLATE';

Line: 280

      SAVEPOINT UPDATE_TEMPLATE_PVT;

Line: 303

      aso_debug_pub.ADD ('UPDATE_TEMPLATE : Begin' , 1, 'N' );

Line: 304

     aso_debug_pub.add('UPDATE_TEMPLATE : p_template_context :'||P_TEMPLATE_REC.TEMPLATE_CONTEXT, 1, 'N');

Line: 305

     aso_debug_pub.add('UPDATE_TEMPLATE : p_template_level :'||P_TEMPLATE_REC.TEMPLATE_LEVEL, 1, 'N');

Line: 319

ASO_SUP_TEMPLATE_PKG.UPDATE_ROW (
  P_TEMPLATE_ID              => P_TEMPLATE_REC.TEMPLATE_ID,
  P_LAST_UPDATE_DATE         => P_TEMPLATE_REC.LAST_UPDATE_DATE ,
  P_LAST_UPDATED_BY          => P_TEMPLATE_REC.LAST_UPDATED_BY ,
  P_LAST_UPDATE_LOGIN        => P_TEMPLATE_REC.LAST_UPDATE_LOGIN ,
  P_TEMPLATE_NAME            => P_TEMPLATE_REC.TEMPLATE_NAME,
  P_DESCRIPTION              => P_TEMPLATE_REC.DESCRIPTION,
  P_TEMPLATE_LEVEL           => P_TEMPLATE_REC.TEMPLATE_LEVEL,
  P_TEMPLATE_CONTEXT         => P_TEMPLATE_REC.TEMPLATE_CONTEXT,
  p_context                  => P_TEMPLATE_REC.context,
  P_ATTRIBUTE1               => P_TEMPLATE_REC.ATTRIBUTE1,
  P_ATTRIBUTE2               => P_TEMPLATE_REC.ATTRIBUTE2,
  P_ATTRIBUTE3               => P_TEMPLATE_REC.ATTRIBUTE3,
  P_ATTRIBUTE4               => P_TEMPLATE_REC.ATTRIBUTE4,
  P_ATTRIBUTE5               => P_TEMPLATE_REC.ATTRIBUTE5,
  P_ATTRIBUTE6               => P_TEMPLATE_REC.ATTRIBUTE6,
  P_ATTRIBUTE7               => P_TEMPLATE_REC.ATTRIBUTE7,
  P_ATTRIBUTE8               => P_TEMPLATE_REC.ATTRIBUTE8,
  P_ATTRIBUTE9               => P_TEMPLATE_REC.ATTRIBUTE9,
  P_ATTRIBUTE10              => P_TEMPLATE_REC.ATTRIBUTE10,
  P_ATTRIBUTE11              => P_TEMPLATE_REC.ATTRIBUTE11,
  P_ATTRIBUTE12              => P_TEMPLATE_REC.ATTRIBUTE12,
  P_ATTRIBUTE13              => P_TEMPLATE_REC.ATTRIBUTE13,
  P_ATTRIBUTE14              => P_TEMPLATE_REC.ATTRIBUTE14,
  P_ATTRIBUTE15              => P_TEMPLATE_REC.ATTRIBUTE15,
  P_ATTRIBUTE16              => P_TEMPLATE_REC.ATTRIBUTE16,
  P_ATTRIBUTE17              => P_TEMPLATE_REC.ATTRIBUTE17,
  P_ATTRIBUTE18              => P_TEMPLATE_REC.ATTRIBUTE18,
  P_ATTRIBUTE19              => P_TEMPLATE_REC.ATTRIBUTE19,
  P_ATTRIBUTE20              => P_TEMPLATE_REC.ATTRIBUTE20
  );

Line: 359

      aso_debug_pub.ADD ( 'UPDATE_TEMPLATE:  end' , 1 , 'N' );

Line: 397

END Update_Template;