1 PACKAGE CS_STD AUTHID CURRENT_USER as
2 /* $Header: csxcstds.pls 120.4.12020000.3 2013/01/16 13:39:22 spamujul ship $ */
3 --
4 --
5 --
6 --
7 procedure Get_Default_Values(flex_code IN VARCHAR2 DEFAULT 'MSTK',
8 mfg_org_id IN OUT NOCOPY NUMBER,
9 appl_short_name IN OUT NOCOPY VARCHAR2);
10
11 procedure Get_Default_Values(flex_code IN VARCHAR2 DEFAULT 'MSTK',
12 mfg_org_id IN OUT NOCOPY NUMBER,
13 mfg_org_name IN OUT NOCOPY VARCHAR2,
14 appl_short_name IN OUT NOCOPY VARCHAR2);
15
16 procedure Get_Default_Values(order_by_code IN VARCHAR2,
17 order_by_lookup_type IN VARCHAR2,
18 flex_code IN VARCHAR2 DEFAULT 'MSTK',
19 mfg_org_id IN OUT NOCOPY NUMBER,
20 appl_short_name IN OUT NOCOPY VARCHAR2,
21 order_by IN OUT NOCOPY VARCHAR2);
22
23 procedure Get_Default_Values(order_by_code IN VARCHAR2,
24 order_by_lookup_type IN VARCHAR2,
25 flex_code IN VARCHAR2 DEFAULT 'MSTK',
26 mfg_org_id IN OUT NOCOPY NUMBER,
27 appl_short_name IN OUT NOCOPY VARCHAR2,
28 order_by IN OUT NOCOPY VARCHAR2,
29 order_type IN VARCHAR2,
30 order_type_id IN OUT NOCOPY NUMBER,
31 day_uom_code IN VARCHAR2,
32 day_uom IN OUT NOCOPY VARCHAR2,
33 month_uom_code IN VARCHAR2,
34 month_uom IN OUT NOCOPY VARCHAR2 );
35
36 --
37 --
38 --Get the coterminated end date. It assumes that p_cot_day_mth
39 --is in American English DD-MON format. (even though this is not
40 --NLS compliant
41 -- Commented the function because it not GSCC complaint
42
43 /* function get_coterminated_end_dt
44 (
45 p_cot_day_mth varchar2,
46 p_start_dt date default sysdate
47 ) return date;
48 pragma RESTRICT_REFERENCES (get_coterminated_end_dt,WNDS,WNPS);
49 --
50
51 */
52 --Get the contact's primary phone#.
53 function get_contact_phone
54 (
55 p_contact_id number
56 ) return varchar2;
57 pragma RESTRICT_REFERENCES (get_contact_phone,WNDS,WNPS);
58 --
59 --
60 --Get the item's revision description.
61 --If p_error_flag is 'FALSE', then a NULL is returned if the revision is
62 --invalid. If p_error_flag is 'TRUE', the NO_DATA_FOUND exception is raised
63 --if the revision is invalid, and it is upto the calling code to handle it.
64 function get_item_rev_desc
65 (
66 p_org_id number,
67 p_inv_item_id number,
68 p_revision varchar2,
69 p_error_flag varchar2 default 'TRUE'
70 ) return varchar2;
71 pragma RESTRICT_REFERENCES (get_item_rev_desc,WNDS,WNPS);
72 --
73 --
74 --Get the site_use_id's location.
75 --If p_error_flag is 'FALSE', then a NULL is returned if the site_use is
76 --invalid. If p_error_flag is 'TRUE', the NO_DATA_FOUND exception is raised
77 --if the site_use is invalid, and it is upto the calling code to handle it.
78 function get_site_use_location
79 (
80 p_site_use_id number,
81 p_error_flag varchar2 default 'TRUE'
82 ) return varchar2;
83 pragma RESTRICT_REFERENCES (get_site_use_location,WNDS,WNPS);
84 --
85 --
86 --Get the customer name.
87 --If p_error_flag is 'FALSE', then a NULL is returned if the PK is
88 --invalid. If p_error_flag is 'TRUE', the NO_DATA_FOUND exception is raised
89 --if the PK is invalid, and it is upto the calling code to handle it.
90 function get_cust_name
91 (
92 p_customer_id number,
93 p_error_flag varchar2 default 'TRUE'
94 ) return varchar2;
95 pragma RESTRICT_REFERENCES (get_cust_name,WNDS,WNPS);
96 --
97 --
98 --Get the comma-separated item_ids of the attached warranties on an item,
99 --as on p_war_date. The Item-Validation-Organization of the attached
100 --warranty is the same as the item's.
101 --Note: Used by CSOEBAT and CSXSUDCP form as of 1/29/97.
102 function get_war_item_ids
103 (
104 p_organization_id number,
105 p_inventory_item_id number,
106 p_war_date date default sysdate
107 ) return varchar2;
108 -- Bug 4321391. removed pragma restriction because bom_bill_of_materials view
109 -- uses fnd_global
110 --pragma RESTRICT_REFERENCES (get_war_item_ids,WNDS,WNPS);
111 --
112 --
113 --Get the system's name.
114 --If p_error_flag is 'FALSE', then a NULL is returned if the PK is
115 --invalid. If p_error_flag is 'TRUE', the NO_DATA_FOUND exception is raised
116 --if the PK is invalid, and it is upto the calling code to handle it.
117 function get_system_name
118 (
119 p_system_id number,
120 p_error_flag varchar2 default 'TRUE'
121 ) return varchar2;
122 pragma RESTRICT_REFERENCES (get_system_name,WNDS,WNPS);
123 --
124 --
125 --
126 -- This function returns Y or N for warranty attached to a customer
127 -- product_id
128 function warranty_exists
129 (
130 cp_id NUMBER
131 ) return VARCHAR2 ;
132 pragma RESTRICT_REFERENCES (warranty_exists,WNDS,WNPS);
133
134 procedure Get_Primary_Address(x_id NUMBER,
135 x_site_use_code VARCHAR2,
136 x_location OUT NOCOPY VARCHAR2,
137 x_site_use_id OUT NOCOPY NUMBER,
138 x_address1 OUT NOCOPY VARCHAR2,
139 x_address2 OUT NOCOPY VARCHAR2,
140 x_address3 OUT NOCOPY VARCHAR2,
141 error_flag OUT NOCOPY NUMBER) ;
142
143 -- CS_Get_Serviced_Status
144 FUNCTION CS_Get_Serviced_Status
145 ( X_CP_ID IN NUMBER
146 ) RETURN VARCHAR2;
147 pragma RESTRICT_REFERENCES (cs_get_serviced_status,WNDS,WNPS);
148
149 /******
150 procedure Output_Messages( p_return_status VARCHAR2,
151 p_msg_count NUMBER) ;
152
153 ******/
154 procedure Get_Address_from_id(x_id NUMBER,
155 x_location OUT NOCOPY VARCHAR2,
156 x_address1 OUT NOCOPY VARCHAR2,
157 x_address2 OUT NOCOPY VARCHAR2,
158 x_address3 OUT NOCOPY VARCHAR2,
159 error_flag OUT NOCOPY NUMBER) ;
160
161 -- This function returns the next entry in a periodic cycle.
162 -- As of 9/1/98, only 12 mth periods are supported. Thus, on subsequent
163 -- invocations, this functions currently returns 1, 2, ... 12, 1, 2, ...
164 -- p_reset = 1 will reset cycle.
165 function GetNextValInPeriod
166 (
167 p_reset NUMBER
168 ) return number ;
169 pragma RESTRICT_REFERENCES (GetNextValInPeriod, WNDS, RNDS);
170
171 -- This function returns the item category of an item in the OE
172 -- category set.
173 function GetItemCategory
174 (
175 p_inv_item_id number,
176 p_inv_orgn_id number
177 ) return varchar2;
178 pragma RESTRICT_REFERENCES (GetItemCategory, WNDS, WNPS);
179
180 FUNCTION SITE_USE_ADDRESS(site_id IN NUMBER) RETURN VARCHAR2 ;
181
182 -- This function returns the "inventory organization" ID (or whats also
183 -- called the "warehouse" ID that the Service suite of products should
184 -- use for validating items
185 function Get_Item_Valdn_Orgzn_ID return number;
186 -- pragma RESTRICT_REFERENCES (Get_Item_Valdn_Orgzn_ID, WNDS, WNPS);
187 pragma RESTRICT_REFERENCES (Get_Item_Valdn_Orgzn_ID, WNDS);
188
189 /* The Following Function will take address fields and Format them based on
190 HZ_FORMAT_PUB. In case of error, it returns a simple concatenation of fields.*/
191
192
193 FUNCTION format_address( address_style IN VARCHAR2,
194 address1 IN VARCHAR2,
195 address2 IN VARCHAR2,
196 address3 IN VARCHAR2,
197 address4 IN VARCHAR2,
198 city IN VARCHAR2,
199 county IN VARCHAR2,
200 state IN VARCHAR2,
201 province IN VARCHAR2,
202 postal_code IN VARCHAR2,
203 territory_short_name IN VARCHAR2,
204 country_code IN VARCHAR2 default NULL,
205 customer_name IN VARCHAR2 default NULL,
206 first_name IN VARCHAR2 default NULL,
207 last_name IN VARCHAR2 default NULL,
208 mail_stop IN VARCHAR2 default NULL,
209 default_country_code IN VARCHAR2 default NULL,
210 default_country_desc IN VARCHAR2 default NULL,
211 print_home_country_flag IN VARCHAR2 default NULL,
212 print_default_attn_flag IN VARCHAR2 default NULL,
213 width IN NUMBER default NULL,
214 height_min IN NUMBER default NULL,
215 height_max IN NUMBER default NULL
216 )return VARCHAR2;
217 --pragma RESTRICT_REFERENCES (format_address, WNDS,WNPS);
218
219 FUNCTION format_address_concat( address_style IN VARCHAR2,
220 address1 IN VARCHAR2,
221 address2 IN VARCHAR2,
222 address3 IN VARCHAR2,
223 address4 IN VARCHAR2,
224 city IN VARCHAR2,
225 county IN VARCHAR2,
226 state IN VARCHAR2,
227 province IN VARCHAR2,
228 postal_code IN VARCHAR2,
229 territory_short_name IN VARCHAR2
230 )return VARCHAR2 ;
231 pragma RESTRICT_REFERENCES (format_address_concat, WNDS, WNPS);
232
233 -- Added for 12.1.2
234 function return_primary_phone
235 (
236 party_id number
237 ) return varchar2;
238
239 --bug 11830221
240 function return_transpose_phone
241 (
242 party_id number
243 ) return varchar2;
244
245 function check_onetime
246 (
247 incident_location_id IN number
248 ) return varchar2;
249
250 function CS_Get_Resource_Phone_Email
251 ( p_resource_id IN NUMBER,
252 contact_type in varchar2
253 ) return varchar2;
254 FUNCTION GetProfileLastUpdate(p_party_id NUMBER,
255 p_level VARCHAR2,
256 p_account_id NUMBER DEFAULT NULL,
257 p_site_id NUMBER DEFAULT NULL
258 )
259 RETURN DATE;
260
261 PROCEDURE GetDrillDownSQL(vblockID IN NUMBER DEFAULT NULL,
262 vPartyID IN NUMBER DEFAULT NULL,
263 vAccountID IN NUMBER DEFAULT NULL,
264 vpSiteID IN NUMBER DEFAULT NULL,
265 vLevel IN VARCHAR2 DEFAULT NULL,
266 vSql OUT NOCOPY VARCHAR2
267 );
268 END CS_STD;