eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VP_ASSOCIATIONS_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 138: OR(TRUNC(NVL(p_vasv_rec.end_date, okl_accounting_util.g_final_date)) > TRUNC(NVL(lv_parent_end_date,okl_accounting_util.g_final_date)))

134: OPEN c_get_parent_dt_csr(l_parent_object_id);
135: FETCH c_get_parent_dt_csr INTO lv_parent_start_date,lv_parent_end_date,lv_contract_number;
136: CLOSE c_get_parent_dt_csr;
137: IF((TRUNC(p_vasv_rec.start_date) < TRUNC(lv_parent_start_date))
138: OR(TRUNC(NVL(p_vasv_rec.end_date, okl_accounting_util.g_final_date)) > TRUNC(NVL(lv_parent_end_date,okl_accounting_util.g_final_date)))
139: )THEN
140: IF(p_vasv_rec.assoc_object_type_code = 'LC_TEMPLATE')THEN
141: lv_message_name := G_LC_ASSOC_DATE_MISMATCH;
142: ELSIF(p_vasv_rec.assoc_object_type_code = 'LA_TEMPLATE')THEN

Line 357: AND ((trunc(start_date) BETWEEN trunc(cp_start_date) AND trunc(NVL(cp_end_date,okl_accounting_util.g_final_date))) OR

353: SELECT 'X'
354: FROM okl_vp_associations
355: WHERE chr_id = cp_chr_id
356: AND assoc_object_id = cp_object_id
357: AND ((trunc(start_date) BETWEEN trunc(cp_start_date) AND trunc(NVL(cp_end_date,okl_accounting_util.g_final_date))) OR
358: (trunc(cp_start_date) BETWEEN trunc(start_date) AND TRUNC(NVL(end_date,okl_accounting_util.g_final_date))));
359:
360: CURSOR c_chk_lat_dates1(cp_crs_id okl_vp_change_requests.id%TYPE
361: ,cp_object_id okl_vp_associations.assoc_object_id%TYPE

Line 358: (trunc(cp_start_date) BETWEEN trunc(start_date) AND TRUNC(NVL(end_date,okl_accounting_util.g_final_date))));

354: FROM okl_vp_associations
355: WHERE chr_id = cp_chr_id
356: AND assoc_object_id = cp_object_id
357: AND ((trunc(start_date) BETWEEN trunc(cp_start_date) AND trunc(NVL(cp_end_date,okl_accounting_util.g_final_date))) OR
358: (trunc(cp_start_date) BETWEEN trunc(start_date) AND TRUNC(NVL(end_date,okl_accounting_util.g_final_date))));
359:
360: CURSOR c_chk_lat_dates1(cp_crs_id okl_vp_change_requests.id%TYPE
361: ,cp_object_id okl_vp_associations.assoc_object_id%TYPE
362: ,cp_start_date okl_vp_associations.start_date%TYPE

Line 368: AND ((trunc(start_date) BETWEEN trunc(cp_start_date) AND trunc(NVL(cp_end_date,okl_accounting_util.g_final_date))) OR

364: SELECT 'X'
365: FROM okl_vp_associations
366: WHERE crs_id = cp_crs_id
367: AND assoc_object_id = cp_object_id
368: AND ((trunc(start_date) BETWEEN trunc(cp_start_date) AND trunc(NVL(cp_end_date,okl_accounting_util.g_final_date))) OR
369: (trunc(cp_start_date) BETWEEN trunc(start_date) AND TRUNC(NVL(end_date,okl_accounting_util.g_final_date))));
370:
371: BEGIN
372:

Line 369: (trunc(cp_start_date) BETWEEN trunc(start_date) AND TRUNC(NVL(end_date,okl_accounting_util.g_final_date))));

365: FROM okl_vp_associations
366: WHERE crs_id = cp_crs_id
367: AND assoc_object_id = cp_object_id
368: AND ((trunc(start_date) BETWEEN trunc(cp_start_date) AND trunc(NVL(cp_end_date,okl_accounting_util.g_final_date))) OR
369: (trunc(cp_start_date) BETWEEN trunc(start_date) AND TRUNC(NVL(end_date,okl_accounting_util.g_final_date))));
370:
371: BEGIN
372:
373: x_return_status := l_return_status;