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 AR_CASH_RECEIPTS

Line 20: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL

16: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE
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:

Line 36: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;

32: l_msg_count NUMBER;
33: l_msg_data VARCHAR2(2000);
34: l_api_name CONSTANT VARCHAR2(30) := 'migrate_Applications';
35:
36: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
37: i NUMBER;
38: j NUMBER;
39: k NUMBER;
40: -------------------------------------------------------------------------------

Line 190: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL

186: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE
187: ,x_return_status OUT NOCOPY VARCHAR2
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

Line 207: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;

203: l_msg_count NUMBER;
204: l_msg_data VARCHAR2(2000);
205: l_api_name CONSTANT VARCHAR2(30) := 'process_advance_receipt';
206:
207: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
208: l_unapp_amt NUMBER;
209: l_org_id NUMBER := p_org_id;
210: l_onacc_amt NUMBER;
211: -------------------------------------------------------------------------------

Line 417: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL -- HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed

413: ,x_return_status OUT NOCOPY VARCHAR2
414: ,x_msg_count OUT NOCOPY NUMBER
415: ,x_msg_data OUT NOCOPY VARCHAR2
416: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
417: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL -- HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
418: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
419: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
420: ) IS
421:

Line 437: -- l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;

433:
434: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
435: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
436: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
437: -- l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
438: --start:| 13-May-2008 cklee --Fixed bug 7036445 |
439: -- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
440: l_customer_num hz_cust_accounts.account_number%TYPE;
441: --end:| 13-May-2008 cklee --Fixed bug 7036445 |

Line 442: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;

438: --start:| 13-May-2008 cklee --Fixed bug 7036445 |
439: -- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
440: l_customer_num hz_cust_accounts.account_number%TYPE;
441: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
442: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
443: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;
444: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
445: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
446:

Line 447: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;

443: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;
444: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
445: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
446:
447: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
448:
449: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
450: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
451: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;

Line 449: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;

445: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
446:
447: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
448:
449: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
450: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
451: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
452: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
453: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;

Line 450: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;

446:
447: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
448:
449: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
450: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
451: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
452: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
453: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
454: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;

Line 452: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;

448:
449: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
450: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
451: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
452: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
453: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
454: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
455: l_receipt_count NUMBER;
456:

Line 540: ar_cash_receipts_All arcash

536: a.id,
537: arcash.receipt_Date
538: FROM OKL_TRX_CSH_RECEIPT_V a,
539: OKL_TXL_RCPT_APPS_V b,
540: ar_cash_receipts_All arcash
541: WHERE a.id = b.rct_id_details
542: AND a.FULLY_APPLIED_FLAG = 'N'
543: AND a.EXPIRED_FLAG = 'N'
544: AND a.receipt_type = 'ADV'

Line 926: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed

922: ,x_msg_data OUT NOCOPY VARCHAR2
923: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
924: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
925: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
926: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
927: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
928: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
929: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
930: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL

Line 927: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL

923: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
924: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
925: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
926: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
927: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
928: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
929: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
930: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
931: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL

Line 928: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE

924: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
925: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
926: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
927: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
928: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
929: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
930: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
931: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
932: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL

Line 929: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE

925: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
926: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
927: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
928: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
929: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
930: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
931: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
932: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
933: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL

Line 930: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL

926: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
927: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
928: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
929: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
930: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
931: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
932: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
933: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
934: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL

Line 932: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL

928: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
929: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
930: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
931: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
932: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
933: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
934: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
935: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
936: ,p_xcr_id IN NUMBER DEFAULT NULL

Line 960: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;

956: --start:| 13-May-2008 cklee --Fixed bug 7036445 |
957: -- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
958: l_customer_num hz_cust_accounts.account_number%TYPE;
959: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
960: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
961: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;
962: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;
963: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
964: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

Line 962: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;

958: l_customer_num hz_cust_accounts.account_number%TYPE;
959: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
960: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
961: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;
962: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;
963: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
964: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
965:
966:

Line 969: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;

965:
966:
967: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
968:
969: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
970: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
971: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;
972: l_receipt_count NUMBER;
973:

Line 1215: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed

1211: ,x_msg_data OUT NOCOPY VARCHAR2
1212: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
1213: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
1214: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
1215: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
1216: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
1217: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
1218: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
1219: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL

Line 1216: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL

