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 3177: CURSOR get_deal_type_csr(p_chr_id OKL_K_HEADERS.ID%TYPE)

3173: AND qlt_code = 'AMCFIA';
3174:
3175: --Bug 6740000 ssdeshpa start
3176: --Cursor to get the deal Type for Contract
3177: CURSOR get_deal_type_csr(p_chr_id OKL_K_HEADERS.ID%TYPE)
3178: IS
3179: SELECT DEAL_TYPE
3180: FROM OKL_K_HEADERS
3181: WHERE ID = p_chr_id;

Line 3180: FROM OKL_K_HEADERS

3176: --Cursor to get the deal Type for Contract
3177: CURSOR get_deal_type_csr(p_chr_id OKL_K_HEADERS.ID%TYPE)
3178: IS
3179: SELECT DEAL_TYPE
3180: FROM OKL_K_HEADERS
3181: WHERE ID = p_chr_id;
3182:
3183: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
3184: --Bug 6740000 ssdeshpa End

Line 3183: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;

3179: SELECT DEAL_TYPE
3180: FROM OKL_K_HEADERS
3181: WHERE ID = p_chr_id;
3182:
3183: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
3184: --Bug 6740000 ssdeshpa End
3185:
3186: i NUMBER := 0;
3187: l_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;

Line 3510: okl_k_headers B,

3506: A.TRANSACTION_DATE,
3507: B.MULTI_GAAP_YN, -- MGAAP 7263041
3508: C.REPORTING_PDT_ID -- MGAAP 7263041
3509: FROM okl_rbk_selected_contract A,
3510: okl_k_headers B,
3511: okl_products C
3512: WHERE A.khr_id = p_chr_id
3513: AND NVL(A.status,'NEW') = 'UNDER REVISION'
3514: AND A.KHR_ID = B.ID -- MGAAP 7263041

Line 3535: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;

3531: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;
3532: l_rbk_transaction_id okl_rbk_selected_contract.transaction_id%TYPE;
3533:
3534: -- MGAAP start 7263041
3535: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;
3536: l_reporting_pdt_id okl_products.reporting_pdt_id%TYPE;
3537: -- MGAAP end 7263041
3538:
3539: --Bug# 4107330

Line 4531: l_object_version_no OKL_K_HEADERS.OBJECT_VERSION_NUMBER%TYPE;

4527: l_prev_contract_id NUMBER;
4528: l_kle_id NUMBER;
4529:
4530: -- Bug#4542290 - smadhava - 26-AUG-2005 - Added - Start
4531: l_object_version_no OKL_K_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
4532: -- Bug#4542290 - smadhava - 26-AUG-2005 - Added - End
4533:
4534: l_kle_tbl kle_tbl_type;
4535: l_strm_lalevl_tbl strm_lalevl_tbl_type;

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

4546: OR
4547: criteria_code = 'BOOK_TYPE_CODE'); -- in order to keep Tax Book as selection crietria
4548:
4549: -- Bug#4542290 - smadhava - 26-AUG-2005 - Modified - Start
4550: -- Modified cusor to get the object version number of the OKL_K_HEADERS table
4551: CURSOR rbk_csr (p_req_name VARCHAR2) IS
4552: SELECT
4553: rbk.khr_id,
4554: rbk.contract_number,

Line 4560: , okl_k_headers khr

4556: rbk.kle_id,
4557: rbk.transaction_date,
4558: khr.object_version_number
4559: FROM okl_rbk_selected_contract rbk
4560: , okl_k_headers khr
4561: WHERE
4562: rbk.request_name = p_req_name
4563: AND rbk.selected_flag = 'Y'
4564: AND rbk.transaction_id IS NULL