APPS.AR_REFUNDS_PVT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 58: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE

54: | 06-DEC-2005 JBECKETT Created
55: |
56: *=======================================================================*/
57: PROCEDURE create_refund(
58: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE
59: ,p_amount IN NUMBER
60: ,p_currency_code IN fnd_currencies.currency_code%TYPE
61: ,p_exchange_rate IN NUMBER
62: ,p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE

Line 95: l_app_rec ar_receivable_applications%ROWTYPE;

91: l_line_rowid VARCHAR2(100);
92: l_invoice_interface_id NUMBER;
93: l_invoice_line_interface_id NUMBER;
94: l_rejection_list AP_IMPORT_INVOICES_PKG.rejection_tab_type;
95: l_app_rec ar_receivable_applications%ROWTYPE;
96: l_activity_ccid gl_code_combinations.code_combination_id%TYPE;
97:
98: BEGIN
99:

Line 106: ar_receivable_applications ra

102:
103: SELECT rt.code_combination_id
104: INTO l_activity_ccid
105: FROM ar_receivables_trx rt,
106: ar_receivable_applications ra
107: WHERE ra.receivables_trx_id = rt.receivables_trx_id
108: AND ra.receivable_application_id = p_receivable_application_id;
109:
110: /* Create a payee record if one does not exist..*/

Line 243: X_PRODUCT_TABLE => 'AR_RECEIVABLE_APPLICATIONS_ALL',

239: x_remittance_message1 => p_remittance_message1 ,
240: x_remittance_message2 => p_remittance_message2,
241: x_remittance_message3 => p_remittance_message3,
242: X_APPLICATION_ID => 222,
243: X_PRODUCT_TABLE => 'AR_RECEIVABLE_APPLICATIONS_ALL',
244: X_REFERENCE_KEY1 => p_receivable_application_id,
245: X_REFERENCE_KEY2 => 'AR_RECEIVABLE_APPLICATIONS_ALL',
246: X_REFERENCE_KEY3 => NULL,
247: X_REFERENCE_KEY4 => NULL,

Line 245: X_REFERENCE_KEY2 => 'AR_RECEIVABLE_APPLICATIONS_ALL',

241: x_remittance_message3 => p_remittance_message3,
242: X_APPLICATION_ID => 222,
243: X_PRODUCT_TABLE => 'AR_RECEIVABLE_APPLICATIONS_ALL',
244: X_REFERENCE_KEY1 => p_receivable_application_id,
245: X_REFERENCE_KEY2 => 'AR_RECEIVABLE_APPLICATIONS_ALL',
246: X_REFERENCE_KEY3 => NULL,
247: X_REFERENCE_KEY4 => NULL,
248: X_REFERENCE_KEY5 => NULL,
249: X_PARTY_ID => p_party_id,

Line 433: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE

429: | 06-DEC-2005 JBECKETT Created
430: |
431: *=======================================================================*/
432: PROCEDURE cancel_refund(
433: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE
434: ,p_gl_date IN DATE
435: ,x_return_status OUT NOCOPY VARCHAR2
436: ,x_msg_count OUT NOCOPY NUMBER
437: ,x_msg_data OUT NOCOPY VARCHAR2)