APPS.JTF_RS_SKILL_LEVELS_PVT dependencies on JTF_RS_SKILL_LEVELS_PKG

Line 176: JTF_RS_SKILL_LEVELS_PKG.INSERT_ROW(

172: SELECT jtf_rs_skill_levels_s.nextval
173: INTO l_skill_level_id
174: FROM dual;
175:
176: JTF_RS_SKILL_LEVELS_PKG.INSERT_ROW(
177: X_ROWID => l_rowid,
178: X_SKILL_LEVEL_ID => l_skill_level_id,
179: X_SKILL_LEVEL => p_skill_level,
180: X_LEVEL_NAME => p_level_name,

Line 499: jtf_rs_skill_levels_pkg.lock_row(

495:
496:
497: BEGIN
498:
499: jtf_rs_skill_levels_pkg.lock_row(
500: X_SKILL_LEVEL_ID => l_skill_level_id,
501: X_OBJECT_VERSION_NUMBER => l_object_version_number
502: );
503:

Line 517: jtf_rs_skill_levels_pkg.update_row(

513:
514:
515: l_object_version_number := l_object_version_number +1;
516:
517: jtf_rs_skill_levels_pkg.update_row(
518: X_SKILL_LEVEL_ID => l_skill_level_id,
519: X_SKILL_LEVEL => l_skill_level,
520: X_LEVEL_NAME => l_level_name,
521: X_LEVEL_DESC => l_level_desc,

Line 655: jtf_rs_skill_levels_pkg.lock_row(

651: CLOSE chk_skill_exist_cur;
652:
653: BEGIN
654:
655: jtf_rs_skill_levels_pkg.lock_row(
656: X_SKILL_LEVEL_ID => l_skill_level_id,
657: X_OBJECT_VERSION_NUMBER => p_object_version_num
658: );
659:

Line 670: JTF_RS_SKILL_LEVELS_PKG.DELETE_ROW(

666: RAISE fnd_api.g_exc_error;
667:
668: END;
669:
670: JTF_RS_SKILL_LEVELS_PKG.DELETE_ROW(
671: X_SKILL_LEVEL_ID => l_skill_level_id);
672:
673: ELSIF (chk_skill_exist_cur%notfound) THEN
674: CLOSE chk_skill_exist_cur;