eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_TXL_ITM_INSTS_PVT dependencies on OKC_K_LINES_B

Line 39: p_asset_id IN okc_k_lines_b.id%TYPE,

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,
43: x_msg_count OUT NOCOPY NUMBER,

Line 93: CURSOR get_chr_id (p_cle_id okc_k_lines_b.id%TYPE) IS

89: /*
90: * sjalasut aug 18, 04: added cursor to derive the dnz_chr_id from the dnz_cle_id
91: * to pass the parameters to the business event. BEGIN
92: */
93: CURSOR get_chr_id (p_cle_id okc_k_lines_b.id%TYPE) IS
94: SELECT dnz_chr_id
95: FROM okc_k_lines_b
96: WHERE id = p_cle_id;
97:

Line 95: FROM okc_k_lines_b

91: * to pass the parameters to the business event. BEGIN
92: */
93: CURSOR get_chr_id (p_cle_id okc_k_lines_b.id%TYPE) IS
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: /*

Line 376: ln_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;

372: p_iivv_rec IN iivv_rec_type,
373: x_iivv_rec OUT NOCOPY iivv_rec_type)
374: IS
375: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TXL_ITM_INSTS';
376: ln_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;
377: -- Bug# 3477560
378: CURSOR get_chr_id(p_kle_id OKL_TXL_ASSETS_B.KLE_ID%TYPE)
379: IS
380: SELECT cle.dnz_chr_id

Line 381: FROM okc_k_lines_b cle

377: -- Bug# 3477560
378: CURSOR get_chr_id(p_kle_id OKL_TXL_ASSETS_B.KLE_ID%TYPE)
379: IS
380: SELECT cle.dnz_chr_id
381: FROM okc_k_lines_b cle
382: WHERE cle.id = p_kle_id;
383: --vthiruva..09-Dec-2004..Added code to enable Business Events..START
384: --cursor to fetch the serial number of the item instance record being updated
385: CURSOR get_serial_num(p_id okl_txl_itm_insts.id%TYPE) IS

Line 595: ln_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;

591: x_msg_data OUT NOCOPY VARCHAR2,
592: p_iivv_rec IN iivv_rec_type)
593: IS
594: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TXL_ITM_INSTS';
595: ln_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;
596: -- Bug# 3477560
597: CURSOR get_chr_id(p_kle_id OKL_TXL_ASSETS_B.KLE_ID%TYPE)
598: IS
599: SELECT cle.dnz_chr_id

Line 600: FROM okc_k_lines_b cle

596: -- Bug# 3477560
597: CURSOR get_chr_id(p_kle_id OKL_TXL_ASSETS_B.KLE_ID%TYPE)
598: IS
599: SELECT cle.dnz_chr_id
600: FROM okc_k_lines_b cle
601: WHERE cle.id = p_kle_id;
602: /*
603: * sjalasut aug 18, 04: added cursor to derive the dnz_chr_id and dnz_cle_id
604: * from the item instance to pass the parameters to the business event. BEGIN

Line 608: FROM okc_k_lines_b lines, okl_txl_itm_insts items

604: * from the item instance to pass the parameters to the business event. BEGIN
605: */
606: CURSOR get_chr_cle_id(p_inst_id okl_txl_itm_insts.id%TYPE) IS
607: SELECT lines.dnz_chr_id, items.dnz_cle_id, items.serial_number
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;

Line 613: l_cle_id okc_k_lines_b.id%TYPE;

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: /*
617: * sjalasut aug 18, 04: added cursor to derive the dnz_chr_id and dnz_cle_id

Line 967: FROM okc_k_lines_b line,

963:
964: CURSOR ff1_csr (p_chr_id IN NUMBER,
965: p_line_id IN NUMBER) IS
966: SELECT line.id asset_id
967: FROM okc_k_lines_b line,
968: okc_line_styles_b style,
969: okc_statuses_b sts
970: WHERE line.lse_id = style.id
971: AND style.lty_code = 'FREE_FORM1'

Line 980: FROM okc_k_lines_b line,

976:
977: CURSOR check_item_csr (p_line_id IN NUMBER) IS
978: SELECT mtl.serial_number_control_code,
979: mtl.description item_desc
980: FROM okc_k_lines_b line,
981: okc_line_styles_b style,
982: okc_k_items kitem,
983: mtl_system_items mtl
984: WHERE line.lse_id = style.id

Line 994: FROM okc_k_lines_b ff2,

990: AND line.cle_id = p_line_id;
991:
992: CURSOR inst_csr (p_asset_id IN NUMBER) IS
993: SELECT inst.id inst_id
994: FROM okc_k_lines_b ff2,
995: okc_k_lines_b inst,
996: okc_line_styles_b ff2style,
997: okc_line_styles_b inststyle,
998: okl_txl_itm_insts txl

Line 995: okc_k_lines_b inst,

991:
992: CURSOR inst_csr (p_asset_id IN NUMBER) IS
993: SELECT inst.id inst_id
994: FROM okc_k_lines_b ff2,
995: okc_k_lines_b inst,
996: okc_line_styles_b ff2style,
997: okc_line_styles_b inststyle,
998: okl_txl_itm_insts txl
999: WHERE ff2.lse_id = ff2style.id