[Home] [Help]
1177: CURSOR check_csr(p_chr_id NUMBER) IS
1178: SELECT A.MULTI_GAAP_YN,
1179: B.REPORTING_PDT_ID
1180: FROM OKL_K_HEADERS A,
1181: OKL_PRODUCTS B
1182: WHERE A.ID = p_chr_id
1183: AND A.PDT_ID = B.ID;
1184:
1185: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
1182: WHERE A.ID = p_chr_id
1183: AND A.PDT_ID = B.ID;
1184:
1185: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
1186: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
1187: -- MGAAP start 7263041
1188:
1189: BEGIN
1190: -- Call start_activity to create savepoint, check compatibility
1639: l_msg_data VARCHAR2(2000);
1640: l_currency_code okl_txl_cntrct_lns.currency_code%TYPE;
1641:
1642:
1643: CURSOR Product_csr (p_contract_id IN okl_products_v.id%TYPE) IS
1644: SELECT pdt.id product_id
1645: ,pdt.name product_name
1646: ,khr.sts_code contract_status
1647: ,khr.start_date start_date
1650: ,khr.currency_conversion_rate currency_conversion_rate
1651: ,khr.currency_conversion_type currency_conversion_type
1652: ,khr.currency_conversion_date currency_conversion_date
1653: ,khr.scs_code
1654: FROM okl_products_v pdt
1655: ,okl_k_headers_full_v khr
1656: WHERE khr.id = p_contract_id
1657: AND khr.pdt_id = pdt.id;
1658:
1658:
1659: -- Get the product type
1660: CURSOR l_product_type_csr ( p_pdt_id IN NUMBER) IS
1661: SELECT description
1662: FROM OKL_PRODUCTS_V
1663: WHERE id = p_pdt_id;
1664:
1665: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1666: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
10704: l_pdt_date DATE;
10705: l_pdtv_rec okl_setupproducts_pub.pdtv_rec_type;
10706: l_pdt_parameter_rec okl_setupproducts_pub.pdt_parameters_rec_type;
10707: l_rep_pdt_parameter_rec okl_setupproducts_pub.pdt_parameters_rec_type;
10708: l_reporting_product OKL_PRODUCTS_V.NAME%TYPE;
10709: l_no_data_found BOOLEAN;
10710: l_rep_pdt_id NUMBER;
10711: l_rep_deal_type okl_product_parameters_v.deal_type%TYPE;
10712: l_tax_owner Varchar2(150);