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 100: l_app_rec ar_receivable_applications%ROWTYPE;

96: l_line_rowid VARCHAR2(100);
97: l_invoice_interface_id NUMBER;
98: l_invoice_line_interface_id NUMBER;
99: l_rejection_list AP_IMPORT_INVOICES_PKG.rejection_tab_type;
100: l_app_rec ar_receivable_applications%ROWTYPE;
101: l_activity_ccid gl_code_combinations.code_combination_id%TYPE;
102: l_goods_received_date DATE DEFAULT NULL ;
103: l_invoice_received_date DATE DEFAULT NULL ;
104: l_terms_date_basis VARCHAR2(100);

Line 125: from ar_receivable_applications ra

121:
122: select
123: ra.code_combination_id
124: INTO l_activity_ccid
125: from ar_receivable_applications ra
126: where ra.status='ACTIVITY'
127: and ra.display = 'Y'
128: AND ra.receivable_application_id = p_receivable_application_id;
129:

Line 329: X_PRODUCT_TABLE => 'AR_RECEIVABLE_APPLICATIONS_ALL',

325: x_remittance_message1 => p_remittance_message1 ,
326: x_remittance_message2 => p_remittance_message2,
327: x_remittance_message3 => p_remittance_message3,
328: X_APPLICATION_ID => 222,
329: X_PRODUCT_TABLE => 'AR_RECEIVABLE_APPLICATIONS_ALL',
330: X_REFERENCE_KEY1 => p_receivable_application_id,
331: X_REFERENCE_KEY2 => 'AR_RECEIVABLE_APPLICATIONS_ALL',
332: X_REFERENCE_KEY3 => NULL,
333: X_REFERENCE_KEY4 => NULL,

Line 331: X_REFERENCE_KEY2 => 'AR_RECEIVABLE_APPLICATIONS_ALL',

327: x_remittance_message3 => p_remittance_message3,
328: X_APPLICATION_ID => 222,
329: X_PRODUCT_TABLE => 'AR_RECEIVABLE_APPLICATIONS_ALL',
330: X_REFERENCE_KEY1 => p_receivable_application_id,
331: X_REFERENCE_KEY2 => 'AR_RECEIVABLE_APPLICATIONS_ALL',
332: X_REFERENCE_KEY3 => NULL,
333: X_REFERENCE_KEY4 => NULL,
334: X_REFERENCE_KEY5 => NULL,
335: X_PARTY_ID => p_party_id,

Line 519: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE

515: | 06-DEC-2005 JBECKETT Created
516: |
517: *=======================================================================*/
518: PROCEDURE cancel_refund(
519: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE
520: ,p_gl_date IN DATE
521: ,x_return_status OUT NOCOPY VARCHAR2
522: ,x_msg_count OUT NOCOPY NUMBER
523: ,x_msg_data OUT NOCOPY VARCHAR2)