[Home] [Help]
37: select 1 from okl_fe_eo_terms_all_b
38: where end_of_term_id= p_end_of_term_id;
39:
40: CURSOR eo_term_ver_csr(p_end_of_term_id NUMBER, p_version VARCHAR2) IS
41: select end_of_term_ver_id from okl_fe_eo_term_vers
42: where end_of_term_id= p_end_of_term_id and version_number= p_version;
43:
44: CURSOR eo_term_objects_csr(p_end_of_term_ver_id NUMBER) IS
45: SELECT END_OF_TERM_OBJ_ID,
168: select 1 from okl_fe_eo_terms_all_b
169: where end_of_term_id= p_end_of_term_id;
170:
171: CURSOR end_of_term_ver_csr(p_end_of_term_id NUMBER, p_po_version VARCHAR2) IS
172: select end_of_term_ver_id from okl_fe_eo_term_vers
173: where end_of_term_id= p_end_of_term_id and version_number= p_version;
174:
175: CURSOR eo_term_values_csr(p_version_id NUMBER) IS
176: SELECT END_OF_TERM_VALUE_ID,
358: CREATION_DATE,
359: LAST_UPDATED_BY,
360: LAST_UPDATE_DATE,
361: LAST_UPDATE_LOGIN
362: FROM OKL_FE_EO_TERM_VERS WHERE END_OF_TERM_ID= p_eot_id and version_number=p_eot_version;
363: BEGIN
364:
365: -- get the end of term header
366: OPEN eot_hdr_csr(p_eot_id);
447: SELECT end_of_term_id,
448: eot_type_code,
449: currency_code,
450: category_type_code
451: FROM OKL_FE_EO_TERM_VERS_V
452: WHERE end_of_term_ver_id = p_version_id;
453:
454: -- cursor to see id the records are available
455: CURSOR count_csr(p_version_id IN NUMBER,l_eot_type_code IN VARCHAR2, l_currency_code IN VARCHAR2) IS
559: (select rate_set_version_id from OKL_FE_RATE_SET_VERSIONS where end_of_term_ver_id = p_eot_version_id);
560:
561: -- cursor to fetch the start date and the end of the previous version
562: CURSOR prev_ver_csr(p_eot_id IN NUMBER, p_ver_number IN VARCHAR2) IS
563: SELECT effective_from_date, effective_to_date FROM okl_fe_eo_term_vers where end_of_term_id= p_eot_id
564: AND version_number= p_ver_number-1;
565:
566: TYPE l_start_date_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;
567:
913: j NUMBER;
914: lp_lrtv_tbl okl_lrs_id_tbl;
915:
916: CURSOR latest_active_ver_csr(p_eot_id IN NUMBER) IS
917: SELECT max(version_number) FROM okl_fe_eo_term_vers
918: WHERE end_of_term_id=p_eot_id and sts_code='ACTIVE';
919:
920: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
921: cal_end_date DATE;
1460: j NUMBER;
1461: int_count NUMBER;
1462:
1463: CURSOR cat_type_code_csr(p_end_of_term_ver_id IN NUMBER) IS
1464: SELECT category_type_code,eot_type_code FROM OKL_FE_EO_TERMS_V hdr, OKL_FE_EO_TERM_VERS ver
1465: WHERE hdr.end_of_term_id = ver.end_of_term_id AND ver.end_of_term_ver_id = p_end_of_term_ver_id;
1466:
1467: CURSOR objects_csr(p_end_of_term_ver_id IN NUMBER) IS
1468: SELECT inventory_item_id, organization_id, category_id, category_set_id, resi_category_set_id
1560: SELECT END_OF_TERM_ID,
1561: VERSION_NUMBER,
1562: EFFECTIVE_FROM_DATE,
1563: EFFECTIVE_TO_DATE
1564: FROM OKL_FE_EO_TERM_VERS WHERE END_OF_TERM_VER_ID=p_ver_id;
1565:
1566: CURSOR ver_eff_to_csr(p_eot_id IN NUMBER, p_version_number IN NUMBER)IS
1567: SELECT END_OF_TERM_VER_ID,
1568: EFFECTIVE_TO_DATE FROM okl_fe_eo_term_vers
1564: FROM OKL_FE_EO_TERM_VERS WHERE END_OF_TERM_VER_ID=p_ver_id;
1565:
1566: CURSOR ver_eff_to_csr(p_eot_id IN NUMBER, p_version_number IN NUMBER)IS
1567: SELECT END_OF_TERM_VER_ID,
1568: EFFECTIVE_TO_DATE FROM okl_fe_eo_term_vers
1569: WHERE END_OF_TERM_ID=p_eot_id and VERSION_NUMBER = p_version_number;
1570:
1571: BEGIN
1572: l_return_status := OKL_API.start_activity(l_api_name
1887: l_rcs_rec check_active_resi_cat_sets%ROWTYPE;
1888:
1889: CURSOR get_eot_id(p_ver_id IN NUMBER) IS
1890: SELECT END_OF_TERM_ID
1891: FROM OKL_FE_EO_TERM_VERS WHERE END_OF_TERM_VER_ID=p_ver_id;
1892:
1893: CURSOR get_source_type(p_eot_id IN NUMBER)IS
1894: SELECT EOT_TYPE_CODE
1895: FROM OKL_FE_EO_TERMS_V where end_of_term_id= p_eot_id;