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_PUB dependencies on AR_CASH_RECEIPTS_ALL

Line 10: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL

6: ,x_return_status OUT NOCOPY VARCHAR2
7: ,x_msg_count OUT NOCOPY NUMBER
8: ,x_msg_data OUT NOCOPY VARCHAR2
9: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
10: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
11: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
12: ,p_receipt_type IN OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT NULL
13: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
14: ) IS

Line 26: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;

22:
23: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
24: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
25: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
26: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
27: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
28: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;
29: l_receipt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE DEFAULT NULL;
30: l_receipt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT p_receipt_type;

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

23: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
24: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
25: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
26: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
27: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
28: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;
29: l_receipt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE DEFAULT NULL;
30: l_receipt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT p_receipt_type;
31:

Line 29: l_receipt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE DEFAULT NULL;

25: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
26: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
27: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
28: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;
29: l_receipt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE DEFAULT NULL;
30: l_receipt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT p_receipt_type;
31:
32: BEGIN
33:

Line 105: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL

101: ,x_return_status OUT NOCOPY VARCHAR2
102: ,x_msg_count OUT NOCOPY NUMBER
103: ,x_msg_data OUT NOCOPY VARCHAR2
104: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
105: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
106: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
107: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
108: ,p_receipt_date_from IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
109: ,p_receipt_date_to IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL

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

102: ,x_msg_count OUT NOCOPY NUMBER
103: ,x_msg_data OUT NOCOPY VARCHAR2
104: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
105: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
106: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
107: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
108: ,p_receipt_date_from IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
109: ,p_receipt_date_to IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
110: ,p_receipt_type IN VARCHAR2 DEFAULT NULL

Line 124: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;

120:
121: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
122: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
123: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
124: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
125: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
126: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;
127: l_receipt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE DEFAULT NULL;
128: l_receipt_date_from OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT p_receipt_date_from;

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

121: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
122: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
123: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
124: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
125: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
126: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;
127: l_receipt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE DEFAULT NULL;
128: l_receipt_date_from OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT p_receipt_date_from;
129: l_receipt_date_to OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT p_receipt_date_to;

Line 127: l_receipt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE DEFAULT NULL;

123: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
124: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
125: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
126: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;
127: l_receipt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE DEFAULT NULL;
128: l_receipt_date_from OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT p_receipt_date_from;
129: l_receipt_date_to OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT p_receipt_date_to;
130: l_receipt_type varchar2(30) := p_receipt_type;
131: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;

Line 206: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL

