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_CHANGE_REQUESTS

Line 88: CURSOR get_creq_type_csr(cp_crs_id okl_vp_change_requests.id%TYPE)IS

84: -- abindal end --
85:
86: l_parent_object_id NUMBER;
87:
88: CURSOR get_creq_type_csr(cp_crs_id okl_vp_change_requests.id%TYPE)IS
89: SELECT change_type_code
90: ,chr_id
91: FROM okl_vp_change_requests
92: WHERE id = cp_crs_id;

Line 91: FROM okl_vp_change_requests

87:
88: CURSOR get_creq_type_csr(cp_crs_id okl_vp_change_requests.id%TYPE)IS
89: SELECT change_type_code
90: ,chr_id
91: FROM okl_vp_change_requests
92: WHERE id = cp_crs_id;
93: cv_get_creq_type get_creq_type_csr%ROWTYPE;
94:
95: CURSOR c_get_khr_id (cp_crs_id okl_vp_change_requests.id%TYPE)IS

Line 95: CURSOR c_get_khr_id (cp_crs_id okl_vp_change_requests.id%TYPE)IS

91: FROM okl_vp_change_requests
92: WHERE id = cp_crs_id;
93: cv_get_creq_type get_creq_type_csr%ROWTYPE;
94:
95: CURSOR c_get_khr_id (cp_crs_id okl_vp_change_requests.id%TYPE)IS
96: SELECT id
97: FROM okl_k_headers
98: WHERE crs_id = cp_crs_id;
99:

Line 260: lv_change_type_code okl_vp_change_requests.change_type_code%TYPE;

256: l_agrmnt_name OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
257: /* Manu 31-Aug-2005 Remove REFERENCE_NUMBER column */
258: -- l_appl_temp_name OKL_LEASEAPP_TEMPLATES_V.REFERENCE_NUMBER%TYPE;
259: l_appl_temp_name OKL_LEASEAPP_TMPLS.NAME%TYPE;
260: lv_change_type_code okl_vp_change_requests.change_type_code%TYPE;
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'

Line 329: CURSOR c_get_creq_info(cp_crs_id okl_vp_change_requests.id%TYPE) IS

325: SELECT contract_number
326: FROM OKC_K_HEADERS_B
327: WHERE id = cp_chr_id;
328:
329: CURSOR c_get_creq_info(cp_crs_id okl_vp_change_requests.id%TYPE) IS
330: SELECT change_type_code
331: FROM okl_vp_change_requests
332: WHERE id = cp_crs_id;
333:

Line 331: FROM okl_vp_change_requests

327: WHERE id = cp_chr_id;
328:
329: CURSOR c_get_creq_info(cp_crs_id okl_vp_change_requests.id%TYPE) IS
330: SELECT change_type_code
331: FROM okl_vp_change_requests
332: WHERE id = cp_crs_id;
333:
334: CURSOR c_get_agr_number(cp_crs_id okl_vp_change_requests.id%TYPE)IS
335: SELECT chr.contract_number

Line 334: CURSOR c_get_agr_number(cp_crs_id okl_vp_change_requests.id%TYPE)IS

330: SELECT change_type_code
331: FROM okl_vp_change_requests
332: WHERE id = cp_crs_id;
333:
334: CURSOR c_get_agr_number(cp_crs_id okl_vp_change_requests.id%TYPE)IS
335: SELECT chr.contract_number
336: FROM okc_k_headers_b chr,
337: okl_k_headers khr
338: WHERE chr.id = khr.id

Line 344: OKL_VP_CHANGE_REQUESTS chr

340:
341: CURSOR get_agreement_name(cp_crs_id IN NUMBER) IS
342: SELECT contract_number
343: FROM OKC_K_HEADERS_B okc,
344: OKL_VP_CHANGE_REQUESTS chr
345: WHERE chr.id = cp_crs_id
346: AND okc.id = chr.chr_id;
347: -- abindal end --
348:

Line 360: CURSOR c_chk_lat_dates1(cp_crs_id okl_vp_change_requests.id%TYPE

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

Line 439: -- for ASSOCIATION type of change request, the chr_id in the okl_vp_change_requests table is as good

435: OPEN c_get_agr_number(p_vasv_rec.crs_id);
436: FETCH c_get_agr_number INTO l_agrmnt_name;
437: CLOSE c_get_agr_number;
438: ELSIF('ASSOCIATION' = lv_change_type_code)THEN
439: -- for ASSOCIATION type of change request, the chr_id in the okl_vp_change_requests table is as good
440: OPEN get_agreement_name(p_vasv_rec.crs_id);
441: FETCH get_agreement_name INTO l_agrmnt_name;
442: CLOSE get_agreement_name;
443: END IF;