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.
PACKAGE: APPS.JTF_RS_SKILL_LEVELS_PUB

Source


1 PACKAGE jtf_rs_skill_levels_pub AUTHID CURRENT_USER AS
2  /* $Header: jtfrsuss.pls 120.0 2005/05/11 08:22:51 appldev ship $ */
3 /*#
4  * Package containing procedures to maintain skill levels
5  * @rep:scope internal
6  * @rep:product JTF
7  * @rep:displayname Skill Level Package
8  * @rep:category BUSINESS_ENTITY JTF_RS_RESOURCE_SKILL_LEVEL
9  */
10 
11 
12   /*****************************************************************************************
13    This is a public API that user API will invoke.
14    It provides PROCEDUREs for managing seed data of jtf_rs_skill_levels_vl view
15    create, update and delete rows
16    Its main PROCEDUREs are as following:
17    Create skills
18    Update skills
19    Delete skills
20    Calls to these PROCEDUREs will call PROCEDUREs of jtf_rs_skill_levels_pvt
21    to do inserts, updates and deletes into tables.
22    ******************************************************************************************/
23 
24 
25 /* PROCEDURE to create the skill levels
26    based on input values passed by calling routines. */
27 
28 /*#
29  * Procedure to create a skill level
30  * @param P_API_VERSION API version number
31  * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
32  * @param P_COMMIT Flag to commit at the end of the procedure
33  * @param P_SKILL_LEVEL Skill level indicator (an integer)
34  * @param P_LEVEL_NAME Name of the skill level
35  * @param P_LEVEL_DESC Description of the skill level
36  * @param P_ATTRIBUTE1 Descriptive flexfield Attribute 1
37  * @param P_ATTRIBUTE2 Descriptive flexfield Attribute 2
38  * @param P_ATTRIBUTE3 Descriptive flexfield Attribute 3
39  * @param P_ATTRIBUTE4 Descriptive flexfield Attribute 4
40  * @param P_ATTRIBUTE5 Descriptive flexfield Attribute 5
41  * @param P_ATTRIBUTE6 Descriptive flexfield Attribute 6
42  * @param P_ATTRIBUTE7 Descriptive flexfield Attribute 7
43  * @param P_ATTRIBUTE8 Descriptive flexfield Attribute 8
44  * @param P_ATTRIBUTE9 Descriptive flexfield Attribute 9
45  * @param P_ATTRIBUTE10 Descriptive flexfield Attribute 10
46  * @param P_ATTRIBUTE11	Descriptive flexfield Attribute 11
47  * @param P_ATTRIBUTE12	Descriptive flexfield Attribute 12
48  * @param P_ATTRIBUTE13	Descriptive flexfield Attribute 13
49  * @param P_ATTRIBUTE14	Descriptive flexfield Attribute 14
50  * @param P_ATTRIBUTE15	Descriptive flexfield Attribute 15
51  * @param P_ATTRIBUTE_CATEGORY Descriptive flexfield attribute category
52  * @param X_RETURN_STATUS Output parameter for return status
53  * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
54  * @param X_MSG_DATA Output parameter containing last user message from this procedure
55  * @param X_SKILL_LEVEL_ID Output parameter containing internal unique id of the created skill level
56  * @rep:scope internal
57  * @rep:displayname Create Skill Level
58  */
59 PROCEDURE  create_skills
60   (P_API_VERSION          IN   NUMBER,
61    P_INIT_MSG_LIST        IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
62    P_COMMIT               IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
63    P_SKILL_LEVEL       IN   JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE,
64    P_LEVEL_NAME          IN   JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE,
65    P_LEVEL_DESC           IN   JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE   DEFAULT  NULL,
66    P_ATTRIBUTE1		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE   DEFAULT  NULL,
67    P_ATTRIBUTE2		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE   DEFAULT  NULL,
68    P_ATTRIBUTE3		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE   DEFAULT  NULL,
69    P_ATTRIBUTE4		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE   DEFAULT  NULL,
70    P_ATTRIBUTE5		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE   DEFAULT  NULL,
71    P_ATTRIBUTE6		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE   DEFAULT  NULL,
72    P_ATTRIBUTE7		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE   DEFAULT  NULL,
73    P_ATTRIBUTE8		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE   DEFAULT  NULL,
74    P_ATTRIBUTE9		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE   DEFAULT  NULL,
75    P_ATTRIBUTE10	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE   DEFAULT  NULL,
76    P_ATTRIBUTE11	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE   DEFAULT  NULL,
77    P_ATTRIBUTE12	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE   DEFAULT  NULL,
78    P_ATTRIBUTE13	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE   DEFAULT  NULL,
79    P_ATTRIBUTE14	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE   DEFAULT  NULL,
80    P_ATTRIBUTE15	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE   DEFAULT  NULL,
81    P_ATTRIBUTE_CATEGORY	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE   DEFAULT  NULL,
82    X_RETURN_STATUS        OUT NOCOPY  VARCHAR2,
83    X_MSG_COUNT            OUT NOCOPY  NUMBER,
84    X_MSG_DATA             OUT NOCOPY  VARCHAR2,
85    X_SKILL_LEVEL_ID      OUT NOCOPY JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE
86   );
87 
88  /* PROCEDURE to update skill levels
89 	based on input values passed by calling routines. */
90 
91 /*#
92  * Procedure to create a skill level
93  * @param P_API_VERSION API version number
94  * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
95  * @param P_COMMIT Flag to commit at the end of the procedure
96  * @param P_SKILL_LEVEL_ID Internal unique id of the skill level to update
97  * @param P_SKILL_LEVEL Skill level indicator (an integer)
98  * @param P_LEVEL_NAME Name of the skill level
99  * @param P_LEVEL_DESC Description of the skill level
100  * @param P_OBJECT_VERSION_NUM Object version number of the record to be updated
101  * @param P_ATTRIBUTE1 Descriptive flexfield Attribute 1
102  * @param P_ATTRIBUTE2 Descriptive flexfield Attribute 2
103  * @param P_ATTRIBUTE3 Descriptive flexfield Attribute 3
104  * @param P_ATTRIBUTE4 Descriptive flexfield Attribute 4
105  * @param P_ATTRIBUTE5 Descriptive flexfield Attribute 5
106  * @param P_ATTRIBUTE6 Descriptive flexfield Attribute 6
107  * @param P_ATTRIBUTE7 Descriptive flexfield Attribute 7
108  * @param P_ATTRIBUTE8 Descriptive flexfield Attribute 8
109  * @param P_ATTRIBUTE9 Descriptive flexfield Attribute 9
110  * @param P_ATTRIBUTE10 Descriptive flexfield Attribute 10
111  * @param P_ATTRIBUTE11	Descriptive flexfield Attribute 11
112  * @param P_ATTRIBUTE12	Descriptive flexfield Attribute 12
113  * @param P_ATTRIBUTE13	Descriptive flexfield Attribute 13
114  * @param P_ATTRIBUTE14	Descriptive flexfield Attribute 14
115  * @param P_ATTRIBUTE15	Descriptive flexfield Attribute 15
116  * @param P_ATTRIBUTE_CATEGORY Descriptive flexfield attribute category
117  * @param X_RETURN_STATUS Output parameter for return status
118  * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
119  * @param X_MSG_DATA Output parameter containing last user message from this procedure
120  * @rep:scope internal
121  * @rep:displayname Update Skill Level
122  */
123 PROCEDURE  update_skills
124   (P_API_VERSION          IN   NUMBER,
125    P_INIT_MSG_LIST        IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
126    P_COMMIT               IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
127    P_SKILL_LEVEL_ID      IN   JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE,
128    P_SKILL_LEVEL          IN   JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE   DEFAULT  FND_API.G_MISS_NUM,
129    P_LEVEL_NAME       IN   JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
130    P_LEVEL_DESC          IN   JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
131    P_OBJECT_VERSION_NUM   IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
132    P_ATTRIBUTE1		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
133 
134    P_ATTRIBUTE2		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
135    P_ATTRIBUTE3		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
136    P_ATTRIBUTE4		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
137    P_ATTRIBUTE5		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
138    P_ATTRIBUTE6		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
139    P_ATTRIBUTE7		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
140    P_ATTRIBUTE8		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
141    P_ATTRIBUTE9		  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
142    P_ATTRIBUTE10	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT  FND_API.G_MISS_CHAR,
143    P_ATTRIBUTE11	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT  FND_API.G_MISS_CHAR,
144    P_ATTRIBUTE12	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT  FND_API.G_MISS_CHAR,
145    P_ATTRIBUTE13	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT  FND_API.G_MISS_CHAR,
146    P_ATTRIBUTE14	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT  FND_API.G_MISS_CHAR,
147    P_ATTRIBUTE15	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT  FND_API.G_MISS_CHAR,
148    P_ATTRIBUTE_CATEGORY	  IN   JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT  FND_API.G_MISS_CHAR,
149    X_RETURN_STATUS       OUT NOCOPY    VARCHAR2,
150    X_MSG_COUNT           OUT NOCOPY    NUMBER,
151    X_MSG_DATA            OUT NOCOPY    VARCHAR2
152   );
153 
154 /* PROCEDURE to delete the skill levels */
155 
156 /*#
157  * Procedure to delete a skill level
158  * @param P_API_VERSION API version number
159  * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
160  * @param P_COMMIT Flag to commit at the end of the procedure
161  * @param P_SKILL_LEVEL_ID Internal unique id of the skill level to update
162  * @param P_OBJECT_VERSION_NUM Object version number of the record to be updated
163  * @param X_RETURN_STATUS Output parameter for return status
164  * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
165  * @param X_MSG_DATA Output parameter containing last user message from this procedure
166  * @rep:scope internal
167  * @rep:displayname Delete Skill Level
168  */
169 PROCEDURE  delete_skills
170   (P_API_VERSION          IN     NUMBER,
171    P_INIT_MSG_LIST        IN     VARCHAR2   DEFAULT  FND_API.G_FALSE,
172    P_COMMIT               IN     VARCHAR2   DEFAULT  FND_API.G_FALSE,
173    P_SKILL_LEVEL_ID             IN     JTF_RS_SKILL_LEVELS_B.skill_level_id%TYPE,
174    P_OBJECT_VERSION_NUM   IN     JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
175    X_RETURN_STATUS        OUT NOCOPY    VARCHAR2,
176    X_MSG_COUNT            OUT NOCOPY    NUMBER,
177    X_MSG_DATA             OUT NOCOPY    VARCHAR2
178   );
179 
180 END JTF_RS_SKILL_LEVELS_PUB;