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 OKC_K_HEADERS_B

Line 24: ,okc_k_headers_b chr

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'
28: AND assoc.assoc_object_id = p_vasv_rec.assoc_object_id

Line 35: lv_contract_number okc_k_headers_b.contract_number%TYPE;

31: AND (
32: (trunc(p_vasv_rec.start_date) BETWEEN trunc(assoc.start_date) AND trunc(nvl(assoc.end_date,okl_api.g_miss_date))) OR
33: (trunc(assoc.start_date) BETWEEN trunc(p_vasv_rec.start_date) AND trunc(nvl(p_vasv_rec.end_date,okl_api.g_miss_date)))
34: );
35: lv_contract_number okc_k_headers_b.contract_number%TYPE;
36: BEGIN
37: x_return_status := OKL_API.G_RET_STS_SUCCESS;
38: IF(p_vasv_rec.assoc_object_type_code = 'LC_TEMPLATE')THEN
39: OPEN c_is_uniq_csr;

Line 65: FROM okc_k_headers_b

61: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
62:
63: CURSOR lc_dates_csr (p_object_id IN NUMBER) IS
64: SELECT start_date, end_date
65: FROM okc_k_headers_b
66: WHERE id = p_object_id
67: AND scs_code = 'LEASE'
68: AND template_yn= 'Y';
69:

Line 100: CURSOR c_get_parent_dt_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS

96: SELECT id
97: FROM okl_k_headers
98: WHERE crs_id = cp_crs_id;
99:
100: CURSOR c_get_parent_dt_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
101: SELECT start_date
102: ,end_date
103: ,contract_number
104: FROM okc_k_headers_b

Line 104: FROM okc_k_headers_b

100: CURSOR c_get_parent_dt_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
101: SELECT start_date
102: ,end_date
103: ,contract_number
104: FROM okc_k_headers_b
105: WHERE id = cp_chr_id;
106:
107: lv_parent_start_date okc_k_headers_b.start_date%TYPE;
108: lv_parent_end_date okc_k_headers_b.end_date%TYPE;

Line 107: lv_parent_start_date okc_k_headers_b.start_date%TYPE;

103: ,contract_number
104: FROM okc_k_headers_b
105: WHERE id = cp_chr_id;
106:
107: lv_parent_start_date okc_k_headers_b.start_date%TYPE;
108: lv_parent_end_date okc_k_headers_b.end_date%TYPE;
109: lv_contract_number okc_k_headers_b.contract_number%TYPE;
110: lv_message_name fnd_new_messages.message_name%TYPE;
111:

Line 108: lv_parent_end_date okc_k_headers_b.end_date%TYPE;

104: FROM okc_k_headers_b
105: WHERE id = cp_chr_id;
106:
107: lv_parent_start_date okc_k_headers_b.start_date%TYPE;
108: lv_parent_end_date okc_k_headers_b.end_date%TYPE;
109: lv_contract_number okc_k_headers_b.contract_number%TYPE;
110: lv_message_name fnd_new_messages.message_name%TYPE;
111:
112: BEGIN

Line 109: lv_contract_number okc_k_headers_b.contract_number%TYPE;

105: WHERE id = cp_chr_id;
106:
107: lv_parent_start_date okc_k_headers_b.start_date%TYPE;
108: lv_parent_end_date okc_k_headers_b.end_date%TYPE;
109: lv_contract_number okc_k_headers_b.contract_number%TYPE;
110: lv_message_name fnd_new_messages.message_name%TYPE;
111:
112: BEGIN
113: x_return_status := l_return_status;

Line 256: l_agrmnt_name OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

252: l_credit_class OKL_LEASEAPP_TMPLS.CUST_CREDIT_CLASSIFICATION%TYPE;
253: l_credit_purpose OKL_LEASEAPP_TMPLS.CREDIT_REVIEW_PURPOSE%TYPE;
254: -- l_sic_code OKL_LEASEAPP_TEMPLATES_V.APPLICATION_TYPE%TYPE;
255: l_sic_code OKL_LEASEAPP_TMPLS.INDUSTRY_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;

Line 326: FROM OKC_K_HEADERS_B

322: AND lat.industry_code = cp_sic_code;
323:
324: CURSOR get_agrmnt_name(cp_chr_id IN NUMBER) 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

Line 336: FROM okc_k_headers_b chr,

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
339: AND khr.crs_id = cp_crs_id;
340:

Line 343: FROM OKC_K_HEADERS_B okc,

339: AND khr.crs_id = cp_crs_id;
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 --

Line 349: CURSOR c_chk_lat_dates(cp_chr_id okc_k_headers_b.id%TYPE

345: WHERE chr.id = cp_crs_id
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'