1212: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
1213: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
1214: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
1215: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
1216: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
1217: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
1218: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
1219: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
1220: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL

Line 1217: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE

1213: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
1214: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
1215: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
1216: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
1217: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
1218: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
1219: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
1220: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
1221: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL

Line 1218: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE

1214: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
1215: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
1216: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
1217: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
1218: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
1219: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
1220: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
1221: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
1222: ,p_invoice_total IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL

Line 1219: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL

1215: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
1216: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
1217: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
1218: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
1219: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
1220: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
1221: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
1222: ,p_invoice_total IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
1223: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL

Line 1221: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL

1217: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
1218: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
1219: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
1220: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
1221: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
1222: ,p_invoice_total IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
1223: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
1224: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
1225: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL

Line 1248: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;

1244: --start:| 13-May-2008 cklee --Fixed bug 7036445 |
1245: -- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
1246: l_customer_num hz_cust_accounts.account_number%TYPE;
1247: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
1248: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
1249: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;
1250: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;
1251: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
1252:

Line 1250: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;

1246: l_customer_num hz_cust_accounts.account_number%TYPE;
1247: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
1248: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
1249: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;
1250: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;
1251: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
1252:
1253: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
1254:

Line 1257: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;

1253: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
1254:
1255: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
1256:
1257: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
1258: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
1259: l_expired_flag OKL_TRX_CSH_RECEIPT_V.FULLY_APPLIED_FLAG%TYPE;
1260: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;
1261:

Line 1383: ar_cash_receipts_all arcash

1379:
1380: CURSOR c_get_cust_acct_num(cp_cash_receipt_id IN NUMBER) IS
1381: SELECT hca.account_number
1382: FROM hz_cust_accounts_all hca,
1383: ar_cash_receipts_all arcash
1384: WHERE hca.cust_account_id = arcash.pay_from_customer
1385: AND arcash.cash_receipt_id = cp_cash_receipt_id;
1386:
1387: -------------------------------------------------------------------------------

Line 1804: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed

1800: ,x_return_status OUT NOCOPY VARCHAR2
1801: ,x_msg_count OUT NOCOPY NUMBER
1802: ,x_msg_data OUT NOCOPY VARCHAR2
1803: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
1804: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
1805: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
1806: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
1807: ,p_receipt_date_from IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
1808: ,p_receipt_date_to IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL

Line 1805: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL

1801: ,x_msg_count OUT NOCOPY NUMBER
1802: ,x_msg_data OUT NOCOPY VARCHAR2
1803: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
1804: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
1805: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
1806: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
1807: ,p_receipt_date_from IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
1808: ,p_receipt_date_to IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
1809: ,p_receipt_type IN VARCHAR2 DEFAULT NULL

Line 1828: -- l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL;

1824:
1825: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
1826: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
1827: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
1828: -- l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL;
1829: --start:| 13-May-2008 cklee --Fixed bug 7036445 |
1830: l_customer_num hz_cust_accounts.account_number%TYPE;
1831: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
1832:

Line 1834: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;

1830: l_customer_num hz_cust_accounts.account_number%TYPE;
1831: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
1832:
1833: l_customer_acct_id NUMBER DEFAULT p_customer_num;
1834: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
1835: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;
1836: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
1837: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
1838:

Line 1843: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;

1839: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
1840: l_receipt_date_from OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date_from);
1841: l_receipt_date_to OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date_to);
1842:
1843: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
1844:
1845: l_dflt_days_to_hold_adv_pay OKL_CASH_ALLCTN_RLS.NUM_DAYS_HOLD_ADV_PAY%TYPE;
1846: l_days_to_hold_adv_pay OKL_CASH_ALLCTN_RLS.NUM_DAYS_HOLD_ADV_PAY%TYPE;
1847:

Line 1849: l_temp_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;

1845: l_dflt_days_to_hold_adv_pay OKL_CASH_ALLCTN_RLS.NUM_DAYS_HOLD_ADV_PAY%TYPE;
1846: l_days_to_hold_adv_pay OKL_CASH_ALLCTN_RLS.NUM_DAYS_HOLD_ADV_PAY%TYPE;
1847:
1848: l_temp_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
1849: l_temp_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
1850: l_temp_rcpt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL;
1851:
1852: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1853: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;

Line 1850: l_temp_rcpt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL;

