eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_BPD_ADVANCED_CASH_APP_PVT dependencies on OKL_RECEIPTS_PVT

Line 21: ,p_appl_tbl IN okl_receipts_pvt.appl_tbl_type

17: ,x_return_status OUT NOCOPY VARCHAR2
18: ,x_msg_count OUT NOCOPY NUMBER
19: ,x_msg_data OUT NOCOPY VARCHAR2
20: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
21: ,p_appl_tbl IN okl_receipts_pvt.appl_tbl_type
22: ,x_appl_tbl OUT NOCOPY okl_receipts_pvt.appl_tbl_type
23: ) IS
24:
25: ---------------------------

Line 22: ,x_appl_tbl OUT NOCOPY okl_receipts_pvt.appl_tbl_type

18: ,x_msg_count OUT NOCOPY NUMBER
19: ,x_msg_data OUT NOCOPY VARCHAR2
20: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
21: ,p_appl_tbl IN okl_receipts_pvt.appl_tbl_type
22: ,x_appl_tbl OUT NOCOPY okl_receipts_pvt.appl_tbl_type
23: ) IS
24:
25: ---------------------------
26: -- DECLARE Local Variables

Line 44: l_new_appl_tbl okl_receipts_pvt.appl_tbl_type;

40: -------------------------------------------------------------------------------
41: -- DECLARE Record/Table Types
42: -------------------------------------------------------------------------------
43:
44: l_new_appl_tbl okl_receipts_pvt.appl_tbl_type;
45: l_old_appl_tbl okl_receipts_pvt.appl_tbl_type;
46: l_appl_tbl okl_receipts_pvt.appl_tbl_type;
47: -------------------------------------------------------------------------------
48: -- DEFINE CURSORS

Line 45: l_old_appl_tbl okl_receipts_pvt.appl_tbl_type;

41: -- DECLARE Record/Table Types
42: -------------------------------------------------------------------------------
43:
44: l_new_appl_tbl okl_receipts_pvt.appl_tbl_type;
45: l_old_appl_tbl okl_receipts_pvt.appl_tbl_type;
46: l_appl_tbl okl_receipts_pvt.appl_tbl_type;
47: -------------------------------------------------------------------------------
48: -- DEFINE CURSORS
49: -------------------------------------------------------------------------------

Line 46: l_appl_tbl okl_receipts_pvt.appl_tbl_type;

42: -------------------------------------------------------------------------------
43:
44: l_new_appl_tbl okl_receipts_pvt.appl_tbl_type;
45: l_old_appl_tbl okl_receipts_pvt.appl_tbl_type;
46: l_appl_tbl okl_receipts_pvt.appl_tbl_type;
47: -------------------------------------------------------------------------------
48: -- DEFINE CURSORS
49: -------------------------------------------------------------------------------
50:

Line 192: ,p_appl_tbl IN okl_receipts_pvt.appl_tbl_type

188: ,x_msg_count OUT NOCOPY NUMBER
189: ,x_msg_data OUT NOCOPY VARCHAR2
190: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
191: ,p_org_id IN NUMBER
192: ,p_appl_tbl IN okl_receipts_pvt.appl_tbl_type
193: ,x_remaining_amt OUT NOCOPY NUMBER
194: ) IS
195:
196: ---------------------------

Line 215: l_appl_tbl okl_receipts_pvt.appl_tbl_type;

211: -------------------------------------------------------------------------------
212: -- DECLARE Record/Table Types
213: -------------------------------------------------------------------------------
214:
215: l_appl_tbl okl_receipts_pvt.appl_tbl_type;
216: x_appl_tbl okl_receipts_pvt.appl_tbl_type;
217: l_rcpt_rec okl_receipts_pvt.rcpt_rec_type;
218: -------------------------------------------------------------------------------
219: -- DEFINE CURSORS

Line 216: x_appl_tbl okl_receipts_pvt.appl_tbl_type;

212: -- DECLARE Record/Table Types
213: -------------------------------------------------------------------------------
214:
215: l_appl_tbl okl_receipts_pvt.appl_tbl_type;
216: x_appl_tbl okl_receipts_pvt.appl_tbl_type;
217: l_rcpt_rec okl_receipts_pvt.rcpt_rec_type;
218: -------------------------------------------------------------------------------
219: -- DEFINE CURSORS
220: -------------------------------------------------------------------------------

Line 217: l_rcpt_rec okl_receipts_pvt.rcpt_rec_type;

213: -------------------------------------------------------------------------------
214:
215: l_appl_tbl okl_receipts_pvt.appl_tbl_type;
216: x_appl_tbl okl_receipts_pvt.appl_tbl_type;
217: l_rcpt_rec okl_receipts_pvt.rcpt_rec_type;
218: -------------------------------------------------------------------------------
219: -- DEFINE CURSORS
220: -------------------------------------------------------------------------------
221:

