DBA Data[Home] [Help]

APPS.JTF_RS_RES_AVAILABILITY_PVT dependencies on JTF_RS_RES_AVAILABILITY_PKG

Line 107: JTF_RS_RES_AVAILABILITY_PKG.INSERT_ROW(

103: SELECT jtf_rs_res_availability_s.nextval
104: INTO l_availability_id
105: FROM dual;
106:
107: JTF_RS_RES_AVAILABILITY_PKG.INSERT_ROW(
108: X_ROWID => l_rowid,
109: X_AVAILABILITY_ID => l_availability_id,
110: X_RESOURCE_ID => l_resource_id,
111: X_AVAILABLE_FLAG => P_AVAILABLE_FLAG,

Line 504: jtf_rs_res_availability_pkg.lock_row(

500: END IF;
501:
502: BEGIN
503:
504: jtf_rs_res_availability_pkg.lock_row(
505: x_availability_id => l_availability_id,
506: x_object_version_number => p_object_version_num
507: );
508:

Line 522: jtf_rs_res_availability_pkg.update_row(

518:
519:
520: l_object_version_number := l_object_version_number +1;
521:
522: jtf_rs_res_availability_pkg.update_row(
523: X_AVAILABILITY_ID => l_availability_id,
524: X_RESOURCE_ID => l_resource_id,
525: X_AVAILABLE_FLAG => l_AVAILABLE_FLAG,
526: X_REASON_CODE => l_REASON_CODE,

Line 654: JTF_RS_RES_AVAILABILITY_PKG.DELETE_ROW(

650: FETCH chk_res_exist_cur INTO chk_res_exist_rec;
651: IF (chk_res_exist_cur%FOUND)
652: THEN
653:
654: JTF_RS_RES_AVAILABILITY_PKG.DELETE_ROW(
655: X_AVAILABILITY_ID => l_availability_id);
656:
657: ELSIF (chk_res_exist_cur%notfound) THEN
658: x_return_status := fnd_api.g_ret_sts_error;