eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AR_REFUNDS_PVT dependencies on AP_INVOICES

Line 69: ,p_payment_method_code IN ap_invoices.payment_method_code%TYPE

65: ,p_pay_group_lookup_code IN FND_LOOKUPS.lookup_code%TYPE
66: ,p_pay_alone_flag IN VARCHAR2
67: ,p_org_id IN ar_cash_receipts.org_id%TYPE
68: ,p_legal_entity_id IN ar_cash_receipts.legal_entity_id%TYPE
69: ,p_payment_method_code IN ap_invoices.payment_method_code%TYPE
70: ,p_payment_reason_code IN ap_invoices.payment_reason_code%TYPE
71: ,p_payment_reason_comments IN ap_invoices.payment_reason_comments%TYPE
72: ,p_delivery_channel_code IN ap_invoices.delivery_channel_code%TYPE
73: ,p_remittance_message1 IN ap_invoices.remittance_message1%TYPE

Line 70: ,p_payment_reason_code IN ap_invoices.payment_reason_code%TYPE

66: ,p_pay_alone_flag IN VARCHAR2
67: ,p_org_id IN ar_cash_receipts.org_id%TYPE
68: ,p_legal_entity_id IN ar_cash_receipts.legal_entity_id%TYPE
69: ,p_payment_method_code IN ap_invoices.payment_method_code%TYPE
70: ,p_payment_reason_code IN ap_invoices.payment_reason_code%TYPE
71: ,p_payment_reason_comments IN ap_invoices.payment_reason_comments%TYPE
72: ,p_delivery_channel_code IN ap_invoices.delivery_channel_code%TYPE
73: ,p_remittance_message1 IN ap_invoices.remittance_message1%TYPE
74: ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE

Line 71: ,p_payment_reason_comments IN ap_invoices.payment_reason_comments%TYPE

67: ,p_org_id IN ar_cash_receipts.org_id%TYPE
68: ,p_legal_entity_id IN ar_cash_receipts.legal_entity_id%TYPE
69: ,p_payment_method_code IN ap_invoices.payment_method_code%TYPE
70: ,p_payment_reason_code IN ap_invoices.payment_reason_code%TYPE
71: ,p_payment_reason_comments IN ap_invoices.payment_reason_comments%TYPE
72: ,p_delivery_channel_code IN ap_invoices.delivery_channel_code%TYPE
73: ,p_remittance_message1 IN ap_invoices.remittance_message1%TYPE
74: ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE
75: ,p_remittance_message3 IN ap_invoices.remittance_message3%TYPE

Line 72: ,p_delivery_channel_code IN ap_invoices.delivery_channel_code%TYPE

68: ,p_legal_entity_id IN ar_cash_receipts.legal_entity_id%TYPE
69: ,p_payment_method_code IN ap_invoices.payment_method_code%TYPE
70: ,p_payment_reason_code IN ap_invoices.payment_reason_code%TYPE
71: ,p_payment_reason_comments IN ap_invoices.payment_reason_comments%TYPE
72: ,p_delivery_channel_code IN ap_invoices.delivery_channel_code%TYPE
73: ,p_remittance_message1 IN ap_invoices.remittance_message1%TYPE
74: ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE
75: ,p_remittance_message3 IN ap_invoices.remittance_message3%TYPE
76: ,p_party_id IN hz_parties.party_id%TYPE

Line 73: ,p_remittance_message1 IN ap_invoices.remittance_message1%TYPE

69: ,p_payment_method_code IN ap_invoices.payment_method_code%TYPE
70: ,p_payment_reason_code IN ap_invoices.payment_reason_code%TYPE
71: ,p_payment_reason_comments IN ap_invoices.payment_reason_comments%TYPE
72: ,p_delivery_channel_code IN ap_invoices.delivery_channel_code%TYPE
73: ,p_remittance_message1 IN ap_invoices.remittance_message1%TYPE
74: ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE
75: ,p_remittance_message3 IN ap_invoices.remittance_message3%TYPE
76: ,p_party_id IN hz_parties.party_id%TYPE
77: ,p_party_site_id IN hz_party_sites.party_site_id%TYPE

Line 74: ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE

70: ,p_payment_reason_code IN ap_invoices.payment_reason_code%TYPE
71: ,p_payment_reason_comments IN ap_invoices.payment_reason_comments%TYPE
72: ,p_delivery_channel_code IN ap_invoices.delivery_channel_code%TYPE
73: ,p_remittance_message1 IN ap_invoices.remittance_message1%TYPE
74: ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE
75: ,p_remittance_message3 IN ap_invoices.remittance_message3%TYPE
76: ,p_party_id IN hz_parties.party_id%TYPE
77: ,p_party_site_id IN hz_party_sites.party_site_id%TYPE
78: ,p_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE

Line 75: ,p_remittance_message3 IN ap_invoices.remittance_message3%TYPE

71: ,p_payment_reason_comments IN ap_invoices.payment_reason_comments%TYPE
72: ,p_delivery_channel_code IN ap_invoices.delivery_channel_code%TYPE
73: ,p_remittance_message1 IN ap_invoices.remittance_message1%TYPE
74: ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE
75: ,p_remittance_message3 IN ap_invoices.remittance_message3%TYPE
76: ,p_party_id IN hz_parties.party_id%TYPE
77: ,p_party_site_id IN hz_party_sites.party_site_id%TYPE
78: ,p_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
79: ,p_called_from IN VARCHAR2