Line 321: okl_receipts_pvt.handle_receipt( p_api_version => l_api_version

317: log_file(' l_appl_tbl('||ll||').line_id = '|| l_appl_tbl(ll).line_id);
318: log_file(' l_appl_tbl('||ll||').amount_to_apply = '|| l_appl_tbl(ll).amount_to_apply);
319: END LOOP;
320: END IF;
321: okl_receipts_pvt.handle_receipt( p_api_version => l_api_version
322: ,p_init_msg_list => l_init_msg_list
323: ,x_return_status => l_return_status
324: ,x_msg_count => l_msg_count
325: ,x_msg_data => l_msg_data

Line 332: log_file('okl_receipts_pvt.handle_receipt return status = ' ||x_return_status);

328: ,x_cash_receipt_id => l_receipt_id
329: );
330:
331: x_return_status := l_return_status;
332: log_file('okl_receipts_pvt.handle_receipt return status = ' ||x_return_status);
333: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
334: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
335: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
336: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 710: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(l_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

706: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT AMOUNT: '||l_actual_remittance_amount);
707:
708: --following code added by dkagrawa for cross currency
709: IF l_invoice_currency_code <> l_receipt_currency THEN
710: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(l_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
711: IF l_exchange_rate_type IS NULL THEN
712: OKL_API.set_message( p_app_name => G_APP_NAME
713: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
714: );

Line 1004: l_appl_tbl okl_receipts_pvt.appl_tbl_type;

1000: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
1001:
1002: l_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;
1003:
1004: l_appl_tbl okl_receipts_pvt.appl_tbl_type;
1005: x_appl_tbl okl_receipts_pvt.appl_tbl_type;
1006: l_exchange_rate_type VARCHAR2(100);
1007: l_conversion_rate NUMBER;
1008:

Line 1005: x_appl_tbl okl_receipts_pvt.appl_tbl_type;

1001:
1002: l_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;
1003:
1004: l_appl_tbl okl_receipts_pvt.appl_tbl_type;
1005: x_appl_tbl okl_receipts_pvt.appl_tbl_type;
1006: l_exchange_rate_type VARCHAR2(100);
1007: l_conversion_rate NUMBER;
1008:
1009: -------------------------------------------------------------------------------

Line 1085: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(l_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

1081:
1082: -- get invoice amount due remaining and invoice currency
1083:
1084: IF l_invoice_currency_code <> l_receipt_currency_code THEN
1085: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(l_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
1086: IF l_exchange_rate_type IS NULL THEN
1087: OKL_API.set_message( p_app_name => G_APP_NAME
1088: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
1089: );

Line 1343: l_appl_tbl okl_receipts_pvt.appl_tbl_type;

1339: -- DECLARE Record/Table Types
1340: -------------------------------------------------------------------------------
1341:
1342: l_autocash_appl_tbl okl_auto_cash_appl_rules_pvt.okl_appl_dtls_tbl_type;
1343: l_appl_tbl okl_receipts_pvt.appl_tbl_type;
1344: -------------------------------------------------------------------------------
1345: -- DEFINE CURSORS
1346: -------------------------------------------------------------------------------
1347: --start:| 13-May-2008 cklee --Fixed bug 7036445 |

Line 1557: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(l_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

1553: ------------------------------------------------------------
1554: -- get invoice amount due remaining and invoice currency
1555:
1556: IF l_invoice_currency_code <> l_receipt_currency_code THEN
1557: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(l_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
1558: IF l_exchange_rate_type IS NULL THEN
1559: OKL_API.set_message( p_app_name => G_APP_NAME
1560: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
1561: );

Line 2310: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(l_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

2306: END IF;
2307: log_file('l_remittance_amount ='||l_remittance_amount);
2308: --following code added by dkagrawa for cross currency
2309: IF l_invoice_currency_code <> l_receipt_currency THEN
2310: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(l_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2311: IF l_exchange_rate_type IS NULL THEN
2312: OKL_API.set_message( p_app_name => G_APP_NAME
2313: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
2314: );

Line 2536: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(l_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

2532: IF l_actual_remittance_amount > 0 THEN
2533:
2534: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'RECEIPT '||l_check_number|| ' located with balance of '||l_actual_remittance_amount||' '||l_receipt_currency);
2535: IF l_invoice_currency_code <> l_receipt_currency THEN
2536: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(l_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2537: IF l_exchange_rate_type IS NULL THEN
2538: OKL_API.set_message( p_app_name => G_APP_NAME
2539: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
2540: );