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_VP_ASSOCIATIONS

Line 1: PACKAGE BODY OKL_VP_ASSOCIATIONS_PVT AS

1: PACKAGE BODY OKL_VP_ASSOCIATIONS_PVT AS
2: /* $Header: OKLRVASB.pls 120.12 2006/07/11 10:07:18 dkagrawa noship $ */
3:
4: G_LA_ASSOC_DATE_MISMATCH CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_LA_ASSOC_DATES_MSMTCH';
5: G_LC_ASSOC_DATE_MISMATCH CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_LC_ASSOC_DATES_MSMTCH';

Line 23: FROM okl_vp_associations assoc

19:
20: -- cursor to check uniqueness for lease contract templates
21: CURSOR c_is_uniq_csr IS
22: SELECT chr.contract_number
23: FROM okl_vp_associations assoc
24: ,okc_k_headers_b chr
25: WHERE assoc.chr_id = p_vasv_rec.chr_id
26: AND assoc.assoc_object_id = chr.id
27: AND chr.scs_code = 'LEASE'

Line 265: FROM okl_vp_associations

261: -- abindal end --
262:
263: CURSOR check_duplicate_csr (p_chr_id NUMBER, p_assoc_obj_id NUMBER, p_start_date DATE, p_end_date DATE) IS
264: SELECT '1'
265: FROM okl_vp_associations
266: WHERE chr_id = p_chr_id
267: AND assoc_object_id = p_assoc_obj_id
268: AND start_date <= p_start_date
269: AND nvl(end_date,sysdate) >= nvl(p_end_date,sysdate);

Line 273: FROM okl_vp_associations

269: AND nvl(end_date,sysdate) >= nvl(p_end_date,sysdate);
270:
271: CURSOR check_duplicate_csr1 (p_crs_id NUMBER, p_assoc_obj_id NUMBER, p_start_date DATE, p_end_date DATE) IS
272: SELECT '1'
273: FROM okl_vp_associations
274: WHERE crs_id = p_crs_id
275: AND assoc_object_id = p_assoc_obj_id
276: AND start_date <= p_start_date
277: AND nvl(end_date,sysdate) >= nvl(p_end_date,sysdate);

Line 299: okl_vp_associations_v vpa

295: CURSOR get_la_assoc_chr_rec(cp_chr_id IN NUMBER, -- cp_appl_type IN VARCHAR2,
296: cp_credit_class IN VARCHAR2, cp_credit_review IN VARCHAR2, cp_sic_code IN VARCHAR2)IS
297: SELECT 'X'
298: FROM OKL_LEASEAPP_TMPLS lat,
299: okl_vp_associations_v vpa
300: WHERE lat.id = vpa.assoc_object_id
301: AND vpa.assoc_object_type_code = 'LA_TEMPLATE'
302: AND vpa.chr_id = cp_chr_id
303: AND lat.cust_credit_classification = cp_credit_class

Line 312: okl_vp_associations_v vpa

308: CURSOR get_la_assoc_crs_rec(cp_crs_id IN NUMBER, -- cp_appl_type IN VARCHAR2,
309: cp_credit_class IN VARCHAR2, cp_credit_review IN VARCHAR2, cp_sic_code IN VARCHAR2)IS
310: SELECT 'X'
311: FROM OKL_LEASEAPP_TMPLS lat,
312: okl_vp_associations_v vpa
313: WHERE lat.id = vpa.assoc_object_id
314: AND vpa.assoc_object_type_code = 'LA_TEMPLATE'
315: AND vpa.crs_id = cp_crs_id
316: -- Manu 02-Sep-2005 remove references to APPLICATION_TYPE

Line 350: ,cp_object_id okl_vp_associations.assoc_object_id%TYPE

346: AND okc.id = chr.chr_id;
347: -- abindal end --
348:
349: CURSOR c_chk_lat_dates(cp_chr_id okc_k_headers_b.id%TYPE
350: ,cp_object_id okl_vp_associations.assoc_object_id%TYPE
351: ,cp_start_date okl_vp_associations.start_date%TYPE
352: ,cp_end_date okl_vp_associations.end_date%TYPE)IS
353: SELECT 'X'
354: FROM okl_vp_associations

