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 13192: --p_source_trx_id ---> okl_trx_contracts.id

13188: p_source_table IN VARCHAR2,
13189: p_tax_call_type IN VARCHAR2) IS
13190:
13191: -------------Booking --------------
13192: --p_source_trx_id ---> okl_trx_contracts.id
13193: --p_source_trx_name ---> 'Booking'
13194: --p_source_table ---> 'OKL_TRX_CONTRACTS'
13195: --p_tax_call_type ---> 'ESTIMATED'/'ACTUAL'
13196: --------------------------------------------------

Line 13194: --p_source_table ---> 'OKL_TRX_CONTRACTS'

13190:
13191: -------------Booking --------------
13192: --p_source_trx_id ---> okl_trx_contracts.id
13193: --p_source_trx_name ---> 'Booking'
13194: --p_source_table ---> 'OKL_TRX_CONTRACTS'
13195: --p_tax_call_type ---> 'ESTIMATED'/'ACTUAL'
13196: --------------------------------------------------
13197: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
13198:

Line 13202: FROM okl_trx_contracts a , okl_trx_types_tl b

13198:
13199: -- validate source trx id (Booking)
13200: CURSOR l_trxcontracts_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
13201: SELECT a.try_id, a.khr_id, a.legal_entity_id
13202: FROM okl_trx_contracts a , okl_trx_types_tl b
13203: WHERE a.id = cp_trx_id
13204: AND a.try_id = b.id
13205: AND b.name = cp_trx_type_name
13206: AND language = 'US';

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

13205: AND b.name = cp_trx_type_name
13206: AND language = 'US';
13207:
13208: -- validate source trx id (Rebook)
13209: -- okl_trx_contracts.khr_id has original contract id
13210: -- okl_trx_contracts.khr_id_new has rebook copy contract id
13211: CURSOR l_trxcontracts_rbk_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
13212: SELECT a.khr_id_new, a.legal_entity_id
13213: FROM okl_trx_contracts a , okl_trx_types_tl b

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

13206: AND language = 'US';
13207:
13208: -- validate source trx id (Rebook)
13209: -- okl_trx_contracts.khr_id has original contract id
13210: -- okl_trx_contracts.khr_id_new has rebook copy contract id
13211: CURSOR l_trxcontracts_rbk_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
13212: SELECT a.khr_id_new, a.legal_entity_id
13213: FROM okl_trx_contracts a , okl_trx_types_tl b
13214: WHERE a.id = cp_trx_id

Line 13213: FROM okl_trx_contracts a , okl_trx_types_tl b

13209: -- okl_trx_contracts.khr_id has original contract id
13210: -- okl_trx_contracts.khr_id_new has rebook copy contract id
13211: CURSOR l_trxcontracts_rbk_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
13212: SELECT a.khr_id_new, a.legal_entity_id
13213: FROM okl_trx_contracts a , okl_trx_types_tl b
13214: WHERE a.id = cp_trx_id
13215: AND a.try_id = b.id
13216: AND b.name = cp_trx_type_name
13217: AND language = 'US';

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

14925: p_source_table IN VARCHAR2,
14926: p_tax_call_type IN VARCHAR2) IS
14927:
14928: -------------Pre Rebook --------------
14929: --p_source_trx_id ---> okl_trx_contracts.id
14930: --p_source_trx_name ---> 'Rebook'
14931: --p_source_table ---> 'OKL_TRX_CONTRACTS'
14932: --p_tax_call_type ---> 'ESTIMATED'
14933: --------------------------------------------------

Line 14931: --p_source_table ---> 'OKL_TRX_CONTRACTS'

14927:
14928: -------------Pre Rebook --------------
14929: --p_source_trx_id ---> okl_trx_contracts.id
14930: --p_source_trx_name ---> 'Rebook'
14931: --p_source_table ---> 'OKL_TRX_CONTRACTS'
14932: --p_tax_call_type ---> 'ESTIMATED'
14933: --------------------------------------------------
14934:
14935: BEGIN

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

15061: p_source_trx_name IN VARCHAR2,
15062: p_source_table IN VARCHAR2) IS
15063:
15064: -------------Rebook --------------
15065: --p_source_trx_id ---> okl_trx_contracts.id
15066: --p_source_trx_name ---> 'Rebook'
15067: --p_source_table ---> 'OKL_TRX_CONTRACTS'
15068: --------------------------------------------------
15069:

Line 15067: --p_source_table ---> 'OKL_TRX_CONTRACTS'

15063:
15064: -------------Rebook --------------
15065: --p_source_trx_id ---> okl_trx_contracts.id
15066: --p_source_trx_name ---> 'Rebook'
15067: --p_source_table ---> 'OKL_TRX_CONTRACTS'
15068: --------------------------------------------------
15069:
15070: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
15071:

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

15069:
15070: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
15071:
15072: -- validate source trx id
15073: -- okl_trx_contracts.khr_id has original contract id
15074: -- okl_trx_contracts.khr_id_new has rebook copy contract id
15075: CURSOR l_trxcontracts_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
15076: SELECT a.try_id, a.khr_id, a.khr_id_new, a.date_transaction_occurred
15077: FROM okl_trx_contracts a , okl_trx_types_tl b

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

15070: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
15071:
15072: -- validate source trx id
15073: -- okl_trx_contracts.khr_id has original contract id
15074: -- okl_trx_contracts.khr_id_new has rebook copy contract id
15075: CURSOR l_trxcontracts_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
15076: SELECT a.try_id, a.khr_id, a.khr_id_new, a.date_transaction_occurred
15077: FROM okl_trx_contracts a , okl_trx_types_tl b
15078: WHERE a.id = cp_trx_id

Line 15077: FROM okl_trx_contracts a , okl_trx_types_tl b

15073: -- okl_trx_contracts.khr_id has original contract id
15074: -- okl_trx_contracts.khr_id_new has rebook copy contract id
15075: CURSOR l_trxcontracts_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
15076: SELECT a.try_id, a.khr_id, a.khr_id_new, a.date_transaction_occurred
15077: FROM okl_trx_contracts a , okl_trx_types_tl b
15078: WHERE a.id = cp_trx_id
15079: AND a.try_id = b.id
15080: AND b.name = cp_trx_type_name
15081: AND language = 'US';

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

17523: --p_source_table ---> 'OKL_TRX_REQUESTS'
17524: --------------------------------------------------
17525:
17526: --------------- Booking ------------------
17527: --p_source_trx_id ---> okl_trx_contracts.id
17528: --p_source_trx_name ---> 'Booking'
17529: --p_source_table ---> 'OKL_TRX_CONTRACTS'
17530: --p_tax_call_type ---> 'ESTIMATED'/'ACTUAL' call type
17531: --------------------------------------------------

Line 17529: --p_source_table ---> 'OKL_TRX_CONTRACTS'

17525:
17526: --------------- Booking ------------------
17527: --p_source_trx_id ---> okl_trx_contracts.id
17528: --p_source_trx_name ---> 'Booking'
17529: --p_source_table ---> 'OKL_TRX_CONTRACTS'
17530: --p_tax_call_type ---> 'ESTIMATED'/'ACTUAL' call type
17531: --------------------------------------------------
17532:
17533: --------------- Rebook ------------------

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

17530: --p_tax_call_type ---> 'ESTIMATED'/'ACTUAL' call type
17531: --------------------------------------------------
17532:
17533: --------------- Rebook ------------------
17534: --p_source_trx_id ---> okl_trx_contracts.id
17535: --p_source_trx_name ---> 'Rebook'
17536: --p_source_table ---> 'OKL_TRX_CONTRACTS'
17537: --p_tax_call_type ---> 'ESTIMATED'/'ACTUAL' call type
17538: --------------------------------------------------

Line 17536: --p_source_table ---> 'OKL_TRX_CONTRACTS'

17532:
17533: --------------- Rebook ------------------
17534: --p_source_trx_id ---> okl_trx_contracts.id
17535: --p_source_trx_name ---> 'Rebook'
17536: --p_source_table ---> 'OKL_TRX_CONTRACTS'
17537: --p_tax_call_type ---> 'ESTIMATED'/'ACTUAL' call type
17538: --------------------------------------------------
17539:
17540: -------------- Split Asset ------------------

Line 17590: CURSOR get_rbk_act_khr(p_trx_id okl_trx_contracts.ID%TYPE) IS

17586: AND inst.tas_id = trx.ID
17587: AND cle.ID = inst.kle_id
17588: AND trx.id = p_trx_id;
17589:
17590: CURSOR get_rbk_act_khr(p_trx_id okl_trx_contracts.ID%TYPE) IS
17591: SELECT chr.ID
17592: FROM okl_trx_contracts trx,
17593: okc_k_headers_b chr
17594: WHERE chr.ID = trx.khr_id

Line 17592: FROM okl_trx_contracts trx,

17588: AND trx.id = p_trx_id;
17589:
17590: CURSOR get_rbk_act_khr(p_trx_id okl_trx_contracts.ID%TYPE) IS
17591: SELECT chr.ID
17592: FROM okl_trx_contracts trx,
17593: okc_k_headers_b chr
17594: WHERE chr.ID = trx.khr_id
17595: AND trx.ID = p_trx_id ;
17596:

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

Line 20882: | p_source_table -- OKL_TRX_CONTRACTS

Line 20941: FROM okl_trx_contracts a , okl_trx_types_tl b

20937: AND TAX_LINE_STATUS_CODE = G_ACTIVE_STATUS;
20938:
20939: CURSOR l_trxcontracts_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
20940: SELECT '1'
20941: FROM okl_trx_contracts a , okl_trx_types_tl b
20942: WHERE a.id = cp_trx_id
20943: AND a.try_id = b.id
20944: AND b.name = cp_trx_type_name
20945: AND language = 'US';

Line 20949: FROM okl_trx_contracts_all a , okl_trx_types_tl b

20945: AND language = 'US';
20946:
20947: CURSOR l_trxcontracts_base_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
20948: SELECT '1'
20949: FROM okl_trx_contracts_all a , okl_trx_types_tl b
20950: WHERE a.id = cp_trx_id
20951: AND a.try_id = b.id
20952: AND b.name = cp_trx_type_name
20953: AND language = 'US';