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 7258: IF p_source_trx_name = 'Estimated Billing' AND p_source_table = 'OKL_TRX_QUOTES_B' THEN -- Termination/Repurchase quote creation/updation

7254: p_token1_value => 'Financial Product');
7255: RAISE OKL_API.G_EXCEPTION_ERROR;
7256: END IF;
7257:
7258: IF p_source_trx_name = 'Estimated Billing' AND p_source_table = 'OKL_TRX_QUOTES_B' THEN -- Termination/Repurchase quote creation/updation
7259: IF p_qtp_code LIKE 'TER%' THEN
7260: IF p_early_term_yn = 'Y' THEN
7261: -- get Early term purchase option - K level
7262:

Line 7837: 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

7833:
7834: END IF;
7835:
7836:
7837: 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
7838: OR
7839: ( ( p_source_trx_name = 'Billing' OR p_source_trx_name = 'Credit Memo' )
7840: AND ( p_source_table = 'OKL_TXD_AR_LN_DTLS_B' )
7841: AND ( p_qtp_code LIKE 'REP%' OR p_purpose_code IN ('AMBSPR','CURE','REPAIR_CHARGE') )

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

9970: p_source_trx_name IN VARCHAR2,
9971: p_source_table IN VARCHAR2) IS
9972:
9973: ---- Termination/Repurchase Quote Creation -------
9974: --p_source_trx_id ---> okl_trx_quotes_b.id
9975: --p_source_trx_name ---> 'Estimated Billing'
9976: --p_source_table ---> 'OKL_TRX_QUOTES_B'
9977: --------------------------------------------------
9978:

Line 9976: --p_source_table ---> 'OKL_TRX_QUOTES_B'

9972:
9973: ---- Termination/Repurchase Quote Creation -------
9974: --p_source_trx_id ---> okl_trx_quotes_b.id
9975: --p_source_trx_name ---> 'Estimated Billing'
9976: --p_source_table ---> 'OKL_TRX_QUOTES_B'
9977: --------------------------------------------------
9978:
9979: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
9980:

Line 9985: FROM okl_trx_quotes_b

9981: -- Get quote details
9982: CURSOR l_trxquotes_csr(cp_qte_id IN NUMBER) IS
9983: SELECT khr_id, date_effective_from, early_termination_yn, qtp_code,
9984: legal_entity_id, qrs_code
9985: FROM okl_trx_quotes_b
9986: WHERE id = cp_qte_id;
9987:
9988: -- get the previous tax source transaction for this quote
9989: CURSOR l_prevtaxsources_csr(cp_trx_id IN NUMBER) IS

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

17549: --p_source_table ---> 'OKL_TRX_ASSETS'
17550: --------------------------------------------------
17551:
17552: ---- Termination/Repurchase Quote Creation -------
17553: --p_source_trx_id ---> okl_trx_quotes_b.id
17554: --p_source_trx_name ---> 'Estimated Billing'
17555: --p_source_table ---> 'OKL_TRX_QUOTES_B'
17556: --------------------------------------------------
17557:

Line 17555: --p_source_table ---> 'OKL_TRX_QUOTES_B'

17551:
17552: ---- Termination/Repurchase Quote Creation -------
17553: --p_source_trx_id ---> okl_trx_quotes_b.id
17554: --p_source_trx_name ---> 'Estimated Billing'
17555: --p_source_table ---> 'OKL_TRX_QUOTES_B'
17556: --------------------------------------------------
17557:
17558: /*-----------------------------------------------------------------------+
17559: | Cursor Declarations |

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

17709: OKL_API.set_message( p_app_name => 'OKL',
17710: p_msg_name => 'OKL_TAX_SCH_FLAG_NOT_SET');
17711: END IF;
17712:
17713: ELSIF p_source_trx_name = 'Estimated Billing' AND l_source_table = 'OKL_TRX_QUOTES_B' THEN -- AM Quote creation
17714: process_quote_tax( p_api_version => p_api_version,
17715: p_init_msg_list => OKL_API.G_FALSE,
17716: x_return_status => x_return_status,
17717: x_msg_count => x_msg_count,

Line 19113: FROM okl_trx_quotes_b

19109:
19110: -- Get the quote details
19111: CURSOR l_trxquotes_csr(cp_qte_id IN NUMBER) IS
19112: SELECT qtp_code, qrs_code, early_termination_yn
19113: FROM okl_trx_quotes_b
19114: WHERE id = cp_qte_id;
19115:
19116: -- Get stream type purpose for a given stream type id
19117: CURSOR l_strmtype_csr(cp_sty_id IN NUMBER) IS

Line 19203: l_qtp_code okl_trx_quotes_b.qtp_code%TYPE;

19199: -- Local variables
19200: l_api_version CONSTANT NUMBER := 1;
19201: l_api_name CONSTANT VARCHAR2(30) := 'get_tax_determinants';
19202:
19203: l_qtp_code okl_trx_quotes_b.qtp_code%TYPE;
19204: l_qte_reason okl_trx_quotes_b.qrs_code%TYPE;
19205: l_early_term_yn okl_trx_quotes_b.early_termination_yn%TYPE;
19206: l_purpose_code okl_strm_type_b.stream_type_purpose%TYPE;
19207: l_product_type VARCHAR2(30);

Line 19204: l_qte_reason okl_trx_quotes_b.qrs_code%TYPE;

19200: l_api_version CONSTANT NUMBER := 1;
19201: l_api_name CONSTANT VARCHAR2(30) := 'get_tax_determinants';
19202:
19203: l_qtp_code okl_trx_quotes_b.qtp_code%TYPE;
19204: l_qte_reason okl_trx_quotes_b.qrs_code%TYPE;
19205: l_early_term_yn okl_trx_quotes_b.early_termination_yn%TYPE;
19206: l_purpose_code okl_strm_type_b.stream_type_purpose%TYPE;
19207: l_product_type VARCHAR2(30);
19208: l_def_tax_country VARCHAR2(2);

Line 19205: l_early_term_yn okl_trx_quotes_b.early_termination_yn%TYPE;

19201: l_api_name CONSTANT VARCHAR2(30) := 'get_tax_determinants';
19202:
19203: l_qtp_code okl_trx_quotes_b.qtp_code%TYPE;
19204: l_qte_reason okl_trx_quotes_b.qrs_code%TYPE;
19205: l_early_term_yn okl_trx_quotes_b.early_termination_yn%TYPE;
19206: l_purpose_code okl_strm_type_b.stream_type_purpose%TYPE;
19207: l_product_type VARCHAR2(30);
19208: l_def_tax_country VARCHAR2(2);
19209: l_reporting_flag VARCHAR2(1);