Line 80: ,x_invoice_id OUT NOCOPY ap_invoices.invoice_id%TYPE

76: ,p_party_id IN hz_parties.party_id%TYPE
77: ,p_party_site_id IN hz_party_sites.party_site_id%TYPE
78: ,p_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
79: ,p_called_from IN VARCHAR2
80: ,x_invoice_id OUT NOCOPY ap_invoices.invoice_id%TYPE
81: ,x_return_status OUT NOCOPY VARCHAR2
82: ,x_msg_count OUT NOCOPY NUMBER
83: ,x_msg_data OUT NOCOPY VARCHAR2
84: ,p_invoice_date IN ap_invoices.invoice_date%TYPE DEFAULT NULL -- Bug 7242125

Line 84: ,p_invoice_date IN ap_invoices.invoice_date%TYPE DEFAULT NULL -- Bug 7242125

80: ,x_invoice_id OUT NOCOPY ap_invoices.invoice_id%TYPE
81: ,x_return_status OUT NOCOPY VARCHAR2
82: ,x_msg_count OUT NOCOPY NUMBER
83: ,x_msg_data OUT NOCOPY VARCHAR2
84: ,p_invoice_date IN ap_invoices.invoice_date%TYPE DEFAULT NULL -- Bug 7242125
85: ------------------------------- Bug7525965 Changes Start Here ------------------------------
86: ,p_payment_priority IN ap_invoices_interface.PAYMENT_PRIORITY%TYPE DEFAULT NULL
87: ,p_terms_id IN ap_invoices_interface.TERMS_ID%TYPE DEFAULT NULL
88: ------------------------------- Bug7525965 Changes End Here --------------------------------

Line 86: ,p_payment_priority IN ap_invoices_interface.PAYMENT_PRIORITY%TYPE DEFAULT NULL

82: ,x_msg_count OUT NOCOPY NUMBER
83: ,x_msg_data OUT NOCOPY VARCHAR2
84: ,p_invoice_date IN ap_invoices.invoice_date%TYPE DEFAULT NULL -- Bug 7242125
85: ------------------------------- Bug7525965 Changes Start Here ------------------------------
86: ,p_payment_priority IN ap_invoices_interface.PAYMENT_PRIORITY%TYPE DEFAULT NULL
87: ,p_terms_id IN ap_invoices_interface.TERMS_ID%TYPE DEFAULT NULL
88: ------------------------------- Bug7525965 Changes End Here --------------------------------
89: ,p_gl_date IN DATE DEFAULT NULL) --Bug8283120
90: IS

Line 87: ,p_terms_id IN ap_invoices_interface.TERMS_ID%TYPE DEFAULT NULL

83: ,x_msg_data OUT NOCOPY VARCHAR2
84: ,p_invoice_date IN ap_invoices.invoice_date%TYPE DEFAULT NULL -- Bug 7242125
85: ------------------------------- Bug7525965 Changes Start Here ------------------------------
86: ,p_payment_priority IN ap_invoices_interface.PAYMENT_PRIORITY%TYPE DEFAULT NULL
87: ,p_terms_id IN ap_invoices_interface.TERMS_ID%TYPE DEFAULT NULL
88: ------------------------------- Bug7525965 Changes End Here --------------------------------
89: ,p_gl_date IN DATE DEFAULT NULL) --Bug8283120
90: IS
91: l_External_Payee_Tab IBY_DISBURSEMENT_SETUP_PUB.External_Payee_Tab_Type;

Line 206: debug('Calling AP_INVOICES_INTERFACE_PKG.INSERT_ROW..');

202: END IF;
203: END IF;
204:
205: /* First populate AP interface table..*/
206: debug('Calling AP_INVOICES_INTERFACE_PKG.INSERT_ROW..');
207:
208: SELECT ap_invoices_interface_s.NEXTVAL
209: INTO l_invoice_interface_id
210: FROM DUAL;

Line 208: SELECT ap_invoices_interface_s.NEXTVAL

204:
205: /* First populate AP interface table..*/
206: debug('Calling AP_INVOICES_INTERFACE_PKG.INSERT_ROW..');
207:
208: SELECT ap_invoices_interface_s.NEXTVAL
209: INTO l_invoice_interface_id
210: FROM DUAL;
211:
212: SELECT ap_invoice_lines_interface_s.NEXTVAL

Line 236: AP_INVOICES_INTERFACE_PKG.INSERT_ROW (

232: l_invoice_received_date := p_invoice_date;
233:
234: end if;
235:
236: AP_INVOICES_INTERFACE_PKG.INSERT_ROW (
237: X_ROWID => l_rowid ,
238: X_INVOICE_ID => l_invoice_interface_id,
239: X_INVOICE_NUM => l_invoice_interface_id,
240: X_INVOICE_TYPE_LOOKUP_CODE => 'PAYMENT REQUEST',

Line 344: debug('Calling AP_INVOICES_LINES_INTERFACE_PKG.INSERT_ROW..');

340: x_external_bank_account_id => p_bank_account_id
341: );
342:
343: /* Next populate AP lines interface table..*/
344: debug('Calling AP_INVOICES_LINES_INTERFACE_PKG.INSERT_ROW..');
345:
346: AP_INVOICE_LINES_INTERFACE_PKG.INSERT_ROW(
347: X_ROWID => l_line_rowid,
348: X_INVOICE_ID => l_invoice_interface_id,