DBA Data[Home] [Help]

APPS.OKL_ASSET_SUBSIDY_PVT dependencies on OKL_SUBSIDIES_B

Line 10: name OKL_SUBSIDIES_B.NAME%TYPE := OKL_API.G_MISS_CHAR,

6: -- OKL_ASSET_SUBSIDIES_UV Record Spec
7: TYPE asb_rec_type IS RECORD (
8: subsidy_id NUMBER := OKL_API.G_MISS_NUM,
9: subsidy_cle_id NUMBER := OKL_API.G_MISS_NUM,
10: name OKL_SUBSIDIES_B.NAME%TYPE := OKL_API.G_MISS_CHAR,
11: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
12: amount NUMBER := OKL_API.G_MISS_NUM,
13: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,
14: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,

Line 174: FUNCTION validate_subsidy_pool_applic(p_subsidy_id IN okl_subsidies_b.id%TYPE,

170: -- Version : 1.0
171: -- History : 07-FEB-2005 SJALASUT created
172: -- End of comments
173:
174: FUNCTION validate_subsidy_pool_applic(p_subsidy_id IN okl_subsidies_b.id%TYPE,
175: p_asset_cle_id IN okc_k_lines_b.id%TYPE,
176: p_ast_date_sq IN okc_k_lines_b.start_date%TYPE,
177: p_trx_curr_code_sq IN okc_k_lines_b.currency_code%TYPE,
178: --START: 09-Dec-2005 cklee - Fixed bug#4874385 |

Line 201: FUNCTION is_sub_assoc_with_pool(p_subsidy_id IN okl_subsidies_b.id%TYPE

197: -- Version : 1.0
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: -------------------------------------------------------------------------------

Line 297: PROCEDURE is_balance_valid_after_add (p_subsidy_id IN okl_subsidies_b.id%TYPE

293: -- Version : 1.0
294: -- History : 07-FEB-2005 SJALASUT created
295: -- End of comments
296:
297: PROCEDURE is_balance_valid_after_add (p_subsidy_id IN okl_subsidies_b.id%TYPE
298: ,p_asset_id IN okc_k_lines_b.id%TYPE
299: ,p_subsidy_amount IN NUMBER
300: ,p_subsidy_name IN okl_subsidies_b.name%TYPE
301: ,x_return_status OUT NOCOPY VARCHAR2

Line 300: ,p_subsidy_name IN okl_subsidies_b.name%TYPE

296:
297: PROCEDURE is_balance_valid_after_add (p_subsidy_id IN okl_subsidies_b.id%TYPE
298: ,p_asset_id IN okc_k_lines_b.id%TYPE
299: ,p_subsidy_amount IN NUMBER
300: ,p_subsidy_name IN okl_subsidies_b.name%TYPE
301: ,x_return_status OUT NOCOPY VARCHAR2
302: ,x_msg_count OUT NOCOPY NUMBER
303: ,x_msg_data OUT NOCOPY VARCHAR2
304: );

Line 320: PROCEDURE is_balance_valid_after_add (p_subsidy_id IN okl_subsidies_b.id%TYPE

316: -- Version : 1.0
317: -- History : 07-Dec-2005 cklee created
318: -- End of comments
319:
320: PROCEDURE is_balance_valid_after_add (p_subsidy_id IN okl_subsidies_b.id%TYPE
321: ,p_currency_code IN VARCHAR2
322: ,p_subsidy_amount IN NUMBER
323: ,p_tot_subsidy_amount IN NUMBER
324: ,p_dnz_asset_number IN VARCHAR2