[Home] [Help]
PACKAGE: APPS.WIP_OPERATIONS_UTILITIES
Source
1 PACKAGE WIP_OPERATIONS_UTILITIES AUTHID CURRENT_USER AS
2 /* $Header: wipoputs.pls 120.0.12020000.1 2012/06/27 21:07:20 appldev ship $ */
3
4 PROCEDURE Check_Unique(X_Wip_Entity_Id NUMBER,
5 X_Organization_Id NUMBER,
6 X_Operation_Seq_Num NUMBER,
7 X_Repetitive_Schedule_Id NUMBER);
8
9 FUNCTION Pending_Op_Txns(X_Wip_Entity_Id NUMBER,
10 X_Organization_Id NUMBER,
11 X_Operation_Seq_Num NUMBER,
12 X_Repetitive_Schedule_Id NUMBER,
13 X_Line_Id NUMBER)
14 return BOOLEAN;
15
16 FUNCTION Get_Previous_Op(X_Wip_Entity_Id NUMBER,
17 X_Organization_Id NUMBER,
18 X_Operation_Seq_Num NUMBER,
19 X_Repetitive_Schedule_Id NUMBER)
20 return NUMBER;
21
22 PROCEDURE Get_Prev_Next_Op(X_Wip_Entity_Id NUMBER,
23 X_Organization_Id NUMBER,
24 X_Operation_Seq_Num NUMBER,
25 X_Repetitive_Schedule_Id NUMBER,
26 X_Insert_Flag BOOLEAN,
27 X_Prev_Op_Seq IN OUT NOCOPY NUMBER,
28 X_Next_Op_Seq IN OUT NOCOPY NUMBER);
29
30 PROCEDURE Set_Previous_Op(X_Wip_Entity_Id NUMBER,
31 X_Organization_Id NUMBER,
32 X_Operation_Seq_Num NUMBER,
33 X_Prev_Op_Seq NUMBER,
34 X_Repetitive_Schedule_Id NUMBER);
35
36 PROCEDURE Set_Next_Op(X_Wip_Entity_Id NUMBER,
37 X_Organization_Id NUMBER,
38 X_Operation_Seq_Num NUMBER,
39 X_Next_Op_Seq NUMBER,
40 X_Repetitive_Schedule_Id NUMBER);
41
42 PROCEDURE Delete_Resources(X_Wip_Entity_Id NUMBER,
43 X_Organization_Id NUMBER,
44 X_Operation_Seq_Num NUMBER,
45 X_Repetitive_Schedule_Id NUMBER,
46 x_return_status OUT NOCOPY VARCHAR2);
47
48 PROCEDURE Insert_Resources(X_Wip_Entity_Id NUMBER,
49 X_Organization_Id NUMBER,
50 X_Operation_Seq_Num NUMBER,
51 X_Standard_Operation_Id NUMBER,
52 X_Repetitive_Schedule_Id NUMBER,
53 X_Last_Updated_By NUMBER,
54 X_Created_By NUMBER,
55 X_Last_Update_Login NUMBER,
56 X_Start_Date DATE,
57 X_Completion_Date DATE);
58
59 FUNCTION Num_Standard_Resources(X_Organization_Id NUMBER,
60 X_Standard_Operation_Id NUMBER)
61 RETURN NUMBER;
62
63 PROCEDURE Check_Requirements(X_Wip_Entity_Id NUMBER,
64 X_Organization_Id NUMBER,
65 X_Operation_Seq_Num NUMBER,
66 X_Repetitive_Schedule_Id NUMBER,
67 X_Entity_Start_Date DATE);
68
69 FUNCTION Num_Assembly_Pull(X_Wip_Entity_Id NUMBER,
70 X_Organization_Id NUMBER,
71 X_Operation_Seq_Num NUMBER,
72 X_Repetitive_Schedule_Id NUMBER)
73 return NUMBER;
74
75 FUNCTION Num_Resources(X_Wip_Entity_Id NUMBER,
76 X_Organization_Id NUMBER,
77 X_Operation_Seq_Num NUMBER,
78 X_Repetitive_Schedule_Id NUMBER)
79 return NUMBER;
80
81 PROCEDURE Set_Operation_Dates(X_Wip_Entity_Id NUMBER,
82 X_Organization_Id NUMBER,
83 X_Operation_Seq_Num NUMBER,
84 X_Repetitive_Schedule_Id NUMBER,
85 X_First_Unit_Start_Date DATE,
86 X_Last_Unit_Completion_Date DATE,
87 X_Resource_Start_Date DATE,
88 X_Resource_Completion_Date DATE);
89
90 PROCEDURE Set_Entity_Dates(X_Wip_Entity_Id NUMBER,
91 X_Organization_Id NUMBER,
92 X_Repetitive_Schedule_Id NUMBER,
93 X_First_Unit_Start_Date DATE,
94 X_Last_Unit_Completion_Date DATE);
95
96 PROCEDURE Update_Operationless_Reqs(X_Wip_Entity_Id NUMBER,
97 X_Organization_Id NUMBER,
98 X_Operation_Seq_Num NUMBER,
99 X_Repetitive_Schedule_Id NUMBER,
100 X_Department_Id NUMBER,
101 X_First_Unit_Start_Date DATE);
102
103 PROCEDURE Update_Reqs(X_Wip_Entity_Id NUMBER,
104 X_Organization_Id NUMBER,
105 X_Operation_Seq_Num NUMBER,
106 X_Repetitive_Schedule_Id NUMBER,
107 X_Department_Id NUMBER,
108 X_Start_Date DATE);
109
110 PROCEDURE Get_Prev_Op_Dates(X_Wip_Entity_Id NUMBER,
111 X_Organization_Id NUMBER,
112 X_Prev_Operation_Seq_Num NUMBER,
113 X_Repetitive_Schedule_Id NUMBER,
114 X_First_Unit_Start_Date OUT NOCOPY DATE,
115 X_Last_Unit_Start_Date OUT NOCOPY DATE,
116 X_First_Unit_Completion_Date OUT NOCOPY DATE,
117 X_Last_Unit_Completion_Date OUT NOCOPY DATE);
118
119 PROCEDURE Update_Res_Op_Seq(X_Wip_Entity_Id NUMBER,
120 X_Organization_Id NUMBER,
121 X_Old_Operation_Seq_Num NUMBER,
122 X_New_Operation_Seq_Num NUMBER,
123 X_Repetitive_Schedule_Id NUMBER);
124
125 FUNCTION Other_Active_Schedules(X_Wip_Entity_Id NUMBER,
126 X_Org_Id NUMBER,
127 X_Line_Id NUMBER) RETURN VARCHAR;
128
129 PROCEDURE rollback_database;
130
131
132 END WIP_OPERATIONS_UTILITIES;