[Home] [Help]
PACKAGE: APPS.WPS_CAPACITY_CHANGES_PKG
Source
1 PACKAGE WPS_CAPACITY_CHANGES_PKG AUTHID CURRENT_USER AS
2 /* $Header: WPSCAPCS.pls 115.2 2002/11/01 01:19:08 jenchang ship $ */
3
4
5 /**
6 * This procedure is used to delete a resource exception
7 */
8 PROCEDURE Delete_Resource_Exception(X_Rowid VARCHAR2);
9
10 /**
11 * This procedure is used to delete a resource instance exception
12 */
13 PROCEDURE Delete_Resinst_Exception(X_Rowid VARCHAR2);
14
15 /**
16 * This procedure is used to update a resource exception
17 */
18 PROCEDURE Update_Resource_Exception(X_Rowid VARCHAR2,
19 X_Shift NUMBER,
20 X_Action NUMBER,
21 X_Units NUMBER,
22 X_From_Date DATE,
23 X_To_Date DATE,
24 X_From_Time NUMBER,
25 X_To_Time NUMBER,
26 X_User_Id NUMBER,
27 X_REASON_CODE VARCHAR2 DEFAULT NULL);
28 /**
29 * This procedure is used to insert a resource exception
30 */
31 PROCEDURE Insert_Resource_Exception(X_Resource_Id NUMBER,
32 X_Department_Id NUMBER,
33 X_Shift NUMBER,
34 X_Action NUMBER,
35 X_Units NUMBER,
36 X_From_Date DATE,
37 X_To_Date DATE,
38 X_From_Time NUMBER,
39 X_To_Time NUMBER,
40 X_Sim_Set VARCHAR2,
41 X_User_Id NUMBER,
42 X_REASON_CODE VARCHAR2 DEFAULT NULL);
43 /**
44 * This procedure is used to insert a resource instance exception
45 */
46 PROCEDURE Insert_ResInst_Exception (X_Resource_Id NUMBER,
47 X_Department_Id NUMBER,
48 X_Shift NUMBER,
49 X_Action NUMBER,
50 X_Units NUMBER,
51 X_From_Date DATE,
52 X_To_Date DATE,
53 X_From_Time NUMBER,
54 X_To_Time NUMBER,
55 X_Instance_Id NUMBER,
56 X_Serial_Num VARCHAR2,
57 X_Sim_Set VARCHAR2,
58 X_User_Id NUMBER,
59 X_REASON_CODE VARCHAR2 DEFAULT NULL);
60 /**
61 * This procedure is used to update a resource instance exception
62 */
63 PROCEDURE Update_ResInst_Exception (X_Rowid VARCHAR2,
64 X_Shift NUMBER,
65 X_Action NUMBER,
66 X_Units NUMBER,
67 X_From_Date DATE,
68 X_To_Date DATE,
69 X_From_Time NUMBER,
70 X_To_Time NUMBER,
71 X_Instance_Id NUMBER,
72 X_Serial_Num VARCHAR2,
73 X_User_Id NUMBER,
74 X_REASON_CODE VARCHAR2 DEFAULT NULL);
75
76 /**
77 * This is a utility procedure to check whether the instance exception will
78 * max out the resource assigned units
79 */
80 PROCEDURE CheckResInstForInsert(X_Resource_Id NUMBER,
81 X_Department_Id NUMBER,
82 X_Sim_Set VARCHAR2,
83 X_Shift NUMBER,
84 X_Action NUMBER,
85 X_Units NUMBER,
86 X_From_Date DATE,
87 X_To_Date DATE,
88 X_From_Time NUMBER,
89 X_To_Time NUMBER,
90 X_Return_Id OUT NOCOPY Number);
91
92
93 END WPS_CAPACITY_CHANGES_PKG;