202:
203: PROCEDURE ADVANCED_CASH_APP_CONC ( errbuf OUT NOCOPY VARCHAR2
204: ,retcode OUT NOCOPY NUMBER
205: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
206: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
207: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
208: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
209: ,p_receipt_date_from IN VARCHAR2 DEFAULT NULL
210: ,p_receipt_date_to IN VARCHAR2 DEFAULT NULL

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

203: PROCEDURE ADVANCED_CASH_APP_CONC ( errbuf OUT NOCOPY VARCHAR2
204: ,retcode OUT NOCOPY NUMBER
205: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
206: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
207: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
208: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
209: ,p_receipt_date_from IN VARCHAR2 DEFAULT NULL
210: ,p_receipt_date_to IN VARCHAR2 DEFAULT NULL
211: ,p_receipt_type IN VARCHAR2 DEFAULT NULL

Line 227: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;

223:
224: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
225: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
226: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
227: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
228: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
229: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;
230: l_receipt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE DEFAULT NULL;
231: l_receipt_date_from OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL;

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

224: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
225: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
226: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
227: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
228: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
229: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;
230: l_receipt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE DEFAULT NULL;
231: l_receipt_date_from OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL;
232: l_receipt_date_to OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL;

Line 230: l_receipt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE DEFAULT NULL;

226: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
227: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
228: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
229: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;
230: l_receipt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE DEFAULT NULL;
231: l_receipt_date_from OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL;
232: l_receipt_date_to OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL;
233: l_receipt_type VARCHAR2(30) := p_receipt_type;
234: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;

Line 377: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL

373: ,x_return_status OUT NOCOPY VARCHAR2
374: ,x_msg_count OUT NOCOPY NUMBER
375: ,x_msg_data OUT NOCOPY VARCHAR2
376: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
377: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
378: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
379: )IS
380:
381: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 389: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;

385: l_msg_count NUMBER;
386: l_msg_data VARCHAR(2000);
387:
388: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
389: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
390: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
391:
392:
393:

Line 462: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL

458:
459: PROCEDURE REAPPLIC_RCPT_W_CNTRCT_CONC ( errbuf OUT NOCOPY VARCHAR2
460: ,retcode OUT NOCOPY NUMBER
461: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
462: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
463: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
464: ) IS
465:
466: l_api_version NUMBER := 1;

Line 476: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;

472: l_msg_index_out NUMBER :=0;
473: l_error_msg_rec Okl_Accounting_Util.Error_message_Type;
474:
475: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
476: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
477: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
478: l_request_id NUMBER;
479: l_data varchar2(2000);
480:

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

599: ,x_return_status OUT NOCOPY VARCHAR2
600: ,x_msg_count OUT NOCOPY NUMBER
601: ,x_msg_data OUT NOCOPY VARCHAR2
602: ,p_xcav_tbl IN OKL_BPD_ADVANCED_CASH_APP_PVT.xcav_tbl_type
603: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
604: ,p_receipt_amount IN OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
605: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
606: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
607: ,p_currency_code IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL

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

600: ,x_msg_count OUT NOCOPY NUMBER
601: ,x_msg_data OUT NOCOPY VARCHAR2
602: ,p_xcav_tbl IN OKL_BPD_ADVANCED_CASH_APP_PVT.xcav_tbl_type
603: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
604: ,p_receipt_amount IN OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
605: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
606: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
607: ,p_currency_code IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
608: ,p_ar_inv_tbl IN OKL_BPD_ADVANCED_BILLING_PVT.ar_inv_tbl_type

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

601: ,x_msg_data OUT NOCOPY VARCHAR2
602: ,p_xcav_tbl IN OKL_BPD_ADVANCED_CASH_APP_PVT.xcav_tbl_type
603: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
604: ,p_receipt_amount IN OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
605: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
606: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
607: ,p_currency_code IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
608: ,p_ar_inv_tbl IN OKL_BPD_ADVANCED_BILLING_PVT.ar_inv_tbl_type
609: ) IS

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

602: ,p_xcav_tbl IN OKL_BPD_ADVANCED_CASH_APP_PVT.xcav_tbl_type
603: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
604: ,p_receipt_amount IN OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
605: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
606: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
607: ,p_currency_code IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
608: ,p_ar_inv_tbl IN OKL_BPD_ADVANCED_BILLING_PVT.ar_inv_tbl_type
609: ) IS
610:

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

603: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
604: ,p_receipt_amount IN OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
605: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
606: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
607: ,p_currency_code IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
608: ,p_ar_inv_tbl IN OKL_BPD_ADVANCED_BILLING_PVT.ar_inv_tbl_type
609: ) IS
610:
611: l_ar_inv_tbl OKL_BPD_ADVANCED_BILLING_PVT.ar_inv_tbl_type DEFAULT p_ar_inv_tbl;

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

616: l_msg_count NUMBER;
617: l_msg_data VARCHAR2(2000);
618: l_api_name CONSTANT VARCHAR2(30) := 'AR_advance_receipt';
619:
620: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;
621: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;
622: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;
623: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
624: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_currency_code; -- entered currency code

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

619:
620: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;
621: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;
622: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;
623: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
624: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_currency_code; -- entered currency code
625:
626: -------------------------------------------------------------------------------
627: -- DECLARE Record/Table Types