APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_TRX_REQUESTS

Line 8148: FROM okl_trx_requests a, okl_trx_types_tl b

8144:
8145: -- get the tax schedule request details
8146: CURSOR l_trxrequests_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
8147: SELECT a.dnz_khr_id, a.start_date, a.end_date, a.try_id, a.legal_entity_id, a.org_id
8148: FROM okl_trx_requests a, okl_trx_types_tl b
8149: WHERE a.id = cp_trx_id
8150: AND a.try_id = b.id
8151: AND b.name = cp_trx_type_name
8152: AND language = 'US';

Line 10877: | p_request_id -- Id of OKL_trx_Requests

10873: | p_source_trx_name -- Source transaction Name
10874: | p_source_table -- Source table
10875: | p_tax_call_type -- Tax call type (Values - 'ESTIMATED'/ 'ACTUAL')
10876: | p_serialized_asset -- Serialized Asset (Values - 'Y'/'N')
10877: | p_request_id -- Id of OKL_trx_Requests
10878: | p_alc_final_call -- Determines if the asset location change final
10879: | call is being made for the serialized asset
10880: | (Values - null/'N'/'Y')
10881: |

Line 10912: --p_request_id ---> Id of OKL_trx_Requests

10908: --p_source_trx_name ---> 'Asset Relocation' (changed from Internal Asset Creation to Asset Relocation)
10909: --p_source_table ---> 'OKL_TRX_ASSETS'
10910: --p_tax_call_type ---> Tax call type
10911: --p_serialized_asset ---> Serialized Asset (Y/N)
10912: --p_request_id ---> Id of OKL_trx_Requests
10913: --------------------------------------------------
10914: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10915:
10916: -- validate source trx id

Line 17420: | p_request_id -- ID of Okl_Trx_Requests (applies to Asset Location Change)

17416: | p_source_trx_name -- Source transaction Name
17417: | p_source_table -- Source table
17418: | p_tax_call_type -- Tax call type (applies to Booking, Rebook, Asset Location Change)
17419: | p_serialized_asset -- Serialized asset Y/N flag (applies to Asset Location Change)
17420: | p_request_id -- ID of Okl_Trx_Requests (applies to Asset Location Change)
17421: |
17422: | KNOWN ISSUES
17423: |
17424: | NOTES

Line 17449: --p_source_trx_id ---> okl_trx_requests.id

17445: p_request_id IN NUMBER DEFAULT NULL,
17446: p_alc_final_call IN VARCHAR2 DEFAULT NULL)IS
17447:
17448: --------------- CS Tax Schedule ------------------
17449: --p_source_trx_id ---> okl_trx_requests.id
17450: --p_source_trx_name ---> 'Tax Schedule'
17451: --p_source_table ---> 'OKL_TRX_REQUESTS'
17452: --------------------------------------------------
17453:

Line 17451: --p_source_table ---> 'OKL_TRX_REQUESTS'

17447:
17448: --------------- CS Tax Schedule ------------------
17449: --p_source_trx_id ---> okl_trx_requests.id
17450: --p_source_trx_name ---> 'Tax Schedule'
17451: --p_source_table ---> 'OKL_TRX_REQUESTS'
17452: --------------------------------------------------
17453:
17454: --------------- Booking ------------------
17455: --p_source_trx_id ---> okl_trx_contracts.id

Line 17499: okl_trx_requests trx

17495: CURSOR l_tax_schedule_csr(cp_trx_id IN NUMBER) IS
17496: SELECT rul.rule_information5
17497: FROM okc_rules_b rul,
17498: okc_rule_groups_b rgp,
17499: okl_trx_requests trx
17500: WHERE rgp.dnz_chr_id = trx.dnz_khr_id
17501: AND rul.rgp_id = rgp.id
17502: AND rgp.rgd_code = 'LAHDTX'
17503: AND rul.rule_information_category = 'LASTPR'