eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_PROCESS_SALES_TAX_PVT

Line 3602: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE

3598: SELECT SUM(total_tax)
3599: FROM okl_tax_sources
3600: WHERE trx_id = cp_quote_id
3601: AND asset_number IS NOT NULL
3602: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3603: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE
3604: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID
3605: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;
3606:

Line 3603: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE

3599: FROM okl_tax_sources
3600: WHERE trx_id = cp_quote_id
3601: AND asset_number IS NOT NULL
3602: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3603: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE
3604: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID
3605: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;
3606:
3607: CURSOR l_get_tax_treatment(cp_quote_id IN NUMBER) IS

Line 3604: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID

3600: WHERE trx_id = cp_quote_id
3601: AND asset_number IS NOT NULL
3602: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3603: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE
3604: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID
3605: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;
3606:
3607: CURSOR l_get_tax_treatment(cp_quote_id IN NUMBER) IS
3608: SELECT upfront_tax_treatment, upfront_tax_stream_type,

Line 3605: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;

3601: AND asset_number IS NOT NULL
3602: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3603: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE
3604: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID
3605: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;
3606:
3607: CURSOR l_get_tax_treatment(cp_quote_id IN NUMBER) IS
3608: SELECT upfront_tax_treatment, upfront_tax_stream_type,
3609: pricing_method, parent_object_code, parent_object_id

Line 3624: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE

3620: SELECT total_tax
3621: FROM okl_tax_sources
3622: WHERE trx_id = cp_quote_id
3623: AND asset_number = cp_asset_number
3624: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3625: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE
3626: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID
3627: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;
3628:

Line 3625: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE

3621: FROM okl_tax_sources
3622: WHERE trx_id = cp_quote_id
3623: AND asset_number = cp_asset_number
3624: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3625: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE
3626: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID
3627: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;
3628:
3629: CURSOR l_check_tax_fee_exists(cp_quote_id IN NUMBER) IS

Line 3626: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID

3622: WHERE trx_id = cp_quote_id
3623: AND asset_number = cp_asset_number
3624: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3625: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE
3626: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID
3627: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;
3628:
3629: CURSOR l_check_tax_fee_exists(cp_quote_id IN NUMBER) IS
3630: SELECT '1'

Line 3627: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;

3623: AND asset_number = cp_asset_number
3624: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3625: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE
3626: AND application_id = OKL_PROCESS_SALES_TAX_PVT.G_OKL_APPLICATION_ID
3627: AND trx_level_type = OKL_PROCESS_SALES_TAX_PVT.G_TRX_LEVEL_TYPE;
3628:
3629: CURSOR l_check_tax_fee_exists(cp_quote_id IN NUMBER) IS
3630: SELECT '1'
3631: FROM okl_fees_b

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

3670: RAISE OKL_API.G_EXCEPTION_ERROR;
3671: END IF;
3672:
3673: -- Calculate Sales tax
3674: OKL_PROCESS_SALES_TAX_PVT.calculate_sales_tax(p_api_version => p_api_version,
3675: p_init_msg_list => p_init_msg_list,
3676: x_return_status => x_return_status,
3677: x_msg_count => x_msg_count,
3678: x_msg_data => x_msg_data,