APPS.AR_RECEIPT_UPDATE_API_PUB dependencies on AR_CASH_RECEIPTS

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 26: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;

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;
30: l_customer_bank_account_id NUMBER := p_customer_bank_account_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 298: l_crv_rec ar_cash_receipts_v%ROWTYPE;

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

Line 299: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;

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

Line 301: l_comments ar_cash_receipts.comments%TYPE;

297:
298: l_crv_rec ar_cash_receipts_v%ROWTYPE;
299: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
300: l_creation_method_code ar_receipt_classes.creation_method_code%TYPE;
301: l_comments ar_cash_receipts.comments%TYPE;
302:
303: l_cash_receipt_id NUMBER := p_cash_receipt_id;
304: l_customer_id NUMBER := p_pay_from_customer;
305: l_customer_bank_account_id NUMBER := p_customer_bank_account_id;

Line 322: l_create_pmt_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;

318: -- Create payment_trxn_extension_id
319: l_create_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
320: l_create_msg_count NUMBER;
321: l_create_msg_data VARCHAR2(2000);
322: l_create_pmt_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
323: l_valid_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
324: l_valid_msg_count NUMBER;
325: l_valid_msg_data VARCHAR2(2000);
326: