APPS.OKC_EXP_DATE_ASMBLR_PVT dependencies on OKC_CONDITION_HEADERS_B

Line 14: p_cnh_id IN okc_condition_headers_b.id%TYPE,

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

Line 15: p_dnz_chr_id IN okc_condition_headers_b.dnz_chr_id%TYPE ,

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:

Line 16: p_cnh_variance IN okc_condition_headers_b.cnh_variance%TYPE,

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:

Line 17: p_before_after IN okc_condition_headers_b.before_after%TYPE,

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

Line 18: p_last_rundate IN okc_condition_headers_b.last_rundate%TYPE) IS

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;

Line 26: l_variance okc_condition_headers_b.cnh_variance%TYPE;

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

Line 293: p_cnh_id IN okc_condition_headers_b.id%TYPE,

289: p_init_msg_list IN VARCHAR2 ,
290: x_return_status OUT NOCOPY VARCHAR2,
291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_cnh_id IN okc_condition_headers_b.id%TYPE,
294: p_dnz_chr_id IN okc_condition_headers_b.dnz_chr_id%TYPE ,
295: p_cnh_variance IN okc_condition_headers_b.cnh_variance%TYPE,
296: p_before_after IN okc_condition_headers_b.before_after%TYPE,
297: p_last_rundate IN okc_condition_headers_b.last_rundate%TYPE) IS

Line 294: p_dnz_chr_id IN okc_condition_headers_b.dnz_chr_id%TYPE ,

290: x_return_status OUT NOCOPY VARCHAR2,
291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_cnh_id IN okc_condition_headers_b.id%TYPE,
294: p_dnz_chr_id IN okc_condition_headers_b.dnz_chr_id%TYPE ,
295: p_cnh_variance IN okc_condition_headers_b.cnh_variance%TYPE,
296: p_before_after IN okc_condition_headers_b.before_after%TYPE,
297: p_last_rundate IN okc_condition_headers_b.last_rundate%TYPE) IS
298:

Line 295: p_cnh_variance IN okc_condition_headers_b.cnh_variance%TYPE,

291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_cnh_id IN okc_condition_headers_b.id%TYPE,
294: p_dnz_chr_id IN okc_condition_headers_b.dnz_chr_id%TYPE ,
295: p_cnh_variance IN okc_condition_headers_b.cnh_variance%TYPE,
296: p_before_after IN okc_condition_headers_b.before_after%TYPE,
297: p_last_rundate IN okc_condition_headers_b.last_rundate%TYPE) IS
298:
299:

Line 296: p_before_after IN okc_condition_headers_b.before_after%TYPE,

292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_cnh_id IN okc_condition_headers_b.id%TYPE,
294: p_dnz_chr_id IN okc_condition_headers_b.dnz_chr_id%TYPE ,
295: p_cnh_variance IN okc_condition_headers_b.cnh_variance%TYPE,
296: p_before_after IN okc_condition_headers_b.before_after%TYPE,
297: p_last_rundate IN okc_condition_headers_b.last_rundate%TYPE) IS
298:
299:
300: -- l_api_name CONSTANT VARCHAR2(30) := 'exp_lines_date_assemble';

Line 297: p_last_rundate IN okc_condition_headers_b.last_rundate%TYPE) IS

293: p_cnh_id IN okc_condition_headers_b.id%TYPE,
294: p_dnz_chr_id IN okc_condition_headers_b.dnz_chr_id%TYPE ,
295: p_cnh_variance IN okc_condition_headers_b.cnh_variance%TYPE,
296: p_before_after IN okc_condition_headers_b.before_after%TYPE,
297: p_last_rundate IN okc_condition_headers_b.last_rundate%TYPE) IS
298:
299:
300: -- l_api_name CONSTANT VARCHAR2(30) := 'exp_lines_date_assemble';
301: l_api_name CONSTANT VARCHAR2(30) := 'exp_ln_date_ass';

Line 306: l_variance okc_condition_headers_b.cnh_variance%TYPE;

302: l_api_version CONSTANT NUMBER := 1.0;
303: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
304: k NUMBER;
305: l_last_rundate DATE;
306: l_variance okc_condition_headers_b.cnh_variance%TYPE;
307: --l_corrid_rec okc_aq_pub.corrid_rec_typ;
308: l_msg_tbl okc_aq_pub.msg_tab_typ;
309: l_element_name okc_action_attributes_b.element_name%TYPE;
310: l_element_value VARCHAR2(100);