10: p_init_msg_list IN VARCHAR2 ,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2,
14: p_cnh_id IN okc_condition_headers_b.id%TYPE,
15: p_dnz_chr_id IN okc_condition_headers_b.dnz_chr_id%TYPE ,
16: p_cnh_variance IN okc_condition_headers_b.cnh_variance%TYPE,
17: p_before_after IN okc_condition_headers_b.before_after%TYPE,
18: p_last_rundate IN okc_condition_headers_b.last_rundate%TYPE) IS
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2,
14: p_cnh_id IN okc_condition_headers_b.id%TYPE,
15: p_dnz_chr_id IN okc_condition_headers_b.dnz_chr_id%TYPE ,
16: p_cnh_variance IN okc_condition_headers_b.cnh_variance%TYPE,
17: p_before_after IN okc_condition_headers_b.before_after%TYPE,
18: p_last_rundate IN okc_condition_headers_b.last_rundate%TYPE) IS
19:
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2,
14: p_cnh_id IN okc_condition_headers_b.id%TYPE,
15: p_dnz_chr_id IN okc_condition_headers_b.dnz_chr_id%TYPE ,
16: p_cnh_variance IN okc_condition_headers_b.cnh_variance%TYPE,
17: p_before_after IN okc_condition_headers_b.before_after%TYPE,
18: p_last_rundate IN okc_condition_headers_b.last_rundate%TYPE) IS
19:
20:
13: x_msg_data OUT NOCOPY VARCHAR2,
14: p_cnh_id IN okc_condition_headers_b.id%TYPE,
15: p_dnz_chr_id IN okc_condition_headers_b.dnz_chr_id%TYPE ,
16: p_cnh_variance IN okc_condition_headers_b.cnh_variance%TYPE,
17: p_before_after IN okc_condition_headers_b.before_after%TYPE,
18: p_last_rundate IN okc_condition_headers_b.last_rundate%TYPE) IS
19:
20:
21: l_api_name CONSTANT VARCHAR2(30) := 'exp_date_assemble';
14: p_cnh_id IN okc_condition_headers_b.id%TYPE,
15: p_dnz_chr_id IN okc_condition_headers_b.dnz_chr_id%TYPE ,
16: p_cnh_variance IN okc_condition_headers_b.cnh_variance%TYPE,
17: p_before_after IN okc_condition_headers_b.before_after%TYPE,
18: p_last_rundate IN okc_condition_headers_b.last_rundate%TYPE) IS
19:
20:
21: l_api_name CONSTANT VARCHAR2(30) := 'exp_date_assemble';
22: l_api_version CONSTANT NUMBER := 1.0;
22: l_api_version CONSTANT NUMBER := 1.0;
23: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
24: k NUMBER;
25: l_last_rundate DATE;
26: l_variance okc_condition_headers_b.cnh_variance%TYPE;
27: --l_corrid_rec okc_aq_pub.corrid_rec_typ;
28: l_msg_tbl okc_aq_pub.msg_tab_typ;
29: l_element_name okc_action_attributes_b.element_name%TYPE;
30: l_element_value VARCHAR2(100);
273: p_init_msg_list IN VARCHAR2 ,
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,
276: x_msg_data OUT NOCOPY VARCHAR2,
277: p_cnh_id IN okc_condition_headers_b.id%TYPE,
278: p_dnz_chr_id IN okc_condition_headers_b.dnz_chr_id%TYPE ,
279: p_cnh_variance IN okc_condition_headers_b.cnh_variance%TYPE,
280: p_before_after IN okc_condition_headers_b.before_after%TYPE,
281: p_last_rundate IN okc_condition_headers_b.last_rundate%TYPE) IS
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,
276: x_msg_data OUT NOCOPY VARCHAR2,
277: p_cnh_id IN okc_condition_headers_b.id%TYPE,
278: p_dnz_chr_id IN okc_condition_headers_b.dnz_chr_id%TYPE ,
279: p_cnh_variance IN okc_condition_headers_b.cnh_variance%TYPE,
280: p_before_after IN okc_condition_headers_b.before_after%TYPE,
281: p_last_rundate IN okc_condition_headers_b.last_rundate%TYPE) IS
282:
275: x_msg_count OUT NOCOPY NUMBER,
276: x_msg_data OUT NOCOPY VARCHAR2,
277: p_cnh_id IN okc_condition_headers_b.id%TYPE,
278: p_dnz_chr_id IN okc_condition_headers_b.dnz_chr_id%TYPE ,
279: p_cnh_variance IN okc_condition_headers_b.cnh_variance%TYPE,
280: p_before_after IN okc_condition_headers_b.before_after%TYPE,
281: p_last_rundate IN okc_condition_headers_b.last_rundate%TYPE) IS
282:
283:
276: x_msg_data OUT NOCOPY VARCHAR2,
277: p_cnh_id IN okc_condition_headers_b.id%TYPE,
278: p_dnz_chr_id IN okc_condition_headers_b.dnz_chr_id%TYPE ,
279: p_cnh_variance IN okc_condition_headers_b.cnh_variance%TYPE,
280: p_before_after IN okc_condition_headers_b.before_after%TYPE,
281: p_last_rundate IN okc_condition_headers_b.last_rundate%TYPE) IS
282:
283:
284: -- l_api_name CONSTANT VARCHAR2(30) := 'exp_lines_date_assemble';
277: p_cnh_id IN okc_condition_headers_b.id%TYPE,
278: p_dnz_chr_id IN okc_condition_headers_b.dnz_chr_id%TYPE ,
279: p_cnh_variance IN okc_condition_headers_b.cnh_variance%TYPE,
280: p_before_after IN okc_condition_headers_b.before_after%TYPE,
281: p_last_rundate IN okc_condition_headers_b.last_rundate%TYPE) IS
282:
283:
284: -- l_api_name CONSTANT VARCHAR2(30) := 'exp_lines_date_assemble';
285: l_api_name CONSTANT VARCHAR2(30) := 'exp_ln_date_ass';
286: l_api_version CONSTANT NUMBER := 1.0;
287: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
288: k NUMBER;
289: l_last_rundate DATE;
290: l_variance okc_condition_headers_b.cnh_variance%TYPE;
291: --l_corrid_rec okc_aq_pub.corrid_rec_typ;
292: l_msg_tbl okc_aq_pub.msg_tab_typ;
293: l_element_name okc_action_attributes_b.element_name%TYPE;
294: l_element_value VARCHAR2(100);