1 PACKAGE WIP_Validate AUTHID CURRENT_USER AS
2 /* $Header: WIPSVATS.pls 115.9 2002/12/01 13:13:55 simishra ship $ */
3
4 -- Procedure Get_Attr_Tbl;
5 --
6 -- Used by generator to avoid overriding or duplicating existing
7 -- validation functions.
8 --
9 -- DO NOT MODIFY
10
11 PROCEDURE Get_Attr_Tbl;
12
13 -- Prototypes for validate functions.
14
15 -- START GEN validate
16
17 -- Generator will append new prototypes before end generate comment.
18
19 FUNCTION Desc_Flex ( p_flex_name IN VARCHAR2 )RETURN BOOLEAN;
20
21 -- FUNCTION Created_By(p_created_by IN NUMBER)RETURN BOOLEAN;
22 -- FUNCTION Creation_Date(p_creation_date IN DATE)RETURN BOOLEAN;
23 -- FUNCTION Description(p_description IN VARCHAR2)RETURN BOOLEAN;
24
25 FUNCTION Entity_Type(p_entity_type IN NUMBER)RETURN BOOLEAN;
26 -- FUNCTION Last_Updated_By(p_last_updated_by IN NUMBER)RETURN BOOLEAN;
27 -- FUNCTION Last_Update_Date(p_last_update_date IN DATE)RETURN BOOLEAN;
28 -- FUNCTION Last_Update_Login(p_last_update_login IN NUMBER)RETURN BOOLEAN;
29 FUNCTION Organization(p_organization_id IN NUMBER)RETURN BOOLEAN;
30 FUNCTION Primary_Item(p_primary_item_id IN NUMBER,
31 p_organization_id IN NUMBER)RETURN BOOLEAN;
32 -- FUNCTION Program_Application(p_program_application_id IN NUMBER)RETURN BOOLEAN;
33 -- FUNCTION Program(p_program_id IN NUMBER)RETURN BOOLEAN;
34 -- FUNCTION Program_Update_Date(p_program_update_date IN DATE)RETURN BOOLEAN;
35 -- FUNCTION Request(p_request_id IN NUMBER)RETURN BOOLEAN;
36 FUNCTION Wip_Entity(p_wip_entity_id IN NUMBER)RETURN BOOLEAN;
37 FUNCTION Wip_Entity_Name(p_wip_entity_name IN VARCHAR2,
38 p_organization_id IN NUMBER)RETURN BOOLEAN;
39
40 FUNCTION Alternate_Bom_Designator(p_alternate_bom_designator IN VARCHAR2,
41 p_organization_id IN NUMBER)RETURN BOOLEAN;
42 FUNCTION Alternate_Rout_Designator(p_alternate_rout_designator IN VARCHAR2,
43 p_organization_id IN NUMBER)RETURN BOOLEAN;
44 FUNCTION Bom_Revision(p_bom_revision IN VARCHAR2,
45 p_inventory_item_id IN NUMBER,
46 p_organization_id IN NUMBER)RETURN BOOLEAN;
47 -- FUNCTION Bom_Revision_Date(p_bom_revision_date IN DATE)RETURN BOOLEAN;
48 FUNCTION Build_Sequence(p_build_sequence IN NUMBER,
49 p_wip_entity_id IN NUMBER,
50 p_organization_id IN NUMBER,
51 p_line_id IN NUMBER,
52 p_schedule_group_id IN NUMBER)RETURN BOOLEAN;
53 FUNCTION Class(p_class_code IN VARCHAR2,
54 p_organization_id IN NUMBER)RETURN BOOLEAN;
55 -- FUNCTION Completion_Locator(p_completion_locator_id IN NUMBER)RETURN BOOLEAN;
56 FUNCTION Completion_Subinventory(p_completion_subinventory IN VARCHAR2,
57 p_organization_id IN NUMBER)RETURN BOOLEAN;
58 -- FUNCTION Date_Closed(p_date_closed IN DATE)RETURN BOOLEAN;
59 -- FUNCTION Demand_Class(p_demand_class IN VARCHAR2)RETURN BOOLEAN;
60 FUNCTION Demand_Source_Delivery(p_demand_source_delivery IN VARCHAR2,
61 p_demand_source_line IN VARCHAR2,
62 p_demand_source_header_id IN NUMBER,
63 p_demand_source_type IN NUMBER,
64 p_inventory_item_id IN NUMBER)RETURN BOOLEAN;
65 FUNCTION Demand_Source_Header(p_demand_source_header_id IN NUMBER,
66 p_demand_source_type IN NUMBER,
67 p_inventory_item_id IN NUMBER)RETURN BOOLEAN;
68 FUNCTION Demand_Source_Line(p_demand_source_line IN VARCHAR2,
69 p_demand_source_header_id IN NUMBER,
70 p_demand_source_type IN NUMBER,
71 p_inventory_item_id IN NUMBER)RETURN BOOLEAN;
72 -- FUNCTION Demand_Source_Type(p_demand_source_type IN NUMBER)RETURN BOOLEAN;
73 FUNCTION Kanban_Card(p_kanban_card_id IN NUMBER,
74 p_organization_id IN NUMBER)RETURN BOOLEAN;
75 FUNCTION Line(p_line_id IN NUMBER)RETURN BOOLEAN;
76 FUNCTION Material_Account(p_material_account IN NUMBER)RETURN BOOLEAN;
77 FUNCTION Material_Overhead_Account(p_material_overhead_account IN NUMBER)RETURN BOOLEAN;
78 FUNCTION Material_Variance_Account(p_material_variance_account IN NUMBER)RETURN BOOLEAN;
79 -- FUNCTION Mps_Net_Quantity(p_mps_net_quantity IN NUMBER)RETURN BOOLEAN;
80 -- FUNCTION Mps_Scheduled_Cpl_Date(p_mps_scheduled_cpl_date IN DATE)RETURN BOOLEAN;
81 FUNCTION Osp_Account(p_osp_account IN NUMBER)RETURN BOOLEAN;
82 FUNCTION Osp_Variance_Account(p_osp_variance_account IN NUMBER)RETURN BOOLEAN;
83 FUNCTION Overhead_Account(p_overhead_account IN NUMBER)RETURN BOOLEAN;
84 FUNCTION Overhead_Variance_Account(p_overhead_variance_account IN NUMBER)RETURN BOOLEAN;
85 -- FUNCTION Planned_Quantity(p_planned_quantity IN NUMBER)RETURN BOOLEAN;
86 FUNCTION Project(p_project_id IN NUMBER,
87 p_organization_id IN NUMBER)RETURN BOOLEAN;
88 -- FUNCTION Quantity_Completed(p_quantity_completed IN NUMBER)RETURN BOOLEAN;
89 FUNCTION Resource_Account(p_resource_account IN NUMBER)RETURN BOOLEAN;
90 FUNCTION Resource_Variance_Account(p_resource_variance_account IN NUMBER)RETURN BOOLEAN;
91 FUNCTION Routing_Revision(p_routing_revision IN VARCHAR2,
92 p_inventory_item_id IN NUMBER,
93 p_organization_id IN NUMBER)RETURN BOOLEAN;
94 -- FUNCTION Routing_Revision_Date(p_routing_revision_date IN DATE)RETURN BOOLEAN;
95 -- FUNCTION Scheduled_Completion_Date(p_scheduled_completion_date IN DATE)RETURN BOOLEAN;
96 -- FUNCTION Scheduled(p_scheduled_flag IN NUMBER)RETURN BOOLEAN;
97 -- FUNCTION Scheduled_Start_Date(p_scheduled_start_date IN DATE)RETURN BOOLEAN;
98 FUNCTION Schedule_Group(p_schedule_group_id IN NUMBER)RETURN BOOLEAN;
99 -- FUNCTION Schedule_Number(p_schedule_number IN VARCHAR2)RETURN BOOLEAN;
100 -- FUNCTION Status(p_status IN NUMBER)RETURN BOOLEAN;
101 FUNCTION Std_Cost_Adj_Account(p_std_cost_adj_account IN NUMBER)RETURN BOOLEAN;
102 FUNCTION Task(p_task_id IN NUMBER,
103 p_project_id IN NUMBER,
104 p_organization_id IN NUMBER)RETURN BOOLEAN;
105
106 FUNCTION Bom_Reference(p_bom_reference_id IN NUMBER,
107 p_organization_id IN NUMBER)RETURN BOOLEAN;
108 FUNCTION Common_Bom_Sequence(p_common_bom_sequence_id IN NUMBER)RETURN BOOLEAN;
109 FUNCTION Common_Rout_Sequence(p_common_rout_sequence_id IN NUMBER)RETURN BOOLEAN;
110 -- FUNCTION Date_Completed(p_date_completed IN DATE)RETURN BOOLEAN;
111 -- FUNCTION Date_Released(p_date_released IN DATE)RETURN BOOLEAN;
112 FUNCTION Firm_Planned(p_firm_planned_flag IN NUMBER)RETURN BOOLEAN;
113 FUNCTION Job_Type(p_job_type IN NUMBER)RETURN BOOLEAN;
114 -- FUNCTION Lot_Number(p_lot_number IN VARCHAR2)RETURN BOOLEAN;
115 -- FUNCTION Net_Quantity(p_net_quantity IN NUMBER)RETURN BOOLEAN;
116 FUNCTION Overcpl_Tolerance_Type(p_overcpl_tolerance_type IN NUMBER)RETURN BOOLEAN;
117 -- FUNCTION Overcpl_Tolerance_Value(p_overcpl_tolerance_value IN NUMBER)RETURN BOOLEAN;
118 -- FUNCTION Project_Costed(p_project_costed IN NUMBER)RETURN BOOLEAN;
119 -- FUNCTION Quantity_Scrapped(p_quantity_scrapped IN NUMBER)RETURN BOOLEAN;
120 FUNCTION Routing_Reference(p_routing_reference_id IN NUMBER,
121 p_organization_id IN NUMBER)RETURN BOOLEAN;
122 -- FUNCTION Source(p_source_code IN VARCHAR2)RETURN BOOLEAN;
123 -- FUNCTION Source_Line(p_source_line_id IN NUMBER)RETURN BOOLEAN;
124 -- FUNCTION Start_Quantity(p_start_quantity IN NUMBER)RETURN BOOLEAN;
125 FUNCTION Status_Type(p_status_type IN NUMBER)RETURN BOOLEAN;
126 FUNCTION Wip_Supply_Type(p_wip_supply_type IN NUMBER)RETURN BOOLEAN;
127
128 -- FUNCTION Daily_Production_Rate(p_daily_production_rate IN NUMBER)RETURN BOOLEAN;
129 -- FUNCTION First_Unit_Cpl_Date(p_first_unit_cpl_date IN DATE)RETURN BOOLEAN;
130 -- FUNCTION First_Unit_Start_Date(p_first_unit_start_date IN DATE)RETURN BOOLEAN;
131 -- FUNCTION Last_Unit_Cpl_Date(p_last_unit_cpl_date IN DATE)RETURN BOOLEAN;
132 -- FUNCTION Last_Unit_Start_Date(p_last_unit_start_date IN DATE)RETURN BOOLEAN;
133 -- FUNCTION Processing_Work_Days(p_processing_work_days IN NUMBER)RETURN BOOLEAN;
134 FUNCTION Repetitive_Schedule(p_repetitive_schedule_id IN NUMBER)RETURN BOOLEAN;
135
136 -- FUNCTION Dummy(p_dummy IN VARCHAR2)RETURN BOOLEAN;
137
138 FUNCTION Acct_Period(p_acct_period_id IN NUMBER,
139 p_organization_id IN NUMBER)RETURN BOOLEAN;
140 -- FUNCTION Allowed_Units_Lookup(p_allowed_units_lookup_code IN NUMBER)RETURN BOOLEAN;
141 FUNCTION Completion_Transaction(p_completion_transaction_id IN NUMBER)RETURN BOOLEAN;
142 -- FUNCTION Containers(p_containers IN NUMBER)RETURN BOOLEAN;
143 -- FUNCTION Cost_Group(p_cost_group_id IN NUMBER)RETURN BOOLEAN;
144 -- FUNCTION Current_Loc_Control(p_current_loc_control_code IN NUMBER)RETURN BOOLEAN;
145 -- FUNCTION Customer_Ship(p_customer_ship_id IN NUMBER)RETURN BOOLEAN;
146 -- FUNCTION Cycle_Count(p_cycle_count_id IN NUMBER)RETURN BOOLEAN;
147 -- FUNCTION Demand(p_demand_id IN NUMBER)RETURN BOOLEAN;
148 -- FUNCTION Distribution_Account(p_distribution_account_id IN NUMBER)RETURN BOOLEAN;
149 -- FUNCTION Encumbrance_Account(p_encumbrance_account IN NUMBER)RETURN BOOLEAN;
150 -- FUNCTION Encumbrance_Amount(p_encumbrance_amount IN NUMBER)RETURN BOOLEAN;
151 -- FUNCTION Error(p_error_code IN VARCHAR2)RETURN BOOLEAN;
152 -- FUNCTION Error_Explanation(p_error_explanation IN VARCHAR2)RETURN BOOLEAN;
153 -- FUNCTION Expected_Arrival_Date(p_expected_arrival_date IN DATE)RETURN BOOLEAN;
154 -- FUNCTION Expenditure_Type(p_expenditure_type IN VARCHAR2)RETURN BOOLEAN;
155 -- FUNCTION Final_Completion(p_final_completion_flag IN VARCHAR2)RETURN BOOLEAN;
156 -- FUNCTION Flow_Schedule(p_flow_schedule IN VARCHAR2)RETURN BOOLEAN;
157 -- FUNCTION Freight(p_freight_code IN VARCHAR2)RETURN BOOLEAN;
158 -- FUNCTION Inventory_Item(p_inventory_item_id IN NUMBER)RETURN BOOLEAN;
159 -- FUNCTION Item_Description(p_item_description IN VARCHAR2)RETURN BOOLEAN;
160 -- FUNCTION Item_Inventory_Asset(p_item_inventory_asset_flag IN VARCHAR2)RETURN BOOLEAN;
161 -- FUNCTION Item_Loc_Control(p_item_loc_control_code IN NUMBER)RETURN BOOLEAN;
162 -- FUNCTION Item_Lot_Control(p_item_lot_control_code IN NUMBER)RETURN BOOLEAN;
163 -- FUNCTION Item_Ordering(p_item_ordering IN NUMBER)RETURN BOOLEAN;
164 -- FUNCTION Item_Primary_Uom(p_item_primary_uom_code IN VARCHAR2)RETURN BOOLEAN;
165 -- FUNCTION Item_Restrict_Loc(p_item_restrict_loc_code IN NUMBER)RETURN BOOLEAN;
166 -- FUNCTION Item_Restrict_Subinv(p_item_restrict_subinv_code IN NUMBER)RETURN BOOLEAN;
167 -- FUNCTION Item_Rev_Qty_Control(p_item_rev_qty_control_code IN NUMBER)RETURN BOOLEAN;
168 -- FUNCTION Item_Segments(p_item_segments IN VARCHAR2)RETURN BOOLEAN;
169 -- FUNCTION Item_Serial_Control(p_item_serial_control_code IN NUMBER)RETURN BOOLEAN;
170 -- FUNCTION Item_Shelf_Life(p_item_shelf_life_code IN NUMBER)RETURN BOOLEAN;
171 -- FUNCTION Item_Shelf_Life_Days(p_item_shelf_life_days IN NUMBER)RETURN BOOLEAN;
172 -- FUNCTION Item_Trx_Enabled(p_item_trx_enabled_flag IN VARCHAR2)RETURN BOOLEAN;
173 -- FUNCTION Item_Uom_Class(p_item_uom_class IN VARCHAR2)RETURN BOOLEAN;
174 -- FUNCTION Locator(p_locator_id IN NUMBER)RETURN BOOLEAN;
175 -- FUNCTION Locator_Segments(p_locator_segments IN VARCHAR2)RETURN BOOLEAN;
176 -- FUNCTION Lock_Flag(p_lock_flag IN VARCHAR2)RETURN BOOLEAN;
177 -- FUNCTION Lot_Alpha_Prefix(p_lot_alpha_prefix IN VARCHAR2)RETURN BOOLEAN;
178 -- FUNCTION Lot_Expiration_Date(p_lot_expiration_date IN DATE)RETURN BOOLEAN;
179 -- FUNCTION Material_Alloc_Temp(p_material_alloc_temp_id IN NUMBER)RETURN BOOLEAN;
180 -- FUNCTION Movement(p_movement_id IN NUMBER)RETURN BOOLEAN;
181 -- FUNCTION Negative_Req(p_negative_req_flag IN NUMBER)RETURN BOOLEAN;
182 -- FUNCTION New_Average_Cost(p_new_average_cost IN NUMBER)RETURN BOOLEAN;
183 -- FUNCTION Next_Lot_Number(p_next_lot_number IN VARCHAR2)RETURN BOOLEAN;
184 -- FUNCTION Next_Serial_Number(p_next_serial_number IN VARCHAR2)RETURN BOOLEAN;
185 -- FUNCTION Number_Of_Lots_Entered(p_number_of_lots_entered IN NUMBER)RETURN BOOLEAN;
186 -- FUNCTION Overcpl_Primary_Qty(p_overcpl_primary_qty IN NUMBER)RETURN BOOLEAN;
187 -- FUNCTION Overcpl_Transaction(p_overcpl_transaction_id IN NUMBER)RETURN BOOLEAN;
188 -- FUNCTION Overcpl_Transaction_Qty(p_overcpl_transaction_qty IN NUMBER)RETURN BOOLEAN;
189 -- FUNCTION Pa_Expenditure_Org(p_pa_expenditure_org_id IN NUMBER)RETURN BOOLEAN;
190 -- FUNCTION Percentage_Change(p_percentage_change IN NUMBER)RETURN BOOLEAN;
191 -- FUNCTION Physical_Adjustment(p_physical_adjustment_id IN NUMBER)RETURN BOOLEAN;
192 -- FUNCTION Picking_Line(p_picking_line_id IN NUMBER)RETURN BOOLEAN;
193 -- FUNCTION Posting(p_posting_flag IN VARCHAR2)RETURN BOOLEAN;
194 -- FUNCTION Primary_Switch(p_primary_switch IN NUMBER)RETURN BOOLEAN;
195 -- FUNCTION Process(p_process_flag IN VARCHAR2)RETURN BOOLEAN;
196 -- FUNCTION Process_Type(p_process_type IN NUMBER)RETURN BOOLEAN;
197 -- FUNCTION Qa_Collection(p_qa_collection_id IN NUMBER)RETURN BOOLEAN;
198 -- FUNCTION Receiving_Document(p_receiving_document IN VARCHAR2)RETURN BOOLEAN;
199 -- FUNCTION Repetitive_Line(p_repetitive_line_id IN NUMBER)RETURN BOOLEAN;
200 -- FUNCTION Required(p_required_flag IN VARCHAR2)RETURN BOOLEAN;
201 -- FUNCTION Req_Distribution(p_req_distribution_id IN NUMBER)RETURN BOOLEAN;
202 -- FUNCTION Requisition_Line(p_requisition_line_id IN NUMBER)RETURN BOOLEAN;
203 -- FUNCTION Reservation_Quantity(p_reservation_quantity IN NUMBER)RETURN BOOLEAN;
204 -- FUNCTION Revision(p_revision IN VARCHAR2)RETURN BOOLEAN;
205 -- FUNCTION Rma_Line(p_rma_line_id IN NUMBER)RETURN BOOLEAN;
206 -- FUNCTION Schedule(p_schedule_id IN NUMBER)RETURN BOOLEAN;
207 -- FUNCTION Schedule_Update(p_schedule_update_code IN NUMBER)RETURN BOOLEAN;
208 -- FUNCTION Serial_Alpha_Prefix(p_serial_alpha_prefix IN VARCHAR2)RETURN BOOLEAN;
209 -- FUNCTION Serial_Number(p_serial_number IN VARCHAR2)RETURN BOOLEAN;
210 -- FUNCTION Setup_Teardown(p_setup_teardown_code IN NUMBER)RETURN BOOLEAN;
211 -- FUNCTION Shipment_Number(p_shipment_number IN VARCHAR2)RETURN BOOLEAN;
212 -- FUNCTION Shippable(p_shippable_flag IN VARCHAR2)RETURN BOOLEAN;
213 -- FUNCTION Shipped_Quantity(p_shipped_quantity IN NUMBER)RETURN BOOLEAN;
214 -- FUNCTION Ship_To_Location(p_ship_to_location IN NUMBER)RETURN BOOLEAN;
215 -- FUNCTION Source_Project(p_source_project_id IN NUMBER)RETURN BOOLEAN;
216 -- FUNCTION Source_Task(p_source_task_id IN NUMBER)RETURN BOOLEAN;
217 -- FUNCTION Subinventory(p_subinventory_code IN VARCHAR2)RETURN BOOLEAN;
218 -- FUNCTION Supply_Locator(p_supply_locator_id IN NUMBER)RETURN BOOLEAN;
219 -- FUNCTION Supply_Subinventory(p_supply_subinventory IN VARCHAR2)RETURN BOOLEAN;
220 -- FUNCTION To_Project(p_to_project_id IN NUMBER)RETURN BOOLEAN;
221 -- FUNCTION To_Task(p_to_task_id IN NUMBER)RETURN BOOLEAN;
222 -- FUNCTION Transaction_Action(p_transaction_action_id IN NUMBER)RETURN BOOLEAN;
223 -- FUNCTION Transaction_Cost(p_transaction_cost IN NUMBER)RETURN BOOLEAN;
224 -- FUNCTION Transaction_Date(p_transaction_date IN DATE)RETURN BOOLEAN;
225 -- FUNCTION Transaction_Header(p_transaction_header_id IN NUMBER)RETURN BOOLEAN;
226 -- FUNCTION Transaction_Line_Number(p_transaction_line_number IN NUMBER)RETURN BOOLEAN;
227 -- FUNCTION Transaction_Mode(p_transaction_mode IN NUMBER)RETURN BOOLEAN;
228 -- FUNCTION Transaction_Quantity(p_transaction_quantity IN NUMBER)RETURN BOOLEAN;
229 -- FUNCTION Transaction_Reference(p_transaction_reference IN VARCHAR2)RETURN BOOLEAN;
230 -- FUNCTION Transaction_Sequence(p_transaction_sequence_id IN NUMBER)RETURN BOOLEAN;
231 -- FUNCTION Transaction_Source(p_transaction_source_id IN NUMBER)RETURN BOOLEAN;
232 -- FUNCTION Transaction_Source_Name(p_transaction_source_name IN VARCHAR2)RETURN BOOLEAN;
233 -- FUNCTION Transaction_Src_Type(p_transaction_src_type_id IN NUMBER)RETURN BOOLEAN;
234 -- FUNCTION Transaction_Temp(p_transaction_temp_id IN NUMBER)RETURN BOOLEAN;
235 -- FUNCTION Transfer_Cost(p_transfer_cost IN NUMBER)RETURN BOOLEAN;
236 -- FUNCTION Transfer_Organization(p_transfer_organization IN NUMBER)RETURN BOOLEAN;
237 -- FUNCTION Transfer_Percentage(p_transfer_percentage IN NUMBER)RETURN BOOLEAN;
238 -- FUNCTION Transfer_Subinventory(p_transfer_subinventory IN VARCHAR2)RETURN BOOLEAN;
239 -- FUNCTION Transfer_To_Location(p_transfer_to_location IN NUMBER)RETURN BOOLEAN;
240 -- FUNCTION Transportation_Account(p_transportation_account IN NUMBER)RETURN BOOLEAN;
241 -- FUNCTION Transportation_Cost(p_transportation_cost IN NUMBER)RETURN BOOLEAN;
242 -- FUNCTION Trx_Source_Delivery(p_trx_source_delivery_id IN NUMBER)RETURN BOOLEAN;
243 -- FUNCTION Trx_Source_Line(p_trx_source_line_id IN NUMBER)RETURN BOOLEAN;
244 -- FUNCTION Ussgl_Transaction(p_ussgl_transaction_code IN VARCHAR2)RETURN BOOLEAN;
245 -- FUNCTION Valid_Locator(p_valid_locator_flag IN VARCHAR2)RETURN BOOLEAN;
246 -- FUNCTION Valid_Subinventory(p_valid_subinventory_flag IN VARCHAR2)RETURN BOOLEAN;
247 -- FUNCTION Value_Change(p_value_change IN NUMBER)RETURN BOOLEAN;
248 -- FUNCTION Vendor_Lot_Number(p_vendor_lot_number IN VARCHAR2)RETURN BOOLEAN;
249 -- FUNCTION Waybill_Airbill(p_waybill_airbill IN VARCHAR2)RETURN BOOLEAN;
250 -- FUNCTION Wip_Commit(p_wip_commit_flag IN VARCHAR2)RETURN BOOLEAN;
251 -- FUNCTION Wip_Entity_Type(p_wip_entity_type IN NUMBER)RETURN BOOLEAN;
252
253 FUNCTION Activity(p_activity_id IN NUMBER)RETURN BOOLEAN;
257 FUNCTION Basis_Type(p_basis_type IN NUMBER)RETURN BOOLEAN;
254 FUNCTION Activity_Name(p_activity_name IN VARCHAR2)RETURN BOOLEAN;
255 FUNCTION Actual_Resource_Rate(p_actual_resource_rate IN NUMBER)RETURN BOOLEAN;
256 FUNCTION Autocharge_Type(p_autocharge_type IN NUMBER)RETURN BOOLEAN;
258 FUNCTION Created_By_Name(p_created_by_name IN VARCHAR2)RETURN BOOLEAN;
259 FUNCTION Currency(p_currency_code IN VARCHAR2)RETURN BOOLEAN;
260 FUNCTION Currency_Conversion_Date(p_currency_conversion_date IN DATE)RETURN BOOLEAN;
261 FUNCTION Currency_Conversion_Rate(p_currency_conversion_rate IN NUMBER)RETURN BOOLEAN;
262 FUNCTION Currency_Conversion_Type(p_currency_conversion_type IN VARCHAR2)RETURN BOOLEAN;
263 FUNCTION Currency_Actual_Rsc_Rate(p_currency_actual_rsc_rate IN NUMBER)RETURN BOOLEAN;
264 FUNCTION Department_Code(
265 p_department_code IN VARCHAR2,
266 p_organization_id IN NUMBER,
267 p_attribute_name IN VARCHAR2 DEFAULT NULL)
268 RETURN BOOLEAN;
269 FUNCTION Department_Id (
270 p_department_id IN NUMBER,
271 p_attribute_name IN VARCHAR2 DEFAULT NULL)
272 RETURN BOOLEAN;
273 FUNCTION Employee(p_employee_code IN VARCHAR2)RETURN BOOLEAN;
274 FUNCTION Employee_Num(p_employee_num IN VARCHAR2)RETURN BOOLEAN;
275 FUNCTION Group_Id(p_group_id IN NUMBER)RETURN BOOLEAN;
276 FUNCTION Last_Updated_By_Name(p_last_updated_by_name IN VARCHAR2)RETURN BOOLEAN;
277 FUNCTION Move_Transaction(p_move_transaction_id IN NUMBER)RETURN BOOLEAN;
278 FUNCTION Operation_Seq_Num(
279 p_operation_seq_num IN NUMBER,
280 p_attribute_name IN VARCHAR2 DEFAULT NULL)
281 RETURN BOOLEAN;
282 FUNCTION Po_Header(p_po_header_id IN NUMBER)RETURN BOOLEAN;
283 FUNCTION Po_Line(p_po_line_id IN NUMBER)RETURN BOOLEAN;
284 FUNCTION Primary_Quantity(p_primary_quantity IN NUMBER)RETURN BOOLEAN;
285 FUNCTION Primary_Uom(p_primary_uom IN VARCHAR2)RETURN BOOLEAN;
286 FUNCTION Primary_Uom_Class(p_primary_uom_class IN VARCHAR2)RETURN BOOLEAN;
287 FUNCTION Process_Phase(
288 p_process_phase IN NUMBER,
289 p_lookup_type IN VARCHAR2)
290 RETURN BOOLEAN;
291 FUNCTION Process_Status(p_process_status IN NUMBER)RETURN BOOLEAN;
292 FUNCTION Project_Number(p_project_number IN VARCHAR2)RETURN BOOLEAN;
293 FUNCTION Rcv_Transaction(p_rcv_transaction_id IN NUMBER)RETURN BOOLEAN;
294 FUNCTION Reason(p_reason_id IN NUMBER)RETURN BOOLEAN;
295 FUNCTION Reason_Name(p_reason_name IN VARCHAR2)RETURN BOOLEAN;
296 FUNCTION Receiving_Account(p_receiving_account_id IN NUMBER)RETURN BOOLEAN;
297 FUNCTION Reference(p_reference IN VARCHAR2)RETURN BOOLEAN;
298 FUNCTION Resource_Code(
299 p_resource_code IN VARCHAR2,
300 p_organization_id IN NUMBER)
301 RETURN BOOLEAN;
302 FUNCTION Resource_Id(p_resource_id IN NUMBER)RETURN BOOLEAN;
303 FUNCTION Resource_Seq_Num(p_resource_seq_num IN NUMBER)RETURN BOOLEAN;
304 FUNCTION Resource_Type(p_resource_type IN NUMBER)RETURN BOOLEAN;
305 FUNCTION Standard_Rate(p_standard_rate_flag IN NUMBER)RETURN BOOLEAN;
306 FUNCTION Task_Number(p_task_number IN VARCHAR2)RETURN BOOLEAN;
307 FUNCTION Transaction(p_transaction_id IN NUMBER)RETURN BOOLEAN;
308 FUNCTION Usage_Rate_Or_Amount(p_usage_rate_or_amount IN NUMBER)RETURN BOOLEAN;
309
310 /**FUNCTION Fm_Department_Code(p_fm_department_code IN VARCHAR2, p_organization_id IN NUMBER)RETURN BOOLEAN; **/
311 /**FUNCTION Fm_Department_Id(p_fm_department_id IN NUMBER)RETURN BOOLEAN; **/
312 /**FUNCTION Fm_Intraop_Step_Type(p_fm_intraop_step_type IN NUMBER)RETURN BOOLEAN;**/
313 /**FUNCTION Fm_Operation(p_fm_operation_code IN VARCHAR2)RETURN BOOLEAN; **/
314 /**FUNCTION Fm_Operation_Seq_Num(p_fm_operation_seq_num IN NUMBER)RETURN BOOLEAN;**/
315 FUNCTION Intraop_Step_Type(
316 p_intraop_step_type IN NUMBER,
317 p_attribute_name IN VARCHAR2 DEFAULT NULL)
318 RETURN BOOLEAN;
319 FUNCTION Kanban(p_kanban_id IN NUMBER)RETURN BOOLEAN;
320 FUNCTION Operation_Code(
321 p_operation_code IN VARCHAR2,
322 p_attribute_name IN VARCHAR2 DEFAULT NULL)
323 RETURN BOOLEAN;
324 FUNCTION Overcompletion(p_overcompletion_flag IN VARCHAR2)RETURN BOOLEAN;
325 FUNCTION Overmove_Txn_Qty(p_overmove_txn_qty IN NUMBER)RETURN BOOLEAN;
326 FUNCTION Scrap_Account(p_scrap_account_id IN NUMBER)RETURN BOOLEAN;
327 /**FUNCTION To_Department_Code(p_to_department_code IN VARCHAR2, p_organization_id IN NUMBER)RETURN BOOLEAN; **/
328 /*FUNCTION To_Department_Id(p_to_department_id IN NUMBER)RETURN BOOLEAN; */
329 /*FUNCTION To_Intraop_Step_Type(p_to_intraop_step_type IN NUMBER)RETURN BOOLEAN;*/
330 /**FUNCTION To_Operation(p_to_operation_code IN VARCHAR2)RETURN BOOLEAN; **/
331 /** FUNCTION To_Operation_Seq_Num(p_to_operation_seq_num IN NUMBER)RETURN BOOLEAN; **/
332 FUNCTION Transaction_Link(p_transaction_link_id IN NUMBER)RETURN BOOLEAN;
333 FUNCTION Transaction_Type(
334 p_transaction_type_id IN NUMBER,
335 p_lookup_type IN VARCHAR2)
336 RETURN BOOLEAN;
337 FUNCTION Transaction_Uom(p_transaction_uom IN VARCHAR2)RETURN BOOLEAN;
338
339 -- FUNCTION Currency_Act_Rsc_Rate(p_currency_act_rsc_rate IN NUMBER)RETURN BOOLEAN;
340
341 -- END GEN validate
342
343 END WIP_Validate;
[Home] [Help]