1 PACKAGE EAM_REQUIREMENTS_PKG as
2 /* $Header: EAMMRTHS.pls 120.2 2005/09/22 23:12:35 grajan noship $ */
3
4 /************************************************
5 * Default Values: *
6 * These are just indicative values. Actual *
7 * default values are in procedure spec. *
8 ************************************************/
9 Default_Repetitive_Schedule_Id NUMBER := null; -- No Repetitive Schedule
10 Default_MPS_Required_Quantity NUMBER := null;
11 Default_MPS_Date_Required DATE := null;
12
13 PROCEDURE Pre_Insert;
14
15 PROCEDURE Insert_Row (X_row_id IN OUT NOCOPY VARCHAR2,
16 X_inventory_item_id IN NUMBER,
17 X_organization_id IN NUMBER,
18 X_wip_entity_id IN NUMBER,
19 X_operation_seq_num IN NUMBER,
20 X_repetitive_schedule_id IN NUMBER default null,
21 X_last_update_date IN DATE,
22 X_last_updated_by IN NUMBER,
23 X_creation_date IN DATE,
24 X_created_by IN NUMBER,
25 X_last_update_login IN NUMBER,
26 X_department_id IN NUMBER,
27 X_wip_supply_type IN NUMBER,
28 X_date_required IN DATE,
29 X_required_quantity IN NUMBER,
30 X_quantity_issued IN NUMBER,
31 X_quantity_per_assembly IN NUMBER,
32 X_comments IN VARCHAR2,
33 X_supply_subinventory IN VARCHAR2,
34 X_supply_locator_id IN NUMBER,
35 X_mrp_net_flag IN NUMBER,
36 X_mps_required_quantity IN NUMBER default null,
37 X_mps_date_required IN DATE default null,
38 X_attribute_category IN VARCHAR2,
39 X_attribute1 IN VARCHAR2,
40 X_attribute2 IN VARCHAR2,
41 X_attribute3 IN VARCHAR2,
42 X_attribute4 IN VARCHAR2,
43 X_attribute5 IN VARCHAR2,
44 X_attribute6 IN VARCHAR2,
45 X_attribute7 IN VARCHAR2,
46 X_attribute8 IN VARCHAR2,
47 X_attribute9 IN VARCHAR2,
48 X_attribute10 IN VARCHAR2,
49 X_attribute11 IN VARCHAR2,
50 X_attribute12 IN VARCHAR2,
51 X_attribute13 IN VARCHAR2,
52 X_attribute14 IN VARCHAR2,
53 X_attribute15 IN VARCHAR2,
54 X_auto_request_material IN VARCHAR2,
55 X_L_EAM_MAT_REC OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type,
56 X_material_shortage_flag OUT NOCOPY VARCHAR2,
57 X_material_shortage_check_date OUT NOCOPY DATE
58 );
59
60
61
62 PROCEDURE Update_Row (X_row_id IN VARCHAR2,
63 X_inventory_item_id IN NUMBER,
64 X_organization_id IN NUMBER,
65 X_wip_entity_id IN NUMBER,
66 X_operation_seq_num IN NUMBER,
67 X_repetitive_schedule_id IN NUMBER default null,
68 X_last_update_date IN DATE,
69 X_last_updated_by IN NUMBER,
70 X_last_update_login IN NUMBER,
71 X_department_id IN NUMBER,
72 X_wip_supply_type IN NUMBER,
73 X_date_required IN DATE,
74 X_required_quantity IN NUMBER,
75 X_quantity_issued IN NUMBER,
76 X_quantity_per_assembly IN NUMBER,
77 X_comments IN VARCHAR2,
78 X_supply_subinventory IN VARCHAR2,
79 X_supply_locator_id IN NUMBER,
80 X_mrp_net_flag IN NUMBER,
81 X_mps_required_quantity IN NUMBER default null,
82 X_mps_date_required IN DATE default null,
83 X_attribute_category IN VARCHAR2,
84 X_attribute1 IN VARCHAR2,
85 X_attribute2 IN VARCHAR2,
86 X_attribute3 IN VARCHAR2,
87 X_attribute4 IN VARCHAR2,
88 X_attribute5 IN VARCHAR2,
89 X_attribute6 IN VARCHAR2,
90 X_attribute7 IN VARCHAR2,
91 X_attribute8 IN VARCHAR2,
92 X_attribute9 IN VARCHAR2,
93 X_attribute10 IN VARCHAR2,
94 X_attribute11 IN VARCHAR2,
95 X_attribute12 IN VARCHAR2,
96 X_attribute13 IN VARCHAR2,
97 X_attribute14 IN VARCHAR2,
98 X_attribute15 IN VARCHAR2,
99 X_auto_request_material IN VARCHAR2,
100 X_L_EAM_MAT_REC OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type,
101 X_material_shortage_flag OUT NOCOPY VARCHAR2,
102 X_material_shortage_check_date OUT NOCOPY DATE
103 );
104
105
106 PROCEDURE Lock_Row( X_row_id IN VARCHAR2,
107 X_inventory_item_id IN NUMBER,
108 X_organization_id IN NUMBER,
109 X_wip_entity_id IN NUMBER,
110 X_operation_seq_num IN NUMBER,
111 X_department_id IN NUMBER,
112 X_wip_supply_type IN NUMBER,
113 X_date_required IN DATE,
114 X_required_quantity IN NUMBER,
115 X_quantity_issued IN NUMBER,
116 X_quantity_per_assembly IN NUMBER,
117 X_comments IN VARCHAR2,
118 X_supply_subinventory IN VARCHAR2,
119 X_supply_locator_id IN NUMBER,
120 X_mrp_net_flag IN NUMBER,
121 X_attribute_category IN VARCHAR2,
122 X_attribute1 IN VARCHAR2,
123 X_attribute2 IN VARCHAR2,
124 X_attribute3 IN VARCHAR2,
125 X_attribute4 IN VARCHAR2,
126 X_attribute5 IN VARCHAR2,
127 X_attribute6 IN VARCHAR2,
128 X_attribute7 IN VARCHAR2,
129 X_attribute8 IN VARCHAR2,
130 X_attribute9 IN VARCHAR2,
131 X_attribute10 IN VARCHAR2,
132 X_attribute11 IN VARCHAR2,
133 X_attribute12 IN VARCHAR2,
134 X_attribute13 IN VARCHAR2,
135 X_attribute14 IN VARCHAR2,
136 X_attribute15 IN VARCHAR2,
137 X_auto_request_material IN VARCHAR2);
138
139
140 PROCEDURE Delete_Row(X_row_id IN VARCHAR2,
141 X_material_shortage_flag OUT NOCOPY VARCHAR2,
142 X_material_shortage_check_date OUT NOCOPY DATE);
143
144
145 --
146 -- baroy - API to delete a requirements row from SS
147 --
148 PROCEDURE Delete_Row_SS(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2,
151 p_commit IN VARCHAR2,
152 p_validate_only IN VARCHAR2,
153 p_record_version_number IN NUMBER,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2,
157 p_inventory_item_id IN NUMBER,
158 p_organization_id IN NUMBER,
159 p_wip_entity_id IN NUMBER,
160 p_operation_seq_num IN NUMBER);
161
162 -- Procuedure to delete a description based direct item
163
164 PROCEDURE Delete_Desc_Row_SS(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2,
167 p_commit IN VARCHAR2,
168 p_validate_only IN VARCHAR2,
169 p_record_version_number IN NUMBER,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 p_di_sequence_id IN NUMBER,
174 p_organization_id IN NUMBER,
175 p_wip_entity_id IN NUMBER,
176 p_operation_seq_num IN NUMBER);
177
178
179 END EAM_REQUIREMENTS_PKG;