1846: l_days_to_hold_adv_pay OKL_CASH_ALLCTN_RLS.NUM_DAYS_HOLD_ADV_PAY%TYPE;
1847:
1848: l_temp_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
1849: l_temp_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
1850: l_temp_rcpt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL;
1851:
1852: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1853: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1854: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;

Line 1852: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;

1848: l_temp_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
1849: l_temp_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
1850: l_temp_rcpt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL;
1851:
1852: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1853: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1854: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
1855: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1856: l_on_account_bal AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;

Line 1853: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;

1849: l_temp_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
1850: l_temp_rcpt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL;
1851:
1852: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1853: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1854: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
1855: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1856: l_on_account_bal AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1857: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;

Line 1855: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;

1851:
1852: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1853: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1854: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
1855: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1856: l_on_account_bal AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1857: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
1858: l_receipt_count NUMBER;
1859: l_receipt_type VARCHAR2(30) := p_receipt_type;

Line 1856: l_on_account_bal AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;

1852: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1853: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1854: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
1855: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1856: l_on_account_bal AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1857: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
1858: l_receipt_count NUMBER;
1859: l_receipt_type VARCHAR2(30) := p_receipt_type;
1860:

Line 1937: ar_Cash_receipts_all b

1933: b.currency_code,
1934: b.receipt_date,
1935: a.id
1936: FROM OKL_TRX_CSH_RECEIPT_V a,
1937: ar_Cash_receipts_all b
1938: WHERE a.fully_applied_flag = 'N'
1939: AND a.expired_flag = 'N'
1940: AND a.receipt_type = 'ADV'
1941: AND a.cash_receipt_id = b.cash_receipt_id

Line 1955: AR_CASH_RECEIPTS_ALL c

1951: c.receipt_date,
1952: b.khr_id
1953: FROM OKL_TRX_CSH_RECEIPT_V a,
1954: OKL_TXL_RCPT_APPS_V b,
1955: AR_CASH_RECEIPTS_ALL c
1956: WHERE a.id = b.rct_id_details
1957: AND a.cash_receipt_id = c.cash_receipt_id
1958: AND a.FULLY_APPLIED_FLAG = 'N'
1959: AND a.receipt_type = 'ADV'

Line 1978: AR_CASH_RECEIPTS_ALL b,

1974: a.id,
1975: b.cash_receipt_id icr_id,
1976: b.pay_from_customer customer_number
1977: FROM OKL_TRX_CSH_RECEIPT_V a,
1978: AR_CASH_RECEIPTS_ALL b,
1979: hz_cust_accounts_all hca
1980: WHERE a.cash_receipt_id = b.cash_receipt_id
1981: AND hca.account_number = cp_customer_num
1982: AND b.pay_from_customer = hca.cust_account_id

Line 2009: FROM AR_CASH_RECEIPTS

2005: amount,
2006: receipt_date,
2007: receipt_number,
2008: decode(currency_code,cp_receipt_currency,1,2) order_by_ccy
2009: FROM AR_CASH_RECEIPTS
2010: WHERE pay_from_customer = cp_customer_id
2011: AND currency_code = decode(p_cross_currency_allowed,'N',cp_receipt_currency,currency_code) --dkagrawa added decode for cross currency support
2012: AND receipt_date >= cp_receipt_date_from
2013: AND receipt_date <= cp_receipt_date_to

Line 2058: FROM AR_CASH_RECEIPTS a,

2054:
2055: CURSOR c_get_rcpt_id ( cp_receipt_number in VARCHAR2
2056: ,cp_customer_num in VARCHAR2) IS
2057: SELECT a.cash_receipt_id icr_id
2058: FROM AR_CASH_RECEIPTS a,
2059: hz_cust_Accounts_all hca
2060: WHERE a.receipt_number = l_receipt_num
2061: AND a.pay_from_customer = hca.cust_account_id
2062: AND hca.account_number = cp_customer_num;

Line 2714: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;

2710: l_msg_count NUMBER;
2711: l_msg_data VARCHAR2(2000);
2712: l_api_name CONSTANT VARCHAR2(30) := 'reapplic_rcpt_w_cntrct';
2713:
2714: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2715: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2716: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
2717: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2718: l_on_account_bal AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;

Line 2715: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;

2711: l_msg_data VARCHAR2(2000);
2712: l_api_name CONSTANT VARCHAR2(30) := 'reapplic_rcpt_w_cntrct';
2713:
2714: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2715: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2716: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
2717: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2718: l_on_account_bal AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2719: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;

