APPS.OKL_TXL_ITM_INSTS_PVT dependencies on OKC_K_HEADERS_B

Line 38: p_chr_id IN okc_k_headers_b.id%TYPE,

34: -- End of comments
35:
36: PROCEDURE raise_business_event(p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2,
38: p_chr_id IN okc_k_headers_b.id%TYPE,
39: p_asset_id IN okc_k_lines_b.id%TYPE,
40: p_ser_num IN okl_txl_itm_insts.serial_number%TYPE,
41: p_event_name IN VARCHAR2,
42: x_return_status OUT NOCOPY VARCHAR2,

Line 98: l_chr_id okc_k_headers_b.id%TYPE;

94: SELECT dnz_chr_id
95: FROM okc_k_lines_b
96: WHERE id = p_cle_id;
97:
98: l_chr_id okc_k_headers_b.id%TYPE;
99: /*
100: * sjalasut aug 18, 04: added cursor to derive the dnz_chr_id from the dnz_cle_id
101: * to pass the parameters to the business event. END
102: */

Line 612: l_chr_id okc_k_headers_b.id%TYPE;

608: FROM okc_k_lines_b lines, okl_txl_itm_insts items
609: WHERE items.id = p_inst_id
610: AND lines.id = items.dnz_cle_id;
611:
612: l_chr_id okc_k_headers_b.id%TYPE;
613: l_cle_id okc_k_lines_b.id%TYPE;
614: l_ser_num okl_txl_itm_insts.serial_number%TYPE;
615:
616: /*

Line 958: FROM okc_k_headers_b chr,

954: l_api_name CONSTANT VARCHAR2(30) := 'RESET_ITEM_SRL_NUMBER';
955:
956: CURSOR chr_csr (p_chr_id IN NUMBER) IS
957: SELECT 'Y'
958: FROM okc_k_headers_b chr,
959: okc_statuses_b sts
960: WHERE chr.id = p_chr_id
961: AND sts.code = chr.sts_code
962: AND sts.ste_code IN ('SIGNED', 'ENTERED');