APPS.OKL_ASSET_SUBSIDY_PVT dependencies on OKC_K_LINES_B

Line 175: p_asset_cle_id IN okc_k_lines_b.id%TYPE,

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 |
179: p_tot_subsidy_amount IN NUMBER DEFAULT 0,

Line 176: p_ast_date_sq IN okc_k_lines_b.start_date%TYPE,

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 |
179: p_tot_subsidy_amount IN NUMBER DEFAULT 0,
180: p_subsidy_amount IN NUMBER DEFAULT 0,

Line 177: p_trx_curr_code_sq IN okc_k_lines_b.currency_code%TYPE,

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 |
179: p_tot_subsidy_amount IN NUMBER DEFAULT 0,
180: p_subsidy_amount IN NUMBER DEFAULT 0,
181: p_filter_flag IN VARCHAR2 DEFAULT 'Y',

Line 242: ,p_asset_date IN okc_k_lines_b.start_date%TYPE

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: -------------------------------------------------------------------------------
246: -- FUNCTION is_sub_pool_conv_rate_valid

Line 263: ,p_asset_date IN okc_k_lines_b.start_date%TYPE

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: -------------------------------------------------------------------------------
267: -- FUNCTION is_balance_valid_before_add

Line 298: ,p_asset_id IN okc_k_lines_b.id%TYPE

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
302: ,x_msg_count OUT NOCOPY NUMBER