1 PACKAGE WSH_CORE AUTHID CURRENT_USER AS
2 /* $Header: WSHCORES.pls 115.0 99/07/16 08:18:11 porting ship $ */
3
4
5
6 -- Name item_flex_name
7 -- Purpose converts inventory_item_id into its name
8 -- Assumption The id parameters are valid.
9 -- Arguments
10 -- inventory_item_id
11 -- warehouse_id
12 -- RETURN VARCHAR if name not found, '?' will be returned.
13 --
14 FUNCTION Item_Flex_Name(inventory_item_id IN NUMBER,
15 warehouse_id IN NUMBER) RETURN VARCHAR2;
16
17
18 -- Name locator_flex_name
19 -- Purpose converts locaotr_id into its name
20 -- Assumption The id parameters are valid.
21 -- Arguments
22 -- locaotr_item_id
23 -- warehouse_id
24 -- RETURN VARCHAR if name not found, '?' will be returned.
25 --
26 FUNCTION Locator_Flex_Name(locator_id IN NUMBER,
27 warehouse_id IN NUMBER) RETURN VARCHAR2;
28
29
30 -- Name generic_flex_name
31 -- Purpose converts entity_id into its name
32 -- Arguments
33 -- entity_id
34 -- warehouse_id
35 -- app_name (short app name; e.g. 'INV')
36 -- k_flex_code (key flexfield code; e.g., 'MSTK')
37 -- struct_num (structure number; e.g., 101)
38 -- Assumption The parameters are valid.
39 -- RETURN VARCHAR2 if name not found, '?' will be returned.
40 FUNCTION generic_flex_name(
41 entity_id IN NUMBER,
42 warehouse_id IN NUMBER,
43 app_name IN VARCHAR2,
44 k_flex_code IN VARCHAR2,
45 struct_num IN NUMBER)
46 RETURN VARCHAR2;
47
48
49 -- Name shipper_address
50 -- Purpose obtain the shipper's address information for the reports.
51 -- Assumption org_id exists, and the address is available.
52 -- Input Argument
53 -- org_id
54 -- Output Arguments (all are VARCHAR2(30))
55 -- org_name
56 -- address1
57 -- address2
58 -- address3
59 -- city
60 -- region (state)
61 -- postal_code (zip)
62 -- country
63 --
64 PROCEDURE Shipper_Address(
65 org_id in number,
66 org_name out varchar2,
67 address1 out varchar2,
68 address2 out varchar2,
69 address3 out varchar2,
70 city out varchar2,
71 region out varchar2,
72 postal_code out varchar2,
73 country out varchar2);
74
75 -- Name city_region_postal
76 -- Purpose concatenates the three fields for the reports
77 -- Input Arguments
78 -- city
79 -- region (state)
80 -- postal_code (zip)
81 -- RETURN VARCHAR2
82 --
83 FUNCTION city_region_postal(
84 city in varchar2,
85 region in varchar2,
86 postal_code in varchar2)
87 RETURN VARCHAR2;
88
89 -- define pragma so function can be used in selects
90 PRAGMA RESTRICT_REFERENCES (city_region_postal, WNDS, WNPS);
91
92 END WSH_CORE;