Line 351: ,cp_start_date okl_vp_associations.start_date%TYPE

347: -- abindal end --
348:
349: CURSOR c_chk_lat_dates(cp_chr_id okc_k_headers_b.id%TYPE
350: ,cp_object_id okl_vp_associations.assoc_object_id%TYPE
351: ,cp_start_date okl_vp_associations.start_date%TYPE
352: ,cp_end_date okl_vp_associations.end_date%TYPE)IS
353: SELECT 'X'
354: FROM okl_vp_associations
355: WHERE chr_id = cp_chr_id

Line 352: ,cp_end_date okl_vp_associations.end_date%TYPE)IS

348:
349: CURSOR c_chk_lat_dates(cp_chr_id okc_k_headers_b.id%TYPE
350: ,cp_object_id okl_vp_associations.assoc_object_id%TYPE
351: ,cp_start_date okl_vp_associations.start_date%TYPE
352: ,cp_end_date okl_vp_associations.end_date%TYPE)IS
353: SELECT 'X'
354: FROM okl_vp_associations
355: WHERE chr_id = cp_chr_id
356: AND assoc_object_id = cp_object_id

Line 354: FROM okl_vp_associations

350: ,cp_object_id okl_vp_associations.assoc_object_id%TYPE
351: ,cp_start_date okl_vp_associations.start_date%TYPE
352: ,cp_end_date okl_vp_associations.end_date%TYPE)IS
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))));

Line 361: ,cp_object_id okl_vp_associations.assoc_object_id%TYPE

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
363: ,cp_end_date okl_vp_associations.end_date%TYPE)IS
364: SELECT 'X'
365: FROM okl_vp_associations

Line 362: ,cp_start_date okl_vp_associations.start_date%TYPE

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
363: ,cp_end_date okl_vp_associations.end_date%TYPE)IS
364: SELECT 'X'
365: FROM okl_vp_associations
366: WHERE crs_id = cp_crs_id

Line 363: ,cp_end_date okl_vp_associations.end_date%TYPE)IS

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
363: ,cp_end_date okl_vp_associations.end_date%TYPE)IS
364: SELECT 'X'
365: FROM okl_vp_associations
366: WHERE crs_id = cp_crs_id
367: AND assoc_object_id = cp_object_id

Line 365: FROM okl_vp_associations

361: ,cp_object_id okl_vp_associations.assoc_object_id%TYPE
362: ,cp_start_date okl_vp_associations.start_date%TYPE
363: ,cp_end_date okl_vp_associations.end_date%TYPE)IS
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))));

Line 763: l_chr_id OKL_VP_ASSOCIATIONS.CHR_ID%TYPE;

759: p_vasv_rec IN vasv_rec_type
760: ) IS
761: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_VP_ASSOCIATIONS';
762: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
763: l_chr_id OKL_VP_ASSOCIATIONS.CHR_ID%TYPE;
764:
765:
766: CURSOR cur_get_chr_id IS
767: SELECT chr_id

Line 768: FROM okl_vp_associations

764:
765:
766: CURSOR cur_get_chr_id IS
767: SELECT chr_id
768: FROM okl_vp_associations
769: WHERE id = p_vasv_rec.id;
770:
771: BEGIN
772: x_return_status := l_return_status;

Line 1310: FROM okl_vp_associations

1306: description,
1307: assoc_object_type_code,
1308: assoc_object_id,
1309: assoc_object_version
1310: FROM okl_vp_associations
1311: WHERE id = p_id;
1312:
1313: l_vasv_rec vasv_rec_type;
1314: BEGIN

Line 1478: FROM okl_vp_associations

1474: description,
1475: assoc_object_type_code,
1476: assoc_object_id,
1477: assoc_object_version
1478: FROM okl_vp_associations
1479: WHERE chr_id = p_chr_id
1480: AND crs_id IS NULL;
1481:
1482: l_vasv_tbl vasv_tbl_type;

Line 1566: END OKL_VP_ASSOCIATIONS_PVT;

1562: END copy_crs_associations;
1563:
1564:
1565:
1566: END OKL_VP_ASSOCIATIONS_PVT;