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_CONTRACTS

Line 2600: --p_source_table ---> 'OKL_TRX_CONTRACTS'

2596:
2597: ------------- Reverse contract -------------------------
2598: --p_source_trx_id ---> okl_trx_assets.id
2599: --p_source_trx_name ---> 'Reverse'
2600: --p_source_table ---> 'OKL_TRX_CONTRACTS'
2601: --------------------------------------------------
2602: -- Local variables
2603: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2604: l_rev_trx_type_id NUMBER;

Line 2648: FROM okl_trx_contracts a, okl_trx_types_tl b

2644: AND tax_line_status_code = G_ACTIVE_STATUS;
2645:
2646: CURSOR l_trxcontracts_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
2647: SELECT a.try_id, a.khr_id, a.legal_entity_id, a.date_transaction_occurred
2648: FROM okl_trx_contracts a, okl_trx_types_tl b
2649: WHERE a.id = cp_trx_id
2650: AND a.try_id = b.id
2651: AND b.name = cp_trx_type_name
2652: AND language = 'US';

Line 13157: --p_source_trx_id ---> okl_trx_contracts.id

13153: p_source_table IN VARCHAR2,
13154: p_tax_call_type IN VARCHAR2) IS
13155:
13156: -------------Booking --------------
13157: --p_source_trx_id ---> okl_trx_contracts.id
13158: --p_source_trx_name ---> 'Booking'
13159: --p_source_table ---> 'OKL_TRX_CONTRACTS'
13160: --p_tax_call_type ---> 'ESTIMATED'/'ACTUAL'
13161: --------------------------------------------------

Line 13159: --p_source_table ---> 'OKL_TRX_CONTRACTS'

13155:
13156: -------------Booking --------------
13157: --p_source_trx_id ---> okl_trx_contracts.id
13158: --p_source_trx_name ---> 'Booking'
13159: --p_source_table ---> 'OKL_TRX_CONTRACTS'
13160: --p_tax_call_type ---> 'ESTIMATED'/'ACTUAL'
13161: --------------------------------------------------
13162: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
13163:

Line 13167: FROM okl_trx_contracts a , okl_trx_types_tl b

13163:
13164: -- validate source trx id (Booking)
13165: CURSOR l_trxcontracts_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
13166: SELECT a.try_id, a.khr_id, a.legal_entity_id
13167: FROM okl_trx_contracts a , okl_trx_types_tl b
13168: WHERE a.id = cp_trx_id
13169: AND a.try_id = b.id
13170: AND b.name = cp_trx_type_name
13171: AND language = 'US';

Line 13174: -- okl_trx_contracts.khr_id has original contract id

13170: AND b.name = cp_trx_type_name
13171: AND language = 'US';
13172:
13173: -- validate source trx id (Rebook)
13174: -- okl_trx_contracts.khr_id has original contract id
13175: -- okl_trx_contracts.khr_id_new has rebook copy contract id
13176: CURSOR l_trxcontracts_rbk_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
13177: SELECT a.khr_id_new, a.legal_entity_id
13178: FROM okl_trx_contracts a , okl_trx_types_tl b

Line 13175: -- okl_trx_contracts.khr_id_new has rebook copy contract id

13171: AND language = 'US';
13172:
13173: -- validate source trx id (Rebook)
13174: -- okl_trx_contracts.khr_id has original contract id
13175: -- okl_trx_contracts.khr_id_new has rebook copy contract id
13176: CURSOR l_trxcontracts_rbk_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
13177: SELECT a.khr_id_new, a.legal_entity_id
13178: FROM okl_trx_contracts a , okl_trx_types_tl b
13179: WHERE a.id = cp_trx_id

Line 13178: FROM okl_trx_contracts a , okl_trx_types_tl b

13174: -- okl_trx_contracts.khr_id has original contract id
13175: -- okl_trx_contracts.khr_id_new has rebook copy contract id
13176: CURSOR l_trxcontracts_rbk_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
13177: SELECT a.khr_id_new, a.legal_entity_id
13178: FROM okl_trx_contracts a , okl_trx_types_tl b
13179: WHERE a.id = cp_trx_id
13180: AND a.try_id = b.id
13181: AND b.name = cp_trx_type_name
13182: AND language = 'US';

Line 14858: --p_source_trx_id ---> okl_trx_contracts.id

14854: p_source_table IN VARCHAR2,
14855: p_tax_call_type IN VARCHAR2) IS
14856:
14857: -------------Pre Rebook --------------
14858: --p_source_trx_id ---> okl_trx_contracts.id
14859: --p_source_trx_name ---> 'Rebook'
14860: --p_source_table ---> 'OKL_TRX_CONTRACTS'
14861: --p_tax_call_type ---> 'ESTIMATED'
14862: --------------------------------------------------

Line 14860: --p_source_table ---> 'OKL_TRX_CONTRACTS'

14856:
14857: -------------Pre Rebook --------------
14858: --p_source_trx_id ---> okl_trx_contracts.id
14859: --p_source_trx_name ---> 'Rebook'
14860: --p_source_table ---> 'OKL_TRX_CONTRACTS'
14861: --p_tax_call_type ---> 'ESTIMATED'
14862: --------------------------------------------------
14863:
14864: BEGIN

Line 14994: --p_source_trx_id ---> okl_trx_contracts.id

14990: p_source_trx_name IN VARCHAR2,
14991: p_source_table IN VARCHAR2) IS
14992:
14993: -------------Rebook --------------
14994: --p_source_trx_id ---> okl_trx_contracts.id
14995: --p_source_trx_name ---> 'Rebook'
14996: --p_source_table ---> 'OKL_TRX_CONTRACTS'
14997: --------------------------------------------------
14998:

