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.

APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_TRX_QUOTES_B

Line 7227: IF p_source_trx_name = 'Estimated Billing' AND p_source_table = 'OKL_TRX_QUOTES_B' THEN -- Termination/Repurchase quote creation/updation

7223: p_token1_value => 'Financial Product');
7224: RAISE OKL_API.G_EXCEPTION_ERROR;
7225: END IF;
7226:
7227: IF p_source_trx_name = 'Estimated Billing' AND p_source_table = 'OKL_TRX_QUOTES_B' THEN -- Termination/Repurchase quote creation/updation
7228: IF p_qtp_code LIKE 'TER%' THEN
7229: IF p_early_term_yn = 'Y' THEN
7230: -- get Early term purchase option - K level
7231:

Line 7806: IF ( (p_source_trx_name IS NULL AND p_source_table = 'OKL_TRX_QUOTES_B' AND p_qtp_code LIKE 'REP%')-- Repurchase quote creation/updation

7802:
7803: END IF;
7804:
7805:
7806: IF ( (p_source_trx_name IS NULL AND p_source_table = 'OKL_TRX_QUOTES_B' AND p_qtp_code LIKE 'REP%')-- Repurchase quote creation/updation
7807: OR
7808: ( ( p_source_trx_name = 'Billing' OR p_source_trx_name = 'Credit Memo' )
7809: AND ( p_source_table = 'OKL_TXD_AR_LN_DTLS_B' )
7810: AND ( p_qtp_code LIKE 'REP%' OR p_purpose_code IN ('AMBSPR','CURE','REPAIR_CHARGE') )

Line 9941: --p_source_trx_id ---> okl_trx_quotes_b.id

9937: p_source_trx_name IN VARCHAR2,
9938: p_source_table IN VARCHAR2) IS
9939:
9940: ---- Termination/Repurchase Quote Creation -------
9941: --p_source_trx_id ---> okl_trx_quotes_b.id
9942: --p_source_trx_name ---> 'Estimated Billing'
9943: --p_source_table ---> 'OKL_TRX_QUOTES_B'
9944: --------------------------------------------------
9945:

Line 9943: --p_source_table ---> 'OKL_TRX_QUOTES_B'

9939:
9940: ---- Termination/Repurchase Quote Creation -------
9941: --p_source_trx_id ---> okl_trx_quotes_b.id
9942: --p_source_trx_name ---> 'Estimated Billing'
9943: --p_source_table ---> 'OKL_TRX_QUOTES_B'
9944: --------------------------------------------------
9945:
9946: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
9947:

Line 9952: FROM okl_trx_quotes_b

9948: -- Get quote details
9949: CURSOR l_trxquotes_csr(cp_qte_id IN NUMBER) IS
9950: SELECT khr_id, date_effective_from, early_termination_yn, qtp_code,
9951: legal_entity_id, qrs_code
9952: FROM okl_trx_quotes_b
9953: WHERE id = cp_qte_id;
9954:
9955: -- get the previous tax source transaction for this quote
9956: CURSOR l_prevtaxsources_csr(cp_trx_id IN NUMBER) IS

Line 17481: --p_source_trx_id ---> okl_trx_quotes_b.id

17477: --p_source_table ---> 'OKL_TRX_ASSETS'
17478: --------------------------------------------------
17479:
17480: ---- Termination/Repurchase Quote Creation -------
17481: --p_source_trx_id ---> okl_trx_quotes_b.id
17482: --p_source_trx_name ---> 'Estimated Billing'
17483: --p_source_table ---> 'OKL_TRX_QUOTES_B'
17484: --------------------------------------------------
17485:

Line 17483: --p_source_table ---> 'OKL_TRX_QUOTES_B'

17479:
17480: ---- Termination/Repurchase Quote Creation -------
17481: --p_source_trx_id ---> okl_trx_quotes_b.id
17482: --p_source_trx_name ---> 'Estimated Billing'
17483: --p_source_table ---> 'OKL_TRX_QUOTES_B'
17484: --------------------------------------------------
17485:
17486: /*-----------------------------------------------------------------------+
17487: | Cursor Declarations |

Line 17611: ELSIF p_source_trx_name = 'Estimated Billing' AND l_source_table = 'OKL_TRX_QUOTES_B' THEN -- AM Quote creation

17607: OKL_API.set_message( p_app_name => 'OKL',
17608: p_msg_name => 'OKL_TAX_SCH_FLAG_NOT_SET');
17609: END IF;
17610:
17611: ELSIF p_source_trx_name = 'Estimated Billing' AND l_source_table = 'OKL_TRX_QUOTES_B' THEN -- AM Quote creation
17612: process_quote_tax( p_api_version => p_api_version,
17613: p_init_msg_list => OKL_API.G_FALSE,
17614: x_return_status => x_return_status,
17615: x_msg_count => x_msg_count,

Line 18946: FROM okl_trx_quotes_b

18942:
18943: -- Get the quote details
18944: CURSOR l_trxquotes_csr(cp_qte_id IN NUMBER) IS
18945: SELECT qtp_code, qrs_code, early_termination_yn
18946: FROM okl_trx_quotes_b
18947: WHERE id = cp_qte_id;
18948:
18949: -- Get stream type purpose for a given stream type id
18950: CURSOR l_strmtype_csr(cp_sty_id IN NUMBER) IS

Line 19036: l_qtp_code okl_trx_quotes_b.qtp_code%TYPE;

19032: -- Local variables
19033: l_api_version CONSTANT NUMBER := 1;
19034: l_api_name CONSTANT VARCHAR2(30) := 'get_tax_determinants';
19035:
19036: l_qtp_code okl_trx_quotes_b.qtp_code%TYPE;
19037: l_qte_reason okl_trx_quotes_b.qrs_code%TYPE;
19038: l_early_term_yn okl_trx_quotes_b.early_termination_yn%TYPE;
19039: l_purpose_code okl_strm_type_b.stream_type_purpose%TYPE;
19040: l_product_type VARCHAR2(30);

Line 19037: l_qte_reason okl_trx_quotes_b.qrs_code%TYPE;

19033: l_api_version CONSTANT NUMBER := 1;
19034: l_api_name CONSTANT VARCHAR2(30) := 'get_tax_determinants';
19035:
19036: l_qtp_code okl_trx_quotes_b.qtp_code%TYPE;
19037: l_qte_reason okl_trx_quotes_b.qrs_code%TYPE;
19038: l_early_term_yn okl_trx_quotes_b.early_termination_yn%TYPE;
19039: l_purpose_code okl_strm_type_b.stream_type_purpose%TYPE;
19040: l_product_type VARCHAR2(30);
19041: l_def_tax_country VARCHAR2(2);

Line 19038: l_early_term_yn okl_trx_quotes_b.early_termination_yn%TYPE;

19034: l_api_name CONSTANT VARCHAR2(30) := 'get_tax_determinants';
19035:
19036: l_qtp_code okl_trx_quotes_b.qtp_code%TYPE;
19037: l_qte_reason okl_trx_quotes_b.qrs_code%TYPE;
19038: l_early_term_yn okl_trx_quotes_b.early_termination_yn%TYPE;
19039: l_purpose_code okl_strm_type_b.stream_type_purpose%TYPE;
19040: l_product_type VARCHAR2(30);
19041: l_def_tax_country VARCHAR2(2);
19042: l_reporting_flag VARCHAR2(1);