DBA Data[Home] [Help]

APPS.WSH_SHIPMENT_REQUEST_PKG dependencies on WSH_NEW_DEL_INTERFACE

Line 5: delivery_interface_id WSH_NEW_DEL_INTERFACE.delivery_interface_id%TYPE,

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,

Line 6: organization_code WSH_NEW_DEL_INTERFACE.organization_code%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,

Line 7: organization_id WSH_NEW_DEL_INTERFACE.organization_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,

Line 8: customer_id WSH_NEW_DEL_INTERFACE.customer_id%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,

Line 9: customer_name WSH_NEW_DEL_INTERFACE.customer_name%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,

Line 10: ship_to_customer_id WSH_NEW_DEL_INTERFACE.ship_to_customer_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,
14: ship_to_address2 WSH_NEW_DEL_INTERFACE.ship_to_address2%TYPE,

Line 11: ship_to_customer_name WSH_NEW_DEL_INTERFACE.ship_to_customer_name%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,

Line 12: ship_to_address_id WSH_NEW_DEL_INTERFACE.ship_to_address_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,
16: ship_to_address4 WSH_NEW_DEL_INTERFACE.ship_to_address4%TYPE,

Line 13: ship_to_address1 WSH_NEW_DEL_INTERFACE.ship_to_address1%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,

Line 14: ship_to_address2 WSH_NEW_DEL_INTERFACE.ship_to_address2%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,

Line 15: ship_to_address3 WSH_NEW_DEL_INTERFACE.ship_to_address3%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,

Line 16: ship_to_address4 WSH_NEW_DEL_INTERFACE.ship_to_address4%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,

Line 17: ship_to_city WSH_NEW_DEL_INTERFACE.ship_to_city%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,

Line 18: ship_to_state WSH_NEW_DEL_INTERFACE.ship_to_state%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,

Line 19: ship_to_country WSH_NEW_DEL_INTERFACE.ship_to_country%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,

Line 20: ship_to_postal_code WSH_NEW_DEL_INTERFACE.ship_to_postal_code%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,

Line 21: ship_to_contact_id WSH_NEW_DEL_INTERFACE.ship_to_contact_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,

Line 22: ship_to_contact_name WSH_NEW_DEL_INTERFACE.ship_to_contact_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,

Line 23: ship_to_contact_phone WSH_NEW_DEL_INTERFACE.ship_to_contact_phone%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,

Line 24: invoice_to_customer_id WSH_NEW_DEL_INTERFACE.invoice_to_customer_id%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,

Line 25: invoice_to_customer_name WSH_NEW_DEL_INTERFACE.invoice_to_customer_name%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,

Line 26: invoice_to_address_id WSH_NEW_DEL_INTERFACE.invoice_to_address_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,
30: invoice_to_address4 WSH_NEW_DEL_INTERFACE.invoice_to_address4%TYPE,

Line 27: invoice_to_address1 WSH_NEW_DEL_INTERFACE.invoice_to_address1%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,

Line 28: invoice_to_address2 WSH_NEW_DEL_INTERFACE.invoice_to_address2%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,

Line 29: invoice_to_address3 WSH_NEW_DEL_INTERFACE.invoice_to_address3%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,

Line 30: invoice_to_address4 WSH_NEW_DEL_INTERFACE.invoice_to_address4%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,

Line 31: invoice_to_city WSH_NEW_DEL_INTERFACE.invoice_to_city%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,

Line 32: invoice_to_state WSH_NEW_DEL_INTERFACE.invoice_to_state%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,

Line 33: invoice_to_country WSH_NEW_DEL_INTERFACE.invoice_to_country%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,

Line 34: invoice_to_postal_code WSH_NEW_DEL_INTERFACE.invoice_to_postal_code%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,

Line 35: invoice_to_contact_id WSH_NEW_DEL_INTERFACE.invoice_to_contact_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,

Line 36: invoice_to_contact_name WSH_NEW_DEL_INTERFACE.invoice_to_contact_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,

Line 37: invoice_to_contact_phone WSH_NEW_DEL_INTERFACE.invoice_to_contact_phone%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,

Line 38: deliver_to_customer_id WSH_NEW_DEL_INTERFACE.deliver_to_customer_id%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,

Line 39: deliver_to_customer_name WSH_NEW_DEL_INTERFACE.deliver_to_customer_name%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,

Line 40: deliver_to_address_id WSH_NEW_DEL_INTERFACE.deliver_to_address_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,
44: deliver_to_address4 WSH_NEW_DEL_INTERFACE.deliver_to_address4%TYPE,

Line 41: deliver_to_address1 WSH_NEW_DEL_INTERFACE.deliver_to_address1%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,

Line 42: deliver_to_address2 WSH_NEW_DEL_INTERFACE.deliver_to_address2%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,

Line 43: deliver_to_address3 WSH_NEW_DEL_INTERFACE.deliver_to_address3%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,

Line 44: deliver_to_address4 WSH_NEW_DEL_INTERFACE.deliver_to_address4%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,

Line 45: deliver_to_city WSH_NEW_DEL_INTERFACE.deliver_to_city%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,

Line 46: deliver_to_state WSH_NEW_DEL_INTERFACE.deliver_to_state%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,

Line 47: deliver_to_country WSH_NEW_DEL_INTERFACE.deliver_to_country%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,

Line 48: deliver_to_postal_code WSH_NEW_DEL_INTERFACE.deliver_to_postal_code%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,

Line 49: deliver_to_contact_id WSH_NEW_DEL_INTERFACE.deliver_to_contact_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,

Line 50: deliver_to_contact_name WSH_NEW_DEL_INTERFACE.deliver_to_contact_name%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,

Line 51: deliver_to_contact_phone WSH_NEW_DEL_INTERFACE.deliver_to_contact_phone%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,
55: currency_code WSH_NEW_DEL_INTERFACE.currency_code%TYPE,

Line 52: transaction_type_id WSH_NEW_DEL_INTERFACE.transaction_type_id%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,

Line 53: price_list_id WSH_NEW_DEL_INTERFACE.price_list_id%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,

Line 55: currency_code WSH_NEW_DEL_INTERFACE.currency_code%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,

Line 56: carrier_code WSH_NEW_DEL_INTERFACE.carrier_code%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,

Line 57: carrier_id WSH_NEW_DEL_INTERFACE.carrier_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,
61: fob_code WSH_NEW_DEL_INTERFACE.fob_code%TYPE,

Line 58: service_level WSH_NEW_DEL_INTERFACE.service_level%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),

Line 59: mode_of_transport WSH_NEW_DEL_INTERFACE.mode_of_transport%TYPE,

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,

Line 60: freight_terms_code WSH_NEW_DEL_INTERFACE.freight_terms_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,
64: document_revision NUMBER,

Line 61: fob_code WSH_NEW_DEL_INTERFACE.fob_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,
65: order_number NUMBER,

Line 413: -- populated in Wsh_New_Del_Interface table.

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,