Line 14996: --p_source_table ---> 'OKL_TRX_CONTRACTS'

14992:
14993: -------------Rebook --------------
14994: --p_source_trx_id ---> okl_trx_contracts.id
14995: --p_source_trx_name ---> 'Rebook'
14996: --p_source_table ---> 'OKL_TRX_CONTRACTS'
14997: --------------------------------------------------
14998:
14999: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
15000:

Line 15002: -- okl_trx_contracts.khr_id has original contract id

14998:
14999: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
15000:
15001: -- validate source trx id
15002: -- okl_trx_contracts.khr_id has original contract id
15003: -- okl_trx_contracts.khr_id_new has rebook copy contract id
15004: CURSOR l_trxcontracts_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
15005: SELECT a.try_id, a.khr_id, a.khr_id_new, a.date_transaction_occurred
15006: FROM okl_trx_contracts a , okl_trx_types_tl b

Line 15003: -- okl_trx_contracts.khr_id_new has rebook copy contract id

14999: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
15000:
15001: -- validate source trx id
15002: -- okl_trx_contracts.khr_id has original contract id
15003: -- okl_trx_contracts.khr_id_new has rebook copy contract id
15004: CURSOR l_trxcontracts_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
15005: SELECT a.try_id, a.khr_id, a.khr_id_new, a.date_transaction_occurred
15006: FROM okl_trx_contracts a , okl_trx_types_tl b
15007: WHERE a.id = cp_trx_id

Line 15006: FROM okl_trx_contracts a , okl_trx_types_tl b

15002: -- okl_trx_contracts.khr_id has original contract id
15003: -- okl_trx_contracts.khr_id_new has rebook copy contract id
15004: CURSOR l_trxcontracts_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
15005: SELECT a.try_id, a.khr_id, a.khr_id_new, a.date_transaction_occurred
15006: FROM okl_trx_contracts a , okl_trx_types_tl b
15007: WHERE a.id = cp_trx_id
15008: AND a.try_id = b.id
15009: AND b.name = cp_trx_type_name
15010: AND language = 'US';

Line 17455: --p_source_trx_id ---> okl_trx_contracts.id

17451: --p_source_table ---> 'OKL_TRX_REQUESTS'
17452: --------------------------------------------------
17453:
17454: --------------- Booking ------------------
17455: --p_source_trx_id ---> okl_trx_contracts.id
17456: --p_source_trx_name ---> 'Booking'
17457: --p_source_table ---> 'OKL_TRX_CONTRACTS'
17458: --p_tax_call_type ---> 'ESTIMATED'/'ACTUAL' call type
17459: --------------------------------------------------

Line 17457: --p_source_table ---> 'OKL_TRX_CONTRACTS'

17453:
17454: --------------- Booking ------------------
17455: --p_source_trx_id ---> okl_trx_contracts.id
17456: --p_source_trx_name ---> 'Booking'
17457: --p_source_table ---> 'OKL_TRX_CONTRACTS'
17458: --p_tax_call_type ---> 'ESTIMATED'/'ACTUAL' call type
17459: --------------------------------------------------
17460:
17461: --------------- Rebook ------------------

Line 17462: --p_source_trx_id ---> okl_trx_contracts.id

17458: --p_tax_call_type ---> 'ESTIMATED'/'ACTUAL' call type
17459: --------------------------------------------------
17460:
17461: --------------- Rebook ------------------
17462: --p_source_trx_id ---> okl_trx_contracts.id
17463: --p_source_trx_name ---> 'Rebook'
17464: --p_source_table ---> 'OKL_TRX_CONTRACTS'
17465: --p_tax_call_type ---> 'ESTIMATED'/'ACTUAL' call type
17466: --------------------------------------------------

Line 17464: --p_source_table ---> 'OKL_TRX_CONTRACTS'

17460:
17461: --------------- Rebook ------------------
17462: --p_source_trx_id ---> okl_trx_contracts.id
17463: --p_source_trx_name ---> 'Rebook'
17464: --p_source_table ---> 'OKL_TRX_CONTRACTS'
17465: --p_tax_call_type ---> 'ESTIMATED'/'ACTUAL' call type
17466: --------------------------------------------------
17467:
17468: -------------- Split Asset ------------------

Line 20692: | p_source_trx_id -- OKL_TRX_CONTRACTS.ID (ID of Pre-Rebook or Rebook transaction)

Line 20694: | p_source_table -- OKL_TRX_CONTRACTS

Line 20753: FROM okl_trx_contracts a , okl_trx_types_tl b

20749: AND TAX_LINE_STATUS_CODE = G_ACTIVE_STATUS;
20750:
20751: CURSOR l_trxcontracts_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
20752: SELECT '1'
20753: FROM okl_trx_contracts a , okl_trx_types_tl b
20754: WHERE a.id = cp_trx_id
20755: AND a.try_id = b.id
20756: AND b.name = cp_trx_type_name
20757: AND language = 'US';

Line 20761: FROM okl_trx_contracts_all a , okl_trx_types_tl b

20757: AND language = 'US';
20758:
20759: CURSOR l_trxcontracts_base_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
20760: SELECT '1'
20761: FROM okl_trx_contracts_all a , okl_trx_types_tl b
20762: WHERE a.id = cp_trx_id
20763: AND a.try_id = b.id
20764: AND b.name = cp_trx_type_name
20765: AND language = 'US';