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,
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:
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,
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:
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;