APPS.OKL_MLA_CREATE_UPDATE_PUB dependencies on OKL_K_HEADERS

Line 169: l_end_date OKL_K_HEADERS_FULL_V.END_DATE%TYPE DEFAULT NULL;

165: p_contract_number IN VARCHAR2,
166: p_source_chr_id IN NUMBER,
167: x_chr_id OUT NOCOPY NUMBER) AS
168:
169: l_end_date OKL_K_HEADERS_FULL_V.END_DATE%TYPE DEFAULT NULL;
170: l_start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE DEFAULT NULL;
171: l_term_duration OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE DEFAULT NULL;
172:
173: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 170: l_start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE DEFAULT NULL;

166: p_source_chr_id IN NUMBER,
167: x_chr_id OUT NOCOPY NUMBER) AS
168:
169: l_end_date OKL_K_HEADERS_FULL_V.END_DATE%TYPE DEFAULT NULL;
170: l_start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE DEFAULT NULL;
171: l_term_duration OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE DEFAULT NULL;
172:
173: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
174: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 171: l_term_duration OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE DEFAULT NULL;

167: x_chr_id OUT NOCOPY NUMBER) AS
168:
169: l_end_date OKL_K_HEADERS_FULL_V.END_DATE%TYPE DEFAULT NULL;
170: l_start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE DEFAULT NULL;
171: l_term_duration OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE DEFAULT NULL;
172:
173: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
174: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
175: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

Line 180: FROM okl_k_headers khr,

176: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
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);

Line 672: okl_k_headers khr

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
676: AND prl.chr_id = CHR.id

Line 692: okl_k_headers khr

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'
696: AND NVL(CHR.template_yn,'N') = p_temp_yn

Line 712: FROM okl_k_headers_full_v chr

708:
709:
710: CURSOR l_program_csr IS
711: SELECT chr.id
712: FROM okl_k_headers_full_v chr
713: WHERE chr.scs_code = 'PROGRAM'
714: AND nvl(chr.template_yn, 'N') = 'N'
715: AND chr.sts_code = 'ACTIVE'
716: AND chr.authoring_org_id = p_org_id