DBA Data[Home] [Help]

PACKAGE: APPS.CS_STD

Source


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;