DBA Data[Home] [Help]

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 277: p_cnh_id IN okc_condition_headers_b.id%TYPE,

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

Line 278: p_dnz_chr_id IN okc_condition_headers_b.dnz_chr_id%TYPE ,

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:

Line 279: p_cnh_variance IN okc_condition_headers_b.cnh_variance%TYPE,

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:

Line 280: p_before_after IN okc_condition_headers_b.before_after%TYPE,

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

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

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

Line 290: l_variance okc_condition_headers_b.cnh_variance%TYPE;

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