DBA Data[Home] [Help]

APPS.JTF_RS_SKILL_LEVELS_PKG dependencies on JTF_RS_SKILL_LEVELS_PKG

Line 1: package body JTF_RS_SKILL_LEVELS_PKG as

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

Line 384: JTF_RS_SKILL_LEVELS_PKG.INSERT_ROW(

380:
381: OPEN c_last_updated;
382: FETCH c_last_updated into l_last_updated_by;
383: IF c_last_updated%NOTFOUND THEN
384: JTF_RS_SKILL_LEVELS_PKG.INSERT_ROW(
385: X_ROWID => X_ROWID,
386: X_SKILL_LEVEL_ID => x_skill_level_id,
387: X_LEVEL_NAME => X_LEVEL_NAME,
388: X_LEVEL_DESC => X_LEVEL_DESC,

Line 414: JTF_RS_SKILL_LEVELS_PKG.UPDATE_ROW(

410: X_LAST_UPDATED_BY => l_user_id,
411: X_LAST_UPDATE_LOGIN => 0);
412: ELSIF c_last_updated%FOUND THEN
413: IF l_last_updated_by = 1 THEN
414: JTF_RS_SKILL_LEVELS_PKG.UPDATE_ROW(
415: X_SKILL_LEVEL_ID => X_SKILL_LEVEL_ID,
416: X_SKILL_LEVEL => X_SKILL_LEVEL,
417: X_LEVEL_NAME => X_LEVEL_NAME,
418: X_LEVEL_DESC => X_LEVEL_DESC,

Line 444: end JTF_RS_SKILL_LEVELS_PKG;

440: END IF;
441: CLOSE c_last_updated;
442: End LOAD_ROW;
443:
444: end JTF_RS_SKILL_LEVELS_PKG;