DBA Data[Home] [Help]

APPS.OKL_CS_TRANSFER_ASSUMPTION_PVT dependencies on OKL_TRX_CONTRACTS

Line 20: x_header_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,

16: p_header_tbl IN tcnv_tbl_type,
17: p_add_hdr_tbl IN add_hdr_tbl_type,
18: p_old_line_tbl IN l_before_trf_tbl,
19: p_new_line_tbl IN l_after_trf_tbl,
20: x_header_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
21: x_taav_tbl OUT NOCOPY taav_tbl_type,
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_msg_count OUT NOCOPY NUMBER,
24: x_msg_data OUT NOCOPY VARCHAR2)

Line 118: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(p_api_version => p_api_version,

114: END LOOP;
115: END IF;
116: END IF;
117:
118: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(p_api_version => p_api_version,
119: p_init_msg_list => p_init_msg_list,
120: x_return_status => x_return_status,
121: x_msg_count => x_msg_count,
122: x_msg_data => x_msg_data,

Line 202: x_header_tbl OUT NOCOPY Okl_Trx_Contracts_Pub.tcnv_tbl_type,

198: p_header_tbl IN tcnv_tbl_type,
199: p_upd_hdr_tbl IN upd_hdr_tbl_type,
200: p_old_line_tbl IN l_before_trf_tbl,
201: p_new_line_tbl IN l_after_trf_tbl,
202: x_header_tbl OUT NOCOPY Okl_Trx_Contracts_Pub.tcnv_tbl_type,
203: x_taaV_tbl OUT NOCOPY taav_tbl_type,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2)

Line 262: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => p_api_version,

258:
259: l_count := p_old_line_tbl.COUNT;
260:
261:
262: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => p_api_version,
263: p_init_msg_list => fnd_api.g_false,
264: x_return_status => x_return_status,
265: x_msg_count => x_msg_count,
266: x_msg_data => x_msg_data,

Line 349: x_header_tbl OUT NOCOPY Okl_Trx_Contracts_Pub.tcnv_tbl_type,

345: p_header_tbl IN tcnv_tbl_type,
346: p_upd_hdr_tbl IN upd_hdr_tbl_type,
347: p_old_line_tbl IN l_before_trf_tbl,
348: p_new_line_tbl IN l_after_trf_tbl,
349: x_header_tbl OUT NOCOPY Okl_Trx_Contracts_Pub.tcnv_tbl_type,
350: x_taaV_tbl OUT NOCOPY taav_tbl_type,
351: x_return_status OUT NOCOPY VARCHAR2,
352: x_msg_count OUT NOCOPY NUMBER,
353: x_msg_data OUT NOCOPY VARCHAR2)

Line 402: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => p_api_version,

398: l_tcnv_rec.legal_entity_id := p_header_tbl(1).legal_entity_id; --dkagrawa added for LE uptake
399:
400:
401:
402: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => p_api_version,
403: p_init_msg_list => fnd_api.g_false,
404: x_return_status => x_return_status,
405: x_msg_count => x_msg_count,
406: x_msg_data => x_msg_data,

Line 495: FROM OKL_TRX_CONTRACTS

491:
492: --Obtain the request record details
493: CURSOR c_request_record(p_request_id IN NUMBER) IS
494: SELECT *
495: FROM OKL_TRX_CONTRACTS
496: WHERE id = p_request_id;
497:
498: --Obtain the new lessee name
499: CURSOR c_lessee(p_party_id IN NUMBER) IS

Line 594: l_request_record OKL_TRX_CONTRACTS%ROWTYPE;

590: l_billto_id NUMBER;
591: l_contact_name VARCHAR2(300);
592: l_contact_party_id NUMBER;
593: l_phone VARCHAR2(30);
594: l_request_record OKL_TRX_CONTRACTS%ROWTYPE;
595: l_taa_record OKL_TAA_REQUEST_DETAILS_B%rowtype;
596: l_ctr_no VARCHAR2(120);
597: l_acct_no VARCHAR2(30);
598: l_acct_id NUMBER;