1 PACKAGE BOM_Globals AS
2 /* $Header: BOMSGLBS.pls 120.18.12000000.5 2007/07/20 10:44:55 deegupta ship $ */
3 /*#
4 * This API contains methods to populate the System Information Record with global data.
5 * This will store global data like User Id,Login Id,Program Application Id,Program Id etc
6 * to the System Information Record.These data are used for checking the access privileges of the
7 * user to the Business Object processed.This also stores differene flags like ECO_Impl,ECO_Cancl etc
8 * to set the status of the business object and its components.
9 * @rep:scope private
10 * @rep:product BOM
11 * @rep:compatibility S
12 * @rep:lifecycle active
13 * @rep:displayname Global API
14 */
15 /**************************************************************************
16 --
17 -- FILENAME
18 --
19 -- BOMSGLBS.pls
20 --
21 -- DESCRIPTION
22 --
23 -- Spec of package BOM_Globals
24 --
25 -- NOTES
26 --
27 -- HISTORY
28 --
29 -- 16-JUL-1999 Rahul Chitko Initial Creation
30 --
31 -- 07-MAY-2001 Refai Farook EAM related changes
32 --
33 -- 08-Apr-2003 snelloli Added Functions Get_Alternate Get_Structure_Type
34 ****************************************************************************/
35 G_OPR_CREATE CONSTANT VARCHAR2(30) := 'CREATE';
36 G_OPR_UPDATE CONSTANT VARCHAR2(30) := 'UPDATE';
37 G_OPR_DELETE CONSTANT VARCHAR2(30) := 'DELETE';
38 G_OPR_LOCK CONSTANT VARCHAR2(30) := 'LOCK';
39 G_OPR_NONE CONSTANT VARCHAR2(30) := NULL;
40 G_OPR_CANCEL CONSTANT VARCHAR2(30) := 'CANCEL';
41 G_RECORD_FOUND CONSTANT VARCHAR2(1) := 'F';
42 G_RECORD_NOT_FOUND CONSTANT VARCHAR2(1) := 'N';
43 G_MODEL CONSTANT NUMBER := 1;
44 G_OPTION_CLASS CONSTANT NUMBER := 2;
45 G_PLANNING CONSTANT NUMBER := 3;
46 G_STANDARD CONSTANT NUMBER := 4;
47 G_PRODUCT_FAMILY CONSTANT NUMBER := 5;
48 G_ECO_BO CONSTANT VARCHAR2(3) := 'ECO';
49 G_BOM_BO CONSTANT VARCHAR2(3) := 'BOM';
50 G_MASS_CHANGE CONSTANT VARCHAR2(10) := 'MASSCHANGE';
51 G_BOM_OBJ_TYPE CONSTANT VARCHAR2(30) := null; -- Added by hgelli
52 G_COMPS_LIMIT CONSTANT NUMBER := 9999999;
53 G_PKG_ST_TYPE_NAME CONSTANT VARCHAR2(30) := 'Packaging Hierarchy';
54 G_SKIP_BOMTBICX VARCHAR2(1) := 'N' ;
55 --bug:4162717 Alternate Bom Designator string for primary structure,
56 --dependency on oracle.apps.bom.common.util.BomConstants.PRIMARY_UI constant in java
57 G_PRIMARY_UI CONSTANT VARCHAR2(6) := '*NULL*';
58 G_BATCH_ID NUMBER :=NULL; --4306013
59 G_SHOW_IMPL_COMPS_ONLY VARCHAR2(1) := 'N';
60
61 --Flag to decide whether trigger BOMTBICX needs to fire or not.
62 -- Table type used to hold organization codes
63 TYPE OrgID_tbl_type IS TABLE OF NUMBER
64 INDEX BY BINARY_INTEGER;
65
66 -- This change is for the Performance testing logging
67 G_TIME_LOGGED NUM_VARRAY;
68 G_METHOD_LOGGED VARCHAR2_VARRAY;
69 G_TOP NUMBER := -1;
70 G_FLOW_ID NUMBER ;
71 G_STACK_SIZE CONSTANT NUMBER := 500;
72 G_PROFILE_ENABLED CONSTANT VARCHAR2(2) := '1';
73
74 TYPE SYSTEM_INFORMATION_REC_TYPE IS RECORD
75 ( Entity VARCHAR2(30) := NULL
76 , org_id NUMBER := NULL
77 , Eco_Name VARCHAR2(10) := NULL
78 , User_Id NUMBER := NULL
79 , Login_Id NUMBER := NULL
80 , Prog_AppId NUMBER := NULL
81 , Prog_Id NUMBER := NULL
82 , Request_Id NUMBER := NULL
83 , ECO_Impl BOOLEAN := NULL
84 , ECO_Cancl BOOLEAN := NULL
85 , WKFL_Process BOOLEAN := NULL
86 , ECO_Access BOOLEAN := NULL
87 , RITEM_Impl BOOLEAN := NULL
88 , RITEM_Cancl BOOLEAN := NULL
89 , RCOMP_Cancl BOOLEAN := NULL
90 , STD_Item_Access NUMBER := NULL
91 , MDL_Item_Access NUMBER := NULL
92 , PLN_Item_Access NUMBER := NULL
93 , OC_Item_Access NUMBER := NULL
94 , Bill_Sequence_Id NUMBER := NULL
95 , Current_Revision VARCHAR2(3) := NULL
96 , BO_Identifier VARCHAR2(3) := 'ECO'
97 , Unit_Effectivity BOOLEAN := FALSE
98 , Unit_Controlled_Item BOOLEAN := FALSE
99 , Unit_Controlled_Component BOOLEAN := FALSE
100 , Require_Item_Rev NUMBER := NULL -- based on profile
101 , debug_flag VARCHAR2(1) := 'N'
102 , routing_sequence_id NUMBER := NULL
103 , lot_number VARCHAR2(30) := NULL
104 , from_wip_entity_id NUMBER := NULL
105 , to_wip_entity_id NUMBER := NULL
106 , from_cum_qty NUMBER := NULL
107 , eco_for_production NUMBER := 2
108 , new_routing_revision VARCHAR2(30) := NULL
109 , assembly_item_id NUMBER := NULL
110 , validate_for_plm VARCHAR2(1) := 'N'
111 );
112 /*#
113 * This method initializes the System Information Record.It initializes
114 * User_Id, Login_Id, Prog_Appid, Prog_Id in System_Information record.It also
115 * pulls in values of profiles ENG: Standard Item Access, ENG: Model Item Access
116 * and ENG: Planning Item Access into STD_Item_Access, MDL_Item_Access and PLN_Item_Access respectively.
117 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
118 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
119 * @param x_return_status IN OUT NOCOPY Return Status
120 * @rep:scope public
121 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
122 * @rep:compatibility S
123 * @rep:lifecycle active
124 * @rep:displayname Initialize System Info Record
125 */
126 PROCEDURE Init_System_Info_Rec
127 ( x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
128 , x_return_status IN OUT NOCOPY VARCHAR2
129 );
130 /*#
131 * This function returns the information stored in the Systen
132 * Information Record.System Information Record holds User_Id, Login_Id, Prog_Appid, Prog_Id
133 * The System Information Record also conatins profile information like profiles ENG: Standard Item Access, ENG: Model Item Access
134 * and ENG: Planning Item Access into STD_Item_Access, MDL_Item_Access and PLN_Item_Access
135 * @return System Information Record
136 * @rep:scope public
137 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
138 * @rep:compatibility S
139 * @rep:lifecycle active
140 * @rep:displayname Get System Information
141 */
142 FUNCTION Get_System_Information
143 RETURN Bom_Globals.System_Information_Rec_Type;
144
145 /*#
146 * This method sets the System Information in the System Information
147 * Record.This sets User_Id, Login_Id, Prog_Appid, Prog_Id in System_Information record
148 * and profile values like ENG: Standard Item Access, ENG: Model Item Access
149 * and ENG: Planning Item Access into STD_Item_Access, MDL_Item_Access and PLN_Item_Access
150 * @param p_system_information_rec IN input System Information Record
151 * @paraminfo {@rep:innertype Bom_Globals.System_Information_Rec_Type}
152 * @rep:scope private
153 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
154 * @rep:compatibility S
155 * @rep:lifecycle active
156 * @rep:displayname Set System Information
157 */
158 PROCEDURE Set_System_Information
159 ( p_system_information_rec IN
160 Bom_Globals.System_Information_Rec_Type);
161 /*#
162 * This method sets the Bill Sequence Id.Bill Sequence Id can be used for
163 * identifying a unique BOM Header Record.This procedure sets the Bill Sequence
164 * Id for the BOM Header imported.It sets the value in the System Information Record
165 * @param p_bill_sequence_id IN Bill Sequence Id
166 * @rep:scope private
167 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
168 * @rep:compatibility S
169 * @rep:lifecycle active
170 * @rep:displayname Set Bill Sequence Id
171 */
172 PROCEDURE Set_Bill_Sequence_id
173 ( p_bill_sequence_id IN NUMBER);
174 /*#
175 * This function returns the Bill Sequence Id for the
176 * Bom Header Record.Bill Sequence Id can uniquely identify
177 * a Bom Header Record.Function returns the value in the System
178 * Information Record.Bill Sequence Id links the Bom Structure Header with the
179 * Components.
180 * @return Bill Sequence Id
181 * @rep:scope private
182 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
183 * @rep:compatibility S
184 * @rep:lifecycle active
185 * @rep:displayname Get Bill Sequence Id
186 */
187
188 FUNCTION Get_Bill_Sequence_id RETURN NUMBER;
189
190 /*#
191 * This method sets the Entity Name.The Entity Name is
192 * stored in the System Information Record.The Entity Name is
193 * a user friendly name to the Business Object processed
194 * @param p_entity IN Entity Name
195 * @rep:scope private
196 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
197 * @rep:compatibility S
198 * @rep:lifecycle active
199 * @rep:displayname Set Entity Name
200 */
201 PROCEDURE Set_Entity
202 ( p_entity IN VARCHAR2);
203 /*#
204 * This function will return the Entity Name.The Entity Name is
205 * obtained from the System Information Record.
206 * @return Entity Name
207 * @rep:scope private
208 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
209 * @rep:compatibility S
210 * @rep:lifecycle active
211 * @rep:displayname Get Entity Name
212 */
213
214 FUNCTION Get_Entity RETURN VARCHAR2;
215 /*#
216 * This method sets the Organization Id.It sets the value of
217 * Oganization Id attribute in the System Information Record.
218 * @param p_org_id IN Organization Id
219 * @rep:scope private
220 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
221 * @rep:compatibility S
222 * @rep:lifecycle active
223 * @rep:displayname Set Organization Id
224 */
225 PROCEDURE Set_Org_id
226 ( p_org_id IN NUMBER);
227
228 /*#
229 * This function retrieves the Organization Id.It gets the value of
230 * Oganization Id attribute from the System Information Record.
231 * @return Organization Id
232 * @rep:scope private
233 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
234 * @rep:compatibility S
235 * @rep:lifecycle active
236 * @rep:displayname Get Organization Id
237 */
238 FUNCTION Get_Org_id RETURN NUMBER;
239 PRAGMA RESTRICT_REFERENCES(Get_Org_id, WNDS);
240 /*#
241 * This method sets the Engineering ChangeOrder Name.It sets the value of
242 * ECO name attribute in the System Information Record.
243 * @param p_eco_name IN ECO Name
244 * @rep:scope private
245 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
246 * @rep:compatibility S
247 * @rep:lifecycle active
248 * @rep:displayname Set ECO Name
249 */
250 PROCEDURE Set_Eco_Name
251 ( p_eco_name IN VARCHAR2);
252
253 /*#
254 * This function retrieves the ECO Name.It gets the value of
255 * ECO Name attribute from the System Information Record.
256 * @return ECO Name
257 * @rep:scope private
258 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
259 * @rep:compatibility S
260 * @rep:lifecycle active
261 * @rep:displayname Get ECO Name
262 */
263 FUNCTION Get_Eco_Name RETURN VARCHAR2;
264 /*#
265 * This method sets the User Id value.It sets the value of
266 * User Id attribute in the System Information Record.
267 * @param p_user_id IN User Id
268 * @rep:scope private
269 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
270 * @rep:compatibility S
271 * @rep:lifecycle active
272 * @rep:displayname Set User Id
273 */
274
275 PROCEDURE Set_User_Id
276 ( p_user_id IN NUMBER);
277
278 /*#
279 * This function retrieves the User Id.It gets the value of
280 * User Id attribute from the System Information Record.
281 * @return User Id
282 * @rep:scope private
283 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
284 * @rep:compatibility S
285 * @rep:lifecycle active
286 * @rep:displayname Get User Id
287 */
288 FUNCTION Get_User_ID RETURN NUMBER;
289 PRAGMA RESTRICT_REFERENCES(Get_User_Id, WNDS);
290
291 /*#
292 * This method sets the Login Id value.It sets the value of
293 * Login Id attribute in the System Information Record.
294 * @param p_login_id IN Login Id
295 * @rep:scope private
296 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
297 * @rep:compatibility S
298 * @rep:lifecycle active
299 * @rep:displayname Set Login Id
300 */
301 PROCEDURE Set_Login_Id
302 ( p_login_id IN NUMBER );
303
304 /*#
305 * This function retrieves the Login Id.It gets the value of
306 * Login Id attribute from the System Information Record.
307 * @return Login Id
308 * @rep:scope private
309 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
310 * @rep:compatibility S
311 * @rep:lifecycle active
312 * @rep:displayname Get Login Id
313 */
314 FUNCTION Get_Login_Id RETURN NUMBER;
315 PRAGMA RESTRICT_REFERENCES(Get_Login_Id, WNDS);
316
317 /*#
318 * This method sets the Program Application Id value.It sets the value of
319 * Program Application Id attribute in the System Information Record.
320 * @param p_prog_Appid IN Program Applcation Id
321 * @rep:scope private
322 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
323 * @rep:compatibility S
324 * @rep:lifecycle active
325 * @rep:displayname Set Program Application Id
326 */
327 PROCEDURE Set_Prog_AppId
328 ( p_prog_Appid IN NUMBER );
329
330 /*#
331 * This function retrieves the Program Application Id.It gets the value of
332 * Program Application Id attribute from the System Information Record.
333 * @return Program Application Id
334 * @rep:scope private
335 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
336 * @rep:compatibility S
337 * @rep:lifecycle active
338 * @rep:displayname Get Program Application Id
339 */
340 FUNCTION Get_Prog_AppId RETURN NUMBER;
341 PRAGMA RESTRICT_REFERENCES(Get_Prog_AppId, WNDS);
342
343 /*#
344 * This method sets the Program Id value.It sets the value of
345 * Program Id attribute in the System Information Record.
346 * @param p_prog_id IN Program Id
347 * @rep:scope private
348 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
349 * @rep:compatibility S
350 * @rep:lifecycle active
351 * @rep:displayname Set Program Id
352 */
353 PROCEDURE Set_Prog_Id
354 ( p_prog_id IN NUMBER );
355
356 /*#
360 * @rep:scope private
357 * This function retrieves the Program Id.It gets the value of
358 * Program Id attribute from the System Information Record.
359 * @return Program Id
361 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
362 * @rep:compatibility S
363 * @rep:lifecycle active
364 * @rep:displayname Get Program Id
365 */
366 FUNCTION Get_Prog_Id RETURN NUMBER;
367 PRAGMA RESTRICT_REFERENCES(Get_Prog_Id, WNDS);
368
369 /*#
370 * This method sets the Request Id value.It sets the value of
371 * Request Id attribute in the System Information Record.
372 * @param p_request_id IN Request Id
373 * @rep:scope private
374 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
375 * @rep:compatibility S
376 * @rep:lifecycle active
377 * @rep:displayname Set Request Id
378 */
379 PROCEDURE Set_Request_Id
380 ( p_request_id IN NUMBER );
381
382 /*#
383 * This function retrieves the Request Id.It gets the value of
384 * Request Id attribute from the System Information Record.
385 * @return Request Id
386 * @rep:scope private
387 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
388 * @rep:compatibility S
389 * @rep:lifecycle active
390 * @rep:displayname Get Request Id
391 */
392 FUNCTION Get_Request_id RETURN NUMBER;
393 PRAGMA RESTRICT_REFERENCES(Get_Request_Id, WNDS);
394
395 /*#
396 * This method sets the ECO_Impl value.It sets the value of
397 * ECO_Impl attribute as true or false based on the implemented status of ECO
398 * in the System Information Record.
399 * @param p_eco_impl IN Request Id
400 * @rep:scope private
401 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
402 * @rep:compatibility S
403 * @rep:lifecycle active
404 * @rep:displayname Set ECO Implemented
405 */
406 PROCEDURE Set_Eco_Impl
407 ( p_eco_impl IN BOOLEAN );
408
409 /*#
410 * This function returns true or false based on the implemented
411 * status of ECO_Impl.Returns true if ECO is implemeted and fasle if
412 * ECO is not Implemeted.
413 * @return Boolean
414 * @rep:scope private
415 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
416 * @rep:compatibility S
417 * @rep:lifecycle active
418 * @rep:displayname Is ECO Implemented
419 */
420 FUNCTION Is_Eco_Impl RETURN BOOLEAN;
421
422 /*#
423 * This method sets the ECO_Cancel value.It sets true if ECO
424 * is cancelled and false if ECO is not cancelled
425 * in the System Information Record.
426 * @param p_eco_cancl IN Boolean flag for indicating whether ECO is cancelled or not
427 * @rep:scope private
428 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
429 * @rep:compatibility S
430 * @rep:lifecycle active
431 * @rep:displayname Set ECO Cancel
432 */
433 PROCEDURE Set_Eco_Cancl
434 ( p_eco_cancl IN BOOLEAN );
435
436 /*#
437 * This function returns true or false based on the
438 * status of ECO_Cancl.Returns true if ECO is cancelled and fasle if
439 * ECO is not Cancelled.
440 * @return Boolean
441 * @rep:scope private
442 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
443 * @rep:compatibility S
444 * @rep:lifecycle active
445 * @rep:displayname Is ECO Cancelled
446 */
447 FUNCTION Is_Eco_Cancl RETURN BOOLEAN;
448
449 /*#
450 * This method sets the Work Flow process attribute.It sets true or
451 * false value for the Work Flow Process attribute in the System Information
452 * Record
453 * @param p_wkfl_process IN Boolean flag for indicating whether a Work Flow Process or not
454 * @rep:scope private
455 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
456 * @rep:compatibility S
457 * @rep:lifecycle active
458 * @rep:displayname Set Work Flow Process
459 */
460 PROCEDURE Set_Wkfl_Process
461 ( p_wkfl_process IN BOOLEAN );
462
463 /*#
464 * This function returns true or false based on the
465 * value of Work Flow process attribute in the System Information Record.
466 * Returns true if a Work Flow Process exists in ECO and false otherwise
467 * @return Boolean
468 * @rep:scope private
469 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
470 * @rep:compatibility S
471 * @rep:lifecycle active
472 * @rep:displayname Is Work Flow Process
473 */
474 FUNCTION Is_Wkfl_Process RETURN BOOLEAN;
475
476 /*#
477 * This method will set the value of the system information record
478 * attribute Eco_Access. True if the user has access to the ECO
479 * and false otherwise.
480 * @param p_eco_access IN Boolean flag for indicating the ECO acess values
481 * @rep:scope private
482 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
483 * @rep:compatibility S
484 * @rep:lifecycle active
485 * @rep:displayname Set ECO Acess
486 */
487 PROCEDURE Set_Eco_Access
488 ( p_eco_access IN BOOLEAN );
489
490 /*#
491 * This function returns true or false based on the
492 * value of ECO acess attribute in the System Information Record.
493 * Returns true if ECO acees is true and false otherwise
494 * @return Boolean
495 * @rep:scope private
499 * @rep:displayname Is ECO Acess
496 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
497 * @rep:compatibility S
498 * @rep:lifecycle active
500 */
501 FUNCTION Is_Eco_Access RETURN BOOLEAN;
502
503 /*#
504 * This method will set the value of RItem_Impl attribute.It sets
505 * value based on whether the Revised Item is implemented or not in
506 * the system information record
507 * @param p_ritem_impl IN Revision Item Implemented Flag
508 * @rep:scope private
509 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
510 * @rep:compatibility S
511 * @rep:lifecycle active
512 * @rep:displayname Set RItem Implemented
513 */
514 PROCEDURE Set_RItem_Impl
515 ( p_ritem_impl IN BOOLEAN );
516
517 /*#
518 * This function returns true or false based on the
519 * value of Ritem_Impl attribute in the System Information Record.
520 * Returns true if Revision Item is implemented and false otherwise
521 * @return Boolean
522 * @rep:scope private
523 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
524 * @rep:compatibility S
525 * @rep:lifecycle active
526 * @rep:displayname Is Rev Item Implemented
527 */
528 FUNCTION Is_RItem_Impl RETURN BOOLEAN;
529
530 /*#
531 * This method will set the value of RItem_Cancel attribute.It sets
532 * value based on whether the Revised Item is cancelled or not, in
533 * the system information record
534 * @param p_ritem_cancl IN Revision Item Cancelled Flag
535 * @rep:scope private
536 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
537 * @rep:compatibility S
538 * @rep:lifecycle active
539 * @rep:displayname Set Revised Item Cancel
540 */
541 PROCEDURE Set_RItem_Cancl
542 ( p_ritem_cancl IN BOOLEAN );
543
544 /*#
545 * This function returns true or false based on the
546 * value of Ritem_Cancl attribute in the System Information Record.
547 * Returns true if Revision Item is cancelled and false otherwise
548 * @return Boolean
549 * @rep:scope private
550 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
551 * @rep:compatibility S
552 * @rep:lifecycle active
553 * @rep:displayname Is Rev Item Cancelled
554 */
555 FUNCTION Is_RItem_Cancl RETURN BOOLEAN;
556
557 /*#
558 * This method will set the value of RComp_Cancel attribute.It sets
559 * value based on whether the Revision Component is cancelled or not, in
560 * the system information record
561 * @param p_rcomp_cancl IN Revision Component Cancelled Flag
562 * @rep:scope private
563 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
564 * @rep:compatibility S
565 * @rep:lifecycle active
566 * @rep:displayname Set Revised Component Cancel
567 */
568 PROCEDURE Set_RComp_Cancl
569 ( p_rcomp_cancl IN BOOLEAN );
570
571 /*#
572 * This function returns true or false based on the
573 * value of RComp_Cancl attribute in the System Information Record.
574 * Returns true if Revision Component is cancelled and false otherwise
575 * @return Boolean
576 * @rep:scope private
577 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
578 * @rep:compatibility S
579 * @rep:lifecycle active
580 * @rep:displayname Is Rev Component Cancelled
581 */
582 FUNCTION Is_RComp_Cancl RETURN BOOLEAN;
583
584 /*#
585 * This method will set the value of Std_Item_Acess attribute.It sets
586 * value based on whether the Standard Item is accessible not, in
587 * the system information record
588 * @param p_std_item_access IN Standard Item Access Flag
589 * @rep:scope private
590 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
591 * @rep:compatibility S
592 * @rep:lifecycle active
593 * @rep:displayname Set Standard Item Access
594 */
595 PROCEDURE Set_Std_Item_Access
596 ( p_std_item_access IN NUMBER );
597
598 /*#
599 * This function returns the value of Std_Item_Access
600 * attribute.It retrieves the value from the System Information Record
601 * @return Standard Item Access Value
602 * @rep:scope private
603 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
604 * @rep:compatibility S
605 * @rep:lifecycle active
606 * @rep:displayname Get Std Item Access
607 */
608 FUNCTION Get_Std_Item_Access RETURN NUMBER;
609
610 /*#
611 * This method will set the value of Mdl_Item_Access attribute.It sets
612 * value based on whether the Model Item is accessible not, in
613 * the system information record
614 * @param p_mdl_item_access IN Model Item Access Flag
615 * @rep:scope private
616 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
617 * @rep:compatibility S
618 * @rep:lifecycle active
619 * @rep:displayname Set Model Item Access
620 */
621 PROCEDURE Set_Mdl_Item_Access
622 ( p_mdl_item_access IN NUMBER );
623
624 /*#
625 * This function returns the value of Mdl_Item_Access
626 * attribute.It retrieves the value from the System Information Record
627 * @return Model Item Access Value
628 * @rep:scope private
629 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
630 * @rep:compatibility S
631 * @rep:lifecycle active
635
632 * @rep:displayname Get Model Item Access
633 */
634 FUNCTION Get_Mdl_Item_Access RETURN NUMBER;
636 /*#
637 * This method will set the value of Pln_Item_Access attribute.It sets
638 * value based on whether the Planning Item is accessible not, in
639 * the system information record
640 * @param p_Pln_item_access IN Planning Item Access Flag
641 * @rep:scope private
642 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
643 * @rep:compatibility S
644 * @rep:lifecycle active
645 * @rep:displayname Set Planning Item Access
646 */
647 PROCEDURE Set_Pln_Item_Access
648 ( p_Pln_item_access IN NUMBER );
649
650 /*#
651 * This function returns the value of Pln_Item_Access
652 * attribute.It retrieves the value from the System Information Record
653 * @return Planning Item Access Value
654 * @rep:scope private
655 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
656 * @rep:compatibility S
657 * @rep:lifecycle active
658 * @rep:displayname Get Planning Item Access
659 */
660 FUNCTION Get_Pln_Item_Access RETURN NUMBER;
661
662 /*#
663 * This method will set the value of OC_Item_Access attribute.It sets
664 * value based on whether the Option Class Item is accessible not, in
665 * the system information record
666 * @param p_oc_item_access IN Option Class Item Access Flag
667 * @rep:scope private
668 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
669 * @rep:compatibility S
670 * @rep:lifecycle active
671 * @rep:displayname Set Option Calss Item Access
672 */
673 PROCEDURE Set_OC_Item_Access
674 ( p_oc_item_access IN NUMBER );
675
676 /*#
677 * This function returns the value of OC_Item_Access
678 * attribute.It retrieves the value from the System Information Record
679 * whether the Option Class Item is accessible or not
680 * @return Option Calss Item Access Value
681 * @rep:scope private
682 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
683 * @rep:compatibility S
684 * @rep:lifecycle active
685 * @rep:displayname Get Option Class Item Access
686 */
687 FUNCTION Get_OC_Item_Access RETURN NUMBER;
688
689 /*#
690 * This method will set the value of Current Revision attribute.It sets
691 * value of Current Revision attribute in
692 * the system information record
693 * @param p_current_revision IN Crrent Revision
694 * @rep:scope private
695 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
696 * @rep:compatibility S
697 * @rep:lifecycle active
698 * @rep:displayname Set Current Revision
699 */
700 PROCEDURE Set_Current_Revision
701 ( p_current_revision IN VARCHAR2 );
702
703 /*#
704 * This function returns the value of Crrent Revision
705 * attribute.It retrieves the value from the System Information Record
706 * @return Current Revision
707 * @rep:scope private
708 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
709 * @rep:compatibility S
710 * @rep:lifecycle active
711 * @rep:displayname Get Current Revision
712 */
713 FUNCTION Get_Current_Revision RETURN VARCHAR2;
714
715 /*#
716 * This Procedure will set the value of Business Object Identifier.It sets
717 * value of the Identifier in the system information record and this value is checked
718 * at the time of import
719 * @param p_bo_identifier IN Business Object Identifier
720 * @rep:scope private
721 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
722 * @rep:compatibility S
723 * @rep:lifecycle active
724 * @rep:displayname Set BO Identifier
725 */
726 PROCEDURE Set_BO_Identifier
727 ( p_bo_identifier IN VARCHAR2 );
728
729 /*#
730 * This function returns the value of Business Object Identifier
731 * It retrieves the value from the System Information Record
732 * @return Business Object Identifier
733 * @rep:scope private
734 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
735 * @rep:compatibility S
736 * @rep:lifecycle active
737 * @rep:displayname Get BO Identifier
738 */
739 FUNCTION Get_BO_Identifier RETURN VARCHAR2;
740
741 /*#
742 * This method will set the value of Unit Controlled Item Attribute.It sets
743 * value of the attribute in the system information record
744 * @param p_Unit_Controlled_Item IN Unit Controlled Item
745 * @rep:scope private
746 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
747 * @rep:compatibility S
748 * @rep:lifecycle active
749 * @rep:displayname Set Unit Controlled Item
750 */
751 PROCEDURE Set_Unit_Controlled_Item
752 ( p_Unit_Controlled_Item IN BOOLEAN);
753
754 /*#
755 * This method will set the value of Unit Controlled Item Attribute.It sets
756 * value of the attribute in the system information record
757 * @param p_inventory_item_id IN Inventory Item Id
758 * @param p_organization_id IN Organization Id
759 * @rep:scope private
760 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
761 * @rep:compatibility S
762 * @rep:lifecycle active
763 * @rep:displayname Set Unit Controlled Item
764 */
765 PROCEDURE Set_Unit_Controlled_Item
766 ( p_inventory_item_id IN NUMBER
770 * This function returns the value of the Unit Controlled Item attribute
767 , p_organization_id IN NUMBER);
768
769 /*#
771 * It retrieves the value from the System Information Record
772 * @return Unit Controlled Item
773 * @rep:scope private
774 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
775 * @rep:compatibility S
776 * @rep:lifecycle active
777 * @rep:displayname Get Unit Controlled Item
778 */
779 FUNCTION Get_Unit_Controlled_Item RETURN BOOLEAN;
780
781 /*#
782 * This method will set the value of Unit Controlled Component Attribute.It sets
783 * value of the attribute in the system information record
784 * @param p_Unit_Controlled_Component IN Unit Controlled Component
785 * @rep:scope private
786 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
787 * @rep:compatibility S
788 * @rep:lifecycle active
789 * @rep:displayname Set Unit Controlled Component
790 */
791 PROCEDURE Set_Unit_Controlled_Component
792 ( p_Unit_Controlled_Component IN BOOLEAN);
793 /*#
794 * This method will set the value of Unit Controlled Component Attribute.It sets
795 * value of the attribute in the system information record
796 * @param p_inventory_item_id IN Inventory Item Id
797 * @param p_organization_id IN Organization Id
798 * @rep:scope private
799 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
800 * @rep:compatibility S
801 * @rep:lifecycle active
802 * @rep:displayname Set Unit Controlled Component
803 */
804 PROCEDURE Set_Unit_Controlled_Component
805 ( p_inventory_item_id IN NUMBER
806 , p_organization_id IN NUMBER);
807
808 /*#
809 * This function returns the value of the Unit Controlled Component attribute
810 * It retrieves the value from the System Information Record
811 * @return Boolean
812 * @rep:scope private
813 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
814 * @rep:compatibility S
815 * @rep:lifecycle active
816 * @rep:displayname Get Unit Controlled Component
817 */
818 FUNCTION Get_Unit_Controlled_Component RETURN BOOLEAN;
819
820 /*#
821 * This method will set the value of Unit Effectivity Attribute.It sets
822 * value of the attribute in the system information record
823 * @param p_Unit_Effectivity IN Unit Effectivity
824 * @rep:scope private
825 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
826 * @rep:compatibility S
827 * @rep:lifecycle active
828 * @rep:displayname Set Unit Effectivity
829 */
830 PROCEDURE Set_Unit_Effectivity
831 ( p_Unit_Effectivity IN BOOLEAN );
832
833 /*#
834 * This function returns the value of the Unit Effectivity attribute
835 * It retrieves the value from the System Information Record
836 * @return Boolean
837 * @rep:scope private
838 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
839 * @rep:compatibility S
840 * @rep:lifecycle active
841 * @rep:displayname Get Unit Effecivity
842 */
843 FUNCTION Get_Unit_Effectivity RETURN BOOLEAN;
844
845 /*#
846 * This method will set the value of Require Item Rev attribute.It sets
847 * value of the attribute in the system information record
848 * @param p_Require_Rev IN Require Item Revision
849 * @rep:scope private
850 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
851 * @rep:compatibility S
852 * @rep:lifecycle active
853 * @rep:displayname Set Required Item Revision
854 */
855 PROCEDURE Set_Require_Item_Rev
856 ( p_Require_Rev IN NUMBER );
857
858 /*#
859 * This function returns the value of the Require Item Revision attribute
860 * It retrieves the value from the System Information Record
861 * @return Item Revision Required or not
862 * @rep:scope private
863 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
864 * @rep:compatibility S
865 * @rep:lifecycle active
866 * @rep:displayname Is Item Rev Required
867 */
868 FUNCTION Is_Item_Rev_Required RETURN NUMBER;
869
870 /*#
871 * This method will set the value of Routing Sequence Id attribute.It sets
872 * value of the attribute in the system information record
873 * @param p_routing_sequence_id IN Routing Sequence Id
874 * @rep:scope private
875 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
876 * @rep:compatibility S
877 * @rep:lifecycle active
878 * @rep:displayname Set Routing Sequence Id
879 */
880 PROCEDURE Set_Routing_Sequence_Id
881 ( p_routing_sequence_id IN NUMBER );
882
883 /*#
884 * This function returns the value of the Routing Sequence Id attribute
885 * It retrieves the value from the System Information Record
886 * @return Routing Sequence Id
887 * @rep:scope private
888 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
889 * @rep:compatibility S
890 * @rep:lifecycle active
891 * @rep:displayname Get Routing Sequence Id
892 */
893 FUNCTION Get_Routing_Sequence_Id RETURN NUMBER;
894
895 /*#
896 * This method will set the value of Lot Number attribute.It sets
897 * value of the attribute in the system information record
898 * @param p_lot_number IN Lot Number
899 * @rep:scope private
903 * @rep:displayname Set Lot Number
900 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
901 * @rep:compatibility S
902 * @rep:lifecycle active
904 */
905 PROCEDURE Set_Lot_Number
906 ( p_lot_number IN VARCHAR2 );
907
908 /*#
909 * This function returns the value of the Lot Number attribute
910 * It retrieves the value from the System Information Record
911 * @return Lot Number
912 * @rep:scope private
913 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
914 * @rep:compatibility S
915 * @rep:lifecycle active
916 * @rep:displayname Get Lot Number
917 */
918 FUNCTION Get_Lot_Number RETURN VARCHAR2;
919
920 /*#
921 * This method will set the value of From WIP Entity Id attribute.It sets
922 * value of the attribute in the system information record
923 * @param p_from_wip_entity_id IN From WIP Entity Id
924 * @rep:scope private
925 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
926 * @rep:compatibility S
927 * @rep:lifecycle active
928 * @rep:displayname Set From WIP Entity Id
929 */
930 PROCEDURE Set_From_Wip_Entity_Id
931 ( p_from_wip_entity_id IN NUMBER);
932
933 /*#
934 * This function returns the value of the From WIP Entity Id attribute
935 * It retrieves the value from the System Information Record
936 * @return From WIP Entity Id value
937 * @rep:scope private
938 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
939 * @rep:compatibility S
940 * @rep:lifecycle active
941 * @rep:displayname Get From WIP Entity Id
942 */
943 FUNCTION Get_From_Wip_Entity_Id RETURN NUMBER;
944
945 /*#
946 * This method will set the value of To WIP Entity Id attribute.It sets
947 * value of the attribute in the system information record
948 * @param p_to_wip_entity_id IN To WIP Entity Id
949 * @rep:scope private
950 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
951 * @rep:compatibility S
952 * @rep:lifecycle active
953 * @rep:displayname Set To WIP Entity Id
954 */
955 PROCEDURE Set_To_Wip_Entity_Id
956 ( p_to_wip_entity_id IN NUMBER);
957
958 /*#
959 * This function returns the value of the To WIP Entity Id attribute
960 * It retrieves the value from the System Information Record
961 * @return To WIP Entity Id Value
962 * @rep:scope private
963 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
964 * @rep:compatibility S
965 * @rep:lifecycle active
966 * @rep:displayname Get To WIP Entity Id
967 */
968 FUNCTION Get_To_Wip_Entity_Id RETURN NUMBER;
969
970 /*#
971 * This method will set the value of From_Cum_Qty attribute.It sets
972 * value of the attribute in the system information record
973 * @param p_from_cum_qty IN From Cum Qty
974 * @rep:scope private
975 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
976 * @rep:compatibility S
977 * @rep:lifecycle active
978 * @rep:displayname Set From Cum Qty
979 */
980 PROCEDURE Set_From_Cum_Qty
981 ( p_from_cum_qty IN NUMBER);
982
983 /*#
984 * This function returns the value of the From_Cum_Qty attribute
985 * It retrieves the value from the System Information Record
986 * @return From Cum Quantity
987 * @rep:scope private
988 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
989 * @rep:compatibility S
990 * @rep:lifecycle active
991 * @rep:displayname Get From Cum Qty
992 */
993 FUNCTION Get_From_Cum_Qty RETURN NUMBER;
994
995 /*#
996 * This method will set the value of Eco For Production attribute.It sets
997 * value of the attribute in the system information record
998 * @param p_eco_for_production IN Eco For Production
999 * @rep:scope private
1000 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1001 * @rep:compatibility S
1002 * @rep:lifecycle active
1003 * @rep:displayname Set Eco For Production
1004 */
1005 PROCEDURE Set_Eco_For_Production
1006 ( p_eco_for_production IN NUMBER);
1007
1008 /*#
1009 * This function returns the value of the Eco For Production attribute
1010 * It retrieves the value from the System Information Record
1011 * @return ECO For Production
1012 * @rep:scope private
1013 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1014 * @rep:compatibility S
1015 * @rep:lifecycle active
1019
1016 * @rep:displayname Get Eco For Production
1017 */
1018 FUNCTION Get_Eco_For_Production RETURN NUMBER;
1020 /*#
1021 * This method will set the value of New Routing Revision attribute.It sets
1022 * value of the attribute in the system information record
1023 * @param p_new_routing_revision IN New Routing Revision
1024 * @rep:scope private
1025 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1026 * @rep:compatibility S
1027 * @rep:lifecycle active
1028 * @rep:displayname Set New Routing Revision
1029 */
1030 PROCEDURE Set_New_Routing_Revision
1031 ( p_new_routing_revision IN VARCHAR2 );
1032
1033 /*#
1034 * This function returns the value of the New Routing Revision attribute
1035 * It gets the value in the System Information record.
1036 * @return New Routing Revision
1037 * @rep:scope private
1038 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1039 * @rep:compatibility S
1040 * @rep:lifecycle active
1041 * @rep:displayname Get New Routing Revision
1042 */
1043 FUNCTION Get_New_Routing_Revision RETURN VARCHAR2;
1044
1045
1046 /*#
1047 * This method will set the value of Request For Approval attribute.
1048 * @param p_change_notice IN Change Notice
1049 * @param p_organization_id IN Organization Id
1050 * @param x_err_text IN OUT NOCOPY output Error Text
1051 * @rep:scope private
1052 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1053 * @rep:compatibility S
1054 * @rep:lifecycle active
1055 * @rep:displayname Set Request For Approval
1056 */
1057 PROCEDURE Set_Request_For_Approval
1058 ( p_change_notice IN VARCHAR2
1059 , p_organization_id IN NUMBER
1060 , x_err_text IN OUT NOCOPY VARCHAR2
1061 );
1062
1063 PROCEDURE Check_Approved_For_Process
1064 ( p_change_notice IN VARCHAR2
1065 , p_organization_id IN NUMBER
1066 , x_processed IN OUT NOCOPY BOOLEAN
1067 , x_err_text IN OUT NOCOPY VARCHAR2
1068 );
1069
1070 /*#
1071 * This function returns the value of the Process Name attribute
1072 * @return Process Name
1073 * @rep:scope private
1074 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1075 * @rep:compatibility S
1076 * @rep:lifecycle active
1077 * @rep:displayname Get Process Name
1078 */
1079 FUNCTION Get_Process_Name RETURN VARCHAR2;
1080
1081 /*#
1082 * This method will Initialize the porcess name attribute .
1083 * @param p_change_order_type_id In Change Order Type Id
1084 * @param p_priority_code IN Priority Code
1085 * @param p_organization_id IN organization Id
1086 * @rep:scope private
1087 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1088 * @rep:compatibility S
1089 * @rep:lifecycle active
1090 * @rep:displayname Init Process Name
1091 */
1092 PROCEDURE Init_Process_Name
1093 ( p_change_order_type_id IN NUMBER
1094 , p_priority_code IN VARCHAR2
1095 , p_organization_id IN NUMBER
1096 );
1097
1098 /*#
1099 * This method will check the validity of the transaction type.The
1100 * transaction type should be create,updaet or delete.If teh transaction type
1101 * is not of these types then Standard Error is raised.
1102 * @param p_transaction_type IN Transaction type
1103 * @param p_entity IN Entity Name
1104 * @param p_entity_id IN Entity Id
1105 * @param x_valid IN OUT NOCOPY Validity flag
1106 * @param x_Mesg_Token_Tbl IN OUT NOCOPY Message token Table
1107 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
1108 * @rep:scope private
1109 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1110 * @rep:compatibility S
1111 * @rep:lifecycle active
1112 * @rep:displayname Transaction Type Validity
1113 */
1114 PROCEDURE Transaction_Type_Validity
1115 ( p_transaction_type IN VARCHAR2
1116 , p_entity IN VARCHAR2
1117 , p_entity_id IN VARCHAR2
1118 , x_valid IN OUT NOCOPY BOOLEAN
1119 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1120 );
1121 /*#
1122 * This method sets the debug flag value and enables Debug.Debug Messages will be
1123 * added based on the value of this debug flag
1124 * @param p_debug_flag IN Debug Flag
1125 * @rep:scope private
1126 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1127 * @rep:compatibility S
1128 * @rep:lifecycle active
1129 * @rep:displayname Set Debug
1130 */
1131 PROCEDURE Set_Debug
1132 ( p_debug_flag IN VARCHAR2
1133 );
1134
1135 /*#
1136 * This function will retrieve the debug flag value.
1137 * @return Debug Flag Value
1138 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1139 * @rep:compatibility S
1140 * @rep:lifecycle active
1141 * @rep:displayname Get Debug
1142 */
1143 FUNCTION Get_Debug RETURN VARCHAR2;
1144
1145 /*#
1146 * This method will set the value of Assembly Item Id attribute.
1147 * @param p_assembly_item_id IN Assembly Item Id
1148 * @rep:scope private
1149 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1150 * @rep:compatibility S
1154 PROCEDURE Set_Assembly_Item_id(p_assembly_item_id IN NUMBER);
1151 * @rep:lifecycle active
1152 * @rep:displayname Set Assembly Item Id
1153 */
1155
1156 /*#
1157 * This function returns the value of the Assembly Item Id attribute
1158 * @return Assembly Item Id
1159 * @rep:scope private
1160 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1161 * @rep:compatibility S
1162 * @rep:lifecycle active
1163 * @rep:displayname Get Assembly Item Id
1164 */
1165 FUNCTION Get_Assembly_Item_id RETURN NUMBER;
1166
1167
1168 /*#
1169 * This Procedure will set the value of Caller Type attribute.It sets
1170 * value of the attribute in the Control record
1171 * @param p_Caller_Type IN Caller Type
1172 * @rep:scope private
1173 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1174 * @rep:compatibility S
1175 * @rep:lifecycle active
1176 * @rep:displayname Set Caller Type
1177 */
1178 PROCEDURE Set_Caller_Type
1179 ( p_Caller_Type IN VARCHAR2 );
1180
1181 /*#
1182 * This function returns the value of the Caller Type attribute
1183 * It retrieves the value from the Control Record
1184 * @return Caller Type
1185 * @rep:scope private
1186 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1187 * @rep:compatibility S
1188 * @rep:lifecycle active
1189 * @rep:displayname Get Caller Type
1190 */
1191 FUNCTION Get_Caller_Type RETURN VARCHAR2;
1192
1193
1194 /*#
1195 * This function returns the value of the Structure Type attribute.
1196 * It will return the display name fot teh structure type.
1197 * @param p_bill_sequence_id IN Bill Sequence Id
1198 * @param p_organization_id IN Organization Id
1199 * @return Structure Type display name
1200 * @rep:scope private
1201 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1202 * @rep:compatibility S
1203 * @rep:lifecycle active
1204 * @rep:displayname Get Structure Type
1205 */
1206 FUNCTION Get_Structure_Type
1207 ( p_bill_sequence_id IN NUMBER
1208 , p_organization_id IN NUMBER
1209 )
1210 RETURN VARCHAR2;
1211
1212 /*#
1213 * This function returns the value of the Alternate BOM Designator attribute
1214 * @param p_bill_sequence_id IN Bill Sequence Id
1215 * @return Alternate BOM Designator
1216 * @rep:scope private
1217 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1218 * @rep:compatibility S
1219 * @rep:lifecycle active
1220 * @rep:displayname Get Alternate BOM Designator
1221 */
1222 FUNCTION Get_Alternate
1223 (p_bill_sequence_id NUMBER)
1224 RETURN VARCHAR2;
1225
1226 /*#
1227 * This function returns the value of the Item Type Meaning
1228 * @param p_item_type IN Item Type
1229 * @return Item Type Meaning
1230 * @rep:scope private
1231 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1232 * @rep:compatibility S
1233 * @rep:lifecycle active
1234 * @rep:displayname Get Item Type Meaning
1235 */
1236 FUNCTION get_item_type
1237 ( p_item_type IN VARCHAR2)
1238 RETURN VARCHAR2;
1239
1240 /*#
1241 * This function returns the Error or Warning Messages for
1242 * that Business Object.It Retrieves the message specified by
1243 * the messaeg name
1244 * @param p_application_id IN Application Id
1245 * @param p_message_name IN Message Name
1246 * @return Message
1247 * @rep:scope private
1248 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1249 * @rep:compatibility S
1250 * @rep:lifecycle active
1251 * @rep:displayname Retrieve Messsage
1252 */
1253 FUNCTION RETRIEVE_MESSAGE(
1254 p_application_id IN VARCHAR2
1255 , p_message_name IN VARCHAR2
1256 ) RETURN VARCHAR2;
1257 PRAGMA RESTRICT_REFERENCES(RETRIEVE_MESSAGE,WNDS);
1258
1259 /*Bug 5737158 Function to get concatenated segments. */
1260 FUNCTION Get_Concat_Segs(
1261 p_item_id IN NUMBER,
1262 p_org_id IN NUMBER
1263 ) RETURN VARCHAR2;
1264
1265 /*#
1266 * This function returns the name of the
1267 * Refence Designator.The Reference Designator is
1268 * Identified by the component Sequence id.
1269 * @param p_component_sequence_id IN Component Sequence Id
1270 * @return Reference Designator Name
1271 * @rep:scope private
1272 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1273 * @rep:compatibility S
1274 * @rep:lifecycle active
1275 * @rep:displayname Get Reference Designator
1276 */
1277 FUNCTION get_reference_designators
1278 ( p_component_sequence_id IN NUMBER
1279 ) return VARCHAR2;
1280
1281 PRAGMA RESTRICT_REFERENCES(get_reference_designators,WNDS);
1282
1283 /*#
1284 * This function returns the Item Name.It identifies the
1285 * Item Name with Assembly Item Id and Organization Id
1286 * @param p_item_id IN Assembly Item Id
1287 * @param p_org_id IN Organization Id
1288 * @return Assembly Item Name
1289 * @rep:scope private
1290 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1291 * @rep:compatibility S
1292 * @rep:lifecycle active
1293 * @rep:displayname Get Item Name
1294 */
1295 FUNCTION Get_Item_Name(p_item_id IN NUMBER,p_org_id IN NUMBER) RETURN VARCHAR2;
1296 PRAGMA RESTRICT_REFERENCES(Get_Item_Name, WNDS);
1297 /*#
1301 * @param x_org_list IN OUT NOCOPY Organization List
1298 * This method returns the organization list.The Organization List
1299 * @param p_org_hier IN Organization Hierarchy
1300 * @param p_organization_id IN Organization Id
1302 * @rep:scope private
1303 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1304 * @rep:compatibility S
1305 * @rep:lifecycle active
1306 * @rep:displayname Get Org List
1307 */
1308 PROCEDURE Get_Orgs
1309 ( p_org_hier IN VARCHAR2
1310 , p_organization_id IN NUMBER
1311 , x_org_list IN OUT NOCOPY BOM_GLOBALS.OrgID_tbl_type
1312 );
1313
1314 /*#
1315 * This method sets the validate_for_plm flag
1316 * It sets the value in the System Information Record
1317 * @param p_validate_for_plm_flag IN Validate For Plm Flag
1318 * @rep:scope private
1319 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1320 * @rep:compatibility S
1321 * @rep:lifecycle active
1322 * @rep:displayname Set Validate For Plm
1323 */
1324 PROCEDURE Set_Validate_For_Plm
1325 ( p_validate_for_plm_flag IN VARCHAR2
1326 );
1327
1328 /*#
1329 * This function returns the valus of valiidate_for_plm_flag.
1330 * It gets the value from the System Information Record.
1331 * @return Validate For Plm Flag Value
1332 * @rep:scope private
1333 * @rep:lifecycle active
1334 * @rep:compatibility S
1335 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1336 * @rep:displayname Get Plm Flag
1337 */
1338
1339
1340 FUNCTION Get_Validate_For_Plm RETURN VARCHAR2;
1341
1342 FUNCTION Is_GTIN_Structure_Type_Id (p_Structure_Type_Id IN NUMBER) RETURN BOOLEAN;
1343
1344 /*#
1345 * This function will find if PLM is enabled or not
1346 * @return Y or N
1347 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1348 * @rep:compatibility S
1349 * @rep:lifecycle active
1350 * @rep:displayname Get Debug
1351 */
1352 FUNCTION Is_PLM_Enabled RETURN VARCHAR2;
1353
1354 /*#
1355 * This function will find if PIM is enabled or not
1356 * @return Y or N
1357 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1358 * @rep:compatibility S
1359 * @rep:lifecycle active
1360 * @rep:displayname Get Debug
1361 */
1362 FUNCTION Is_PIM_Enabled RETURN VARCHAR2;
1363
1364 /*#
1365 * This function will find if PDS is enabled or not
1366 * @return Y or N
1367 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1368 * @rep:compatibility S
1369 * @rep:lifecycle active
1370 * @rep:displayname Get Debug
1371 */
1372 FUNCTION Is_PDS_Enabled RETURN VARCHAR2;
1373
1374 /*#
1375 * This function will find if PIM or PDS is enabled or not
1376 * @return Y or N
1377 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1378 * @rep:compatibility S
1379 * @rep:lifecycle active
1380 * @rep:displayname Get Debug
1381 */
1382 FUNCTION Is_PIM_PDS_Enabled RETURN VARCHAR2;
1383
1384
1385 --
1386 -- With the enhancement to BOM functionality for supporting various PLM
1387 -- requirements, BOM/Structures can have revisions and the components
1388 -- can maintain effectivity with respect to these revisions.
1389 -- We therefore now stamp the component with from_minor_revision_id
1390 -- and component_minor_revision_id
1391 -- These values are crucial for the explosion of BOM to work correctly for
1392 -- a particular minor revision.
1393 --
1394
1395 -- This procedure does the following
1396 -- 1. Based on Component's Effectivity, get the component Revision
1397 -- and component minor revision.
1398 -- 2. Based on current db date get the object revision id and from_minor_revision id
1399 -- 2. Get the max minor revsion id/code for the current bill
1400 -- object_revision_id is null or object is 'EGO_ITEM' and
1401 -- object_revision_id = item_revsion_id
1402 --
1403 /* Procedure to default the New Structure Revision Attributes */
1404 PROCEDURE GET_DEF_REV_ATTRS
1405 ( p_bill_sequence_id IN NUMBER
1406 , p_comp_item_id IN NUMBER
1407 , p_effectivity_date IN DATE
1408 , x_object_revision_id OUT NOCOPY VARCHAR2
1409 , x_minor_revision_id OUT NOCOPY VARCHAR2
1410 , x_comp_revision_id OUT NOCOPY VARCHAR2
1411 , x_comp_minor_revision_id OUT NOCOPY VARCHAR2
1412 );
1413
1414 FUNCTION Get_Change_Policy_Val (p_bill_seq_id IN NUMBER,
1415 p_item_revision_code IN VARCHAR2) RETURN VARCHAR2;
1416
1417 /*Function to return the change policy on a structure type/item/org*/
1418 FUNCTION Get_Change_Policy_Val (p_item_id IN NUMBER,
1419 p_org_id IN NUMBER,
1420 p_structure_type_id in NUMBER) RETURN VARCHAR2;
1421
1422 /* bug:4162717 Alternate Bom Designator string for primary structure */
1423 FUNCTION GET_PRIMARY_UI
1424 RETURN VARCHAR2;
1425
1426 FUNCTION Check_ItemAttrGroup_Security(viewPrivilegeName IN VARCHAR2,
1427 editPrivilegeName IN VARCHAR2,
1428 partyId IN VARCHAR2,
1429 inventoryItemId IN NUMBER,
1430 organizationId IN NUMBER) RETURN VARCHAR2;
1431
1432 /*#
1433 * This function will return Y if the revised component is editable.
1434 * @param p_comp_seq_id IN Component Sequence Id of the component
1435 * @return Y or N
1439 * @rep:lifecycle active
1436 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1437 * @rep:compatibility S
1438 * @rep:scope private
1440 * @rep:displayname Is Revised Component Editable
1441 */
1442 FUNCTION Is_Rev_Comp_Editable(p_comp_seq_id IN NUMBER)
1443 RETURN VARCHAR2;
1444
1445
1446 /*Function to return the change policy on a structure type/item/org*/
1447
1448 FUNCTION Get_Change_Policy_Val (p_item_id IN NUMBER,
1449 p_org_id IN NUMBER,
1450 p_rev_id IN NUMBER,
1451 p_rev_date IN DATE,
1452 p_structure_type_id in NUMBER) RETURN VARCHAR2;
1453
1454 FUNCTION Check_Change_Policy_Range (p_item_id IN NUMBER,
1455 p_org_id IN NUMBER,
1456 p_start_revision IN VARCHAR2,
1457 p_end_revision IN VARCHAR2,
1458 p_start_rev_id IN NUMBER,
1459 p_end_rev_id IN NUMBER,
1460 p_effective_date IN DATE,
1461 p_disable_date IN DATE,
1462 p_current_chg_pol IN VARCHAR2,
1463 p_structure_type_id IN NUMBER,
1464 p_use_eco IN VARCHAR2) RETURN VARCHAR2;
1465
1466
1467 FUNCTION Check_Change_Policy_Range (p_item_id IN NUMBER,
1468 p_org_id IN NUMBER,
1469 p_component_sequence_id IN NUMBER,
1470 p_current_chg_pol IN VARCHAR2,
1471 p_structure_type_id IN NUMBER,
1472 p_context_rev_id IN NUMBER,
1473 p_use_eco IN VARCHAR2) RETURN VARCHAR2;
1474
1475
1476 /* Function to split the component and copy the user attributes, RFD and Subcomps */
1477 FUNCTION split_component(p_comp_seq_id IN NUMBER,
1478 p_rev_id IN NUMBER,
1479 p_disable_rev_id IN NUMBER,
1480 p_disable_date IN DATE)
1481 RETURN NUMBER;
1482
1483 /* Function to get the effective component with respect to the passed parent item's revision */
1484 FUNCTION get_effetive_component(p_comp_seq_id IN NUMBER,
1485 p_rev_id IN NUMBER,
1486 p_explosion_date DATE)
1490 p_rev_id IN NUMBER)
1487 RETURN NUMBER;
1488
1489 FUNCTION get_effetive_component(p_comp_seq_id IN NUMBER,
1491 RETURN NUMBER;
1492
1493 /* Function to get the catalog category name for the given item_catalog_group_id */
1494 FUNCTION get_item_catalog_category(p_item_catalog_group_id IN NUMBER)
1495 RETURN VARCHAR2;
1496
1497 FUNCTION Get_Bill_Header_ECN(p_bill_seq_id IN NUMBER)
1498 RETURN VARCHAR2;
1499
1500 PROCEDURE uda_attribute_defaulting(p_bill_sequence_id IN VARCHAR2
1501 ,p_component_sequence_id IN VARCHAR2 DEFAULT NULL
1502 ,p_object_name IN VARCHAR2
1503 ,p_structure_type_id IN VARCHAR2
1504 ,x_return_status OUT NOCOPY VARCHAR2
1505 ,x_msg_data OUT NOCOPY VARCHAR2);
1506
1507 PROCEDURE Init_Logging;
1508
1509 PROCEDURE Start_Logging(flow_name VARCHAR2,flow_id NUMBER);
1510
1511 PROCEDURE Log_Start_Time(operation_name VARCHAR2);
1512
1513 PROCEDURE Log_Exec_Time;
1514
1515 PROCEDURE Stop_Logging;
1516
1517 PROCEDURE set_show_Impl_comps_only(p_option IN VARCHAR2);
1518
1519 FUNCTION get_show_Impl_comps_only RETURN VARCHAR2;
1520
1521 FUNCTION check_chg_pol_for_delete(p_bill_seq_id IN NUMBER,
1522 p_comp_seq_id IN NUMBER,
1523 p_start_revision IN VARCHAR2,
1524 p_end_revision IN VARCHAR2,
1525 p_start_rev_id IN NUMBER,
1526 p_end_rev_id IN NUMBER,
1527 p_effective_date IN DATE,
1528 p_disable_date IN DATE,
1529 p_current_chg_pol IN VARCHAR2) RETURN VARCHAR2;
1530
1531 FUNCTION get_comp_names(p_comp_seq_ids IN VARCHAR2) RETURN VARCHAR2;
1532
1533 FUNCTION get_lookup_meaning(p_lookup_type IN VARCHAR2,
1534 p_lookup_code IN VARCHAR2) RETURN VARCHAR2;
1535 /*#
1536 * This method sets the Profile MFG_ORGANIZATION_ID .It sets the value of
1537 * Oganization Id for this profile.
1538 * @param p_org_id IN Organization Id
1539 * @rep:scope private
1540 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
1541 * @rep:compatibility S
1542 * @rep:lifecycle active
1543 * @rep:displayname Set Profile Org id
1544 */
1545 PROCEDURE Set_Profile_Org_id( p_org_id IN NUMBER);
1546
1547 END BOM_Globals;
[Home] [Help]