DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_PROCESS_SALES_TAX_PVT

Line 3502: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE

3498: SELECT SUM(total_tax)
3499: FROM okl_tax_sources
3500: WHERE trx_id = cp_quote_id
3501: AND asset_number IS NOT NULL
3502: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3503: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE
3504: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID
3505: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;
3506:

Line 3503: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE

3499: FROM okl_tax_sources
3500: WHERE trx_id = cp_quote_id
3501: AND asset_number IS NOT NULL
3502: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3503: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE
3504: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID
3505: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;
3506:
3507: CURSOR l_get_tax_treatment(cp_quote_id IN NUMBER) IS

Line 3504: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID

3500: WHERE trx_id = cp_quote_id
3501: AND asset_number IS NOT NULL
3502: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3503: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE
3504: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID
3505: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;
3506:
3507: CURSOR l_get_tax_treatment(cp_quote_id IN NUMBER) IS
3508: SELECT upfront_tax_treatment, upfront_tax_stream_type,

Line 3505: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;

3501: AND asset_number IS NOT NULL
3502: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3503: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE
3504: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID
3505: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;
3506:
3507: CURSOR l_get_tax_treatment(cp_quote_id IN NUMBER) IS
3508: SELECT upfront_tax_treatment, upfront_tax_stream_type,
3509: pricing_method, parent_object_code, parent_object_id

Line 3524: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE

3520: SELECT total_tax
3521: FROM okl_tax_sources
3522: WHERE trx_id = cp_quote_id
3523: AND asset_number = cp_asset_number
3524: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3525: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE
3526: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID
3527: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;
3528:

Line 3525: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE

3521: FROM okl_tax_sources
3522: WHERE trx_id = cp_quote_id
3523: AND asset_number = cp_asset_number
3524: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3525: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE
3526: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID
3527: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;
3528:
3529: CURSOR l_check_tax_fee_exists(cp_quote_id IN NUMBER) IS

Line 3526: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID

3522: WHERE trx_id = cp_quote_id
3523: AND asset_number = cp_asset_number
3524: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3525: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE
3526: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID
3527: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;
3528:
3529: CURSOR l_check_tax_fee_exists(cp_quote_id IN NUMBER) IS
3530: SELECT '1'

Line 3527: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;

3523: AND asset_number = cp_asset_number
3524: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3525: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE
3526: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID
3527: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;
3528:
3529: CURSOR l_check_tax_fee_exists(cp_quote_id IN NUMBER) IS
3530: SELECT '1'
3531: FROM okl_fees_b

Line 3573: OKL_PROCESS_SALES_TAX_PVT.calculate_sales_tax(p_api_version => p_api_version,

3569: RAISE OKL_API.G_EXCEPTION_ERROR;
3570: END IF;
3571:
3572: -- Calculate Sales tax
3573: OKL_PROCESS_SALES_TAX_PVT.calculate_sales_tax(p_api_version => p_api_version,
3574: p_init_msg_list => p_init_msg_list,
3575: x_return_status => x_return_status,
3576: x_msg_count => x_msg_count,
3577: x_msg_data => x_msg_data,