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 5059: SELECT RA_CUSTOMER_TRX_S.NEXTVAL

5055: /*---------------------------*
5056: | Get the unique identifier |
5057: *---------------------------*/
5058:
5059: SELECT RA_CUSTOMER_TRX_S.NEXTVAL
5060: INTO l_customer_trx_id
5061: FROM DUAL;
5062:
5063: /*----------------------------*

Line 5897: p_ship_via IN ra_customer_trx.ship_via%type,

5893: | |
5894: +===========================================================================*/
5895: PROCEDURE lock_compare_frt_cover(
5896: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5897: p_ship_via IN ra_customer_trx.ship_via%type,
5898: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5899: p_waybill_number IN ra_customer_trx.waybill_number%type,
5900: p_fob_point IN ra_customer_trx.fob_point%type)
5901: IS

Line 5898: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

5894: +===========================================================================*/
5895: PROCEDURE lock_compare_frt_cover(
5896: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5897: p_ship_via IN ra_customer_trx.ship_via%type,
5898: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5899: p_waybill_number IN ra_customer_trx.waybill_number%type,
5900: p_fob_point IN ra_customer_trx.fob_point%type)
5901: IS
5902: l_trx_rec ra_customer_trx%rowtype;

Line 6094: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,

6090: p_trx_date IN ra_customer_trx.trx_date%type,
6091: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
6092: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
6093: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
6094: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
6095: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
6096: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6097: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
6098: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,

Line 6095: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,

6091: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
6092: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
6093: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
6094: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
6095: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
6096: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6097: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
6098: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
6099: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,

Line 6096: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,

6092: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
6093: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
6094: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
6095: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
6096: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6097: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
6098: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
6099: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
6100: p_customer_reference IN ra_customer_trx.customer_reference%type,

Line 6097: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,

6093: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
6094: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
6095: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
6096: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6097: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
6098: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
6099: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
6100: p_customer_reference IN ra_customer_trx.customer_reference%type,
6101: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,

Line 6098: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,

6094: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
6095: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
6096: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6097: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
6098: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
6099: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
6100: p_customer_reference IN ra_customer_trx.customer_reference%type,
6101: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
6102: p_cr_method_for_installments IN

Line 6099: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,

6095: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
6096: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6097: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
6098: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
6099: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
6100: p_customer_reference IN ra_customer_trx.customer_reference%type,
6101: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
6102: p_cr_method_for_installments IN
6103: ra_customer_trx.credit_method_for_installments%type,

Line 6105: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,

6101: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
6102: p_cr_method_for_installments IN
6103: ra_customer_trx.credit_method_for_installments%type,
6104: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
6105: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
6106: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
6107: p_exchange_date IN ra_customer_trx.exchange_date%type,
6108: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
6109: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,

Line 6131: p_shipment_id IN ra_customer_trx.shipment_id%type,

6127: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
6128: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
6129: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
6130: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
6131: p_shipment_id IN ra_customer_trx.shipment_id%type,
6132: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
6133: p_ship_via IN ra_customer_trx.ship_via%type,
6134: p_term_due_date IN ra_customer_trx.term_due_date%type,
6135: p_term_id IN ra_customer_trx.term_id%type,

Line 6132: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

6128: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
6129: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
6130: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
6131: p_shipment_id IN ra_customer_trx.shipment_id%type,
6132: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
6133: p_ship_via IN ra_customer_trx.ship_via%type,
6134: p_term_due_date IN ra_customer_trx.term_due_date%type,
6135: p_term_id IN ra_customer_trx.term_id%type,
6136: p_territory_id IN ra_customer_trx.territory_id%type,

Line 6133: p_ship_via IN ra_customer_trx.ship_via%type,

6129: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
6130: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
6131: p_shipment_id IN ra_customer_trx.shipment_id%type,
6132: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
6133: p_ship_via IN ra_customer_trx.ship_via%type,
6134: p_term_due_date IN ra_customer_trx.term_due_date%type,
6135: p_term_id IN ra_customer_trx.term_id%type,
6136: p_territory_id IN ra_customer_trx.territory_id%type,
6137: p_waybill_number IN ra_customer_trx.waybill_number%type,

