DBA Data[Home] [Help]

APPS.OKL_ASSET_SUBSIDY_PVT dependencies on OKL_SUBSIDY_POOLS_B

Line 202: ,x_subsidy_pool_id OUT NOCOPY okl_subsidy_pools_b.id%TYPE

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

Line 203: ,x_sub_pool_curr_code OUT NOCOPY okl_subsidy_pools_b.currency_code%TYPE) RETURN VARCHAR2;

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: -------------------------------------------------------------------------------

Line 221: FUNCTION is_sub_pool_active (p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE

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

Line 222: ,x_pool_status OUT NOCOPY okl_subsidy_pools_b.decision_status_code%TYPE) RETURN VARCHAR2;

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: -------------------------------------------------------------------------------

Line 241: FUNCTION is_sub_pool_active_by_date (p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE

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: -------------------------------------------------------------------------------

Line 262: FUNCTION is_sub_pool_conv_rate_valid(p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE

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: -------------------------------------------------------------------------------

Line 280: FUNCTION is_balance_valid_before_add (p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE

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: -------------------------------------------------------------------------------