PACKAGE: APPS.WIP_INTERFACE_TH

Source

1 PACKAGE WIP_INTERFACE_TH AUTHID CURRENT_USER AS
2 /* $Header: wipjsths.pls 115.6 2002/12/12 14:58:00 rmahidha ship $ */
3 
4 PROCEDURE Update_Row(
5 X_Rowid VARCHAR2,
6 X_Group_Id NUMBER,
7 X_Process_Phase NUMBER,
8 X_Process_Status NUMBER,
9 X_Request_Id NUMBER,
10 X_Source_Code VARCHAR2,
11 X_Source_Line_Id NUMBER,
12 X_Load_Type NUMBER,
13 X_Organization_Code VARCHAR2,
14 X_Job_Name VARCHAR2,
15 X_Line_Code VARCHAR2,
16 X_Start_Quantity NUMBER,
17 X_Net_Quantity NUMBER,
18 X_Processing_Work_Days NUMBER,
19 X_Daily_Production_Rate NUMBER,
20 X_Class_Code VARCHAR2,
21 X_Lot_Number VARCHAR2,
22 X_Schedule_Group_Name VARCHAR2,
23 X_Build_Sequence NUMBER,
24 X_Project_Number VARCHAR2,
25 X_Task_Number VARCHAR2,
26 X_Status_Type NUMBER,
27 X_Firm_Planned_Flag NUMBER,
28 X_Demand_Class VARCHAR2,
29 X_Scheduling_Method NUMBER,
30 X_First_Unit_Start_Date DATE,
31 X_Last_Unit_Start_Date DATE,
32 X_First_Unit_Completion_Date DATE,
33 X_Last_Unit_Completion_Date DATE,
34 X_Alternate_Bom_Designator VARCHAR2,
35 X_Bom_Revision VARCHAR2,
36 X_Bom_Revision_Date DATE,
37 X_Wip_Supply_Type NUMBER,
38 X_Alternate_Routing_Designator VARCHAR2,
39 X_Routing_Revision VARCHAR2,
40 X_Routing_Revision_Date DATE,
41 X_Completion_Subinventory VARCHAR2,
42 X_Locator VARCHAR2,
43 X_Description VARCHAR2,
44 X_Created_By_Name VARCHAR2,
45 X_Locator_Id NUMBER,
46 X_Organization_Id NUMBER,
47 X_Primary_Item_Id NUMBER,
48 X_Line_Id NUMBER,
49 X_Bom_Reference_Id NUMBER,
50 X_Routing_Reference_Id NUMBER,
51 X_Schedule_Group_Id NUMBER,
52 X_Project_Id NUMBER,
53 X_Task_Id NUMBER,
54 /*X_Project_Costed NUMBER,*/
55 X_Last_Update_login NUMBER,
56 X_Last_Updated_By NUMBER,
57 X_Last_Update_Date DATE,
58 X_Created_By NUMBER,
59 X_Creation_Date DATE,
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 );
77 
78 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
79 PROCEDURE Delete_Resubmit(X_Rowid VARCHAR2);
80 PROCEDURE Delete_Children(X_Rowid VARCHAR2);
81 
82 PROCEDURE Lock_Row(
83 X_Rowid VARCHAR2,
84 X_Group_Id NUMBER,
85 X_Process_Phase NUMBER,
86 X_Process_Status NUMBER,
87 X_Request_Id NUMBER,
88 X_Source_Code VARCHAR2,
89 X_Source_Line_Id NUMBER,
90 X_Load_Type NUMBER,
91 X_Organization_Code VARCHAR2,
92 X_Job_Name VARCHAR2,
93 X_Line_Code VARCHAR2,
94 X_Start_Quantity NUMBER,
95 X_Net_Quantity NUMBER,
96 X_Processing_Work_Days NUMBER,
97 X_Daily_Production_Rate NUMBER,
98 X_Class_Code VARCHAR2,
99 X_Lot_Number VARCHAR2,
100 X_Schedule_Group_Name VARCHAR2,
101 X_Build_Sequence NUMBER,
102 X_Project_Number VARCHAR2,
103 X_Task_Number VARCHAR2,
104 X_Status_Type NUMBER,
105 X_Firm_Planned_Flag NUMBER,
106 X_Demand_Class VARCHAR2,
107 X_Scheduling_Method NUMBER,
108 X_First_Unit_Start_Date DATE,
109 X_Last_Unit_Start_Date DATE,
110 X_First_Unit_Completion_Date DATE,
111 X_Last_Unit_Completion_Date DATE,
112 X_Alternate_Bom_Designator VARCHAR2,
113 X_Bom_Revision VARCHAR2,
114 X_Bom_Revision_Date DATE,
115 X_Wip_Supply_Type NUMBER,
116 X_Alternate_Routing_Designator VARCHAR2,
117 X_Routing_Revision VARCHAR2,
118 X_Routing_Revision_Date DATE,
119 X_Completion_Subinventory VARCHAR2,
120 X_Locator VARCHAR2,
121 X_Description VARCHAR2,
122 X_Created_By_Name VARCHAR2,
123 X_Locator_Id NUMBER,
124 X_Organization_Id NUMBER,
125 X_Primary_Item_Id NUMBER,
126 X_Line_Id NUMBER,
127 X_Bom_Reference_Id NUMBER,
128 X_Routing_Reference_Id NUMBER,
129 X_Schedule_Group_Id NUMBER,
130 X_Project_Id NUMBER,
131 X_Task_Id NUMBER,
132 /*X_Project_Costed NUMBER,*/
133 X_Last_Update_login NUMBER,
134 X_Last_Updated_By NUMBER,
135 X_Last_Update_Date DATE,
136 X_Created_By NUMBER,
137 X_Creation_Date DATE,
138 X_Attribute_Category VARCHAR2,
139 X_Attribute1 VARCHAR2,
140 X_Attribute2 VARCHAR2,
141 X_Attribute3 VARCHAR2,
142 X_Attribute4 VARCHAR2,
143 X_Attribute5 VARCHAR2,
144 X_Attribute6 VARCHAR2,
145 X_Attribute7 VARCHAR2,
146 X_Attribute8 VARCHAR2,
147 X_Attribute9 VARCHAR2,
148 X_Attribute10 VARCHAR2,
149 X_Attribute11 VARCHAR2,
150 X_Attribute12 VARCHAR2,
151 X_Attribute13 VARCHAR2,
152 X_Attribute14 VARCHAR2,
153 X_Attribute15 VARCHAR2
154 );
155 
156 END WIP_INTERFACE_TH;