DBA Data[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: IS
86: l_External_Payee_Tab IBY_DISBURSEMENT_SETUP_PUB.External_Payee_Tab_Type;
87: l_Ext_Payee_ID_Tab IBY_DISBURSEMENT_SETUP_PUB.Ext_Payee_ID_Tab_Type;
88: l_Ext_Payee_Create_Tab IBY_DISBURSEMENT_SETUP_PUB.Ext_Payee_Create_Tab_Type;

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

136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138:
139: /* First populate AP interface table..*/
140: debug('Calling AP_INVOICES_INTERFACE_PKG.INSERT_ROW..');
141:
142: SELECT ap_invoices_interface_s.NEXTVAL
143: INTO l_invoice_interface_id
144: FROM DUAL;

Line 142: SELECT ap_invoices_interface_s.NEXTVAL

138:
139: /* First populate AP interface table..*/
140: debug('Calling AP_INVOICES_INTERFACE_PKG.INSERT_ROW..');
141:
142: SELECT ap_invoices_interface_s.NEXTVAL
143: INTO l_invoice_interface_id
144: FROM DUAL;
145:
146: SELECT ap_invoice_lines_interface_s.NEXTVAL

Line 150: AP_INVOICES_INTERFACE_PKG.INSERT_ROW (

146: SELECT ap_invoice_lines_interface_s.NEXTVAL
147: INTO l_invoice_line_interface_id
148: FROM DUAL;
149:
150: AP_INVOICES_INTERFACE_PKG.INSERT_ROW (
151: X_ROWID => l_rowid ,
152: X_INVOICE_ID => l_invoice_interface_id,
153: X_INVOICE_NUM => l_invoice_interface_id,
154: X_INVOICE_TYPE_LOOKUP_CODE => 'PAYMENT REQUEST',

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

254: x_external_bank_account_id => p_bank_account_id
255: );
256:
257: /* Next populate AP lines interface table..*/
258: debug('Calling AP_INVOICES_LINES_INTERFACE_PKG.INSERT_ROW..');
259:
260: AP_INVOICE_LINES_INTERFACE_PKG.INSERT_ROW(
261: X_ROWID => l_line_rowid,
262: X_INVOICE_ID => l_invoice_interface_id,