DBA Data[Home] [Help]

APPS.AR_RECEIPT_UPDATE_API_PUB dependencies on AR_CASH_RECEIPTS_V

Line 20: x_crv_rec OUT NOCOPY ar_cash_receipts_v%ROWTYPE

16: p_customer_bank_account_id IN NUMBER,
17: x_msg_count OUT NOCOPY NUMBER,
18: x_msg_data OUT NOCOPY VARCHAR2,
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_crv_rec OUT NOCOPY ar_cash_receipts_v%ROWTYPE
21: )
22: IS
23:
24:

Line 25: l_crv_rec ar_cash_receipts_v%ROWTYPE;

21: )
22: IS
23:
24:
25: l_crv_rec ar_cash_receipts_v%ROWTYPE;
26: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
27: l_creation_method_code ar_receipt_classes.creation_method_code%TYPE;
28: l_cash_receipt_id NUMBER := p_cash_receipt_id;
29: l_customer_id NUMBER := p_customer_id;

Line 78: FROM AR_CASH_RECEIPTS_V

74: ELSE
75:
76: SELECT count(*)
77: INTO l_valid
78: FROM AR_CASH_RECEIPTS_V
79: WHERE cash_receipt_id = p_cash_receipt_id;
80:
81: IF l_valid = 0 THEN
82: arp_standard.debug('Invlaid Cash_receipt_id passed .');

Line 96: FROM AR_CASH_RECEIPTS_V

92:
93: END IF;
94:
95: SELECT * INTO l_crv_rec
96: FROM AR_CASH_RECEIPTS_V
97: WHERE cash_receipt_id = p_cash_receipt_id;
98:
99: x_crv_rec := l_crv_rec;
100:

Line 299: l_crv_rec ar_cash_receipts_v%ROWTYPE;

295:
296: l_api_name CONSTANT VARCHAR2(50) := 'update_receipt_unid_to_unapp';
297: l_api_version CONSTANT NUMBER := 1.0;
298:
299: l_crv_rec ar_cash_receipts_v%ROWTYPE;
300: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
301: l_creation_method_code ar_receipt_classes.creation_method_code%TYPE;
302:
303: l_cash_receipt_id NUMBER := p_cash_receipt_id;