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

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

Line: 7


   create, update and delete rows
   Its main procedures are as following:
   Create skills
   Update skills
   Delete skills
   Calls to these procedures will call procedures of jtf_rs_skill_levels_pvt
   to do inserts, updates and deletes into tables.
   ******************************************************************************************/

 /* Package variables. */

  G_PKG_NAME         VARCHAR2(30) := 'JTF_RS_SKILL_LEVELS_PUB';

Line: 24


   create, update and delete rows
   Its main procedures are as following:
   Create skills
   Update skills
   Delete skills
   Calls to these procedures will call procedures of jtf_rs_skill_levels_pvt
   to do inserts, updates and deletes into tables.
   ******************************************************************************************/


/* Procedure to create the skill levels
   based on input values passed by calling routines. */

  PROCEDURE  create_skills
  (P_API_VERSION          IN   NUMBER,
   P_INIT_MSG_LIST        IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
   P_COMMIT               IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
   P_SKILL_LEVEL       IN   JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE,
   P_LEVEL_NAME          IN   JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE,
   P_LEVEL_DESC           IN   JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE   DEFAULT  NULL,
   P_ATTRIBUTE1		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE   DEFAULT  NULL,
   P_ATTRIBUTE2		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE   DEFAULT  NULL,
   P_ATTRIBUTE3		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE   DEFAULT  NULL,
   P_ATTRIBUTE4		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE   DEFAULT  NULL,
   P_ATTRIBUTE5		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE   DEFAULT  NULL,
   P_ATTRIBUTE6		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE   DEFAULT  NULL,
   P_ATTRIBUTE7		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE   DEFAULT  NULL,
   P_ATTRIBUTE8		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE   DEFAULT  NULL,
   P_ATTRIBUTE9		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE   DEFAULT  NULL,
   P_ATTRIBUTE10	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE   DEFAULT  NULL,
   P_ATTRIBUTE11	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE   DEFAULT  NULL,
   P_ATTRIBUTE12	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE   DEFAULT  NULL,
   P_ATTRIBUTE13	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE   DEFAULT  NULL,
   P_ATTRIBUTE14	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE   DEFAULT  NULL,
   P_ATTRIBUTE15	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE   DEFAULT  NULL,
   P_ATTRIBUTE_CATEGORY	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE   DEFAULT  NULL,
   X_RETURN_STATUS        OUT NOCOPY  VARCHAR2,
   X_MSG_COUNT            OUT NOCOPY  NUMBER,
   X_MSG_DATA             OUT NOCOPY  VARCHAR2,
   X_SKILL_LEVEL_ID      OUT NOCOPY JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE
  )IS

  l_api_name    CONSTANT VARCHAR2(30) := 'CREATE_SKILLS';

Line: 167


  /* Procedure to update skill levels
	based on input values passed by calling routines. */

  PROCEDURE  update_skills
  (P_API_VERSION          IN   NUMBER,
   P_INIT_MSG_LIST        IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
   P_COMMIT               IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
   P_SKILL_LEVEL_ID      IN   JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE,
   P_SKILL_LEVEL          IN   JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE   DEFAULT  FND_API.G_MISS_NUM,
   P_LEVEL_NAME       IN   JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_LEVEL_DESC          IN   JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_OBJECT_VERSION_NUM   IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
   P_ATTRIBUTE1		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE2		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE3		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE4		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE5		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE6		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE7		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE8		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE9		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE10	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE11	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE12	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE13	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE14	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE15	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE_CATEGORY	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT  FND_API.G_MISS_CHAR,
   X_RETURN_STATUS       OUT NOCOPY    VARCHAR2,
   X_MSG_COUNT           OUT NOCOPY    NUMBER,
   X_MSG_DATA            OUT NOCOPY    VARCHAR2
  ) IS
  l_api_name    CONSTANT VARCHAR2(30) := 'UPDATE_SKILLS';

Line: 215


     SAVEPOINT UPDATE_SKILL_LEVELS_SP;

Line: 231


		 JTF_RS_SKILL_LEVELS_PVT.UPDATE_SKILLS(
                               P_API_VERSION            => l_api_version,
                               P_INIT_MSG_LIST          => p_init_msg_list,
                               P_COMMIT                 => p_commit,
                               P_SKILL_LEVEL_ID        => p_skill_level_id,
                               P_SKILL_LEVEL            => p_skill_level,
                               P_LEVEL_NAME         => p_level_name,
                               P_LEVEL_DESC            => p_level_desc,
                               P_OBJECT_VERSION_NUM     => l_object_version_number,
                               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_ATTRIBUTE_CATEGORY     => p_attribute_category,
                               X_RETURN_STATUS          => l_return_status,
                               X_MSG_COUNT              => l_msg_count,
                               X_MSG_DATA               => l_msg_data
                              );

Line: 277


      ROLLBACK TO UPDATE_SKILL_LEVELS_SP;

Line: 282


      ROLLBACK TO UPDATE_SKILL_LEVELS_SP;

Line: 287


      ROLLBACK TO UPDATE_SKILL_LEVELS_SP;

Line: 295


   END  update_skills;

Line: 298


  PROCEDURE  delete_skills
  (P_API_VERSION          IN     NUMBER,
   P_INIT_MSG_LIST        IN     VARCHAR2   DEFAULT  FND_API.G_FALSE,
   P_COMMIT               IN     VARCHAR2   DEFAULT  FND_API.G_FALSE,
   P_SKILL_LEVEL_ID             IN     JTF_RS_SKILL_LEVELS_B.skill_level_id%TYPE,
   P_OBJECT_VERSION_NUM   IN     JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
   X_RETURN_STATUS        OUT NOCOPY    VARCHAR2,
   X_MSG_COUNT            OUT NOCOPY    NUMBER,
   X_MSG_DATA             OUT NOCOPY    VARCHAR2
  )IS


  l_api_name    CONSTANT VARCHAR2(30) := 'DELETE_SKILLS';

Line: 324


     SAVEPOINT DELETE_SKILL_LEVELS_SP;

Line: 341


    JTF_RS_SKILL_LEVELS_PVT.DELETE_SKILLS
  (P_API_VERSION         => l_api_version,
   P_INIT_MSG_LIST       => p_init_msg_list,
   P_COMMIT              => p_commit,
   P_SKILL_LEVEL_ID     => p_skill_level_id,
   P_OBJECT_VERSION_NUM  => p_object_version_num,
   X_RETURN_STATUS       => l_return_status,
   X_MSG_COUNT           => l_msg_count,
   X_MSG_DATA            => l_msg_data
  );

Line: 366


      ROLLBACK TO DELETE_SKILL_LEVELS_SP;

Line: 370


      ROLLBACK TO DELETE_SKILL_LEVELS_SP;

Line: 374


      ROLLBACK TO DELETE_SKILL_LEVELS_SP;

Line: 383


 END delete_skills;