198: -- History : 07-FEB-2005 SJALASUT created
199: -- End of comments
200:
201: FUNCTION is_sub_assoc_with_pool(p_subsidy_id IN okl_subsidies_b.id%TYPE
202: ,x_subsidy_pool_id OUT NOCOPY okl_subsidy_pools_b.id%TYPE
203: ,x_sub_pool_curr_code OUT NOCOPY okl_subsidy_pools_b.currency_code%TYPE) RETURN VARCHAR2;
204:
205: -------------------------------------------------------------------------------
206: -- FUNCTION is_sub_pool_active
199: -- End of comments
200:
201: FUNCTION is_sub_assoc_with_pool(p_subsidy_id IN okl_subsidies_b.id%TYPE
202: ,x_subsidy_pool_id OUT NOCOPY okl_subsidy_pools_b.id%TYPE
203: ,x_sub_pool_curr_code OUT NOCOPY okl_subsidy_pools_b.currency_code%TYPE) RETURN VARCHAR2;
204:
205: -------------------------------------------------------------------------------
206: -- FUNCTION is_sub_pool_active
207: -------------------------------------------------------------------------------
217: -- Version : 1.0
218: -- History : 07-FEB-2005 SJALASUT created
219: -- End of comments
220:
221: FUNCTION is_sub_pool_active (p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
222: ,x_pool_status OUT NOCOPY okl_subsidy_pools_b.decision_status_code%TYPE) RETURN VARCHAR2;
223:
224: -------------------------------------------------------------------------------
225: -- FUNCTION is_sub_pool_active_by_date
218: -- History : 07-FEB-2005 SJALASUT created
219: -- End of comments
220:
221: FUNCTION is_sub_pool_active (p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
222: ,x_pool_status OUT NOCOPY okl_subsidy_pools_b.decision_status_code%TYPE) RETURN VARCHAR2;
223:
224: -------------------------------------------------------------------------------
225: -- FUNCTION is_sub_pool_active_by_date
226: -------------------------------------------------------------------------------
237: -- Version : 1.0
238: -- History : 07-FEB-2005 SJALASUT created
239: -- End of comments
240:
241: FUNCTION is_sub_pool_active_by_date (p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
242: ,p_asset_date IN okc_k_lines_b.start_date%TYPE
243: ) RETURN VARCHAR2;
244:
245: -------------------------------------------------------------------------------
258: -- Version : 1.0
259: -- History : 07-FEB-2005 SJALASUT created
260: -- End of comments
261:
262: FUNCTION is_sub_pool_conv_rate_valid(p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
263: ,p_asset_date IN okc_k_lines_b.start_date%TYPE
264: ,p_trx_currency_code IN okc_k_headers_b.currency_code%TYPE
265: ,x_conversion_rate OUT NOCOPY NUMBER) RETURN VARCHAR2;
266: -------------------------------------------------------------------------------
276: -- Version : 1.0
277: -- History : 07-FEB-2005 SJALASUT created
278: -- End of comments
279:
280: FUNCTION is_balance_valid_before_add (p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
281: , x_pool_balance OUT NOCOPY NUMBER) RETURN VARCHAR2;
282:
283:
284: -------------------------------------------------------------------------------