APPS.OKL_RELEASE_PVT dependencies on OKL_TRX_CONTRACTS

Line 107: FROM okl_trx_contracts

103: IS
104: SELECT tsu_code,
105: complete_transfer_yn,
106: date_transaction_occurred
107: FROM okl_trx_contracts
108: where id = p_source_trx_id;
109:
110: taa_request_rec taa_request_csr%ROWTYPE;
111:

Line 1700: okl_trx_contracts_pub.create_trx_contracts

1696: p_token1 => 'CONTRACT_NUMBER',
1697: p_token1_value => l_cntrct_number);
1698: RAISE OKL_API.G_EXCEPTION_ERROR;
1699: END IF;
1700: okl_trx_contracts_pub.create_trx_contracts
1701: (p_api_version => p_api_version,
1702: p_init_msg_list => p_init_msg_list,
1703: x_return_status => x_return_status,
1704: x_msg_count => x_msg_count,

Line 1789: FROM okl_trx_contracts

1785:
1786: CURSOR taa_party_info_csr(p_taa_trx_id IN NUMBER) IS
1787: SELECT party_rel_id2_new,
1788: trx_number
1789: FROM okl_trx_contracts
1790: WHERE id = p_taa_trx_id;
1791:
1792: taa_party_info_rec taa_party_info_csr%ROWTYPE;
1793:

Line 2275: FROM okl_trx_contracts tcn

2271: -- Called at activation to exclude the current contract --
2272: CURSOR pending_trx_act_csr(p_chr_id IN NUMBER)
2273: IS
2274: SELECT 'Y'
2275: FROM okl_trx_contracts tcn
2276: WHERE tcn.khr_id = p_chr_id
2277: AND tcn.tsu_code IN ('ENTERED','WORKING','WAITING','SUBMITTED')
2278: --rkuttiya added for 12.1.1 Multi GAAP
2279: AND tcn.representation_type = 'PRIMARY'

Line 2288: FROM okl_trx_contracts

2284: IS
2285: SELECT tsu_code,
2286: complete_transfer_yn,
2287: trx_number
2288: FROM okl_trx_contracts
2289: where id = p_source_trx_id;
2290:
2291: taa_request_rec taa_request_csr%ROWTYPE;
2292:

Line 3203: FROM okl_trx_contracts tcn

3199: -- Called at release --
3200: CURSOR pending_trx_csr(p_chr_id IN NUMBER)
3201: IS
3202: SELECT 'Y'
3203: FROM okl_trx_contracts tcn
3204: WHERE tcn.khr_id = p_chr_id
3205: AND tcn.tsu_code IN ('ENTERED','WORKING','WAITING','SUBMITTED')
3206: --rkuttiya added for 12.1.1 Multi GAAP
3207: AND tcn.representation_type = 'PRIMARY'

Line 7152: FROM okl_trx_contracts

7148: l_api_version CONSTANT NUMBER := 1.0;
7149:
7150: CURSOR taa_party_info_csr(p_taa_trx_id IN NUMBER) IS
7151: SELECT party_rel_id2_new
7152: FROM okl_trx_contracts
7153: WHERE id = p_taa_trx_id;
7154:
7155: taa_party_info_rec taa_party_info_csr%ROWTYPE;
7156:

Line 7936: FROM okl_trx_contracts

7932: SELECT tsu_code,
7933: complete_transfer_yn,
7934: --Bug# 4198413
7935: date_transaction_occurred
7936: FROM okl_trx_contracts
7937: where id = p_source_trx_id;
7938:
7939: taa_request_rec taa_request_csr%ROWTYPE;
7940:

Line 8488: FROM okl_trx_contracts tcn,

8484: tcn.source_trx_id ,
8485: --Bug 6657564- Added
8486: RBR_CODE
8487: --Bug 6657564 - End
8488: FROM okl_trx_contracts tcn,
8489: okl_trx_types_tl try
8490: WHERE tcn.khr_id_old = p_orig_chr_id
8491: AND tcn.khr_id_new = p_new_chr_id
8492: AND tcn_type = 'MAE'

Line 8766: OKL_TRX_CONTRACTS_PUB.update_trx_contracts

8762: if (taa_trx_rec.id IS NOT NULL) then
8763: l_tcnv_rec.id := taa_trx_rec.id;
8764: l_tcnv_rec.tsu_code := 'PROCESSED';
8765:
8766: OKL_TRX_CONTRACTS_PUB.update_trx_contracts
8767: (p_api_version => p_api_version,
8768: p_init_msg_list => p_init_msg_list,
8769: x_return_status => x_return_status,
8770: x_msg_count => x_msg_count,

Line 8817: OKL_TRX_CONTRACTS_PUB.update_trx_contracts

8813: l_tcnv_rec.id := taa_trx_rec.source_trx_id;
8814: l_tcnv_rec.tsu_code := 'PROCESSED';
8815: l_tcnv_rec.khr_id_new := p_chr_id;
8816:
8817: OKL_TRX_CONTRACTS_PUB.update_trx_contracts
8818: (p_api_version => p_api_version,
8819: p_init_msg_list => p_init_msg_list,
8820: x_return_status => x_return_status,
8821: x_msg_count => x_msg_count,