DBA Data[Home] [Help]

APPS.OKL_ACCOUNT_DIST_MISC_PVT dependencies on OKL_TRNS_ACC_DSTRS

Line 17: l_curr_code OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;

13: p_mode IN VARCHAR2)
14:
15: IS
16:
17: l_curr_code OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
18: l_currency_conversion_date OKL_TRNS_ACC_DSTRS.currency_conversion_date%TYPE;
19: l_currency_conversion_rate OKL_TRNS_ACC_DSTRS.currency_conversion_rate%TYPE;
20: l_currency_conversion_type OKL_TRNS_ACC_DSTRS.currency_conversion_type%TYPE;
21:

Line 18: l_currency_conversion_date OKL_TRNS_ACC_DSTRS.currency_conversion_date%TYPE;

14:
15: IS
16:
17: l_curr_code OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
18: l_currency_conversion_date OKL_TRNS_ACC_DSTRS.currency_conversion_date%TYPE;
19: l_currency_conversion_rate OKL_TRNS_ACC_DSTRS.currency_conversion_rate%TYPE;
20: l_currency_conversion_type OKL_TRNS_ACC_DSTRS.currency_conversion_type%TYPE;
21:
22:

Line 19: l_currency_conversion_rate OKL_TRNS_ACC_DSTRS.currency_conversion_rate%TYPE;

15: IS
16:
17: l_curr_code OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
18: l_currency_conversion_date OKL_TRNS_ACC_DSTRS.currency_conversion_date%TYPE;
19: l_currency_conversion_rate OKL_TRNS_ACC_DSTRS.currency_conversion_rate%TYPE;
20: l_currency_conversion_type OKL_TRNS_ACC_DSTRS.currency_conversion_type%TYPE;
21:
22:
23: l_date_transaction_occurred DATE;

Line 20: l_currency_conversion_type OKL_TRNS_ACC_DSTRS.currency_conversion_type%TYPE;

16:
17: l_curr_code OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
18: l_currency_conversion_date OKL_TRNS_ACC_DSTRS.currency_conversion_date%TYPE;
19: l_currency_conversion_rate OKL_TRNS_ACC_DSTRS.currency_conversion_rate%TYPE;
20: l_currency_conversion_type OKL_TRNS_ACC_DSTRS.currency_conversion_type%TYPE;
21:
22:
23: l_date_transaction_occurred DATE;
24:

Line 151: FROM OKL_TRNS_ACC_DSTRS

147:
148: CURSOR dist_csr(v_source_id NUMBER,
149: v_source_table VARCHAR2) IS
150: SELECT POSTED_YN
151: FROM OKL_TRNS_ACC_DSTRS
152: WHERE source_id = v_source_id
153: AND source_table = v_source_table;
154:
155:

Line 203: FROM OKL_TRNS_ACC_DSTRS

199: IS
200:
201: CURSOR dist_csr(v_source_id NUMBER, v_source_table VARCHAR2) IS
202: SELECT ID
203: FROM OKL_TRNS_ACC_DSTRS
204: WHERE source_id = v_source_id
205: AND source_table = v_source_table;
206:
207: CURSOR aet_csr(v_source_id NUMBER, v_source_table VARCHAR2) IS

Line 241: -- Start of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs

237: CLOSE dist_csr;
238:
239: IF (l_dist_tbl.COUNT > 0) THEN
240:
241: -- Start of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs
242: IF(L_DEBUG_ENABLED='Y') THEN
243: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
244: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
245: END IF;

Line 248: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRMSCB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');

244: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
245: END IF;
246: IF(IS_DEBUG_PROCEDURE_ON) THEN
247: BEGIN
248: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRMSCB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');
249: END;
250: END IF;
251: Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs(p_api_version => l_api_version
252: ,p_init_msg_list => l_init_msg_list

Line 251: Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs(p_api_version => l_api_version

247: BEGIN
248: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRMSCB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');
249: END;
250: END IF;
251: Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs(p_api_version => l_api_version
252: ,p_init_msg_list => l_init_msg_list
253: ,x_return_status => x_return_status
254: ,x_msg_count => l_msg_count
255: ,x_msg_data => l_msg_data

Line 259: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRMSCB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');

255: ,x_msg_data => l_msg_data
256: ,p_tabv_tbl => l_dist_tbl);
257: IF(IS_DEBUG_PROCEDURE_ON) THEN
258: BEGIN
259: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRMSCB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');
260: END;
261: END IF;
262: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs
263:

Line 262: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs

258: BEGIN
259: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRMSCB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');
260: END;
261: END IF;
262: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs
263:
264: END IF;
265:
266:

Line 382: l_source_table OKL_TRNS_ACC_DSTRS.source_table%TYPE := 'OKL_TXL_CNTRCT_LNS';

378: l_tabv_rec_out TABV_REC_TYPE;
379: l_tabv_rec TABV_REC_TYPE;
380: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
381: l_check_status NUMBER;
382: l_source_table OKL_TRNS_ACC_DSTRS.source_table%TYPE := 'OKL_TXL_CNTRCT_LNS';
383:
384: -- Added by Santonyr to fix the bug 3089327 on 07th Aug, 2003
385:
386: l_tcn_id OKL_TRX_CONTRACTS.ID%TYPE;

Line 491: OKL_TRNS_ACC_DSTRS_PUB.insert_trns_acc_dstrs(p_api_version => l_api_version,

487: POPULATE_DSTR_REC(p_tabv_rec => p_tabv_tbl(i),
488: x_tabv_rec => l_tabv_rec_out,
489: p_mode => 'I');
490:
491: OKL_TRNS_ACC_DSTRS_PUB.insert_trns_acc_dstrs(p_api_version => l_api_version,
492: p_init_msg_list => p_init_msg_list,
493: x_return_status => l_return_status,
494: x_msg_count => x_msg_count,
495: x_msg_data => x_msg_data,