1 PACKAGE POS_CREATE_ASN AS
2 /* $Header: POSASNTS.pls 120.2 2006/01/30 10:45:36 shgao noship $*/
3
4 PROCEDURE create_asn_iface(
5 P_GROUP_ID IN NUMBER,
6 P_LAST_UPDATED_BY IN NUMBER,
7 P_LAST_UPDATE_LOGIN IN NUMBER,
8 P_CREATED_BY IN NUMBER,
9 P_SHIPMENT_NUM IN VARCHAR2,
10 P_VENDOR_NAME IN VARCHAR2,
11 P_VENDOR_ID IN NUMBER,
12 P_VENDOR_SITE_CODE IN VARCHAR2,
13 P_VENDOR_SITE_ID IN NUMBER,
14 P_BILL_OF_LADING IN VARCHAR2,
15 P_PACKING_SLIP IN VARCHAR2,
16 P_SHIPPED_DATE IN VARCHAR2,
17 P_FREIGHT_CARRIER_CODE IN VARCHAR2,
18 P_EXPECTED_RECEIPT_DATE IN VARCHAR2,
19 P_NUM_OF_CONTAINERS IN NUMBER,
20 P_WAYBILL_AIRBILL_NUM IN VARCHAR2,
21 P_COMMENTS IN VARCHAR2,
22 P_PACKAGING_CODE IN VARCHAR2,
23 P_CARRIER_METHOD IN VARCHAR2,
24 P_CARRIER_EQUIPMENT IN VARCHAR2,
25 P_SPECIAL_HANDLING_CODE IN VARCHAR2,
26 P_INVOICE_NUM IN VARCHAR2,
27 P_INVOICE_DATE IN VARCHAR2,
28 P_TOTAL_INVOICE_AMOUNT IN NUMBER,
29 P_PAYMENT_TERMS_ID IN NUMBER,
30 P_HAZARD_CODE IN VARCHAR2,
31 P_FREIGHT_TERMS IN VARCHAR2,
32 P_FREIGHT_AMOUNT IN NUMBER,
33 P_CURRENCY_CODE IN VARCHAR2,
34 P_CURRENCY_CONVERSION_TYPE IN VARCHAR2,
35 P_CURRENCY_CONVERSION_RATE IN NUMBER,
36 P_CURRENCY_CONVERSION_DATE IN VARCHAR2,
37 p_gross_weight IN NUMBER,
38 p_gross_weight_uom IN VARCHAR2 ,
39 p_net_weight IN NUMBER ,
40 p_net_weight_uom IN VARCHAR2 ,
41 p_tar_weight IN NUMBER ,
42 p_tar_weight_uom IN VARCHAR2 ,
43 p_freight_bill_num IN VARCHAR2 ,
44 /* rcv transaction interface parameters */
45 P_QUANTITY_T IN NUMBER,
46 P_UNIT_OF_MEASURE_T IN VARCHAR2,
47 P_ITEM_ID_T IN NUMBER,
48 P_ITEM_REVISION_T IN VARCHAR2,
49 P_SHIP_TO_LOCATION_CODE_T IN VARCHAR2,
50 P_SHIP_TO_ORG_ID_T IN NUMBER,
51 P_PO_HEADER_ID_T IN NUMBER,
52 P_PO_REVISION_NUM_T IN NUMBER,
53 P_PO_LINE_ID_T IN NUMBER,
54 P_PO_LINE_LOCATION_ID_T IN NUMBER,
55 P_PO_UNIT_PRICE_T IN NUMBER,
56 P_PACKING_SLIP_T IN VARCHAR2,
57 P_SHIPPED_DATE_T IN VARCHAR2,
58 P_EXPECTED_RECEIPT_DATE_T IN VARCHAR2,
59 P_NUM_OF_CONTAINERS_T IN NUMBER,
60 P_VENDOR_ITEM_NUM_T IN VARCHAR2,
61 P_VENDOR_LOT_NUM_T IN VARCHAR2,
62 P_COMMENTS_T IN VARCHAR2,
63 P_TRUCK_NUM_T IN VARCHAR2,
64 P_CONTAINER_NUM_T IN VARCHAR2,
65 P_DELIVER_TO_LOCATION_CODE_T IN VARCHAR2,
66 P_BARCODE_LABEL_T IN VARCHAR2,
67 P_COUNTRY_OF_ORIGIN_CODE_T IN VARCHAR2,
68 P_DOCUMENT_LINE_NUM_T IN NUMBER,
69 P_DOCUMENT_SHIPMENT_LINE_NUM_T IN NUMBER,
70 p_error_code IN OUT NOCOPY VARCHAR2,
71 p_error_message IN OUT NOCOPY VARCHAR2,
72 P_PAYMENT_TERMS_NAME IN VARCHAR2,
73 P_OPERATING_UNIT_ID IN NUMBER,
74 P_PO_RELEASE_ID IN NUMBER,
75 p_tax_amount IN VARCHAR2,
76 p_license_plate_number in varchar2 default null,
77 p_lpn_group_id in number);
78
79 FUNCTION getAvailableShipmentQuantity(p_lineLocationID IN NUMBER) RETURN NUMBER;
80 FUNCTION getTolerableShipmentQuantity(p_lineLocationID IN NUMBER) RETURN NUMBER;
81 PROCEDURE getShipmentQuantity ( p_line_location_id IN NUMBER,
82 p_available_quantity IN OUT NOCOPY NUMBER,
83 p_tolerable_quantity IN OUT NOCOPY NUMBER,
84 p_unit_of_measure IN OUT NOCOPY VARCHAR2);
85
86 PROCEDURE getConvertedQuantity ( p_line_location_id IN NUMBER,
87 p_available_quantity IN NUMBER,
88 p_new_unit_of_measure IN VARCHAR2,
89 p_converted_quantity OUT NOCOPY NUMBER );
90
91
92
93 PROCEDURE callPreProcessor(p_groupId in number);
94
95 PROCEDURE VALIDATE_FREIGHT_CARRIER (
96 p_organization_id IN NUMBER,
97 p_freight_code IN VARCHAR2,
98 p_count OUT NOCOPY NUMBER
99 );
100
101 END POS_CREATE_ASN;
102