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 OKL_TRX_CSH_RECEIPT_V

Line 11: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL

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
15:

Line 12: ,p_receipt_type IN OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT NULL

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
15:
16: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 25: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;

21: l_msg_data VARCHAR(2000);
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;

Line 28: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;

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:
32: BEGIN

Line 30: l_receipt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT p_receipt_type;

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:
34: ------------------------------------------------------------

Line 107: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL

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
111: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'

Line 108: ,p_receipt_date_from IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL

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
111: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
112: ) IS

Line 109: ,p_receipt_date_to IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%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
111: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
112: ) IS
113:

Line 123: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;

119: l_msg_data VARCHAR(2000);
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;

Line 126: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;

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;
130: l_receipt_type varchar2(30) := p_receipt_type;

Line 128: l_receipt_date_from OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT p_receipt_date_from;

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;
132:

Line 129: l_receipt_date_to OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT p_receipt_date_to;

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;
132:
133: BEGIN

Line 208: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL

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
212: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'

Line 226: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;

222: l_error_msg_rec Okl_Accounting_Util.Error_message_Type;
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;

Line 229: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;

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;
233: l_receipt_type VARCHAR2(30) := p_receipt_type;

Line 231: l_receipt_date_from OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%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;
235:

Line 232: l_receipt_date_to OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL;

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;
235:
236: l_request_id NUMBER;

Line 621: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;

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
625:

Line 622: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;

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
625:
626: -------------------------------------------------------------------------------

Line 624: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_currency_code; -- entered currency code

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
628: -------------------------------------------------------------------------------