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.

APPS.ARP_CT_PKG dependencies on RA_CUSTOMER_TRX_S

Line 3714: SELECT RA_CUSTOMER_TRX_S.NEXTVAL

3710: /*---------------------------*
3711: | Get the unique identifier |
3712: *---------------------------*/
3713:
3714: SELECT RA_CUSTOMER_TRX_S.NEXTVAL
3715: INTO l_customer_trx_id
3716: FROM DUAL;
3717:
3718: /*----------------------------*

Line 4552: p_ship_via IN ra_customer_trx.ship_via%type,

4548: | |
4549: +===========================================================================*/
4550: PROCEDURE lock_compare_frt_cover(
4551: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
4552: p_ship_via IN ra_customer_trx.ship_via%type,
4553: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4554: p_waybill_number IN ra_customer_trx.waybill_number%type,
4555: p_fob_point IN ra_customer_trx.fob_point%type)
4556: IS

Line 4553: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

4549: +===========================================================================*/
4550: PROCEDURE lock_compare_frt_cover(
4551: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
4552: p_ship_via IN ra_customer_trx.ship_via%type,
4553: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4554: p_waybill_number IN ra_customer_trx.waybill_number%type,
4555: p_fob_point IN ra_customer_trx.fob_point%type)
4556: IS
4557: l_trx_rec ra_customer_trx%rowtype;

Line 4749: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,

4745: p_trx_date IN ra_customer_trx.trx_date%type,
4746: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
4747: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
4748: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
4749: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
4750: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
4751: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
4752: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
4753: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,

Line 4750: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,

4746: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
4747: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
4748: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
4749: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
4750: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
4751: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
4752: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
4753: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
4754: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,

Line 4751: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,

4747: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
4748: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
4749: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
4750: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
4751: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
4752: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
4753: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
4754: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
4755: p_customer_reference IN ra_customer_trx.customer_reference%type,

Line 4752: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,

4748: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
4749: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
4750: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
4751: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
4752: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
4753: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
4754: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
4755: p_customer_reference IN ra_customer_trx.customer_reference%type,
4756: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,

Line 4753: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,

4749: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
4750: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
4751: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
4752: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
4753: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
4754: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
4755: p_customer_reference IN ra_customer_trx.customer_reference%type,
4756: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
4757: p_cr_method_for_installments IN

Line 4754: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,

4750: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
4751: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
4752: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
4753: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
4754: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
4755: p_customer_reference IN ra_customer_trx.customer_reference%type,
4756: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
4757: p_cr_method_for_installments IN
4758: ra_customer_trx.credit_method_for_installments%type,

Line 4760: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,

4756: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
4757: p_cr_method_for_installments IN
4758: ra_customer_trx.credit_method_for_installments%type,
4759: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
4760: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
4761: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
4762: p_exchange_date IN ra_customer_trx.exchange_date%type,
4763: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
4764: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,

Line 4786: p_shipment_id IN ra_customer_trx.shipment_id%type,

4782: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
4783: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
4784: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
4785: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
4786: p_shipment_id IN ra_customer_trx.shipment_id%type,
4787: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4788: p_ship_via IN ra_customer_trx.ship_via%type,
4789: p_term_due_date IN ra_customer_trx.term_due_date%type,
4790: p_term_id IN ra_customer_trx.term_id%type,

Line 4787: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

4783: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
4784: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
4785: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
4786: p_shipment_id IN ra_customer_trx.shipment_id%type,
4787: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4788: p_ship_via IN ra_customer_trx.ship_via%type,
4789: p_term_due_date IN ra_customer_trx.term_due_date%type,
4790: p_term_id IN ra_customer_trx.term_id%type,
4791: p_territory_id IN ra_customer_trx.territory_id%type,

Line 4788: p_ship_via IN ra_customer_trx.ship_via%type,

4784: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
4785: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
4786: p_shipment_id IN ra_customer_trx.shipment_id%type,
4787: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4788: p_ship_via IN ra_customer_trx.ship_via%type,
4789: p_term_due_date IN ra_customer_trx.term_due_date%type,
4790: p_term_id IN ra_customer_trx.term_id%type,
4791: p_territory_id IN ra_customer_trx.territory_id%type,
4792: p_waybill_number IN ra_customer_trx.waybill_number%type,