Line 2717: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;

2713:
2714: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2715: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2716: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
2717: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2718: l_on_account_bal AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2719: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
2720: l_receipt_count NUMBER;
2721:

Line 2718: l_on_account_bal AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;

2714: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2715: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2716: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
2717: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2718: l_on_account_bal AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2719: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
2720: l_receipt_count NUMBER;
2721:
2722: l_dflt_days_to_hold_adv_pay OKL_CASH_ALLCTN_RLS.NUM_DAYS_HOLD_ADV_PAY%TYPE;

Line 2732: l_temp_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;

2728: l_customer_acct_id NUMBER DEFAULT p_customer_num;
2729: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
2730:
2731: l_temp_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
2732: l_temp_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
2733: l_temp_rcpt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL;
2734:
2735: l_xcr_id NUMBER;
2736: l_rct_id OKL_TRX_CSH_RECEIPT_V.ID%TYPE;

Line 2733: l_temp_rcpt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL;

2729: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
2730:
2731: l_temp_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
2732: l_temp_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
2733: l_temp_rcpt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL;
2734:
2735: l_xcr_id NUMBER;
2736: l_rct_id OKL_TRX_CSH_RECEIPT_V.ID%TYPE;
2737: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;

Line 2789: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b, AR_CASH_RECEIPTS_ALL c

2785: SELECT DISTINCT(a.cash_receipt_id) icr_id,
2786: a.id RCT_ID,
2787: c.receipt_date,
2788: b.khr_id
2789: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b, AR_CASH_RECEIPTS_ALL c
2790: WHERE a.id = b.rct_id_details
2791: AND a.cash_receipt_id = c.cash_receipt_id
2792: AND a.FULLY_APPLIED_FLAG = 'N'
2793: AND a.receipt_type = 'ADV'

Line 3271: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL

3267: ,x_return_status OUT NOCOPY VARCHAR2
3268: ,x_msg_count OUT NOCOPY NUMBER
3269: ,x_msg_data OUT NOCOPY VARCHAR2
3270: ,p_xcav_tbl IN xcav_tbl_type
3271: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
3272: ,p_receipt_amount IN OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
3273: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
3274: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
3275: ,p_currency_code IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL

Line 3272: ,p_receipt_amount IN OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE

3268: ,x_msg_count OUT NOCOPY NUMBER
3269: ,x_msg_data OUT NOCOPY VARCHAR2
3270: ,p_xcav_tbl IN xcav_tbl_type
3271: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
3272: ,p_receipt_amount IN OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
3273: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
3274: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
3275: ,p_currency_code IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
3276: ,p_ar_inv_tbl IN OKL_BPD_ADVANCED_BILLING_PVT.ar_inv_tbl_type

Line 3273: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL

3269: ,x_msg_data OUT NOCOPY VARCHAR2
3270: ,p_xcav_tbl IN xcav_tbl_type
3271: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
3272: ,p_receipt_amount IN OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
3273: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
3274: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
3275: ,p_currency_code IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
3276: ,p_ar_inv_tbl IN OKL_BPD_ADVANCED_BILLING_PVT.ar_inv_tbl_type
3277: ) IS

Line 3274: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL

3270: ,p_xcav_tbl IN xcav_tbl_type
3271: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
3272: ,p_receipt_amount IN OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
3273: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
3274: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
3275: ,p_currency_code IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
3276: ,p_ar_inv_tbl IN OKL_BPD_ADVANCED_BILLING_PVT.ar_inv_tbl_type
3277: ) IS
3278:

Line 3275: ,p_currency_code IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL

3271: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
3272: ,p_receipt_amount IN OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
3273: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
3274: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
3275: ,p_currency_code IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
3276: ,p_ar_inv_tbl IN OKL_BPD_ADVANCED_BILLING_PVT.ar_inv_tbl_type
3277: ) IS
3278:
3279: ---------------------------

Line 3292: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;

3288: l_msg_count NUMBER;
3289: l_msg_data VARCHAR2(2000);
3290: l_api_name CONSTANT VARCHAR2(30) := 'AR_advance_receipt';
3291:
3292: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;
3293: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;
3294: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;
3295:
3296: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;

Line 3297: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;

3293: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;
3294: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;
3295:
3296: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
3297: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
3298:
3299: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_currency_code; -- entered currency code
3300:
3301: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;