APPS.OKL_MLA_CREATE_UPDATE_PUB dependencies on OKC_K_HEADERS_B

Line 181: okc_k_headers_b chr

177:
178: CURSOR get_k_start_date_and_term_csr(l_chr_id NUMBER) IS
179: SELECT chr.start_date, khr.term_duration
180: FROM okl_k_headers khr,
181: okc_k_headers_b chr
182: WHERE khr.id = chr.id
183: AND chr.id = l_chr_id;
184: l_scs_code VARCHAR2(30);
185:

Line 188: From okc_k_headers_b

184: l_scs_code VARCHAR2(30);
185:
186: Cursor l_scs_csr is
187: Select scs_code
188: From okc_k_headers_b
189: where id = p_source_chr_id;
190:
191: BEGIN
192:

Line 274: From okc_k_headers_b

270: l_scs_code VARCHAR2(30);
271:
272: Cursor l_scs_csr is
273: Select scs_code
274: From okc_k_headers_b
275: where id = p_source_chr_id;
276: BEGIN
277:
278: --Call the old api in case of MASTER_LEASE agreement

Line 384: l_chr_id okc_k_headers_b.id%type := NULL;

380: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
381:
382: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
383: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
384: l_chr_id okc_k_headers_b.id%type := NULL;
385:
386: CURSOR c_vp_cpl_csr(p_source_id NUMBER) IS
387: SELECT id, object_version_number, sfwt_flag,
388: cpl_id, chr_id, cle_id,

Line 655: FROM okc_k_headers_b CHR

651:
652: -- cursor when only customer is selected
653: CURSOR l_source_chr_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2) IS
654: SELECT CHR.id
655: FROM okc_k_headers_b CHR
656: , okc_k_party_roles_b prl
657: WHERE prl.dnz_chr_id = CHR.id
658: AND prl.chr_id = CHR.id
659: AND CHR.scs_code = p_scs_code

Line 671: FROM okc_k_headers_b CHR,

667:
668: -- cursor when only customer and program is selected
669: CURSOR l_source_chr_prog_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2, l_prog_id NUMBER) IS
670: SELECT CHR.id
671: FROM okc_k_headers_b CHR,
672: okl_k_headers khr
673: , okc_k_party_roles_b prl
674: WHERE chr.id = khr.id
675: AND prl.dnz_chr_id = CHR.id

Line 691: FROM okc_k_headers_b CHR,

687:
688: -- cursor when only program is selected
689: CURSOR l_source_prog_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, l_prog_id NUMBER) IS
690: SELECT CHR.id
691: FROM okc_k_headers_b CHR,
692: okl_k_headers khr
693: WHERE chr.id = khr.id
694: AND CHR.scs_code = p_scs_code
695: AND CHR.chr_type = 'CYA'

Line 703: FROM okc_k_headers_b CHR

699: where vpaso.chr_id = l_prog_id);
700:
701: CURSOR l_src_chr_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2) IS
702: SELECT CHR.id
703: FROM okc_k_headers_b CHR
704: WHERE CHR.scs_code = p_scs_code
705: AND CHR.chr_type = 'CYA'
706: AND CHR.template_yn = p_temp_yn
707: AND CHR.contract_number = p_source_contract_number;

Line 722: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

718: AND NVL(chr.end_date,p_effective_from) >= p_effective_from
719: AND chr.contract_number = p_program_name;
720:
721:
722: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
723: l_object_code VARCHAR2(30) DEFAULT NULL;
724: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
725:
726: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 724: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

720:
721:
722: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
723: l_object_code VARCHAR2(30) DEFAULT NULL;
724: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
725:
726: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
727:
728: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 1146: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

1142:
1143: l_api_name VARCHAR2(30) := 'update_deal';
1144: l_api_version CONSTANT NUMBER := 1.0;
1145:
1146: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
1147: l_chr_id NUMBER;
1148: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1149: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1150: