DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_VENDOR_PRG_PVT dependencies on OKL_TRX_CONTRACTS

Line 40: SUBTYPE tcnv_rec_type IS OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

36: -- Table Type to store Recs of IA Details
37: TYPE va_k_tbl_type IS TABLE OF va_k_rec_type INDEX BY BINARY_INTEGER;
38:
39: -- SUBTYPE the transaction Rec Type
40: SUBTYPE tcnv_rec_type IS OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
41:
42: -- *********************
43: -- GLOBAL MESSAGE CONSTANTS
44: -- *********************

Line 471: FROM OKL_TRX_CONTRACTS TRN

467:
468: -- Get the IA TRN for Termination ie TCN_TYPE = 'IAT'
469: CURSOR get_trn_csr (p_va_id IN NUMBER) IS
470: SELECT TRN.tsu_code
471: FROM OKL_TRX_CONTRACTS TRN
472: WHERE TRN.khr_id = p_va_id
473: --rkuttiya added for 12.1.1 Multi GAAP
474: AND TRN.representation_type = 'PRIMARY'
475: --

Line 669: FROM OKL_TRX_CONTRACTS TRN

665: TRN.tmt_recycle_yn,
666: TRN.tmt_generic_flag1_yn,
667: TRN.tmt_generic_flag2_yn,
668: TRN.tmt_generic_flag3_yn
669: FROM OKL_TRX_CONTRACTS TRN
670: WHERE TRN.khr_id = p_ia_id
671: --rkuttiya added for 12.1.1 Multi GAAP
672: AND TRN.representation_type = 'PRIMARY'
673: --

Line 763: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(

759: lp_tcnv_rec.currency_code := l_currency_code;
760: lp_tcnv_rec.date_transaction_occurred := p_sys_date;
761:
762: -- Call create_trx_contracts to create transaction
763: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(
764: p_api_version => l_api_version,
765: p_init_msg_list => G_FALSE,
766: x_return_status => l_return_status,
767: x_msg_count => l_msg_count,

Line 912: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(

908: lp_tcnv_rec.tmt_validated_yn := l_status;
909: END IF;
910:
911: -- Call update_trx_contracts to update transaction
912: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(
913: p_api_version => l_api_version,
914: p_init_msg_list => G_FALSE,
915: x_return_status => l_return_status,
916: x_msg_count => l_msg_count,

Line 1344: p_trx_source_table => 'OKL_TRX_CONTRACTS_V',

1340:
1341: /*
1342: -- Store messages in TRX_MSGS
1343: OKL_AM_UTIL_PVT.process_messages(
1344: p_trx_source_table => 'OKL_TRX_CONTRACTS_V',
1345: p_trx_id => l_tcnv_rec.id,
1346: x_return_status => l_return_status);
1347:
1348: -- raise exception if api failed