APPS.OKL_TXL_ASSETS_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 101: FROM okl_k_headers_full_v

97: CURSOR header_curr_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
98: SELECT currency_code,
99: currency_conversion_type,
100: currency_conversion_date
101: FROM okl_k_headers_full_v
102: WHERE id = p_chr_id;
103:
104: --| start 29-Oct-08 cklee Bug: 7492324 default salvage in here so that |
105: --| when create and copy asset can refer to the |

Line 143: l_header_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

139: --| end 29-Oct-08 cklee Bug: 7492324 default salvage in here so that |
140: --| when create and copy asset can refer to the |
141: --| same source |
142:
143: l_header_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
144: l_header_curr_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
145: l_header_curr_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
146:
147: l_talv_rec tlvv_rec_type;

Line 144: l_header_curr_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;

140: --| when create and copy asset can refer to the |
141: --| same source |
142:
143: l_header_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
144: l_header_curr_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
145: l_header_curr_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
146:
147: l_talv_rec tlvv_rec_type;
148:

Line 145: l_header_curr_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;

141: --| same source |
142:
143: l_header_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
144: l_header_curr_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
145: l_header_curr_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
146:
147: l_talv_rec tlvv_rec_type;
148:
149: /*

Line 563: FROM okl_k_headers_full_v h,

559: CURSOR header_curr_csr(p_txl_id OKL_TXL_ASSETS_V.ID%TYPE) IS
560: SELECT h.currency_code,
561: h.currency_conversion_type,
562: h.currency_conversion_date
563: FROM okl_k_headers_full_v h,
564: okl_txl_assets_v asset
565: WHERE h.id = asset.dnz_khr_id
566: AND asset.id = p_txl_id;
567:

Line 623: l_header_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

619: l_asset_id okc_k_lines_b.id%TYPE;
620: l_old_book_code okl_txl_assets_b.corporate_book%TYPE;
621: --vthiruva..fix for business events..30-Dec-2004..end
622:
623: l_header_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
624: l_header_curr_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
625: l_header_curr_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
626:
627: BEGIN

Line 624: l_header_curr_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;

620: l_old_book_code okl_txl_assets_b.corporate_book%TYPE;
621: --vthiruva..fix for business events..30-Dec-2004..end
622:
623: l_header_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
624: l_header_curr_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
625: l_header_curr_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
626:
627: BEGIN
628: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 625: l_header_curr_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;

621: --vthiruva..fix for business events..30-Dec-2004..end
622:
623: l_header_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
624: l_header_curr_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
625: l_header_curr_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
626:
627: BEGIN
628: x_return_status := OKL_API.G_RET_STS_SUCCESS;
629: -- Call start_activity to create savepoint, check compatibility