1: PACKAGE WSH_SHIPMENT_BATCH_PKG AUTHID CURRENT_USER AS
2: /* $Header: WSHSBPKS.pls 120.0.12020000.2 2013/01/17 03:57:11 ueshanka ship $ */
3:
4: TYPE Shipment_Batch_Record IS RECORD (
5: customer_id WSH_DELIVERY_DETAILS.customer_id%TYPE,
6: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
7: ship_from_location_id WSH_DELIVERY_DETAILS.ship_from_location_id%TYPE,
8: org_id WSH_DELIVERY_DETAILS.org_id%TYPE,
9: currency_code WSH_DELIVERY_DETAILS.currency_code%TYPE,
2: /* $Header: WSHSBPKS.pls 120.0.12020000.2 2013/01/17 03:57:11 ueshanka ship $ */
3:
4: TYPE Shipment_Batch_Record IS RECORD (
5: customer_id WSH_DELIVERY_DETAILS.customer_id%TYPE,
6: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
7: ship_from_location_id WSH_DELIVERY_DETAILS.ship_from_location_id%TYPE,
8: org_id WSH_DELIVERY_DETAILS.org_id%TYPE,
9: currency_code WSH_DELIVERY_DETAILS.currency_code%TYPE,
10: ship_to_site_use_id WSH_DELIVERY_DETAILS.ship_to_site_use_id%TYPE,
3:
4: TYPE Shipment_Batch_Record IS RECORD (
5: customer_id WSH_DELIVERY_DETAILS.customer_id%TYPE,
6: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
7: ship_from_location_id WSH_DELIVERY_DETAILS.ship_from_location_id%TYPE,
8: org_id WSH_DELIVERY_DETAILS.org_id%TYPE,
9: currency_code WSH_DELIVERY_DETAILS.currency_code%TYPE,
10: ship_to_site_use_id WSH_DELIVERY_DETAILS.ship_to_site_use_id%TYPE,
11: invoice_to_site_use_id NUMBER,
4: TYPE Shipment_Batch_Record IS RECORD (
5: customer_id WSH_DELIVERY_DETAILS.customer_id%TYPE,
6: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
7: ship_from_location_id WSH_DELIVERY_DETAILS.ship_from_location_id%TYPE,
8: org_id WSH_DELIVERY_DETAILS.org_id%TYPE,
9: currency_code WSH_DELIVERY_DETAILS.currency_code%TYPE,
10: ship_to_site_use_id WSH_DELIVERY_DETAILS.ship_to_site_use_id%TYPE,
11: invoice_to_site_use_id NUMBER,
12: deliver_to_site_use_id WSH_DELIVERY_DETAILS.deliver_to_site_use_id%TYPE,
5: customer_id WSH_DELIVERY_DETAILS.customer_id%TYPE,
6: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
7: ship_from_location_id WSH_DELIVERY_DETAILS.ship_from_location_id%TYPE,
8: org_id WSH_DELIVERY_DETAILS.org_id%TYPE,
9: currency_code WSH_DELIVERY_DETAILS.currency_code%TYPE,
10: ship_to_site_use_id WSH_DELIVERY_DETAILS.ship_to_site_use_id%TYPE,
11: invoice_to_site_use_id NUMBER,
12: deliver_to_site_use_id WSH_DELIVERY_DETAILS.deliver_to_site_use_id%TYPE,
13: ship_to_contact_id WSH_DELIVERY_DETAILS.ship_to_contact_id%TYPE,
6: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
7: ship_from_location_id WSH_DELIVERY_DETAILS.ship_from_location_id%TYPE,
8: org_id WSH_DELIVERY_DETAILS.org_id%TYPE,
9: currency_code WSH_DELIVERY_DETAILS.currency_code%TYPE,
10: ship_to_site_use_id WSH_DELIVERY_DETAILS.ship_to_site_use_id%TYPE,
11: invoice_to_site_use_id NUMBER,
12: deliver_to_site_use_id WSH_DELIVERY_DETAILS.deliver_to_site_use_id%TYPE,
13: ship_to_contact_id WSH_DELIVERY_DETAILS.ship_to_contact_id%TYPE,
14: invoice_to_contact_id NUMBER,
8: org_id WSH_DELIVERY_DETAILS.org_id%TYPE,
9: currency_code WSH_DELIVERY_DETAILS.currency_code%TYPE,
10: ship_to_site_use_id WSH_DELIVERY_DETAILS.ship_to_site_use_id%TYPE,
11: invoice_to_site_use_id NUMBER,
12: deliver_to_site_use_id WSH_DELIVERY_DETAILS.deliver_to_site_use_id%TYPE,
13: ship_to_contact_id WSH_DELIVERY_DETAILS.ship_to_contact_id%TYPE,
14: invoice_to_contact_id NUMBER,
15: deliver_to_contact_id WSH_DELIVERY_DETAILS.deliver_to_contact_id%TYPE,
16: ship_method_code WSH_DELIVERY_DETAILS.ship_method_code%TYPE,
9: currency_code WSH_DELIVERY_DETAILS.currency_code%TYPE,
10: ship_to_site_use_id WSH_DELIVERY_DETAILS.ship_to_site_use_id%TYPE,
11: invoice_to_site_use_id NUMBER,
12: deliver_to_site_use_id WSH_DELIVERY_DETAILS.deliver_to_site_use_id%TYPE,
13: ship_to_contact_id WSH_DELIVERY_DETAILS.ship_to_contact_id%TYPE,
14: invoice_to_contact_id NUMBER,
15: deliver_to_contact_id WSH_DELIVERY_DETAILS.deliver_to_contact_id%TYPE,
16: ship_method_code WSH_DELIVERY_DETAILS.ship_method_code%TYPE,
17: freight_terms_code WSH_DELIVERY_DETAILS.freight_terms_code%TYPE,
11: invoice_to_site_use_id NUMBER,
12: deliver_to_site_use_id WSH_DELIVERY_DETAILS.deliver_to_site_use_id%TYPE,
13: ship_to_contact_id WSH_DELIVERY_DETAILS.ship_to_contact_id%TYPE,
14: invoice_to_contact_id NUMBER,
15: deliver_to_contact_id WSH_DELIVERY_DETAILS.deliver_to_contact_id%TYPE,
16: ship_method_code WSH_DELIVERY_DETAILS.ship_method_code%TYPE,
17: freight_terms_code WSH_DELIVERY_DETAILS.freight_terms_code%TYPE,
18: fob_code WSH_DELIVERY_DETAILS.fob_code%TYPE,
19: group_id NUMBER );
12: deliver_to_site_use_id WSH_DELIVERY_DETAILS.deliver_to_site_use_id%TYPE,
13: ship_to_contact_id WSH_DELIVERY_DETAILS.ship_to_contact_id%TYPE,
14: invoice_to_contact_id NUMBER,
15: deliver_to_contact_id WSH_DELIVERY_DETAILS.deliver_to_contact_id%TYPE,
16: ship_method_code WSH_DELIVERY_DETAILS.ship_method_code%TYPE,
17: freight_terms_code WSH_DELIVERY_DETAILS.freight_terms_code%TYPE,
18: fob_code WSH_DELIVERY_DETAILS.fob_code%TYPE,
19: group_id NUMBER );
20:
13: ship_to_contact_id WSH_DELIVERY_DETAILS.ship_to_contact_id%TYPE,
14: invoice_to_contact_id NUMBER,
15: deliver_to_contact_id WSH_DELIVERY_DETAILS.deliver_to_contact_id%TYPE,
16: ship_method_code WSH_DELIVERY_DETAILS.ship_method_code%TYPE,
17: freight_terms_code WSH_DELIVERY_DETAILS.freight_terms_code%TYPE,
18: fob_code WSH_DELIVERY_DETAILS.fob_code%TYPE,
19: group_id NUMBER );
20:
21: TYPE Shipment_Batch_Tbl IS TABLE OF Shipment_Batch_Record index by binary_integer;
14: invoice_to_contact_id NUMBER,
15: deliver_to_contact_id WSH_DELIVERY_DETAILS.deliver_to_contact_id%TYPE,
16: ship_method_code WSH_DELIVERY_DETAILS.ship_method_code%TYPE,
17: freight_terms_code WSH_DELIVERY_DETAILS.freight_terms_code%TYPE,
18: fob_code WSH_DELIVERY_DETAILS.fob_code%TYPE,
19: group_id NUMBER );
20:
21: TYPE Shipment_Batch_Tbl IS TABLE OF Shipment_Batch_Record index by binary_integer;
22: