APPS.OKL_SRV_PVT dependencies on OKL_FE_STD_RT_TMP_VERS

Line 410: -- Procedure get_rec for OKL_FE_STD_RT_TMP_VERS

406: RETURN(x_return_status);
407: END validate_day_convention_code;
408:
409: --------------------------------------------------------------------------------
410: -- Procedure get_rec for OKL_FE_STD_RT_TMP_VERS
411: --------------------------------------------------------------------------------
412:
413: FUNCTION get_rec(p_srv_rec IN okl_srv_rec
414: ,x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_srv_rec IS

Line 451: FROM okl_fe_std_rt_tmp_vers

447: ,creation_date
448: ,last_updated_by
449: ,last_update_date
450: ,last_update_login
451: FROM okl_fe_std_rt_tmp_vers
452: WHERE okl_fe_std_rt_tmp_vers.std_rate_tmpl_ver_id = p_id;
453: l_srv_pk srv_pk_csr%ROWTYPE;
454: l_srv_rec okl_srv_rec;
455:

Line 452: WHERE okl_fe_std_rt_tmp_vers.std_rate_tmpl_ver_id = p_id;

448: ,last_updated_by
449: ,last_update_date
450: ,last_update_login
451: FROM okl_fe_std_rt_tmp_vers
452: WHERE okl_fe_std_rt_tmp_vers.std_rate_tmpl_ver_id = p_id;
453: l_srv_pk srv_pk_csr%ROWTYPE;
454: l_srv_rec okl_srv_rec;
455:
456: BEGIN

Line 825: FROM okl_fe_std_rt_tmp_vers

821: PRAGMA EXCEPTION_INIT(e_resource_busy, - 00054);
822:
823: CURSOR lock_csr(p_def_srv_rec IN okl_srv_rec) IS
824: SELECT object_version_number
825: FROM okl_fe_std_rt_tmp_vers
826: WHERE std_rate_tmpl_ver_id = p_def_srv_rec.std_rate_tmpl_ver_id
827: AND object_version_number = p_def_srv_rec.object_version_number
828: FOR UPDATE OF object_version_number NOWAIT;
829:

Line 832: FROM okl_fe_std_rt_tmp_vers

828: FOR UPDATE OF object_version_number NOWAIT;
829:
830: CURSOR lchk_csr(p_def_srv_rec IN okl_srv_rec) IS
831: SELECT object_version_number
832: FROM okl_fe_std_rt_tmp_vers
833: WHERE std_rate_tmpl_ver_id = p_def_srv_rec.std_rate_tmpl_ver_id;
834: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
835: l_object_version_number okl_fe_item_residual_all.object_version_number%TYPE;
836: lc_object_version_number okl_fe_item_residual_all.object_version_number%TYPE;

Line 1041: INSERT INTO okl_fe_std_rt_tmp_vers

1037: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1038: RAISE okl_api.g_exception_error;
1039: END IF;
1040:
1041: INSERT INTO okl_fe_std_rt_tmp_vers
1042: (std_rate_tmpl_ver_id
1043: ,object_version_number
1044: ,version_number
1045: ,std_rate_tmpl_id

Line 1489: UPDATE okl_fe_std_rt_tmp_vers

1485: ELSIF (l_return_status = g_ret_sts_error) THEN
1486: RAISE okl_api.g_exception_error;
1487: END IF;
1488:
1489: UPDATE okl_fe_std_rt_tmp_vers
1490: SET std_rate_tmpl_ver_id = l_def_srv_rec.std_rate_tmpl_ver_id
1491: ,object_version_number = l_def_srv_rec.object_version_number + 1
1492: ,version_number = l_def_srv_rec.version_number
1493: ,std_rate_tmpl_id = l_def_srv_rec.std_rate_tmpl_id

Line 1670: DELETE FROM okl_fe_std_rt_tmp_vers

1666: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1667: RAISE okl_api.g_exception_error;
1668: END IF;
1669:
1670: DELETE FROM okl_fe_std_rt_tmp_vers
1671: WHERE std_rate_tmpl_ver_id = l_srv_rec.std_rate_tmpl_ver_id;
1672:
1673: EXCEPTION
1674: WHEN g_exception_halt_validation THEN