DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_SKILLS_PVT dependencies on JTF_RS_RESOURCE_SKILLS_PKG

Line 630: JTF_RS_RESOURCE_SKILLS_PKG.INSERT_ROW(

626: SELECT jtf_rs_resource_skills_s.nextval
627: INTO l_resource_skill_id
628: FROM dual;
629:
630: JTF_RS_RESOURCE_SKILLS_PKG.INSERT_ROW(
631: X_ROWID => l_rowid,
632: X_RESOURCE_SKILL_ID => l_resource_skill_id,
633: X_RESOURCE_ID => p_resource_id,
634: X_SKILL_LEVEL_ID => p_SKILL_LEVEL_ID,

Line 1066: jtf_rs_resource_skills_pkg.lock_row(

1062: -------------------------------------------------------------------------------------------
1063:
1064: BEGIN
1065:
1066: jtf_rs_resource_skills_pkg.lock_row(
1067: X_RESOURCE_SKILL_ID => l_resource_skill_id,
1068: X_OBJECT_VERSION_NUMBER => p_object_version_num
1069: );
1070:

Line 1083: jtf_rs_resource_skills_pkg.update_row(

1079: END;
1080:
1081: l_object_version_number := l_object_version_number +1;
1082:
1083: jtf_rs_resource_skills_pkg.update_row(
1084: X_RESOURCE_SKILL_ID => l_resource_skill_id,
1085: X_RESOURCE_ID => l_resource_id,
1086: X_SKILL_LEVEL_ID => l_SKILL_LEVEL_ID,
1087: X_CATEGORY_ID => l_category_id,

Line 1225: JTF_RS_RESOURCE_SKILLS_PKG.DELETE_ROW(

1221: FETCH chk_res_exist_cur INTO chk_res_exist_rec;
1222: IF (chk_res_exist_cur%FOUND)
1223: THEN
1224:
1225: JTF_RS_RESOURCE_SKILLS_PKG.DELETE_ROW(
1226: X_RESOURCE_SKILL_ID => l_resource_skill_id);
1227:
1228: ELSIF (chk_res_exist_cur%notfound) THEN
1229: x_return_status := fnd_api.g_ret_sts_error;