DBA Data[Home] [Help]

APPS.OKL_LA_SALES_TAX_PVT dependencies on OKL_TRX_CONTRACTS_ALL

Line 857: p_transaction_id IN okl_trx_contracts_all.id%TYPE DEFAULT NULL,

853: p_api_version IN NUMBER,
854: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
855: p_contract_id IN okc_k_headers_all_b.id%TYPE,
856: p_transaction_type IN okl_trx_types_tl.name%TYPE,
857: p_transaction_id IN okl_trx_contracts_all.id%TYPE DEFAULT NULL,
858: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,
859: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
860: --Bug# 6619311
861: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,

Line 858: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,

854: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
855: p_contract_id IN okc_k_headers_all_b.id%TYPE,
856: p_transaction_type IN okl_trx_types_tl.name%TYPE,
857: p_transaction_id IN okl_trx_contracts_all.id%TYPE DEFAULT NULL,
858: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,
859: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
860: --Bug# 6619311
861: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,
862: x_transaction_id OUT NOCOPY okl_trx_contracts_all.id%TYPE,

Line 859: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,

855: p_contract_id IN okc_k_headers_all_b.id%TYPE,
856: p_transaction_type IN okl_trx_types_tl.name%TYPE,
857: p_transaction_id IN okl_trx_contracts_all.id%TYPE DEFAULT NULL,
858: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,
859: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
860: --Bug# 6619311
861: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,
862: x_transaction_id OUT NOCOPY okl_trx_contracts_all.id%TYPE,
863: x_trxh_out_rec OUT NOCOPY Okl_Trx_Contracts_Pvt.tcnv_rec_type, -- R12 Change

Line 861: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,

857: p_transaction_id IN okl_trx_contracts_all.id%TYPE DEFAULT NULL,
858: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,
859: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
860: --Bug# 6619311
861: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,
862: x_transaction_id OUT NOCOPY okl_trx_contracts_all.id%TYPE,
863: x_trxh_out_rec OUT NOCOPY Okl_Trx_Contracts_Pvt.tcnv_rec_type, -- R12 Change
864: x_return_status OUT NOCOPY VARCHAR2,
865: x_msg_count OUT NOCOPY NUMBER,

Line 862: x_transaction_id OUT NOCOPY okl_trx_contracts_all.id%TYPE,

858: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,
859: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
860: --Bug# 6619311
861: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,
862: x_transaction_id OUT NOCOPY okl_trx_contracts_all.id%TYPE,
863: x_trxh_out_rec OUT NOCOPY Okl_Trx_Contracts_Pvt.tcnv_rec_type, -- R12 Change
864: x_return_status OUT NOCOPY VARCHAR2,
865: x_msg_count OUT NOCOPY NUMBER,
866: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 3190: ,p_transaction_id IN okl_trx_contracts_all.khr_id%TYPE

3186: PROCEDURE create_upfront_tax_accounting(
3187: p_api_version IN NUMBER
3188: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3189: ,p_contract_id IN okc_k_headers_all_b.id%TYPE
3190: ,p_transaction_id IN okl_trx_contracts_all.khr_id%TYPE
3191: ,p_transaction_type IN VARCHAR2
3192: ,x_return_status OUT NOCOPY VARCHAR2
3193: ,x_msg_count OUT NOCOPY NUMBER
3194: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 3352: FROM okl_trx_contracts_all a

3348: IS
3349: SELECT 1
3350: FROM dual
3351: WHERE EXISTS (SELECT a.id
3352: FROM okl_trx_contracts_all a
3353: ,okl_trx_types_v b
3354: WHERE a.khr_id = p_contract_id
3355: AND a.try_id = b.id
3356: --rkuttiya added for 12.1.1 Multi GAAP