[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
| update_header_cover |
| |
| DESCRIPTION |
| Updates a record in ra_customer_trx. |
| |
| SCOPE - PUBLIC |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug |
| arp_process_header.update_header |
| |
| ARGUMENTS : IN: |
| p_form_name |
| p_form_version |
| p_trx_amount |
| p_trx_class |
| p_gl_date |
| p_term_in_use_flag |
| p_open_rec_flag |
| p_recalc_tax_flag |
| p_rerun_autoacc_flag |
| p_receivable_ccid |
| p_customer_trx_id |
| p_trx_number |
| p_posting_control_id |
| p_ra_post_loop_number |
| p_complete_flag |
| p_initial_customer_trx_id |
| p_initial_customer_trx_line_id |
| p_previous_customer_trx_id |
| p_related_customer_trx_id |
| p_recurred_from_trx_number |
| p_cust_trx_type_id |
| p_batch_id |
| p_batch_source_id |
| p_agreement_id |
| p_trx_date |
| p_bill_to_customer_id |
| p_bill_to_contact_id |
| p_bill_to_site_use_id |
| p_ship_to_customer_id |
| p_ship_to_contact_id |
| p_ship_to_site_use_id |
| p_sold_to_customer_id |
| p_sold_to_site_use_id |
| p_sold_to_contact_id |
| p_customer_reference |
| p_customer_reference_date |
| p_cr_method_for_installments |
| p_credit_method_for_rules |
| p_start_date_commitment |
| p_end_date_commitment |
| p_exchange_date |
| p_exchange_rate |
| p_exchange_rate_type |
| p_customer_bank_account_id |
| p_finance_charges |
| p_fob_point |
| p_comments |
| p_internal_notes |
| p_invoice_currency_code |
| p_invoicing_rule_id |
| p_last_printed_sequence_num |
| p_orig_system_batch_name |
| p_primary_salesrep_id |
| p_printing_count |
| p_printing_last_printed |
| p_printing_option |
| p_printing_original_date |
| p_printing_pending |
| p_purchase_order |
| p_purchase_order_date |
| p_purchase_order_revision |
| p_receipt_method_id |
| p_remit_to_address_id |
| p_shipment_id |
| p_ship_date_actual |
| p_ship_via |
| p_term_due_date |
| p_term_id |
| p_territory_id |
| p_waybill_number |
| p_status_trx |
| p_reason_code |
| p_doc_sequence_id |
| p_doc_sequence_value |
| p_paying_customer_id |
| p_paying_site_use_id |
| p_related_batch_source_id |
| p_default_tax_exempt_flag |
| p_created_from |
| p_ps_dispute_amount |
| p_ps_dispute_date |
| p_deflt_ussgl_trx_code_context |
| p_deflt_ussgl_transaction_code |
| p_old_trx_number |
| p_interface_header_context |
| p_interface_header_attribute1 |
| p_interface_header_attribute2 |
| p_interface_header_attribute3 |
| p_interface_header_attribute4 |
| p_interface_header_attribute5 |
| p_interface_header_attribute6 |
| p_interface_header_attribute7 |
| p_interface_header_attribute8 |
| p_interface_header_attribute9 |
| p_interface_header_attribute10 |
| p_interface_header_attribute11 |
| p_interface_header_attribute12 |
| p_interface_header_attribute13 |
| p_interface_header_attribute14 |
| p_interface_header_attribute15 |
| p_attribute_category |
| p_attribute1 |
| p_attribute2 |
| p_attribute3 |
| p_attribute4 |
| p_attribute5 |
| p_attribute6 |
| p_attribute7 |
| p_attribute8 |
| p_attribute9 |
| p_attribute10 |
| p_attribute11 |
| p_attribute12 |
| p_attribute13 |
| p_attribute14 |
| p_attribute15 |
| p_commit_customer_trx_line_id |
| p_commit_inventory_item_id |
| p_commit_memo_line_id |
| p_commit_description |
| p_commit_extended_amount |
| p_commit_interface_line_attr1 |
| p_commit_interface_line_attr2 |
| p_commit_interface_line_attr3 |
| p_commit_interface_line_attr4 |
| p_commit_interface_line_attr5 |
| p_commit_interface_line_attr6 |
| p_commit_interface_line_attr7 |
| p_commit_interface_line_attr8 |
| p_commit_interface_line_attr9 |
| p_commit_interface_line_attr10 |
| p_commit_interface_line_attr11 |
| p_commit_interface_line_attr12 |
| p_commit_interface_line_attr13 |
| p_commit_interface_line_attr14 |
| p_commit_interface_line_attr15 |
| p_commit_interface_line_contxt |
| p_commit_attribute_category |
| p_commit_attribute1 |
| p_commit_attribute2 |
| p_commit_attribute3 |
| p_commit_attribute4 |
| p_commit_attribute5 |
| p_commit_attribute6 |
| p_commit_attribute7 |
| p_commit_attribute8 |
| p_commit_attribute9 |
| p_commit_attribute10 |
| p_commit_attribute11 |
| p_commit_attribute12 |
| p_commit_attribute13 |
| p_commit_attribute14 |
| p_commit_attribute15 |
| OUT: |
| p_trx_number |
| p_customer_trx_id |
| IN/ OUT: |
| |
| RETURNS : NONE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| 27-NOV-95 Martin Johnson Created |
| 18-May-05 Debbie Sue Jancis Added Legal Entity Id for LE project |
| 28-MAR-2006 Herve Yu BUG#4897183 call update XLA events |
| |
+===========================================================================*/
PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
PROCEDURE update_header_cover(
p_form_name IN varchar2,
p_form_version IN number,
p_trx_amount IN number,
p_trx_class IN VARCHAR2,
p_gl_date IN DATE,
p_term_in_use_flag IN varchar2,
p_open_rec_flag IN VARCHAR2,
p_recalc_tax_flag IN varchar2,
p_rerun_autoacc_flag IN varchar2,
p_receivable_ccid IN NUMBER,
p_customer_trx_id IN NUMBER,
p_trx_number IN VARCHAR2,
p_posting_control_id IN NUMBER,
p_ra_post_loop_number IN NUMBER,
p_complete_flag IN VARCHAR2,
p_initial_customer_trx_id IN NUMBER,
p_initial_customer_trx_line_id IN NUMBER,
p_previous_customer_trx_id IN NUMBER,
p_related_customer_trx_id IN NUMBER,
p_recurred_from_trx_number IN VARCHAR2,
p_cust_trx_type_id IN NUMBER,
p_batch_id IN NUMBER,
p_batch_source_id IN NUMBER,
p_agreement_id IN NUMBER,
p_trx_date IN DATE,
p_bill_to_customer_id IN NUMBER,
p_bill_to_contact_id IN NUMBER,
p_bill_to_site_use_id IN NUMBER,
p_ship_to_customer_id IN NUMBER,
p_ship_to_contact_id IN NUMBER,
p_ship_to_site_use_id IN NUMBER,
p_sold_to_customer_id IN NUMBER,
p_sold_to_site_use_id IN NUMBER,
p_sold_to_contact_id IN NUMBER,
p_customer_reference IN VARCHAR2,
p_customer_reference_date IN DATE,
p_cr_method_for_installments IN VARCHAR2,
p_credit_method_for_rules IN VARCHAR2,
p_start_date_commitment IN DATE,
p_end_date_commitment IN DATE,
p_exchange_date IN DATE,
p_exchange_rate IN NUMBER,
p_exchange_rate_type IN VARCHAR2,
p_customer_bank_account_id IN NUMBER,
p_finance_charges IN VARCHAR2,
p_fob_point IN VARCHAR2,
p_comments IN VARCHAR2,
p_internal_notes IN VARCHAR2,
p_invoice_currency_code IN VARCHAR2,
p_invoicing_rule_id IN NUMBER,
p_last_printed_sequence_num IN NUMBER,
p_orig_system_batch_name IN VARCHAR2,
p_primary_salesrep_id IN NUMBER,
p_printing_count IN NUMBER,
p_printing_last_printed IN DATE,
p_printing_option IN VARCHAR2,
p_printing_original_date IN DATE,
p_printing_pending IN VARCHAR2,
p_purchase_order IN VARCHAR2,
p_purchase_order_date IN DATE,
p_purchase_order_revision IN VARCHAR2,
p_receipt_method_id IN NUMBER,
p_remit_to_address_id IN NUMBER,
p_shipment_id IN NUMBER,
p_ship_date_actual IN DATE,
p_ship_via IN VARCHAR2,
p_term_due_date IN DATE,
p_term_id IN NUMBER,
p_territory_id IN NUMBER,
p_waybill_number IN VARCHAR2,
p_status_trx IN VARCHAR2,
p_reason_code IN VARCHAR2,
p_doc_sequence_id IN NUMBER,
p_doc_sequence_value IN NUMBER,
p_paying_customer_id IN NUMBER,
p_paying_site_use_id IN NUMBER,
p_related_batch_source_id IN NUMBER,
p_default_tax_exempt_flag IN VARCHAR2,
p_created_from IN VARCHAR2,
p_ps_dispute_amount IN number,
p_ps_dispute_date IN date,
p_deflt_ussgl_trx_code_context IN VARCHAR2,
p_deflt_ussgl_transaction_code IN VARCHAR2,
p_old_trx_number IN VARCHAR2,
p_interface_header_context IN VARCHAR2,
p_interface_header_attribute1 IN VARCHAR2,
p_interface_header_attribute2 IN VARCHAR2,
p_interface_header_attribute3 IN VARCHAR2,
p_interface_header_attribute4 IN VARCHAR2,
p_interface_header_attribute5 IN VARCHAR2,
p_interface_header_attribute6 IN VARCHAR2,
p_interface_header_attribute7 IN VARCHAR2,
p_interface_header_attribute8 IN VARCHAR2,
p_interface_header_attribute9 IN VARCHAR2,
p_interface_header_attribute10 IN VARCHAR2,
p_interface_header_attribute11 IN VARCHAR2,
p_interface_header_attribute12 IN VARCHAR2,
p_interface_header_attribute13 IN VARCHAR2,
p_interface_header_attribute14 IN VARCHAR2,
p_interface_header_attribute15 IN VARCHAR2,
p_attribute_category IN VARCHAR2,
p_attribute1 IN VARCHAR2,
p_attribute2 IN VARCHAR2,
p_attribute3 IN VARCHAR2,
p_attribute4 IN VARCHAR2,
p_attribute5 IN VARCHAR2,
p_attribute6 IN VARCHAR2,
p_attribute7 IN VARCHAR2,
p_attribute8 IN VARCHAR2,
p_attribute9 IN VARCHAR2,
p_attribute10 IN VARCHAR2,
p_attribute11 IN VARCHAR2,
p_attribute12 IN VARCHAR2,
p_attribute13 IN VARCHAR2,
p_attribute14 IN VARCHAR2,
p_attribute15 IN VARCHAR2,
p_commit_customer_trx_line_id IN NUMBER,
p_commit_inventory_item_id IN NUMBER,
p_commit_memo_line_id IN NUMBER,
p_commit_description IN VARCHAR2,
p_commit_extended_amount IN NUMBER,
p_commit_interface_line_attr1 IN VARCHAR2,
p_commit_interface_line_attr2 IN VARCHAR2,
p_commit_interface_line_attr3 IN VARCHAR2,
p_commit_interface_line_attr4 IN VARCHAR2,
p_commit_interface_line_attr5 IN VARCHAR2,
p_commit_interface_line_attr6 IN VARCHAR2,
p_commit_interface_line_attr7 IN VARCHAR2,
p_commit_interface_line_attr8 IN VARCHAR2,
p_commit_interface_line_attr9 IN VARCHAR2,
p_commit_interface_line_attr10 IN VARCHAR2,
p_commit_interface_line_attr11 IN VARCHAR2,
p_commit_interface_line_attr12 IN VARCHAR2,
p_commit_interface_line_attr13 IN VARCHAR2,
p_commit_interface_line_attr14 IN VARCHAR2,
p_commit_interface_line_attr15 IN VARCHAR2,
p_commit_interface_line_contxt IN VARCHAR2,
p_commit_attribute_category IN VARCHAR2,
p_commit_attribute1 IN VARCHAR2,
p_commit_attribute2 IN VARCHAR2,
p_commit_attribute3 IN VARCHAR2,
p_commit_attribute4 IN VARCHAR2,
p_commit_attribute5 IN VARCHAR2,
p_commit_attribute6 IN VARCHAR2,
p_commit_attribute7 IN VARCHAR2,
p_commit_attribute8 IN VARCHAR2,
p_commit_attribute9 IN VARCHAR2,
p_commit_attribute10 IN VARCHAR2,
p_commit_attribute11 IN VARCHAR2,
p_commit_attribute12 IN VARCHAR2,
p_commit_attribute13 IN VARCHAR2,
p_commit_attribute14 IN VARCHAR2,
p_commit_attribute15 IN VARCHAR2,
p_ctl_default_ussgl_trx_code IN varchar2,
p_status OUT NOCOPY varchar2,
p_legal_entity_id IN NUMBER DEFAULT NULL,
p_payment_trxn_extension_id IN NUMBER DEFAULT NULL,
p_billing_date IN DATE DEFAULT NULL,
p_ct_reference IN VARCHAR2 DEFAULT NULL) IS /* Bug fix 5330712 */
--{BUG#4897183
CURSOR cev IS
SELECT t.trx_date,
d.gl_date,
t.org_id,
d.set_of_books_id,
t.term_id,
t.exchange_rate,
t.exchange_date,
t.exchange_rate_type,
t.complete_flag -- Bug 8936486
FROM ra_customer_trx t,
ra_cust_trx_line_gl_dist d
WHERE t.customer_trx_id = p_customer_trx_id
AND t.customer_trx_id = d.customer_trx_id
AND d.account_class = 'REC' ;
SELECT customer_trx_line_id
FROM ra_customer_trx_lines_all
WHERE customer_trx_id = p_trx_id
AND line_type = 'LINE';
SELECT complete_flag
FROM ra_customer_trx_all
WHERE customer_trx_id = p_customer_trx_id;
arp_util.debug('arp_process_header_updte_cover.update_header_cover()+');
arp_acct_event_pkg.update_dates_for_trx_event
(p_source_id_int_1 => p_customer_trx_id,
p_trx_number => p_trx_number,
p_legal_entity_id => p_legal_entity_id,
p_ledger_id => l_sob_id,
p_org_id => l_org_id,
p_event_id => NULL,
p_valuation_method => NULL,
p_entity_type_code => 'TRANSACTIONS',
p_event_type_code => 'INV_CREATE',
p_curr_event_date => l_gl_date,
p_event_date => p_gl_date,
p_status => 'I',
p_action => 'UPDATE_EVENT_DATE',
p_curr_trx_date => l_trx_date,
p_transaction_date => p_trx_date,
x_event_id => x_event_id);
arp_process_header.update_header(
p_form_name,
p_form_version,
l_trx_rec,
p_customer_trx_id,
NVL(p_trx_amount,0),
p_trx_class,
p_gl_date,
p_initial_customer_trx_line_id,
l_commit_rec,
p_open_rec_flag,
p_term_in_use_flag,
l_recalc_tax_flag,
l_rerun_autoacc_flag,
NVL(p_ps_dispute_amount,0),
p_ps_dispute_date,
p_status);
/* 8349620 - Added Call to eTax API update_exchange_rate when
Exchange details updates.*/
IF lf
THEN
/* Determine state for etax sync call */
IF (p_complete_flag = 'Y') AND (NVL(p_exchange_rate, 0) <> NVL(l_exch_rate, 0) OR
NVL(p_exchange_rate_type, '$#') <> NVL(l_exch_type, '$#') OR
NOT((p_exchange_date iS NULL AND l_exch_date IS NULL) OR p_exchange_date = l_exch_date)) THEN
arp_etax_services_pkg.update_exchange_info(
p_customer_trx_id => p_customer_trx_id,
p_exchange_rate => p_exchange_rate,
p_exchange_date => p_exchange_date,
p_exchange_rate_type => p_exchange_rate_type );
/* execute line_det_factor update (discount amount
may have changed) */
IF PG_DEBUG in ('Y','C')
THEN
arp_debug.debug('term has changed, execute update of LDF');
/* loop through the lines and update line det factors
for each */
FOR line IN c_line(p_customer_trx_id)
LOOP
arp_etax_services_pkg.line_det_factors(line.customer_trx_line_id,
p_customer_trx_id,
'UPDATE');
/* execute synchronize w/ line update */
arp_etax_util.synchronize_for_doc_seq(p_customer_trx_id,l_return_status,
NULL,
'Y');
/* execute synchronize w/out line update */
IF PG_DEBUG in ('Y','C')
THEN
arp_debug.debug('execute synchronize for doc seq only');
arp_util.debug('arp_process_header_updte_cover.update_header_cover()-');
'exception: arp_process_header_updte_cover.update_header_cover()');
END update_header_cover;