[Home] [Help]
159:
160: ------------------------------------------------------------------------------
161: -- PROCEDURE build_selection
162: -- This proecdure builds "SELECT" statement from Operands and criteria
163: -- provided on OKL_MASS_RBK_CRITERIA Table against a REQUEST_NAME.
164: -- It returns the SELECT Statement for further processing
165: -- Calls:
166: -- Called by:
167: ------------------------------------------------------------------------------
178: l_proc_name VARCHAR2(35) := 'BUILD_SELECTION';
179:
180: CURSOR mass_rbk_csr (p_req_name VARCHAR2) IS
181: SELECT *
182: FROM okl_mass_rbk_criteria
183: WHERE request_name = p_req_name
184: AND operand IS NOT NULL
185: ORDER BY line_number;
186:
186:
187: CURSOR crit_csr (p_code VARCHAR2) IS
188: SELECT 'Y'
189: FROM fnd_lookups
190: WHERE lookup_type = 'OKL_MASS_RBK_CRITERIA'
191: AND lookup_code = p_code;
192:
193: l_query VARCHAR2(2000);
194: l_clause VARCHAR2(10);
440:
441: ------------------------------------------------------------------------------
442: -- PROCEDURE get_contract
443: -- This proecdure uses DYNAMIC SQL to get list of contracts from
444: -- selection criteria provided by user in OKL_MASS_RBK_CRITERIA
445: -- against REQUEST_NAME
446: -- It returns the list of contracts selected under present crietria
447: -- Calls:
448: -- Called by:
452: p_init_msg_list IN VARCHAR2,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_msg_count OUT NOCOPY NUMBER,
455: x_msg_data OUT NOCOPY VARCHAR2,
456: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,
457: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE DEFAULT SYSDATE,
458: x_mstv_tbl OUT NOCOPY mstv_tbl_type,
459: x_rbk_count OUT NOCOPY NUMBER
460: ) IS
474: l_mstv_tbl mstv_tbl_type;
475:
476: get_contract_failed EXCEPTION;
477:
478: CURSOR req_csr (p_request_name OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE) IS
479: SELECT 'Y'
480: FROM okl_rbk_selected_contract
481: WHERE request_name = p_request_name;
482:
621: PROCEDURE validate_request(
622: x_return_status OUT NOCOPY VARCHAR2,
623: x_msg_count OUT NOCOPY NUMBER,
624: x_msg_data OUT NOCOPY VARCHAR2,
625: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,
626: p_mrbv_tbl IN mrbv_tbl_type
627: ) IS
628:
629: l_api_name VARCHAR2(35) := 'validate_request';
854:
855: ------------------------------------------------------------------------------
856: -- PROCEDURE build_and_get_contracts
857: -- Overloaded process to accept transaction date from page
858: -- This proecdure inserts selection criteria to OKL_MASS_RBK_CRITERIA table
859: -- and populates OKL_RBK_SELECTED_CONTRACT table with selected contracts.
860: -- Calls:
861: -- Called by:
862: ------------------------------------------------------------------------------
866: p_init_msg_list IN VARCHAR2,
867: x_return_status OUT NOCOPY VARCHAR2,
868: x_msg_count OUT NOCOPY NUMBER,
869: x_msg_data OUT NOCOPY VARCHAR2,
870: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,
871: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,
872: p_mrbv_tbl IN mrbv_tbl_type,
873: x_mstv_tbl OUT NOCOPY mstv_tbl_type,
874: x_rbk_count OUT NOCOPY NUMBER
1004: END build_and_get_contracts;
1005:
1006: ------------------------------------------------------------------------------
1007: -- PROCEDURE build_and_get_contracts
1008: -- This proecdure inserts selection criteria to OKL_MASS_RBK_CRITERIA table
1009: -- and populates OKL_RBK_SELECTED_CONTRACT table with selected contracts.
1010: -- Calls:
1011: -- Called by:
1012: ------------------------------------------------------------------------------
1016: p_init_msg_list IN VARCHAR2,
1017: x_return_status OUT NOCOPY VARCHAR2,
1018: x_msg_count OUT NOCOPY NUMBER,
1019: x_msg_data OUT NOCOPY VARCHAR2,
1020: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,
1021: p_mrbv_tbl IN mrbv_tbl_type,
1022: x_mstv_tbl OUT NOCOPY mstv_tbl_type,
1023: x_rbk_count OUT NOCOPY NUMBER
1024: ) IS
2354: p_online_yn IN VARCHAR2,
2355: p_khr_id IN OKC_K_HEADERS_V.ID%TYPE,
2356: p_kle_tbl IN kle_tbl_type,
2357: p_line_count IN NUMBER,
2358: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,
2359: p_book_type_code IN FA_BOOKS.BOOK_TYPE_CODE%TYPE,
2360: p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
2361: p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
2362: p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,
4505: p_init_msg_list IN VARCHAR2,
4506: x_return_status OUT NOCOPY VARCHAR2,
4507: x_msg_count OUT NOCOPY NUMBER,
4508: x_msg_data OUT NOCOPY VARCHAR2,
4509: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE
4510: ) IS
4511: l_api_name VARCHAR2(35) := 'process_mass_rebook';
4512: l_proc_name VARCHAR2(35) := 'PROCESS_MASS_REBOOK';
4513: l_api_version NUMBER := 1.0;
4539: CURSOR rbk_set_csr (p_req_name VARCHAR2) IS
4540: SELECT criteria_code,
4541: criteria_value1,
4542: set_value
4543: FROM okl_mass_rbk_criteria
4544: WHERE request_name = p_req_name
4545: AND (set_value IS NOT NULL
4546: OR
4547: criteria_code = 'BOOK_TYPE_CODE'); -- in order to keep Tax Book as selection crietria
6108: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
6109: x_return_status OUT NOCOPY VARCHAR2,
6110: x_msg_count OUT NOCOPY NUMBER,
6111: x_msg_data OUT NOCOPY VARCHAR2,
6112: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,
6113: p_mrbv_tbl IN mrbv_tbl_type,
6114: x_mrbv_tbl OUT NOCOPY mrbv_tbl_type)
6115: IS
6116: