APPS.OKL_MASS_REBOOK_PVT dependencies on OKL_K_HEADERS

Line 218: l_query := 'SELECT CON.ID, CON.CONTRACT_NUMBER, LINE.ID, CON.SHORT_DESCRIPTION FROM OKL_K_HEADERS_FULL_V CON, ';

214: END IF;
215:
216: l_asset_query_present := 'F'; -- Checks the presence of Asset Related Criteria
217:
218: l_query := 'SELECT CON.ID, CON.CONTRACT_NUMBER, LINE.ID, CON.SHORT_DESCRIPTION FROM OKL_K_HEADERS_FULL_V CON, ';
219: l_query := l_query || ' OKL_K_LINES_FULL_V LINE ';
220:
221: --insert into dd_dummy values (1,l_query);
222:

Line 1403: CURSOR fa_line_csr (p_chr_id OKL_K_HEADERS_V.ID%TYPE,

1399: SELECT number_of_items
1400: FROM okc_k_items_v
1401: WHERE cle_id = p_fa_line_id;
1402:
1403: CURSOR fa_line_csr (p_chr_id OKL_K_HEADERS_V.ID%TYPE,
1404: p_kle_id OKC_K_LINES_V.ID%TYPE) IS
1405: SELECT line.id
1406: FROM okc_k_lines_v line,
1407: okc_line_styles_v style

Line 3301: CURSOR get_deal_type_csr(p_chr_id OKL_K_HEADERS.ID%TYPE)

3297: AND qlt_code = 'AMCFIA';
3298:
3299: --Bug 6740000 ssdeshpa start
3300: --Cursor to get the deal Type for Contract
3301: CURSOR get_deal_type_csr(p_chr_id OKL_K_HEADERS.ID%TYPE)
3302: IS
3303: SELECT DEAL_TYPE
3304: FROM OKL_K_HEADERS
3305: WHERE ID = p_chr_id;

Line 3304: FROM OKL_K_HEADERS

3300: --Cursor to get the deal Type for Contract
3301: CURSOR get_deal_type_csr(p_chr_id OKL_K_HEADERS.ID%TYPE)
3302: IS
3303: SELECT DEAL_TYPE
3304: FROM OKL_K_HEADERS
3305: WHERE ID = p_chr_id;
3306:
3307: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
3308: --Bug 6740000 ssdeshpa End

Line 3307: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;

3303: SELECT DEAL_TYPE
3304: FROM OKL_K_HEADERS
3305: WHERE ID = p_chr_id;
3306:
3307: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
3308: --Bug 6740000 ssdeshpa End
3309:
3310: i NUMBER := 0;
3311: l_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;

Line 3634: okl_k_headers B,

3630: A.TRANSACTION_DATE,
3631: B.MULTI_GAAP_YN, -- MGAAP 7263041
3632: C.REPORTING_PDT_ID -- MGAAP 7263041
3633: FROM okl_rbk_selected_contract A,
3634: okl_k_headers B,
3635: okl_products C
3636: WHERE A.khr_id = p_chr_id
3637: AND NVL(A.status,'NEW') = 'UNDER REVISION'
3638: AND A.KHR_ID = B.ID -- MGAAP 7263041

Line 3659: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;

3655: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;
3656: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;
3657:
3658: -- MGAAP start 7263041
3659: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;
3660: l_reporting_pdt_id okl_products.reporting_pdt_id%TYPE;
3661: -- MGAAP end 7263041
3662:
3663: --Bug# 4107330

Line 4671: l_object_version_no OKL_K_HEADERS.OBJECT_VERSION_NUMBER%TYPE;

4667: l_prev_contract_id NUMBER;
4668: l_kle_id NUMBER;
4669:
4670: -- Bug#4542290 - smadhava - 26-AUG-2005 - Added - Start
4671: l_object_version_no OKL_K_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
4672: -- Bug#4542290 - smadhava - 26-AUG-2005 - Added - End
4673:
4674: l_kle_tbl kle_tbl_type;
4675: l_strm_lalevl_tbl strm_lalevl_tbl_type;

Line 4690: -- Modified cusor to get the object version number of the OKL_K_HEADERS table

4686: OR
4687: criteria_code = 'BOOK_TYPE_CODE'); -- in order to keep Tax Book as selection crietria
4688:
4689: -- Bug#4542290 - smadhava - 26-AUG-2005 - Modified - Start
4690: -- Modified cusor to get the object version number of the OKL_K_HEADERS table
4691: CURSOR rbk_csr (p_req_name VARCHAR2) IS
4692: SELECT
4693: rbk.khr_id,
4694: rbk.contract_number,

Line 4700: , okl_k_headers khr

4696: rbk.kle_id,
4697: rbk.transaction_date,
4698: khr.object_version_number
4699: FROM okl_rbk_selected_contract rbk
4700: , okl_k_headers khr
4701: WHERE
4702: rbk.request_name = p_req_name
4703: AND rbk.selected_flag = 'Y'
4704: AND rbk.transaction_id IS NULL