1 package BOMPKMUD as
2 /* $Header: BOMKMUDS.pls 120.1 2005/06/21 01:41:02 appldev ship $ */
3 -- +======================================================================+
4 -- | Copyright (c) 1992 Oracle Corporation Redwood Shores, California, USA|
5 -- | All rights reserved. |
6 -- +======================================================================+
7 -- NAME
8 -- bompkmud.sql
9 -- DESCRIPTION
10 -- Package of stored procedures which facilitate mass update of
11 -- components. The list of revised items is given by the table
12 -- BOM_LISTS. For each revised item, a change order is created
13 -- based on criteria stored in the tables:
14 -- ENG_ENG_CHANGES_INTERFACE, ENG_REVISED_ITEMS_INTERFACE and
15 -- BOM_INVENTORY_COMPS_INTERFACE.
16 -- NOTES
17 -- Initially intended to be called by the C program, BMCMUD.
18 -- MODIFIED (MM/DD/YY)
19 -- 01/13/93
20 -- +======================================================================+
21 --
22 -- Global constants and data types
23 --
24 yes constant number(1) := 1;
25 no constant number(1) := 2;
26
27 Type ProgramInfoStruct is record -- Profile option values
28 (userid number := -1, -- user id
29 reqstid number := 0, -- concurrent request id
30 appid number := null, -- application id
31 progid number := null, -- program id
32 loginid number := null, -- login id
33 model_item_access number := 1,
34 planning_item_access number := 1,
35 standard_item_access number := 1);
36
37 --------------------------------- Procedure -------------------------------
38 --
39 -- NAME
40 -- Mass_update
41 -- DESCRIPTION
42 -- Creates change orders for all items listed in BOM_LISTS, based on
43 -- criteria stored in ENG_CHANGES_INTERFACE,
44 -- ENG_REVISED_ITEMS_INTERFACE and BOM_COMPS_INTERFACE.
45 -- REQUIRES
46 -- List id - unique identifier of list in BOM_LISTS. This may either
47 -- be a session id or a sequence number from BOM_LISTS_S.
48 -- Model Item Access - Yes (1) or No (2). If yes, delete all model bills
49 -- from list.
50 -- Planning Item Access - Yes (1) or No (2). If yes, delete all planning
51 -- bills from list.
52 -- Standard Item Access - Yes (1) or No (2). If yes, delete all
53 -- standard bills from list.
54 -- Change order - Change order number stored in ENG_CHANGES_INTERFACE.
55 -- Organization Id - Organization stored in ENG_CHANGES_INTERFACE.
56 -- Who values - Standard who column information.
57 -- Delete MCO - Delete interface rows after ECO is created. Yes
58 -- (1) or No (2).
59 -- MODIFIES
60 --
61 -- RETURNS
62 -- Error message if unsuccessful, otherwise NULL.
63 -- NOTES
64 -- Originally intended for call by PRO*C program, BMCMUD. Who column
65 -- information will be placed into ENG_ENG_CHANGES_INTERFACE by
66 -- the calling program.
67 -- EXAMPLE
68 --
69
70 Procedure mass_update(list_id in number,
71 profile in ProgramInfoStruct,
72 change_order in varchar2,
73 org_id in number,
74 delete_mco in number,
75 error_message in out nocopy /* file.sql.39 change */ varchar2);
76 end BOMPKMUD;