1011: p_api_version IN NUMBER,
1012: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1013: p_contract_id IN okc_k_headers_all_b.id%TYPE,
1014: p_transaction_type IN okl_trx_types_tl.name%TYPE,
1015: p_transaction_id IN okl_trx_contracts_all.id%TYPE DEFAULT NULL,
1016: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,
1017: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
1018: --Bug# 6619311
1019: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,
1012: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1013: p_contract_id IN okc_k_headers_all_b.id%TYPE,
1014: p_transaction_type IN okl_trx_types_tl.name%TYPE,
1015: p_transaction_id IN okl_trx_contracts_all.id%TYPE DEFAULT NULL,
1016: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,
1017: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
1018: --Bug# 6619311
1019: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,
1020: x_transaction_id OUT NOCOPY okl_trx_contracts_all.id%TYPE,
1013: p_contract_id IN okc_k_headers_all_b.id%TYPE,
1014: p_transaction_type IN okl_trx_types_tl.name%TYPE,
1015: p_transaction_id IN okl_trx_contracts_all.id%TYPE DEFAULT NULL,
1016: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,
1017: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
1018: --Bug# 6619311
1019: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,
1020: x_transaction_id OUT NOCOPY okl_trx_contracts_all.id%TYPE,
1021: x_trxh_out_rec OUT NOCOPY Okl_Trx_Contracts_Pvt.tcnv_rec_type, -- R12 Change
1015: p_transaction_id IN okl_trx_contracts_all.id%TYPE DEFAULT NULL,
1016: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,
1017: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
1018: --Bug# 6619311
1019: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,
1020: x_transaction_id OUT NOCOPY okl_trx_contracts_all.id%TYPE,
1021: x_trxh_out_rec OUT NOCOPY Okl_Trx_Contracts_Pvt.tcnv_rec_type, -- R12 Change
1022: x_return_status OUT NOCOPY VARCHAR2,
1023: x_msg_count OUT NOCOPY NUMBER,
1016: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,
1017: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
1018: --Bug# 6619311
1019: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,
1020: x_transaction_id OUT NOCOPY okl_trx_contracts_all.id%TYPE,
1021: x_trxh_out_rec OUT NOCOPY Okl_Trx_Contracts_Pvt.tcnv_rec_type, -- R12 Change
1022: x_return_status OUT NOCOPY VARCHAR2,
1023: x_msg_count OUT NOCOPY NUMBER,
1024: x_msg_data OUT NOCOPY VARCHAR2) IS
3390: PROCEDURE create_upfront_tax_accounting(
3391: p_api_version IN NUMBER
3392: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3393: ,p_contract_id IN okc_k_headers_all_b.id%TYPE
3394: ,p_transaction_id IN okl_trx_contracts_all.khr_id%TYPE
3395: ,p_transaction_type IN VARCHAR2
3396: ,x_return_status OUT NOCOPY VARCHAR2
3397: ,x_msg_count OUT NOCOPY NUMBER
3398: ,x_msg_data OUT NOCOPY VARCHAR2)
3552: IS
3553: SELECT 1
3554: FROM dual
3555: WHERE EXISTS (SELECT a.id
3556: FROM okl_trx_contracts_all a
3557: ,okl_trx_types_v b
3558: WHERE a.khr_id = p_contract_id
3559: AND a.try_id = b.id
3560: --rkuttiya added for 12.1.1 Multi GAAP