APPS.OKL_TXD_ASSETS_PVT dependencies on OKC_K_LINES_B

Line 44: p_asset_id IN okc_k_lines_b.id%TYPE,

40:
41: PROCEDURE raise_business_event(p_api_version IN NUMBER,
42: p_init_msg_list IN VARCHAR2,
43: p_chr_id IN okc_k_headers_b.id%TYPE,
44: p_asset_id IN okc_k_lines_b.id%TYPE,
45: p_event_name IN VARCHAR2,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2

Line 98: ln_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;

94: l_currency_code OKL_TXD_ASSETS_B.CURRENCY_CODE%TYPE;
95: l_asdv_rec advv_rec_type := p_asdv_rec;
96:
97: -- Bug# 3477560
98: ln_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;
99: CURSOR get_chr_id(p_tal_id OKL_TXD_ASSETS_B.TAL_ID%TYPE)
100: IS
101: SELECT to_char(cle.dnz_chr_id)
102: FROM okc_k_lines_b cle,

Line 102: FROM okc_k_lines_b cle,

98: ln_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;
99: CURSOR get_chr_id(p_tal_id OKL_TXD_ASSETS_B.TAL_ID%TYPE)
100: IS
101: SELECT to_char(cle.dnz_chr_id)
102: FROM okc_k_lines_b cle,
103: okl_txl_assets_b tal,
104: okl_txd_assets_b txd
105: WHERE tal.kle_id = cle.id
106: AND tal.id = txd.tal_id

Line 132: FROM okc_k_lines_b cle,

128: */
129: CURSOR get_chr_and_cle_id(p_tal_id OKL_TXD_ASSETS_B.TAL_ID%TYPE)
130: IS
131: SELECT to_char(cle.dnz_chr_id) chr_id, cle.cle_id cle_id
132: FROM okc_k_lines_b cle,
133: okl_txl_assets_b tal,
134: okl_txd_assets_b txd
135: WHERE tal.kle_id = cle.id
136: AND tal.id = txd.tal_id

Line 141: l_cle_id okc_k_lines_b.id%TYPE;

137: AND tal.tal_type in ('CFA','CIB','CRB','CRL','CRV','CSP','ALI')
138: AND txd.tal_id = p_tal_id;
139:
140: l_chr_id okc_k_headers_b.id%TYPE;
141: l_cle_id okc_k_lines_b.id%TYPE;
142:
143: /*
144: * sjalasut added cursor to derive the contract header id and contract line id. END
145: *

Line 575: ln_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;

571: p_asdv_rec IN advv_rec_type,
572: x_asdv_rec OUT NOCOPY advv_rec_type)
573: IS
574: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TRX_ASSETS_LINE_DTL';
575: ln_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;
576:
577: -- Temp parameters to store cost and currency code
578: l_cost OKL_TXD_ASSETS_B.COST%TYPE;
579: l_currency_code OKL_TXD_ASSETS_B.CURRENCY_CODE%TYPE;

Line 586: FROM okc_k_lines_b cle,

582:
583: CURSOR get_chr_id(p_tal_id OKL_TXD_ASSETS_B.TAL_ID%TYPE)
584: IS
585: SELECT to_char(cle.dnz_chr_id)
586: FROM okc_k_lines_b cle,
587: okl_txl_assets_b tal,
588: okl_txd_assets_b txd
589: WHERE tal.kle_id = cle.id
590: AND tal.id = txd.tal_id

Line 893: ln_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;

889: x_msg_data OUT NOCOPY VARCHAR2,
890: p_asdv_rec IN advv_rec_type)
891: IS
892: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TRX_ASSETS_LINE_DTL';
893: ln_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;
894:
895: -- Bug# 3477560
896: CURSOR get_chr_id(p_txd_id OKL_TXD_ASSETS_B.ID%TYPE)
897: IS

Line 899: FROM okc_k_lines_b cle,

895: -- Bug# 3477560
896: CURSOR get_chr_id(p_txd_id OKL_TXD_ASSETS_B.ID%TYPE)
897: IS
898: SELECT to_char(cle.dnz_chr_id)
899: FROM okc_k_lines_b cle,
900: okl_txl_assets_b tal,
901: okl_txd_assets_b txd
902: WHERE tal.kle_id = cle.id
903: AND tal.id = txd.tal_id

Line 914: FROM okc_k_lines_b cle,

910: */
911: CURSOR get_chr_and_cle_id(p_id OKL_TXD_ASSETS_B.ID%TYPE)
912: IS
913: SELECT to_char(cle.dnz_chr_id) chr_id, cle.cle_id cle_id
914: FROM okc_k_lines_b cle,
915: okl_txl_assets_b tal,
916: okl_txd_assets_b txd
917: WHERE tal.kle_id = cle.id
918: AND tal.id = txd.tal_id

Line 923: l_cle_id okc_k_lines_b.id%TYPE;

919: AND tal.tal_type in ('CFA','CIB','CRB','CRL','CRV','CSP','ALI')
920: AND txd.id = p_id;
921:
922: l_chr_id okc_k_headers_b.id%TYPE;
923: l_cle_id okc_k_lines_b.id%TYPE;
924:
925: /*
926: * sjalasut added cursor to derive the contract header id and contract line id. END
927: *