APPS.OKL_MLA_CREATE_UPDATE_PUB dependencies on OKL_K_HEADERS_FULL_V

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 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