1 PACKAGE BOMCUMYD AS
2 /* $Header: BOMCMYLS.pls 120.2 2006/01/03 22:27:22 bbpatel ship $ */
3 /*#
4 * This API contains procedures to
5 * 1. Calculate Cumulative Yield values for Network Routing for
6 * a. Single Item
7 * b. Range of Items
8 * 2. Calculate Cumulative Yield and Times for Flow Routing for
9 * a. Single Item
10 * b. Range of Items
11 * c. All Items in the Organization
12 *
13 * @rep:scope public
14 * @rep:product BOM
15 * @rep:lifecycle active
16 * @rep:displayname Cumulative Yield calculation for Flow and Network Routing
17 * @rep:compatibility S
18 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
19 */
20
21 /*#
22 * This procedure will Calculate Cumulative Yield values for Network routing for
23 * a) Single Item
24 * b) Range of Items
25 *
26 * @param ERRBUF IN OUT NOCOPY Error Message
27 * @param RETCODE IN OUT NOCOPY Return Code. In case of error, Return Code = 2
28 * @param Current_org_id IN Organization from where the concurrent program is launched
29 * @param Scope IN 1 - Specific Routing; 2 - Range of Routings
30 * @param Flag_Value IN Flag indicating whether item is ENG or BOM. This Value is set based on
31 * profile value for BOM_OR_ENG.
32 * @param Item_Id IN Item Id if the scope is Specific Routing
33 * @param Operation_Type IN Process or Line Operation
34 * @param Update_Events IN 1 - Yes; 2 - No
35 * @param Item_low IN Start Item Id if the scope is Range of Routings
36 * @param Item_high IN End Item Id if the scope is Range of Routings
37 *
38 * @rep:scope public
39 * @rep:lifecycle active
40 * @rep:displayname Calculate Cumulative Yield for Network Routing
41 * @rep:compatibility S
42 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
43 */
44 PROCEDURE Cumulative_Yield(
45 ERRBUF IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
46 RETCODE IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
47 Current_org_id IN NUMBER,
48 Scope IN NUMBER DEFAULT 1,
49 Flag_Value IN VARCHAR2,
50 Item_Id IN NUMBER ,
51 Operation_Type IN NUMBER DEFAULT 1,
52 Update_Events IN NUMBER DEFAULT 1,
53 Item_low IN VARCHAR2,
54 Item_high IN VARCHAR2);
55
56 /*#
57 * This is a procedure for Calculating Yield and Times for Flow Routings for
58 * a) A Specific Item
59 * b) Range of Items
60 * c) All Items in the Organization
61 * Flow Routings are filtered by specifying:
62 * a) Line
63 * b) Operation Type
64 * c) Operation Name
65 * d) Event Name
66 *
67 * @param ERRBUF IN OUT NOCOPY Error Message
68 * @param RETCODE IN OUT NOCOPY Return Code. In case of error, Return Code = 2
69 * @param Current_org_id IN Organization from where the concurrent program is launched
70 * @param Scope IN 1 - Specific Routing; 2 - Range of Routings
71 * @param Flag_Value IN Flag indicating whether item is ENG or BOM. This Value is set based on
72 * profile value for BOM_OR_ENG.
73 * @param Item_Id IN Item Id if the scope is Specific Routing
74 * @param Line_Id IN Line Id
75 * @param Oper_Type IN Process, Line Operation or Event
76 * @param Item_low IN Start Item Id if the scope is Range of Routings
77 * @param Item_high IN End Item Id if the scope is Range of Routings
78 * @param Operation_Name IN Operation Name
79 * @param Event_Name IN Event Name
80 *
81 * @rep:scope public
82 * @rep:lifecycle active
83 * @rep:displayname Calculate Cumulative Yield and Times for Flow Routing
84 * @rep:compatibility S
85 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
86 */
87 PROCEDURE Flow_Batch_Calc(
88 ERRBUF IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
89 RETCODE IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
90 Current_org_id IN NUMBER,
91 Scope IN NUMBER DEFAULT 1,
92 Flag_Value IN VARCHAR2,
93 Item_Id IN NUMBER,
94 Line_Id IN NUMBER,
95 Oper_Type IN NUMBER DEFAULT 3,
96 Item_low IN VARCHAR2,
97 Item_high IN VARCHAR2,
98 Operation_Name IN VARCHAR2,
99 Event_Name IN VARCHAR2);
100
101 END BOMCUMYD;