[Home] [Help]
PACKAGE: APPS.EAM_OPERATIONS_PKG
Source
1 PACKAGE EAM_OPERATIONS_PKG as
2 /* $Header: EAMOPTHS.pls 120.0 2005/05/25 15:59:39 appldev noship $ */
3
4 /************************************************
5 * Default Values: *
6 * Many columns are not used in EAM. As we *
7 * decided, we put the pre-determined default *
8 * value into them. *
9 * These are just indicative values. Actual *
10 * default values are in procedure spec. *
11 ************************************************/
12 Default_Repetitive_Schedule_Id NUMBER := null; -- Not Used.
13 Default_Scheduled_Quantity NUMBER := 1; -- Not Used
14 Default_Qty_In_Queue NUMBER := 0; -- Not Used
15 Default_Qty_Running NUMBER := 0; -- Not Used
16 Default_Qty_Waiting_To_Move NUMBER := 0; -- Not Used
17 Default_Qty_Rejected NUMBER := 0; -- Not Used
18 Default_Qty_Scrapped NUMBER := 0; -- Not Used
19 Default_Qty_Completed NUMBER := 0; -- For Creating a new one
20 Default_Prev_Operation_Seq_Num NUMBER := NULL; -- Not Used
21 Default_Next_Operation_Seq_Num NUMBER := NULL; -- Not Used
22 Default_Count_Point_Type NUMBER := 2; -- No - Autocgarge....Change made to incorporate direct items
23 Default_Backflush_Flag NUMBER := 2; -- No ???
24 Default_Minimum_Transfer_Qty NUMBER := 0; -- Not Used
25 Default_Date_Last_Moved DATE := null; -- Not Used
26
27 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
28 X_Wip_Entity_Id NUMBER,
29 X_Operation_Seq_Num NUMBER,
30 X_Organization_Id NUMBER,
31 X_Repetitive_Schedule_Id NUMBER default null,
32 X_Last_Update_Date DATE,
33 X_Last_Updated_By NUMBER,
34 X_Creation_Date DATE,
35 X_Created_By NUMBER,
36 X_Last_Update_Login NUMBER,
37 X_Operation_Sequence_Id NUMBER,
38 X_Standard_Operation_Id NUMBER,
39 X_Department_Id NUMBER,
40 X_Shutdown_Type VARCHAR2,
41 X_Operation_Completed VARCHAR2,
42 X_Description VARCHAR2,
43 X_Scheduled_Quantity NUMBER default 1,
44 X_Quantity_In_Queue NUMBER default 0,
45 X_Quantity_Running NUMBER default 0,
46 X_Quantity_Waiting_To_Move NUMBER default 0,
47 X_Quantity_Rejected NUMBER default 0,
48 X_Quantity_Scrapped NUMBER default 0,
49 X_Quantity_Completed NUMBER default 0,
50 X_First_Unit_Start_Date DATE,
51 X_First_Unit_Completion_Date DATE,
52 X_Last_Unit_Start_Date DATE,
53 X_Last_Unit_Completion_Date DATE,
54 X_Previous_Operation_Seq_Num NUMBER default null,
55 X_Next_Operation_Seq_Num NUMBER default null,
56 X_Count_Point_Type NUMBER default 1,
57 X_Backflush_Flag NUMBER default 2,
58 X_Minimum_Transfer_Quantity NUMBER default 0,
59 X_Date_Last_Moved DATE default null,
60 X_Attribute_Category VARCHAR2,
61 X_Attribute1 VARCHAR2,
62 X_Attribute2 VARCHAR2,
63 X_Attribute3 VARCHAR2,
64 X_Attribute4 VARCHAR2,
65 X_Attribute5 VARCHAR2,
66 X_Attribute6 VARCHAR2,
67 X_Attribute7 VARCHAR2,
68 X_Attribute8 VARCHAR2,
69 X_Attribute9 VARCHAR2,
70 X_Attribute10 VARCHAR2,
71 X_Attribute11 VARCHAR2,
72 X_Attribute12 VARCHAR2,
73 X_Attribute13 VARCHAR2,
74 X_Attribute14 VARCHAR2,
75 X_Attribute15 VARCHAR2,
76 X_X_Pos NUMBER,
77 X_Y_Pos NUMBER,
78 X_LONG_DESCRIPTION VARCHAR2 default null,
79 X_L_EAM_OP_REC OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_rec_type,
80 X_WO_Start_Date OUT NOCOPY DATE,
81 X_WO_Completion_Date OUT NOCOPY DATE
82 );
83
84
85 PROCEDURE Update_Row(X_Rowid VARCHAR2,
86 X_Wip_Entity_Id NUMBER,
87 X_Operation_Seq_Num NUMBER,
88 X_Organization_Id NUMBER,
89 X_Last_Update_Date DATE,
90 X_Last_Updated_By NUMBER,
91 X_Last_Update_Login NUMBER,
92 X_Operation_Sequence_Id NUMBER,
93 X_Standard_Operation_Id NUMBER,
94 X_Department_Id NUMBER,
95 X_Shutdown_Type VARCHAR2,
96 X_Operation_Completed VARCHAR2,
97 X_Description VARCHAR2,
98 X_First_Unit_Start_Date DATE,
99 X_First_Unit_Completion_Date DATE,
100 X_Last_Unit_Start_Date DATE,
101 X_Last_Unit_Completion_Date DATE,
102 X_Attribute_Category VARCHAR2,
103 X_Attribute1 VARCHAR2,
104 X_Attribute2 VARCHAR2,
105 X_Attribute3 VARCHAR2,
106 X_Attribute4 VARCHAR2,
107 X_Attribute5 VARCHAR2,
108 X_Attribute6 VARCHAR2,
109 X_Attribute7 VARCHAR2,
110 X_Attribute8 VARCHAR2,
111 X_Attribute9 VARCHAR2,
112 X_Attribute10 VARCHAR2,
113 X_Attribute11 VARCHAR2,
114 X_Attribute12 VARCHAR2,
115 X_Attribute13 VARCHAR2,
116 X_Attribute14 VARCHAR2,
117 X_Attribute15 VARCHAR2,
118 X_X_Pos NUMBER,
119 X_Y_Pos NUMBER,
120 X_LONG_DESCRIPTION VARCHAR2 default null,
121 X_L_EAM_OP_REC OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_rec_type,
122 X_WO_Start_Date OUT NOCOPY DATE,
123 X_WO_Completion_Date OUT NOCOPY DATE
124 );
125
126
127 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
128 X_Wip_Entity_Id NUMBER,
129 X_Operation_Seq_Num NUMBER,
130 X_Organization_Id NUMBER,
131 X_Operation_Sequence_Id NUMBER,
132 X_Standard_Operation_Id NUMBER,
133 X_Department_Id NUMBER,
134 X_Shutdown_Type VARCHAR2,
135 X_Operation_Completed VARCHAR2,
136 X_Description VARCHAR2,
137 X_First_Unit_Start_Date DATE,
138 X_First_Unit_Completion_Date DATE,
139 X_Last_Unit_Start_Date DATE,
140 X_Last_Unit_Completion_Date DATE,
141 X_Attribute_Category VARCHAR2,
142 X_Attribute1 VARCHAR2,
143 X_Attribute2 VARCHAR2,
144 X_Attribute3 VARCHAR2,
145 X_Attribute4 VARCHAR2,
146 X_Attribute5 VARCHAR2,
147 X_Attribute6 VARCHAR2,
148 X_Attribute7 VARCHAR2,
149 X_Attribute8 VARCHAR2,
150 X_Attribute9 VARCHAR2,
151 X_Attribute10 VARCHAR2,
152 X_Attribute11 VARCHAR2,
153 X_Attribute12 VARCHAR2,
154 X_Attribute13 VARCHAR2,
155 X_Attribute14 VARCHAR2,
156 X_Attribute15 VARCHAR2,
157 X_X_Pos NUMBER,
158 X_Y_Pos NUMBER,
159 X_LONG_DESCRIPTION VARCHAR2 default null
160 );
161
162
163 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
164 X_WO_Start_Date OUT NOCOPY DATE,
165 X_WO_Completion_Date OUT NOCOPY DATE);
166
167 END EAM_OPERATIONS_PKG;