APPS.OKL_AM_TERMINATE_INV_AGMT_PVT dependencies on OKL_TRX_CONTRACTS

Line 1204: FROM OKL_TRX_CONTRACTS TRN

1200:
1201: -- Get the IA TRN for Termination ie TCN_TYPE = 'IAT'
1202: CURSOR get_trn_csr (p_ia_id IN NUMBER) IS
1203: SELECT TRN.tsu_code
1204: FROM OKL_TRX_CONTRACTS TRN
1205: WHERE TRN.khr_id = p_ia_id
1206: --rkuttiya added for 12.1.1 Multi GAAP
1207: AND TRN.representation_type = 'PRIMARY'
1208: --

Line 1564: FROM OKL_TRX_CONTRACTS TRN

1560: TRN.tmt_generic_flag1_yn,
1561: TRN.tmt_generic_flag2_yn,
1562: TRN.tmt_generic_flag3_yn,
1563: TRN.legal_entity_id
1564: FROM OKL_TRX_CONTRACTS TRN
1565: WHERE TRN.khr_id = p_ia_id
1566: --rkuttiya added for 12.1.1 Multi GAAP
1567: AND TRN.representation_type = 'PRIMARY'
1568: --

Line 1685: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(

1681: lp_tcnv_rec.currency_code := l_currency_code;
1682: lp_tcnv_rec.date_transaction_occurred := p_sys_date;
1683:
1684: -- Call create_trx_contracts to create transaction
1685: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(
1686: p_api_version => l_api_version,
1687: p_init_msg_list => G_FALSE,
1688: x_return_status => l_return_status,
1689: x_msg_count => l_msg_count,

Line 2681: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(

2677:
2678: SAVEPOINT update_transaction_trx;
2679:
2680: -- Call update_trx_contracts to update transaction
2681: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(
2682: p_api_version => l_api_version,
2683: p_init_msg_list => G_FALSE,
2684: x_return_status => l_return_status,
2685: x_msg_count => l_msg_count,

Line 2994: p_trx_source_table => 'OKL_TRX_CONTRACTS',

2990: x_return_status := l_return_status;
2991:
2992: -- Store messages in TRX_MSGS
2993: OKL_AM_UTIL_PVT.process_messages(
2994: p_trx_source_table => 'OKL_TRX_CONTRACTS',
2995: p_trx_id => l_tcnv_rec.id,
2996: x_return_status => l_return_status);
2997:
2998: -- Set the output log if request from BATCH

Line 3027: p_trx_source_table => 'OKL_TRX_CONTRACTS',

3023: WHEN G_EXCEPTION THEN
3024:
3025: -- Store messages in TRX_MSGS
3026: OKL_AM_UTIL_PVT.process_messages(
3027: p_trx_source_table => 'OKL_TRX_CONTRACTS',
3028: p_trx_id => l_tcnv_rec.id,
3029: x_return_status => l_return_status);
3030:
3031: x_return_status := G_RET_STS_SUCCESS;

Line 3150: AND CHR.id NOT IN (SELECT TRX.khr_id FROM OKL_TRX_CONTRACTS TRX -- Dont get IA's with Processed TRN

3146: WHERE CHR.scs_code = 'INVESTOR' -- IA
3147: AND CHR.sts_code = 'ACTIVE' -- ACTIVE
3148: AND CHR.date_terminated IS NULL -- Not Terminated
3149: AND CHR.end_date <= TRUNC(p_date) -- Ended -- RMUNJULU 115.4 3061748 Changed to pick equal dates
3150: AND CHR.id NOT IN (SELECT TRX.khr_id FROM OKL_TRX_CONTRACTS TRX -- Dont get IA's with Processed TRN
3151: WHERE TRX.tsu_code = 'PROCESSED'
3152: --rkuttiya added for 12.1.1 Multi GAAP
3153: AND TRX.representation_type = 'PRIMARY'
3154: --