Line 6138: p_status_trx IN ra_customer_trx.status_trx%type,

6134: p_term_due_date IN ra_customer_trx.term_due_date%type,
6135: p_term_id IN ra_customer_trx.term_id%type,
6136: p_territory_id IN ra_customer_trx.territory_id%type,
6137: p_waybill_number IN ra_customer_trx.waybill_number%type,
6138: p_status_trx IN ra_customer_trx.status_trx%type,
6139: p_reason_code IN ra_customer_trx.reason_code%type,
6140: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
6141: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
6142: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,

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

6769: | and warehouse_id
6770: +===========================================================================*/
6771:
6772:
6773: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6774: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
6775: p_trx_date IN ra_customer_trx.trx_date%type,
6776: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
6777: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

Line 7149: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,

7145: p_trx_date IN ra_customer_trx.trx_date%type,
7146: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
7147: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
7148: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
7149: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
7150: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
7151: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
7152: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
7153: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,

Line 7150: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,

7146: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
7147: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
7148: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
7149: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
7150: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
7151: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
7152: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
7153: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
7154: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,

Line 7151: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,

7147: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
7148: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
7149: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
7150: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
7151: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
7152: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
7153: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
7154: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
7155: p_customer_reference IN ra_customer_trx.customer_reference%type,

Line 7152: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,

7148: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
7149: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
7150: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
7151: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
7152: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
7153: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
7154: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
7155: p_customer_reference IN ra_customer_trx.customer_reference%type,
7156: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,

Line 7153: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,

7149: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
7150: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
7151: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
7152: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
7153: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
7154: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
7155: p_customer_reference IN ra_customer_trx.customer_reference%type,
7156: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
7157: p_cr_method_for_installments IN

Line 7154: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,

7150: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
7151: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
7152: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
7153: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
7154: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
7155: p_customer_reference IN ra_customer_trx.customer_reference%type,
7156: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
7157: p_cr_method_for_installments IN
7158: ra_customer_trx.credit_method_for_installments%type,

Line 7160: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,

7156: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
7157: p_cr_method_for_installments IN
7158: ra_customer_trx.credit_method_for_installments%type,
7159: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
7160: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
7161: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
7162: p_exchange_date IN ra_customer_trx.exchange_date%type,
7163: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
7164: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,

Line 7186: p_shipment_id IN ra_customer_trx.shipment_id%type,

7182: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
7183: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
7184: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
7185: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
7186: p_shipment_id IN ra_customer_trx.shipment_id%type,
7187: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
7188: p_ship_via IN ra_customer_trx.ship_via%type,
7189: p_term_due_date IN ra_customer_trx.term_due_date%type,
7190: p_term_id IN ra_customer_trx.term_id%type,

Line 7187: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

7183: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
7184: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
7185: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
7186: p_shipment_id IN ra_customer_trx.shipment_id%type,
7187: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
7188: p_ship_via IN ra_customer_trx.ship_via%type,
7189: p_term_due_date IN ra_customer_trx.term_due_date%type,
7190: p_term_id IN ra_customer_trx.term_id%type,
7191: p_territory_id IN ra_customer_trx.territory_id%type,

Line 7188: p_ship_via IN ra_customer_trx.ship_via%type,

7184: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
7185: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
7186: p_shipment_id IN ra_customer_trx.shipment_id%type,
7187: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
7188: p_ship_via IN ra_customer_trx.ship_via%type,
7189: p_term_due_date IN ra_customer_trx.term_due_date%type,
7190: p_term_id IN ra_customer_trx.term_id%type,
7191: p_territory_id IN ra_customer_trx.territory_id%type,
7192: p_waybill_number IN ra_customer_trx.waybill_number%type,

Line 7193: p_status_trx IN ra_customer_trx.status_trx%type,

7189: p_term_due_date IN ra_customer_trx.term_due_date%type,
7190: p_term_id IN ra_customer_trx.term_id%type,
7191: p_territory_id IN ra_customer_trx.territory_id%type,
7192: p_waybill_number IN ra_customer_trx.waybill_number%type,
7193: p_status_trx IN ra_customer_trx.status_trx%type,
7194: p_reason_code IN ra_customer_trx.reason_code%type,
7195: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
7196: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
7197: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,