Line 4793: p_status_trx IN ra_customer_trx.status_trx%type,

4789: p_term_due_date IN ra_customer_trx.term_due_date%type,
4790: p_term_id IN ra_customer_trx.term_id%type,
4791: p_territory_id IN ra_customer_trx.territory_id%type,
4792: p_waybill_number IN ra_customer_trx.waybill_number%type,
4793: p_status_trx IN ra_customer_trx.status_trx%type,
4794: p_reason_code IN ra_customer_trx.reason_code%type,
4795: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
4796: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
4797: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,

Line 5427: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,

5423: | and warehouse_id
5424: +===========================================================================*/
5425:
5426:
5427: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5428: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
5429: p_trx_date IN ra_customer_trx.trx_date%type,
5430: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
5431: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

Line 5803: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,

5799: p_trx_date IN ra_customer_trx.trx_date%type,
5800: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
5801: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
5802: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
5803: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
5804: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
5805: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5806: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
5807: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,

Line 5804: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,

5800: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
5801: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
5802: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
5803: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
5804: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
5805: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5806: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
5807: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
5808: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,

Line 5805: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,

5801: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
5802: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
5803: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
5804: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
5805: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5806: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
5807: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
5808: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
5809: p_customer_reference IN ra_customer_trx.customer_reference%type,

Line 5806: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,

5802: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
5803: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
5804: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
5805: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5806: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
5807: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
5808: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
5809: p_customer_reference IN ra_customer_trx.customer_reference%type,
5810: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,

Line 5807: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,

5803: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
5804: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
5805: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5806: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
5807: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
5808: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
5809: p_customer_reference IN ra_customer_trx.customer_reference%type,
5810: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
5811: p_cr_method_for_installments IN

Line 5808: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,

5804: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
5805: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5806: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
5807: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
5808: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
5809: p_customer_reference IN ra_customer_trx.customer_reference%type,
5810: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
5811: p_cr_method_for_installments IN
5812: ra_customer_trx.credit_method_for_installments%type,

Line 5814: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,

5810: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
5811: p_cr_method_for_installments IN
5812: ra_customer_trx.credit_method_for_installments%type,
5813: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
5814: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
5815: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
5816: p_exchange_date IN ra_customer_trx.exchange_date%type,
5817: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
5818: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,

Line 5840: p_shipment_id IN ra_customer_trx.shipment_id%type,

5836: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
5837: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
5838: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
5839: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
5840: p_shipment_id IN ra_customer_trx.shipment_id%type,
5841: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5842: p_ship_via IN ra_customer_trx.ship_via%type,
5843: p_term_due_date IN ra_customer_trx.term_due_date%type,
5844: p_term_id IN ra_customer_trx.term_id%type,

Line 5841: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

5837: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
5838: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
5839: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
5840: p_shipment_id IN ra_customer_trx.shipment_id%type,
5841: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5842: p_ship_via IN ra_customer_trx.ship_via%type,
5843: p_term_due_date IN ra_customer_trx.term_due_date%type,
5844: p_term_id IN ra_customer_trx.term_id%type,
5845: p_territory_id IN ra_customer_trx.territory_id%type,

Line 5842: p_ship_via IN ra_customer_trx.ship_via%type,

5838: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
5839: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
5840: p_shipment_id IN ra_customer_trx.shipment_id%type,
5841: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5842: p_ship_via IN ra_customer_trx.ship_via%type,
5843: p_term_due_date IN ra_customer_trx.term_due_date%type,
5844: p_term_id IN ra_customer_trx.term_id%type,
5845: p_territory_id IN ra_customer_trx.territory_id%type,
5846: p_waybill_number IN ra_customer_trx.waybill_number%type,

Line 5847: p_status_trx IN ra_customer_trx.status_trx%type,

5843: p_term_due_date IN ra_customer_trx.term_due_date%type,
5844: p_term_id IN ra_customer_trx.term_id%type,
5845: p_territory_id IN ra_customer_trx.territory_id%type,
5846: p_waybill_number IN ra_customer_trx.waybill_number%type,
5847: p_status_trx IN ra_customer_trx.status_trx%type,
5848: p_reason_code IN ra_customer_trx.reason_code%type,
5849: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
5850: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
5851: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,