1 PACKAGE MSC_SCATP_PUB AUTHID CURRENT_USER AS
2 /* $Header: MSCVATPS.pls 115.5 2003/06/26 07:50:38 rajjain ship $ */
3
4
5 -- savirine added parameters p_session_id and p_partner_site_id on Sep 10, 2001.
6
7 FUNCTION get_default_ship_method (p_from_location_id IN NUMBER,
8 p_from_instance_id IN NUMBER,
9 p_to_location_id IN NUMBER,
10 p_to_instance_id IN NUMBER,
11 p_session_id IN NUMBER DEFAULT NULL,
12 p_partner_site_id IN NUMBER DEFAULT NULL)
13 return VARCHAR2;
14
15 FUNCTION get_default_intransit_time (p_from_location_id IN NUMBER,
16 p_from_instance_id IN NUMBER,
17 p_to_location_id IN NUMBER,
18 p_to_instance_id IN NUMBER,
19 p_session_id IN NUMBER DEFAULT NULL,
20 p_partner_site_id IN NUMBER DEFAULT NULL)
21 return NUMBER;
22
23 FUNCTION get_ship_method(p_from_org_id IN NUMBER,
24 p_from_org_instance_id IN NUMBER,
25 p_to_org_id IN NUMBER,
26 p_to_org_instance_id IN NUMBER,
27 p_source_ship_method IN VARCHAR2,
28 p_receipt_org_id IN NUMBER)
29 return VARCHAR2;
30
31 FUNCTION get_intransit_time(p_from_org_id IN NUMBER,
32 p_from_org_instance_id IN NUMBER,
33 p_to_org_id IN NUMBER,
34 p_to_org_instance_id IN NUMBER,
35 p_source_ship_method IN VARCHAR2,
36 p_receipt_org_id IN NUMBER)
37 return NUMBER;
38
39 FUNCTION get_weight_cost(p_from_org_id IN NUMBER,
40 p_from_org_instance_id IN NUMBER,
41 p_to_org_id IN NUMBER,
42 p_to_org_instance_id IN NUMBER,
43 p_source_ship_method IN VARCHAR2,
44 p_receipt_org_id IN NUMBER)
45 return NUMBER;
46
47 FUNCTION get_transport_cost(p_from_org_id IN NUMBER,
48 p_from_org_instance_id IN NUMBER,
49 p_to_org_id IN NUMBER,
50 p_to_org_instance_id IN NUMBER,
51 p_source_ship_method IN VARCHAR2,
52 p_receipt_org_id IN NUMBER)
53 return NUMBER;
54
55 PRAGMA RESTRICT_REFERENCES (get_default_ship_method, WNDS,WNPS);
56 PRAGMA RESTRICT_REFERENCES (get_default_intransit_time, WNDS,WNPS);
57 PRAGMA RESTRICT_REFERENCES (get_ship_method, WNDS,WNPS);
58 PRAGMA RESTRICT_REFERENCES (get_intransit_time, WNDS,WNPS);
59 PRAGMA RESTRICT_REFERENCES (get_weight_cost, WNDS,WNPS);
60 PRAGMA RESTRICT_REFERENCES (get_transport_cost, WNDS,WNPS);
61
62 END MSC_SCATP_PUB;