DBA Data[Home] [Help]

APPS.OKL_PAYMENT_PUB dependencies on AR_CASH_RECEIPTS_ALL

Line 9: l_receipt_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE;

5: -- FUNCTION get_ar_receipt_number
6: ------------------------------------------------------------------------------
7: FUNCTION get_ar_receipt_number(p_cash_receipt_id IN NUMBER) RETURN VARCHAR2 IS
8:
9: l_receipt_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE;
10:
11: CURSOR C1 (p_cash_receipt_id IN NUMBER) IS
12: SELECT RECEIPT_NUMBER
13: FROM AR_CASH_RECEIPTS_ALL

Line 13: FROM AR_CASH_RECEIPTS_ALL

9: l_receipt_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE;
10:
11: CURSOR C1 (p_cash_receipt_id IN NUMBER) IS
12: SELECT RECEIPT_NUMBER
13: FROM AR_CASH_RECEIPTS_ALL
14: WHERE CASH_RECEIPT_ID = p_cash_receipt_id;
15:
16: BEGIN
17:

Line 282: x_payment_ref_number OUT NOCOPY AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE,

278: x_msg_count OUT NOCOPY NUMBER,
279: x_msg_data OUT NOCOPY VARCHAR2,
280: p_receipt_rec IN receipt_rec_type,
281: p_payment_tbl IN payment_tbl_type,
282: x_payment_ref_number OUT NOCOPY AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE,
283: x_cash_receipt_id OUT NOCOPY NUMBER
284: )
285: IS
286:

Line 301: l_payment_ref_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE DEFAULT NULL;

297:
298: l_receipt_rec receipt_rec_type := p_receipt_rec;
299: l_payment_tbl payment_tbl_type := p_payment_tbl;
300:
301: l_payment_ref_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE DEFAULT NULL;
302: l_cash_receipt_id NUMBER;
303: BEGIN
304:
305: SAVEPOINT CREATE_PAYMENTS;