DBA Data[Home] [Help]

APPS.OKL_LA_SALES_TAX_PVT dependencies on OKL_TRX_CONTRACTS_ALL

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

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,

Line 1016: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%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,

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

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

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

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,

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

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

Line 3394: ,p_transaction_id IN okl_trx_contracts_all.khr_id%TYPE

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)

Line 3556: FROM okl_trx_contracts_all a

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