APPS.OKL_REVERSE_CONTRACT_PVT dependencies on OKL_TRX_CONTRACTS

Line 109: FROM OKL_TRX_CONTRACTS TC, OKL_TRX_TYPES_B TTB

105: IS
106:
107: CURSOR trx_type_cur IS
108: SELECT '1'
109: FROM OKL_TRX_CONTRACTS TC, OKL_TRX_TYPES_B TTB
110: WHERE TC.KHR_ID = p_contract_id
111: AND TC.TRY_ID = TTB.ID
112: --rkuttiya added for 12.1.1 Multi GAAP
113: AND TC.REPRESENTATION_TYPE = 'PRIMARY'

Line 250: FROM OKL_TRX_CONTRACTS

246: l_count NUMBER :=0;
247:
248: CURSOR ctrct_trx_cur IS
249: SELECT ID, TRY_ID, transaction_date
250: FROM OKL_TRX_CONTRACTS
251: WHERE KHR_ID = p_contract_id
252: --rkuttiya added for 12.1.1 Multi GAAP
253: AND REPRESENTATION_TYPE = 'PRIMARY';
254: --

Line 310: l_upfronttax_trx_id OKL_TRX_CONTRACTS.ID%TYPE;

306: l_upfronttax_source_id_tbl SOURCE_ID_TBL_TYPE;
307: l_upfronttax_trx_exists BOOLEAN := FALSE;
308: l_booking_trx_count NUMBER := 1;
309: l_upfronttax_trx_count NUMBER := 1;
310: l_upfronttax_trx_id OKL_TRX_CONTRACTS.ID%TYPE;
311:
312: -- R12 Change - END
313:
314:

Line 329: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(

325: l_tcnv_rec.id := ctrct_trx_rec.id;
326: l_tcnv_rec.tsu_code := G_CANCELED;
327: l_tcnv_rec.transaction_date := ctrct_trx_rec.transaction_date;
328: l_tcnv_rec.canceled_date := p_transaction_date;
329: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(
330: p_api_version => l_api_version
331: ,p_init_msg_list => l_init_msg_list
332: ,x_return_status => l_return_status
333: ,x_msg_count => l_msg_count

Line 452: p_source_table => 'OKL_TRX_CONTRACTS');

448: x_msg_count => l_msg_count,
449: x_msg_data => l_msg_data,
450: p_source_trx_id => p_reverse_trx_id,
451: p_source_trx_name => 'Reverse',
452: p_source_table => 'OKL_TRX_CONTRACTS');
453:
454: IF l_return_status = G_RET_STS_ERROR THEN
455: RAISE G_EXCEPTION_ERROR;
456: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN

Line 705: FROM OKL_TRX_CONTRACTS

701: WHERE id = p_contract_id;
702:
703: CURSOR ctrct_trx_cur IS
704: SELECT '1'
705: FROM OKL_TRX_CONTRACTS
706: WHERE KHR_ID = p_contract_id
707: --rkuttiya added for 12.1.1 Multi GAAP
708: AND REPRESENTATION_TYPE = 'PRIMARY';
709:

Line 930: Okl_Trx_Contracts_Pub.create_trx_contracts(

926: RAISE OKL_API.G_EXCEPTION_ERROR;
927: END IF;
928:
929: -- Create Transaction Header
930: Okl_Trx_Contracts_Pub.create_trx_contracts(
931: p_api_version => l_api_version
932: ,p_init_msg_list => l_init_msg_list
933: ,x_return_status => l_return_status
934: ,x_msg_count => l_msg_count

Line 1038: Okl_Trx_Contracts_Pub.update_trx_contracts(

1034: l_tcnv_rec.id := x_tcnv_rec.id;
1035: l_tcnv_rec.tsu_code := G_TRX_TSU_CODE_PROCESSED;
1036: l_tcnv_rec.transaction_date := x_tcnv_rec.transaction_date;
1037: -- Update Transaction Header
1038: Okl_Trx_Contracts_Pub.update_trx_contracts(
1039: p_api_version => l_api_version
1040: ,p_init_msg_list => l_init_msg_list
1041: ,x_return_status => l_return_status
1042: ,x_msg_count => l_msg_count