APPS.JTF_RS_RESOURCE_SKILLS_PKG dependencies on JTF_RS_RESOURCE_SKILLS

Line 1: package body JTF_RS_RESOURCE_SKILLS_PKG as

1: package body JTF_RS_RESOURCE_SKILLS_PKG as
2: /* $Header: jtfrshkb.pls 120.0 2005/05/11 08:20:07 appldev ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 41: cursor C is select ROWID from JTF_RS_RESOURCE_SKILLS

37: X_LAST_UPDATE_DATE in DATE,
38: X_LAST_UPDATED_BY in NUMBER,
39: X_LAST_UPDATE_LOGIN in NUMBER
40: ) is
41: cursor C is select ROWID from JTF_RS_RESOURCE_SKILLS
42: where RESOURCE_SKILL_ID = X_RESOURCE_SKILL_ID
43: ;
44: begin
45: insert into JTF_RS_RESOURCE_SKILLS (

Line 45: insert into JTF_RS_RESOURCE_SKILLS (

41: cursor C is select ROWID from JTF_RS_RESOURCE_SKILLS
42: where RESOURCE_SKILL_ID = X_RESOURCE_SKILL_ID
43: ;
44: begin
45: insert into JTF_RS_RESOURCE_SKILLS (
46: RESOURCE_SKILL_ID,
47: RESOURCE_ID,
48: SKILL_LEVEL_ID,
49: CATEGORY_ID,

Line 133: from JTF_RS_RESOURCE_SKILLS

129: X_OBJECT_VERSION_NUMBER in NUMBER
130: ) is
131: cursor c is select
132: OBJECT_VERSION_NUMBER
133: from JTF_RS_RESOURCE_SKILLS
134: where RESOURCE_SKILL_ID = X_RESOURCE_SKILL_ID
135: and OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
136: for update of RESOURCE_SKILL_ID nowait;
137: recinfo c%rowtype;

Line 194: update JTF_RS_RESOURCE_SKILLS set

190: X_LAST_UPDATED_BY in NUMBER,
191: X_LAST_UPDATE_LOGIN in NUMBER
192: ) is
193: begin
194: update JTF_RS_RESOURCE_SKILLS set
195: RESOURCE_ID = X_RESOURCE_ID,
196: SKILL_LEVEL_ID = X_SKILL_LEVEL_ID,
197: CATEGORY_ID = X_CATEGORY_ID,
198: SUBCATEGORY = X_SUBCATEGORY,

Line 239: delete from JTF_RS_RESOURCE_SKILLS

235: X_RESOURCE_SKILL_ID in NUMBER
236: ) is
237: begin
238:
239: delete from JTF_RS_RESOURCE_SKILLS
240: where RESOURCE_SKILL_ID = X_RESOURCE_SKILL_ID;
241:
242: if (sql%notfound) then
243: raise no_data_found;

Line 247: end JTF_RS_RESOURCE_SKILLS_PKG;

243: raise no_data_found;
244: end if;
245: end DELETE_ROW;
246:
247: end JTF_RS_RESOURCE_SKILLS_PKG;