1: PACKAGE WSH_SHIPMENT_REQUEST_PKG AUTHID CURRENT_USER AS
2: /* $Header: WSHSRPKS.pls 120.0.12010000.5 2009/12/03 12:08:35 mvudugul noship $ */
3:
4: TYPE Del_Interface_Rec_Type IS RECORD (
5: delivery_interface_id WSH_NEW_DEL_INTERFACE.delivery_interface_id%TYPE,
6: organization_code WSH_NEW_DEL_INTERFACE.organization_code%TYPE,
7: organization_id WSH_NEW_DEL_INTERFACE.organization_id%TYPE,
8: customer_id WSH_NEW_DEL_INTERFACE.customer_id%TYPE,
9: customer_name WSH_NEW_DEL_INTERFACE.customer_name%TYPE,
2: /* $Header: WSHSRPKS.pls 120.0.12010000.5 2009/12/03 12:08:35 mvudugul noship $ */
3:
4: TYPE Del_Interface_Rec_Type IS RECORD (
5: delivery_interface_id WSH_NEW_DEL_INTERFACE.delivery_interface_id%TYPE,
6: organization_code WSH_NEW_DEL_INTERFACE.organization_code%TYPE,
7: organization_id WSH_NEW_DEL_INTERFACE.organization_id%TYPE,
8: customer_id WSH_NEW_DEL_INTERFACE.customer_id%TYPE,
9: customer_name WSH_NEW_DEL_INTERFACE.customer_name%TYPE,
10: ship_to_customer_id WSH_NEW_DEL_INTERFACE.ship_to_customer_id%TYPE,
3:
4: TYPE Del_Interface_Rec_Type IS RECORD (
5: delivery_interface_id WSH_NEW_DEL_INTERFACE.delivery_interface_id%TYPE,
6: organization_code WSH_NEW_DEL_INTERFACE.organization_code%TYPE,
7: organization_id WSH_NEW_DEL_INTERFACE.organization_id%TYPE,
8: customer_id WSH_NEW_DEL_INTERFACE.customer_id%TYPE,
9: customer_name WSH_NEW_DEL_INTERFACE.customer_name%TYPE,
10: ship_to_customer_id WSH_NEW_DEL_INTERFACE.ship_to_customer_id%TYPE,
11: ship_to_customer_name WSH_NEW_DEL_INTERFACE.ship_to_customer_name%TYPE,
4: TYPE Del_Interface_Rec_Type IS RECORD (
5: delivery_interface_id WSH_NEW_DEL_INTERFACE.delivery_interface_id%TYPE,
6: organization_code WSH_NEW_DEL_INTERFACE.organization_code%TYPE,
7: organization_id WSH_NEW_DEL_INTERFACE.organization_id%TYPE,
8: customer_id WSH_NEW_DEL_INTERFACE.customer_id%TYPE,
9: customer_name WSH_NEW_DEL_INTERFACE.customer_name%TYPE,
10: ship_to_customer_id WSH_NEW_DEL_INTERFACE.ship_to_customer_id%TYPE,
11: ship_to_customer_name WSH_NEW_DEL_INTERFACE.ship_to_customer_name%TYPE,
12: ship_to_address_id WSH_NEW_DEL_INTERFACE.ship_to_address_id%TYPE,
5: delivery_interface_id WSH_NEW_DEL_INTERFACE.delivery_interface_id%TYPE,
6: organization_code WSH_NEW_DEL_INTERFACE.organization_code%TYPE,
7: organization_id WSH_NEW_DEL_INTERFACE.organization_id%TYPE,
8: customer_id WSH_NEW_DEL_INTERFACE.customer_id%TYPE,
9: customer_name WSH_NEW_DEL_INTERFACE.customer_name%TYPE,
10: ship_to_customer_id WSH_NEW_DEL_INTERFACE.ship_to_customer_id%TYPE,
11: ship_to_customer_name WSH_NEW_DEL_INTERFACE.ship_to_customer_name%TYPE,
12: ship_to_address_id WSH_NEW_DEL_INTERFACE.ship_to_address_id%TYPE,
13: ship_to_address1 WSH_NEW_DEL_INTERFACE.ship_to_address1%TYPE,
6: organization_code WSH_NEW_DEL_INTERFACE.organization_code%TYPE,
7: organization_id WSH_NEW_DEL_INTERFACE.organization_id%TYPE,
8: customer_id WSH_NEW_DEL_INTERFACE.customer_id%TYPE,
9: customer_name WSH_NEW_DEL_INTERFACE.customer_name%TYPE,
10: ship_to_customer_id WSH_NEW_DEL_INTERFACE.ship_to_customer_id%TYPE,
11: ship_to_customer_name WSH_NEW_DEL_INTERFACE.ship_to_customer_name%TYPE,
12: ship_to_address_id WSH_NEW_DEL_INTERFACE.ship_to_address_id%TYPE,
13: ship_to_address1 WSH_NEW_DEL_INTERFACE.ship_to_address1%TYPE,
14: ship_to_address2 WSH_NEW_DEL_INTERFACE.ship_to_address2%TYPE,
7: organization_id WSH_NEW_DEL_INTERFACE.organization_id%TYPE,
8: customer_id WSH_NEW_DEL_INTERFACE.customer_id%TYPE,
9: customer_name WSH_NEW_DEL_INTERFACE.customer_name%TYPE,
10: ship_to_customer_id WSH_NEW_DEL_INTERFACE.ship_to_customer_id%TYPE,
11: ship_to_customer_name WSH_NEW_DEL_INTERFACE.ship_to_customer_name%TYPE,
12: ship_to_address_id WSH_NEW_DEL_INTERFACE.ship_to_address_id%TYPE,
13: ship_to_address1 WSH_NEW_DEL_INTERFACE.ship_to_address1%TYPE,
14: ship_to_address2 WSH_NEW_DEL_INTERFACE.ship_to_address2%TYPE,
15: ship_to_address3 WSH_NEW_DEL_INTERFACE.ship_to_address3%TYPE,
8: customer_id WSH_NEW_DEL_INTERFACE.customer_id%TYPE,
9: customer_name WSH_NEW_DEL_INTERFACE.customer_name%TYPE,
10: ship_to_customer_id WSH_NEW_DEL_INTERFACE.ship_to_customer_id%TYPE,
11: ship_to_customer_name WSH_NEW_DEL_INTERFACE.ship_to_customer_name%TYPE,
12: ship_to_address_id WSH_NEW_DEL_INTERFACE.ship_to_address_id%TYPE,
13: ship_to_address1 WSH_NEW_DEL_INTERFACE.ship_to_address1%TYPE,
14: ship_to_address2 WSH_NEW_DEL_INTERFACE.ship_to_address2%TYPE,
15: ship_to_address3 WSH_NEW_DEL_INTERFACE.ship_to_address3%TYPE,
16: ship_to_address4 WSH_NEW_DEL_INTERFACE.ship_to_address4%TYPE,
9: customer_name WSH_NEW_DEL_INTERFACE.customer_name%TYPE,
10: ship_to_customer_id WSH_NEW_DEL_INTERFACE.ship_to_customer_id%TYPE,
11: ship_to_customer_name WSH_NEW_DEL_INTERFACE.ship_to_customer_name%TYPE,
12: ship_to_address_id WSH_NEW_DEL_INTERFACE.ship_to_address_id%TYPE,
13: ship_to_address1 WSH_NEW_DEL_INTERFACE.ship_to_address1%TYPE,
14: ship_to_address2 WSH_NEW_DEL_INTERFACE.ship_to_address2%TYPE,
15: ship_to_address3 WSH_NEW_DEL_INTERFACE.ship_to_address3%TYPE,
16: ship_to_address4 WSH_NEW_DEL_INTERFACE.ship_to_address4%TYPE,
17: ship_to_city WSH_NEW_DEL_INTERFACE.ship_to_city%TYPE,
10: ship_to_customer_id WSH_NEW_DEL_INTERFACE.ship_to_customer_id%TYPE,
11: ship_to_customer_name WSH_NEW_DEL_INTERFACE.ship_to_customer_name%TYPE,
12: ship_to_address_id WSH_NEW_DEL_INTERFACE.ship_to_address_id%TYPE,
13: ship_to_address1 WSH_NEW_DEL_INTERFACE.ship_to_address1%TYPE,
14: ship_to_address2 WSH_NEW_DEL_INTERFACE.ship_to_address2%TYPE,
15: ship_to_address3 WSH_NEW_DEL_INTERFACE.ship_to_address3%TYPE,
16: ship_to_address4 WSH_NEW_DEL_INTERFACE.ship_to_address4%TYPE,
17: ship_to_city WSH_NEW_DEL_INTERFACE.ship_to_city%TYPE,
18: ship_to_state WSH_NEW_DEL_INTERFACE.ship_to_state%TYPE,
11: ship_to_customer_name WSH_NEW_DEL_INTERFACE.ship_to_customer_name%TYPE,
12: ship_to_address_id WSH_NEW_DEL_INTERFACE.ship_to_address_id%TYPE,
13: ship_to_address1 WSH_NEW_DEL_INTERFACE.ship_to_address1%TYPE,
14: ship_to_address2 WSH_NEW_DEL_INTERFACE.ship_to_address2%TYPE,
15: ship_to_address3 WSH_NEW_DEL_INTERFACE.ship_to_address3%TYPE,
16: ship_to_address4 WSH_NEW_DEL_INTERFACE.ship_to_address4%TYPE,
17: ship_to_city WSH_NEW_DEL_INTERFACE.ship_to_city%TYPE,
18: ship_to_state WSH_NEW_DEL_INTERFACE.ship_to_state%TYPE,
19: ship_to_country WSH_NEW_DEL_INTERFACE.ship_to_country%TYPE,
12: ship_to_address_id WSH_NEW_DEL_INTERFACE.ship_to_address_id%TYPE,
13: ship_to_address1 WSH_NEW_DEL_INTERFACE.ship_to_address1%TYPE,
14: ship_to_address2 WSH_NEW_DEL_INTERFACE.ship_to_address2%TYPE,
15: ship_to_address3 WSH_NEW_DEL_INTERFACE.ship_to_address3%TYPE,
16: ship_to_address4 WSH_NEW_DEL_INTERFACE.ship_to_address4%TYPE,
17: ship_to_city WSH_NEW_DEL_INTERFACE.ship_to_city%TYPE,
18: ship_to_state WSH_NEW_DEL_INTERFACE.ship_to_state%TYPE,
19: ship_to_country WSH_NEW_DEL_INTERFACE.ship_to_country%TYPE,
20: ship_to_postal_code WSH_NEW_DEL_INTERFACE.ship_to_postal_code%TYPE,
13: ship_to_address1 WSH_NEW_DEL_INTERFACE.ship_to_address1%TYPE,
14: ship_to_address2 WSH_NEW_DEL_INTERFACE.ship_to_address2%TYPE,
15: ship_to_address3 WSH_NEW_DEL_INTERFACE.ship_to_address3%TYPE,
16: ship_to_address4 WSH_NEW_DEL_INTERFACE.ship_to_address4%TYPE,
17: ship_to_city WSH_NEW_DEL_INTERFACE.ship_to_city%TYPE,
18: ship_to_state WSH_NEW_DEL_INTERFACE.ship_to_state%TYPE,
19: ship_to_country WSH_NEW_DEL_INTERFACE.ship_to_country%TYPE,
20: ship_to_postal_code WSH_NEW_DEL_INTERFACE.ship_to_postal_code%TYPE,
21: ship_to_contact_id WSH_NEW_DEL_INTERFACE.ship_to_contact_id%TYPE,
14: ship_to_address2 WSH_NEW_DEL_INTERFACE.ship_to_address2%TYPE,
15: ship_to_address3 WSH_NEW_DEL_INTERFACE.ship_to_address3%TYPE,
16: ship_to_address4 WSH_NEW_DEL_INTERFACE.ship_to_address4%TYPE,
17: ship_to_city WSH_NEW_DEL_INTERFACE.ship_to_city%TYPE,
18: ship_to_state WSH_NEW_DEL_INTERFACE.ship_to_state%TYPE,
19: ship_to_country WSH_NEW_DEL_INTERFACE.ship_to_country%TYPE,
20: ship_to_postal_code WSH_NEW_DEL_INTERFACE.ship_to_postal_code%TYPE,
21: ship_to_contact_id WSH_NEW_DEL_INTERFACE.ship_to_contact_id%TYPE,
22: ship_to_contact_name WSH_NEW_DEL_INTERFACE.ship_to_contact_name%TYPE,
15: ship_to_address3 WSH_NEW_DEL_INTERFACE.ship_to_address3%TYPE,
16: ship_to_address4 WSH_NEW_DEL_INTERFACE.ship_to_address4%TYPE,
17: ship_to_city WSH_NEW_DEL_INTERFACE.ship_to_city%TYPE,
18: ship_to_state WSH_NEW_DEL_INTERFACE.ship_to_state%TYPE,
19: ship_to_country WSH_NEW_DEL_INTERFACE.ship_to_country%TYPE,
20: ship_to_postal_code WSH_NEW_DEL_INTERFACE.ship_to_postal_code%TYPE,
21: ship_to_contact_id WSH_NEW_DEL_INTERFACE.ship_to_contact_id%TYPE,
22: ship_to_contact_name WSH_NEW_DEL_INTERFACE.ship_to_contact_name%TYPE,
23: ship_to_contact_phone WSH_NEW_DEL_INTERFACE.ship_to_contact_phone%TYPE,
16: ship_to_address4 WSH_NEW_DEL_INTERFACE.ship_to_address4%TYPE,
17: ship_to_city WSH_NEW_DEL_INTERFACE.ship_to_city%TYPE,
18: ship_to_state WSH_NEW_DEL_INTERFACE.ship_to_state%TYPE,
19: ship_to_country WSH_NEW_DEL_INTERFACE.ship_to_country%TYPE,
20: ship_to_postal_code WSH_NEW_DEL_INTERFACE.ship_to_postal_code%TYPE,
21: ship_to_contact_id WSH_NEW_DEL_INTERFACE.ship_to_contact_id%TYPE,
22: ship_to_contact_name WSH_NEW_DEL_INTERFACE.ship_to_contact_name%TYPE,
23: ship_to_contact_phone WSH_NEW_DEL_INTERFACE.ship_to_contact_phone%TYPE,
24: invoice_to_customer_id WSH_NEW_DEL_INTERFACE.invoice_to_customer_id%TYPE,
17: ship_to_city WSH_NEW_DEL_INTERFACE.ship_to_city%TYPE,
18: ship_to_state WSH_NEW_DEL_INTERFACE.ship_to_state%TYPE,
19: ship_to_country WSH_NEW_DEL_INTERFACE.ship_to_country%TYPE,
20: ship_to_postal_code WSH_NEW_DEL_INTERFACE.ship_to_postal_code%TYPE,
21: ship_to_contact_id WSH_NEW_DEL_INTERFACE.ship_to_contact_id%TYPE,
22: ship_to_contact_name WSH_NEW_DEL_INTERFACE.ship_to_contact_name%TYPE,
23: ship_to_contact_phone WSH_NEW_DEL_INTERFACE.ship_to_contact_phone%TYPE,
24: invoice_to_customer_id WSH_NEW_DEL_INTERFACE.invoice_to_customer_id%TYPE,
25: invoice_to_customer_name WSH_NEW_DEL_INTERFACE.invoice_to_customer_name%TYPE,
18: ship_to_state WSH_NEW_DEL_INTERFACE.ship_to_state%TYPE,
19: ship_to_country WSH_NEW_DEL_INTERFACE.ship_to_country%TYPE,
20: ship_to_postal_code WSH_NEW_DEL_INTERFACE.ship_to_postal_code%TYPE,
21: ship_to_contact_id WSH_NEW_DEL_INTERFACE.ship_to_contact_id%TYPE,
22: ship_to_contact_name WSH_NEW_DEL_INTERFACE.ship_to_contact_name%TYPE,
23: ship_to_contact_phone WSH_NEW_DEL_INTERFACE.ship_to_contact_phone%TYPE,
24: invoice_to_customer_id WSH_NEW_DEL_INTERFACE.invoice_to_customer_id%TYPE,
25: invoice_to_customer_name WSH_NEW_DEL_INTERFACE.invoice_to_customer_name%TYPE,
26: invoice_to_address_id WSH_NEW_DEL_INTERFACE.invoice_to_address_id%TYPE,
19: ship_to_country WSH_NEW_DEL_INTERFACE.ship_to_country%TYPE,
20: ship_to_postal_code WSH_NEW_DEL_INTERFACE.ship_to_postal_code%TYPE,
21: ship_to_contact_id WSH_NEW_DEL_INTERFACE.ship_to_contact_id%TYPE,
22: ship_to_contact_name WSH_NEW_DEL_INTERFACE.ship_to_contact_name%TYPE,
23: ship_to_contact_phone WSH_NEW_DEL_INTERFACE.ship_to_contact_phone%TYPE,
24: invoice_to_customer_id WSH_NEW_DEL_INTERFACE.invoice_to_customer_id%TYPE,
25: invoice_to_customer_name WSH_NEW_DEL_INTERFACE.invoice_to_customer_name%TYPE,
26: invoice_to_address_id WSH_NEW_DEL_INTERFACE.invoice_to_address_id%TYPE,
27: invoice_to_address1 WSH_NEW_DEL_INTERFACE.invoice_to_address1%TYPE,
20: ship_to_postal_code WSH_NEW_DEL_INTERFACE.ship_to_postal_code%TYPE,
21: ship_to_contact_id WSH_NEW_DEL_INTERFACE.ship_to_contact_id%TYPE,
22: ship_to_contact_name WSH_NEW_DEL_INTERFACE.ship_to_contact_name%TYPE,
23: ship_to_contact_phone WSH_NEW_DEL_INTERFACE.ship_to_contact_phone%TYPE,
24: invoice_to_customer_id WSH_NEW_DEL_INTERFACE.invoice_to_customer_id%TYPE,
25: invoice_to_customer_name WSH_NEW_DEL_INTERFACE.invoice_to_customer_name%TYPE,
26: invoice_to_address_id WSH_NEW_DEL_INTERFACE.invoice_to_address_id%TYPE,
27: invoice_to_address1 WSH_NEW_DEL_INTERFACE.invoice_to_address1%TYPE,
28: invoice_to_address2 WSH_NEW_DEL_INTERFACE.invoice_to_address2%TYPE,
21: ship_to_contact_id WSH_NEW_DEL_INTERFACE.ship_to_contact_id%TYPE,
22: ship_to_contact_name WSH_NEW_DEL_INTERFACE.ship_to_contact_name%TYPE,
23: ship_to_contact_phone WSH_NEW_DEL_INTERFACE.ship_to_contact_phone%TYPE,
24: invoice_to_customer_id WSH_NEW_DEL_INTERFACE.invoice_to_customer_id%TYPE,
25: invoice_to_customer_name WSH_NEW_DEL_INTERFACE.invoice_to_customer_name%TYPE,
26: invoice_to_address_id WSH_NEW_DEL_INTERFACE.invoice_to_address_id%TYPE,
27: invoice_to_address1 WSH_NEW_DEL_INTERFACE.invoice_to_address1%TYPE,
28: invoice_to_address2 WSH_NEW_DEL_INTERFACE.invoice_to_address2%TYPE,
29: invoice_to_address3 WSH_NEW_DEL_INTERFACE.invoice_to_address3%TYPE,
22: ship_to_contact_name WSH_NEW_DEL_INTERFACE.ship_to_contact_name%TYPE,
23: ship_to_contact_phone WSH_NEW_DEL_INTERFACE.ship_to_contact_phone%TYPE,
24: invoice_to_customer_id WSH_NEW_DEL_INTERFACE.invoice_to_customer_id%TYPE,
25: invoice_to_customer_name WSH_NEW_DEL_INTERFACE.invoice_to_customer_name%TYPE,
26: invoice_to_address_id WSH_NEW_DEL_INTERFACE.invoice_to_address_id%TYPE,
27: invoice_to_address1 WSH_NEW_DEL_INTERFACE.invoice_to_address1%TYPE,
28: invoice_to_address2 WSH_NEW_DEL_INTERFACE.invoice_to_address2%TYPE,
29: invoice_to_address3 WSH_NEW_DEL_INTERFACE.invoice_to_address3%TYPE,
30: invoice_to_address4 WSH_NEW_DEL_INTERFACE.invoice_to_address4%TYPE,
23: ship_to_contact_phone WSH_NEW_DEL_INTERFACE.ship_to_contact_phone%TYPE,
24: invoice_to_customer_id WSH_NEW_DEL_INTERFACE.invoice_to_customer_id%TYPE,
25: invoice_to_customer_name WSH_NEW_DEL_INTERFACE.invoice_to_customer_name%TYPE,
26: invoice_to_address_id WSH_NEW_DEL_INTERFACE.invoice_to_address_id%TYPE,
27: invoice_to_address1 WSH_NEW_DEL_INTERFACE.invoice_to_address1%TYPE,
28: invoice_to_address2 WSH_NEW_DEL_INTERFACE.invoice_to_address2%TYPE,
29: invoice_to_address3 WSH_NEW_DEL_INTERFACE.invoice_to_address3%TYPE,
30: invoice_to_address4 WSH_NEW_DEL_INTERFACE.invoice_to_address4%TYPE,
31: invoice_to_city WSH_NEW_DEL_INTERFACE.invoice_to_city%TYPE,
24: invoice_to_customer_id WSH_NEW_DEL_INTERFACE.invoice_to_customer_id%TYPE,
25: invoice_to_customer_name WSH_NEW_DEL_INTERFACE.invoice_to_customer_name%TYPE,
26: invoice_to_address_id WSH_NEW_DEL_INTERFACE.invoice_to_address_id%TYPE,
27: invoice_to_address1 WSH_NEW_DEL_INTERFACE.invoice_to_address1%TYPE,
28: invoice_to_address2 WSH_NEW_DEL_INTERFACE.invoice_to_address2%TYPE,
29: invoice_to_address3 WSH_NEW_DEL_INTERFACE.invoice_to_address3%TYPE,
30: invoice_to_address4 WSH_NEW_DEL_INTERFACE.invoice_to_address4%TYPE,
31: invoice_to_city WSH_NEW_DEL_INTERFACE.invoice_to_city%TYPE,
32: invoice_to_state WSH_NEW_DEL_INTERFACE.invoice_to_state%TYPE,
25: invoice_to_customer_name WSH_NEW_DEL_INTERFACE.invoice_to_customer_name%TYPE,
26: invoice_to_address_id WSH_NEW_DEL_INTERFACE.invoice_to_address_id%TYPE,
27: invoice_to_address1 WSH_NEW_DEL_INTERFACE.invoice_to_address1%TYPE,
28: invoice_to_address2 WSH_NEW_DEL_INTERFACE.invoice_to_address2%TYPE,
29: invoice_to_address3 WSH_NEW_DEL_INTERFACE.invoice_to_address3%TYPE,
30: invoice_to_address4 WSH_NEW_DEL_INTERFACE.invoice_to_address4%TYPE,
31: invoice_to_city WSH_NEW_DEL_INTERFACE.invoice_to_city%TYPE,
32: invoice_to_state WSH_NEW_DEL_INTERFACE.invoice_to_state%TYPE,
33: invoice_to_country WSH_NEW_DEL_INTERFACE.invoice_to_country%TYPE,
26: invoice_to_address_id WSH_NEW_DEL_INTERFACE.invoice_to_address_id%TYPE,
27: invoice_to_address1 WSH_NEW_DEL_INTERFACE.invoice_to_address1%TYPE,
28: invoice_to_address2 WSH_NEW_DEL_INTERFACE.invoice_to_address2%TYPE,
29: invoice_to_address3 WSH_NEW_DEL_INTERFACE.invoice_to_address3%TYPE,
30: invoice_to_address4 WSH_NEW_DEL_INTERFACE.invoice_to_address4%TYPE,
31: invoice_to_city WSH_NEW_DEL_INTERFACE.invoice_to_city%TYPE,
32: invoice_to_state WSH_NEW_DEL_INTERFACE.invoice_to_state%TYPE,
33: invoice_to_country WSH_NEW_DEL_INTERFACE.invoice_to_country%TYPE,
34: invoice_to_postal_code WSH_NEW_DEL_INTERFACE.invoice_to_postal_code%TYPE,
27: invoice_to_address1 WSH_NEW_DEL_INTERFACE.invoice_to_address1%TYPE,
28: invoice_to_address2 WSH_NEW_DEL_INTERFACE.invoice_to_address2%TYPE,
29: invoice_to_address3 WSH_NEW_DEL_INTERFACE.invoice_to_address3%TYPE,
30: invoice_to_address4 WSH_NEW_DEL_INTERFACE.invoice_to_address4%TYPE,
31: invoice_to_city WSH_NEW_DEL_INTERFACE.invoice_to_city%TYPE,
32: invoice_to_state WSH_NEW_DEL_INTERFACE.invoice_to_state%TYPE,
33: invoice_to_country WSH_NEW_DEL_INTERFACE.invoice_to_country%TYPE,
34: invoice_to_postal_code WSH_NEW_DEL_INTERFACE.invoice_to_postal_code%TYPE,
35: invoice_to_contact_id WSH_NEW_DEL_INTERFACE.invoice_to_contact_id%TYPE,
28: invoice_to_address2 WSH_NEW_DEL_INTERFACE.invoice_to_address2%TYPE,
29: invoice_to_address3 WSH_NEW_DEL_INTERFACE.invoice_to_address3%TYPE,
30: invoice_to_address4 WSH_NEW_DEL_INTERFACE.invoice_to_address4%TYPE,
31: invoice_to_city WSH_NEW_DEL_INTERFACE.invoice_to_city%TYPE,
32: invoice_to_state WSH_NEW_DEL_INTERFACE.invoice_to_state%TYPE,
33: invoice_to_country WSH_NEW_DEL_INTERFACE.invoice_to_country%TYPE,
34: invoice_to_postal_code WSH_NEW_DEL_INTERFACE.invoice_to_postal_code%TYPE,
35: invoice_to_contact_id WSH_NEW_DEL_INTERFACE.invoice_to_contact_id%TYPE,
36: invoice_to_contact_name WSH_NEW_DEL_INTERFACE.invoice_to_contact_name%TYPE,
29: invoice_to_address3 WSH_NEW_DEL_INTERFACE.invoice_to_address3%TYPE,
30: invoice_to_address4 WSH_NEW_DEL_INTERFACE.invoice_to_address4%TYPE,
31: invoice_to_city WSH_NEW_DEL_INTERFACE.invoice_to_city%TYPE,
32: invoice_to_state WSH_NEW_DEL_INTERFACE.invoice_to_state%TYPE,
33: invoice_to_country WSH_NEW_DEL_INTERFACE.invoice_to_country%TYPE,
34: invoice_to_postal_code WSH_NEW_DEL_INTERFACE.invoice_to_postal_code%TYPE,
35: invoice_to_contact_id WSH_NEW_DEL_INTERFACE.invoice_to_contact_id%TYPE,
36: invoice_to_contact_name WSH_NEW_DEL_INTERFACE.invoice_to_contact_name%TYPE,
37: invoice_to_contact_phone WSH_NEW_DEL_INTERFACE.invoice_to_contact_phone%TYPE,
30: invoice_to_address4 WSH_NEW_DEL_INTERFACE.invoice_to_address4%TYPE,
31: invoice_to_city WSH_NEW_DEL_INTERFACE.invoice_to_city%TYPE,
32: invoice_to_state WSH_NEW_DEL_INTERFACE.invoice_to_state%TYPE,
33: invoice_to_country WSH_NEW_DEL_INTERFACE.invoice_to_country%TYPE,
34: invoice_to_postal_code WSH_NEW_DEL_INTERFACE.invoice_to_postal_code%TYPE,
35: invoice_to_contact_id WSH_NEW_DEL_INTERFACE.invoice_to_contact_id%TYPE,
36: invoice_to_contact_name WSH_NEW_DEL_INTERFACE.invoice_to_contact_name%TYPE,
37: invoice_to_contact_phone WSH_NEW_DEL_INTERFACE.invoice_to_contact_phone%TYPE,
38: deliver_to_customer_id WSH_NEW_DEL_INTERFACE.deliver_to_customer_id%TYPE,
31: invoice_to_city WSH_NEW_DEL_INTERFACE.invoice_to_city%TYPE,
32: invoice_to_state WSH_NEW_DEL_INTERFACE.invoice_to_state%TYPE,
33: invoice_to_country WSH_NEW_DEL_INTERFACE.invoice_to_country%TYPE,
34: invoice_to_postal_code WSH_NEW_DEL_INTERFACE.invoice_to_postal_code%TYPE,
35: invoice_to_contact_id WSH_NEW_DEL_INTERFACE.invoice_to_contact_id%TYPE,
36: invoice_to_contact_name WSH_NEW_DEL_INTERFACE.invoice_to_contact_name%TYPE,
37: invoice_to_contact_phone WSH_NEW_DEL_INTERFACE.invoice_to_contact_phone%TYPE,
38: deliver_to_customer_id WSH_NEW_DEL_INTERFACE.deliver_to_customer_id%TYPE,
39: deliver_to_customer_name WSH_NEW_DEL_INTERFACE.deliver_to_customer_name%TYPE,
32: invoice_to_state WSH_NEW_DEL_INTERFACE.invoice_to_state%TYPE,
33: invoice_to_country WSH_NEW_DEL_INTERFACE.invoice_to_country%TYPE,
34: invoice_to_postal_code WSH_NEW_DEL_INTERFACE.invoice_to_postal_code%TYPE,
35: invoice_to_contact_id WSH_NEW_DEL_INTERFACE.invoice_to_contact_id%TYPE,
36: invoice_to_contact_name WSH_NEW_DEL_INTERFACE.invoice_to_contact_name%TYPE,
37: invoice_to_contact_phone WSH_NEW_DEL_INTERFACE.invoice_to_contact_phone%TYPE,
38: deliver_to_customer_id WSH_NEW_DEL_INTERFACE.deliver_to_customer_id%TYPE,
39: deliver_to_customer_name WSH_NEW_DEL_INTERFACE.deliver_to_customer_name%TYPE,
40: deliver_to_address_id WSH_NEW_DEL_INTERFACE.deliver_to_address_id%TYPE,
33: invoice_to_country WSH_NEW_DEL_INTERFACE.invoice_to_country%TYPE,
34: invoice_to_postal_code WSH_NEW_DEL_INTERFACE.invoice_to_postal_code%TYPE,
35: invoice_to_contact_id WSH_NEW_DEL_INTERFACE.invoice_to_contact_id%TYPE,
36: invoice_to_contact_name WSH_NEW_DEL_INTERFACE.invoice_to_contact_name%TYPE,
37: invoice_to_contact_phone WSH_NEW_DEL_INTERFACE.invoice_to_contact_phone%TYPE,
38: deliver_to_customer_id WSH_NEW_DEL_INTERFACE.deliver_to_customer_id%TYPE,
39: deliver_to_customer_name WSH_NEW_DEL_INTERFACE.deliver_to_customer_name%TYPE,
40: deliver_to_address_id WSH_NEW_DEL_INTERFACE.deliver_to_address_id%TYPE,
41: deliver_to_address1 WSH_NEW_DEL_INTERFACE.deliver_to_address1%TYPE,
34: invoice_to_postal_code WSH_NEW_DEL_INTERFACE.invoice_to_postal_code%TYPE,
35: invoice_to_contact_id WSH_NEW_DEL_INTERFACE.invoice_to_contact_id%TYPE,
36: invoice_to_contact_name WSH_NEW_DEL_INTERFACE.invoice_to_contact_name%TYPE,
37: invoice_to_contact_phone WSH_NEW_DEL_INTERFACE.invoice_to_contact_phone%TYPE,
38: deliver_to_customer_id WSH_NEW_DEL_INTERFACE.deliver_to_customer_id%TYPE,
39: deliver_to_customer_name WSH_NEW_DEL_INTERFACE.deliver_to_customer_name%TYPE,
40: deliver_to_address_id WSH_NEW_DEL_INTERFACE.deliver_to_address_id%TYPE,
41: deliver_to_address1 WSH_NEW_DEL_INTERFACE.deliver_to_address1%TYPE,
42: deliver_to_address2 WSH_NEW_DEL_INTERFACE.deliver_to_address2%TYPE,
35: invoice_to_contact_id WSH_NEW_DEL_INTERFACE.invoice_to_contact_id%TYPE,
36: invoice_to_contact_name WSH_NEW_DEL_INTERFACE.invoice_to_contact_name%TYPE,
37: invoice_to_contact_phone WSH_NEW_DEL_INTERFACE.invoice_to_contact_phone%TYPE,
38: deliver_to_customer_id WSH_NEW_DEL_INTERFACE.deliver_to_customer_id%TYPE,
39: deliver_to_customer_name WSH_NEW_DEL_INTERFACE.deliver_to_customer_name%TYPE,
40: deliver_to_address_id WSH_NEW_DEL_INTERFACE.deliver_to_address_id%TYPE,
41: deliver_to_address1 WSH_NEW_DEL_INTERFACE.deliver_to_address1%TYPE,
42: deliver_to_address2 WSH_NEW_DEL_INTERFACE.deliver_to_address2%TYPE,
43: deliver_to_address3 WSH_NEW_DEL_INTERFACE.deliver_to_address3%TYPE,
36: invoice_to_contact_name WSH_NEW_DEL_INTERFACE.invoice_to_contact_name%TYPE,
37: invoice_to_contact_phone WSH_NEW_DEL_INTERFACE.invoice_to_contact_phone%TYPE,
38: deliver_to_customer_id WSH_NEW_DEL_INTERFACE.deliver_to_customer_id%TYPE,
39: deliver_to_customer_name WSH_NEW_DEL_INTERFACE.deliver_to_customer_name%TYPE,
40: deliver_to_address_id WSH_NEW_DEL_INTERFACE.deliver_to_address_id%TYPE,
41: deliver_to_address1 WSH_NEW_DEL_INTERFACE.deliver_to_address1%TYPE,
42: deliver_to_address2 WSH_NEW_DEL_INTERFACE.deliver_to_address2%TYPE,
43: deliver_to_address3 WSH_NEW_DEL_INTERFACE.deliver_to_address3%TYPE,
44: deliver_to_address4 WSH_NEW_DEL_INTERFACE.deliver_to_address4%TYPE,
37: invoice_to_contact_phone WSH_NEW_DEL_INTERFACE.invoice_to_contact_phone%TYPE,
38: deliver_to_customer_id WSH_NEW_DEL_INTERFACE.deliver_to_customer_id%TYPE,
39: deliver_to_customer_name WSH_NEW_DEL_INTERFACE.deliver_to_customer_name%TYPE,
40: deliver_to_address_id WSH_NEW_DEL_INTERFACE.deliver_to_address_id%TYPE,
41: deliver_to_address1 WSH_NEW_DEL_INTERFACE.deliver_to_address1%TYPE,
42: deliver_to_address2 WSH_NEW_DEL_INTERFACE.deliver_to_address2%TYPE,
43: deliver_to_address3 WSH_NEW_DEL_INTERFACE.deliver_to_address3%TYPE,
44: deliver_to_address4 WSH_NEW_DEL_INTERFACE.deliver_to_address4%TYPE,
45: deliver_to_city WSH_NEW_DEL_INTERFACE.deliver_to_city%TYPE,
38: deliver_to_customer_id WSH_NEW_DEL_INTERFACE.deliver_to_customer_id%TYPE,
39: deliver_to_customer_name WSH_NEW_DEL_INTERFACE.deliver_to_customer_name%TYPE,
40: deliver_to_address_id WSH_NEW_DEL_INTERFACE.deliver_to_address_id%TYPE,
41: deliver_to_address1 WSH_NEW_DEL_INTERFACE.deliver_to_address1%TYPE,
42: deliver_to_address2 WSH_NEW_DEL_INTERFACE.deliver_to_address2%TYPE,
43: deliver_to_address3 WSH_NEW_DEL_INTERFACE.deliver_to_address3%TYPE,
44: deliver_to_address4 WSH_NEW_DEL_INTERFACE.deliver_to_address4%TYPE,
45: deliver_to_city WSH_NEW_DEL_INTERFACE.deliver_to_city%TYPE,
46: deliver_to_state WSH_NEW_DEL_INTERFACE.deliver_to_state%TYPE,
39: deliver_to_customer_name WSH_NEW_DEL_INTERFACE.deliver_to_customer_name%TYPE,
40: deliver_to_address_id WSH_NEW_DEL_INTERFACE.deliver_to_address_id%TYPE,
41: deliver_to_address1 WSH_NEW_DEL_INTERFACE.deliver_to_address1%TYPE,
42: deliver_to_address2 WSH_NEW_DEL_INTERFACE.deliver_to_address2%TYPE,
43: deliver_to_address3 WSH_NEW_DEL_INTERFACE.deliver_to_address3%TYPE,
44: deliver_to_address4 WSH_NEW_DEL_INTERFACE.deliver_to_address4%TYPE,
45: deliver_to_city WSH_NEW_DEL_INTERFACE.deliver_to_city%TYPE,
46: deliver_to_state WSH_NEW_DEL_INTERFACE.deliver_to_state%TYPE,
47: deliver_to_country WSH_NEW_DEL_INTERFACE.deliver_to_country%TYPE,
40: deliver_to_address_id WSH_NEW_DEL_INTERFACE.deliver_to_address_id%TYPE,
41: deliver_to_address1 WSH_NEW_DEL_INTERFACE.deliver_to_address1%TYPE,
42: deliver_to_address2 WSH_NEW_DEL_INTERFACE.deliver_to_address2%TYPE,
43: deliver_to_address3 WSH_NEW_DEL_INTERFACE.deliver_to_address3%TYPE,
44: deliver_to_address4 WSH_NEW_DEL_INTERFACE.deliver_to_address4%TYPE,
45: deliver_to_city WSH_NEW_DEL_INTERFACE.deliver_to_city%TYPE,
46: deliver_to_state WSH_NEW_DEL_INTERFACE.deliver_to_state%TYPE,
47: deliver_to_country WSH_NEW_DEL_INTERFACE.deliver_to_country%TYPE,
48: deliver_to_postal_code WSH_NEW_DEL_INTERFACE.deliver_to_postal_code%TYPE,
41: deliver_to_address1 WSH_NEW_DEL_INTERFACE.deliver_to_address1%TYPE,
42: deliver_to_address2 WSH_NEW_DEL_INTERFACE.deliver_to_address2%TYPE,
43: deliver_to_address3 WSH_NEW_DEL_INTERFACE.deliver_to_address3%TYPE,
44: deliver_to_address4 WSH_NEW_DEL_INTERFACE.deliver_to_address4%TYPE,
45: deliver_to_city WSH_NEW_DEL_INTERFACE.deliver_to_city%TYPE,
46: deliver_to_state WSH_NEW_DEL_INTERFACE.deliver_to_state%TYPE,
47: deliver_to_country WSH_NEW_DEL_INTERFACE.deliver_to_country%TYPE,
48: deliver_to_postal_code WSH_NEW_DEL_INTERFACE.deliver_to_postal_code%TYPE,
49: deliver_to_contact_id WSH_NEW_DEL_INTERFACE.deliver_to_contact_id%TYPE,
42: deliver_to_address2 WSH_NEW_DEL_INTERFACE.deliver_to_address2%TYPE,
43: deliver_to_address3 WSH_NEW_DEL_INTERFACE.deliver_to_address3%TYPE,
44: deliver_to_address4 WSH_NEW_DEL_INTERFACE.deliver_to_address4%TYPE,
45: deliver_to_city WSH_NEW_DEL_INTERFACE.deliver_to_city%TYPE,
46: deliver_to_state WSH_NEW_DEL_INTERFACE.deliver_to_state%TYPE,
47: deliver_to_country WSH_NEW_DEL_INTERFACE.deliver_to_country%TYPE,
48: deliver_to_postal_code WSH_NEW_DEL_INTERFACE.deliver_to_postal_code%TYPE,
49: deliver_to_contact_id WSH_NEW_DEL_INTERFACE.deliver_to_contact_id%TYPE,
50: deliver_to_contact_name WSH_NEW_DEL_INTERFACE.deliver_to_contact_name%TYPE,
43: deliver_to_address3 WSH_NEW_DEL_INTERFACE.deliver_to_address3%TYPE,
44: deliver_to_address4 WSH_NEW_DEL_INTERFACE.deliver_to_address4%TYPE,
45: deliver_to_city WSH_NEW_DEL_INTERFACE.deliver_to_city%TYPE,
46: deliver_to_state WSH_NEW_DEL_INTERFACE.deliver_to_state%TYPE,
47: deliver_to_country WSH_NEW_DEL_INTERFACE.deliver_to_country%TYPE,
48: deliver_to_postal_code WSH_NEW_DEL_INTERFACE.deliver_to_postal_code%TYPE,
49: deliver_to_contact_id WSH_NEW_DEL_INTERFACE.deliver_to_contact_id%TYPE,
50: deliver_to_contact_name WSH_NEW_DEL_INTERFACE.deliver_to_contact_name%TYPE,
51: deliver_to_contact_phone WSH_NEW_DEL_INTERFACE.deliver_to_contact_phone%TYPE,
44: deliver_to_address4 WSH_NEW_DEL_INTERFACE.deliver_to_address4%TYPE,
45: deliver_to_city WSH_NEW_DEL_INTERFACE.deliver_to_city%TYPE,
46: deliver_to_state WSH_NEW_DEL_INTERFACE.deliver_to_state%TYPE,
47: deliver_to_country WSH_NEW_DEL_INTERFACE.deliver_to_country%TYPE,
48: deliver_to_postal_code WSH_NEW_DEL_INTERFACE.deliver_to_postal_code%TYPE,
49: deliver_to_contact_id WSH_NEW_DEL_INTERFACE.deliver_to_contact_id%TYPE,
50: deliver_to_contact_name WSH_NEW_DEL_INTERFACE.deliver_to_contact_name%TYPE,
51: deliver_to_contact_phone WSH_NEW_DEL_INTERFACE.deliver_to_contact_phone%TYPE,
52: transaction_type_id WSH_NEW_DEL_INTERFACE.transaction_type_id%TYPE,
45: deliver_to_city WSH_NEW_DEL_INTERFACE.deliver_to_city%TYPE,
46: deliver_to_state WSH_NEW_DEL_INTERFACE.deliver_to_state%TYPE,
47: deliver_to_country WSH_NEW_DEL_INTERFACE.deliver_to_country%TYPE,
48: deliver_to_postal_code WSH_NEW_DEL_INTERFACE.deliver_to_postal_code%TYPE,
49: deliver_to_contact_id WSH_NEW_DEL_INTERFACE.deliver_to_contact_id%TYPE,
50: deliver_to_contact_name WSH_NEW_DEL_INTERFACE.deliver_to_contact_name%TYPE,
51: deliver_to_contact_phone WSH_NEW_DEL_INTERFACE.deliver_to_contact_phone%TYPE,
52: transaction_type_id WSH_NEW_DEL_INTERFACE.transaction_type_id%TYPE,
53: price_list_id WSH_NEW_DEL_INTERFACE.price_list_id%TYPE,
46: deliver_to_state WSH_NEW_DEL_INTERFACE.deliver_to_state%TYPE,
47: deliver_to_country WSH_NEW_DEL_INTERFACE.deliver_to_country%TYPE,
48: deliver_to_postal_code WSH_NEW_DEL_INTERFACE.deliver_to_postal_code%TYPE,
49: deliver_to_contact_id WSH_NEW_DEL_INTERFACE.deliver_to_contact_id%TYPE,
50: deliver_to_contact_name WSH_NEW_DEL_INTERFACE.deliver_to_contact_name%TYPE,
51: deliver_to_contact_phone WSH_NEW_DEL_INTERFACE.deliver_to_contact_phone%TYPE,
52: transaction_type_id WSH_NEW_DEL_INTERFACE.transaction_type_id%TYPE,
53: price_list_id WSH_NEW_DEL_INTERFACE.price_list_id%TYPE,
54: payment_term_id NUMBER,
47: deliver_to_country WSH_NEW_DEL_INTERFACE.deliver_to_country%TYPE,
48: deliver_to_postal_code WSH_NEW_DEL_INTERFACE.deliver_to_postal_code%TYPE,
49: deliver_to_contact_id WSH_NEW_DEL_INTERFACE.deliver_to_contact_id%TYPE,
50: deliver_to_contact_name WSH_NEW_DEL_INTERFACE.deliver_to_contact_name%TYPE,
51: deliver_to_contact_phone WSH_NEW_DEL_INTERFACE.deliver_to_contact_phone%TYPE,
52: transaction_type_id WSH_NEW_DEL_INTERFACE.transaction_type_id%TYPE,
53: price_list_id WSH_NEW_DEL_INTERFACE.price_list_id%TYPE,
54: payment_term_id NUMBER,
55: currency_code WSH_NEW_DEL_INTERFACE.currency_code%TYPE,
48: deliver_to_postal_code WSH_NEW_DEL_INTERFACE.deliver_to_postal_code%TYPE,
49: deliver_to_contact_id WSH_NEW_DEL_INTERFACE.deliver_to_contact_id%TYPE,
50: deliver_to_contact_name WSH_NEW_DEL_INTERFACE.deliver_to_contact_name%TYPE,
51: deliver_to_contact_phone WSH_NEW_DEL_INTERFACE.deliver_to_contact_phone%TYPE,
52: transaction_type_id WSH_NEW_DEL_INTERFACE.transaction_type_id%TYPE,
53: price_list_id WSH_NEW_DEL_INTERFACE.price_list_id%TYPE,
54: payment_term_id NUMBER,
55: currency_code WSH_NEW_DEL_INTERFACE.currency_code%TYPE,
56: carrier_code WSH_NEW_DEL_INTERFACE.carrier_code%TYPE,
49: deliver_to_contact_id WSH_NEW_DEL_INTERFACE.deliver_to_contact_id%TYPE,
50: deliver_to_contact_name WSH_NEW_DEL_INTERFACE.deliver_to_contact_name%TYPE,
51: deliver_to_contact_phone WSH_NEW_DEL_INTERFACE.deliver_to_contact_phone%TYPE,
52: transaction_type_id WSH_NEW_DEL_INTERFACE.transaction_type_id%TYPE,
53: price_list_id WSH_NEW_DEL_INTERFACE.price_list_id%TYPE,
54: payment_term_id NUMBER,
55: currency_code WSH_NEW_DEL_INTERFACE.currency_code%TYPE,
56: carrier_code WSH_NEW_DEL_INTERFACE.carrier_code%TYPE,
57: carrier_id WSH_NEW_DEL_INTERFACE.carrier_id%TYPE,
51: deliver_to_contact_phone WSH_NEW_DEL_INTERFACE.deliver_to_contact_phone%TYPE,
52: transaction_type_id WSH_NEW_DEL_INTERFACE.transaction_type_id%TYPE,
53: price_list_id WSH_NEW_DEL_INTERFACE.price_list_id%TYPE,
54: payment_term_id NUMBER,
55: currency_code WSH_NEW_DEL_INTERFACE.currency_code%TYPE,
56: carrier_code WSH_NEW_DEL_INTERFACE.carrier_code%TYPE,
57: carrier_id WSH_NEW_DEL_INTERFACE.carrier_id%TYPE,
58: service_level WSH_NEW_DEL_INTERFACE.service_level%TYPE,
59: mode_of_transport WSH_NEW_DEL_INTERFACE.mode_of_transport%TYPE,
52: transaction_type_id WSH_NEW_DEL_INTERFACE.transaction_type_id%TYPE,
53: price_list_id WSH_NEW_DEL_INTERFACE.price_list_id%TYPE,
54: payment_term_id NUMBER,
55: currency_code WSH_NEW_DEL_INTERFACE.currency_code%TYPE,
56: carrier_code WSH_NEW_DEL_INTERFACE.carrier_code%TYPE,
57: carrier_id WSH_NEW_DEL_INTERFACE.carrier_id%TYPE,
58: service_level WSH_NEW_DEL_INTERFACE.service_level%TYPE,
59: mode_of_transport WSH_NEW_DEL_INTERFACE.mode_of_transport%TYPE,
60: freight_terms_code WSH_NEW_DEL_INTERFACE.freight_terms_code%TYPE,
53: price_list_id WSH_NEW_DEL_INTERFACE.price_list_id%TYPE,
54: payment_term_id NUMBER,
55: currency_code WSH_NEW_DEL_INTERFACE.currency_code%TYPE,
56: carrier_code WSH_NEW_DEL_INTERFACE.carrier_code%TYPE,
57: carrier_id WSH_NEW_DEL_INTERFACE.carrier_id%TYPE,
58: service_level WSH_NEW_DEL_INTERFACE.service_level%TYPE,
59: mode_of_transport WSH_NEW_DEL_INTERFACE.mode_of_transport%TYPE,
60: freight_terms_code WSH_NEW_DEL_INTERFACE.freight_terms_code%TYPE,
61: fob_code WSH_NEW_DEL_INTERFACE.fob_code%TYPE,
54: payment_term_id NUMBER,
55: currency_code WSH_NEW_DEL_INTERFACE.currency_code%TYPE,
56: carrier_code WSH_NEW_DEL_INTERFACE.carrier_code%TYPE,
57: carrier_id WSH_NEW_DEL_INTERFACE.carrier_id%TYPE,
58: service_level WSH_NEW_DEL_INTERFACE.service_level%TYPE,
59: mode_of_transport WSH_NEW_DEL_INTERFACE.mode_of_transport%TYPE,
60: freight_terms_code WSH_NEW_DEL_INTERFACE.freight_terms_code%TYPE,
61: fob_code WSH_NEW_DEL_INTERFACE.fob_code%TYPE,
62: ship_method_code VARCHAR2(30),
55: currency_code WSH_NEW_DEL_INTERFACE.currency_code%TYPE,
56: carrier_code WSH_NEW_DEL_INTERFACE.carrier_code%TYPE,
57: carrier_id WSH_NEW_DEL_INTERFACE.carrier_id%TYPE,
58: service_level WSH_NEW_DEL_INTERFACE.service_level%TYPE,
59: mode_of_transport WSH_NEW_DEL_INTERFACE.mode_of_transport%TYPE,
60: freight_terms_code WSH_NEW_DEL_INTERFACE.freight_terms_code%TYPE,
61: fob_code WSH_NEW_DEL_INTERFACE.fob_code%TYPE,
62: ship_method_code VARCHAR2(30),
63: org_id NUMBER,
56: carrier_code WSH_NEW_DEL_INTERFACE.carrier_code%TYPE,
57: carrier_id WSH_NEW_DEL_INTERFACE.carrier_id%TYPE,
58: service_level WSH_NEW_DEL_INTERFACE.service_level%TYPE,
59: mode_of_transport WSH_NEW_DEL_INTERFACE.mode_of_transport%TYPE,
60: freight_terms_code WSH_NEW_DEL_INTERFACE.freight_terms_code%TYPE,
61: fob_code WSH_NEW_DEL_INTERFACE.fob_code%TYPE,
62: ship_method_code VARCHAR2(30),
63: org_id NUMBER,
64: document_revision NUMBER,
57: carrier_id WSH_NEW_DEL_INTERFACE.carrier_id%TYPE,
58: service_level WSH_NEW_DEL_INTERFACE.service_level%TYPE,
59: mode_of_transport WSH_NEW_DEL_INTERFACE.mode_of_transport%TYPE,
60: freight_terms_code WSH_NEW_DEL_INTERFACE.freight_terms_code%TYPE,
61: fob_code WSH_NEW_DEL_INTERFACE.fob_code%TYPE,
62: ship_method_code VARCHAR2(30),
63: org_id NUMBER,
64: document_revision NUMBER,
65: order_number NUMBER,
409: -- x_return_status => Return Status of API (Either S,E,U)
410: --
411: -- COMMENT:
412: -- API to derive/validate standalone related order header attributes
413: -- populated in Wsh_New_Del_Interface table.
414: --=============================================================================
415: --
416: PROCEDURE Derive_Header_Rec(
417: p_om_header_rec IN OUT NOCOPY OM_Header_Rec_Type,