1 PACKAGE MRP_Validate AUTHID CURRENT_USER AS
2 /* $Header: MRPSVATS.pls 115.5 99/07/16 12:38:05 porting 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 FUNCTION Alternate_Bom_Designator(p_alternate_bom_designator IN VARCHAR2)RETURN BOOLEAN;
21 FUNCTION Alternate_Routing_Desig(p_alternate_routing_desig IN VARCHAR2)RETURN BOOLEAN;
22 FUNCTION Bom_Revision(p_bom_revision IN VARCHAR2)RETURN BOOLEAN;
23 FUNCTION Bom_Revision_Date(p_bom_revision_date IN DATE)RETURN BOOLEAN;
24 FUNCTION Build_Sequence(p_build_sequence IN NUMBER)RETURN BOOLEAN;
25 FUNCTION Class(p_class_code IN VARCHAR2)RETURN BOOLEAN;
26 FUNCTION Completion_Locator(p_completion_locator_id IN NUMBER)RETURN BOOLEAN;
27 FUNCTION Completion_Subinventory(p_completion_subinventory IN VARCHAR2)RETURN BOOLEAN;
28 FUNCTION Created_By(p_created_by IN NUMBER)RETURN BOOLEAN;
29 FUNCTION Creation_Date(p_creation_date IN DATE)RETURN BOOLEAN;
30 FUNCTION Date_Closed(p_date_closed IN DATE)RETURN BOOLEAN;
31 FUNCTION Demand_Class(p_demand_class IN VARCHAR2)RETURN BOOLEAN;
32 FUNCTION Demand_Source_Delivery(p_demand_source_delivery IN VARCHAR2)RETURN BOOLEAN;
33 FUNCTION Demand_Source_Header(p_demand_source_header_id IN NUMBER)RETURN BOOLEAN;
34 FUNCTION Demand_Source_Line(p_demand_source_line IN VARCHAR2)RETURN BOOLEAN;
35 FUNCTION Demand_Source_Type(p_demand_source_type IN NUMBER)RETURN BOOLEAN;
36 FUNCTION Last_Updated_By(p_last_updated_by IN NUMBER)RETURN BOOLEAN;
37 FUNCTION Last_Update_Date(p_last_update_date IN DATE)RETURN BOOLEAN;
38 FUNCTION Last_Update_Login(p_last_update_login IN NUMBER)RETURN BOOLEAN;
39 FUNCTION Line(p_line_id IN NUMBER)RETURN BOOLEAN;
40 FUNCTION Material_Account(p_material_account IN NUMBER)RETURN BOOLEAN;
41 FUNCTION Material_Overhead_Account(p_material_overhead_account IN NUMBER)RETURN BOOLEAN;
42 FUNCTION Material_Variance_Account(p_material_variance_account IN NUMBER)RETURN BOOLEAN;
43 FUNCTION Mps_Net_Quantity(p_mps_net_quantity IN NUMBER)RETURN BOOLEAN;
44 FUNCTION Mps_Scheduled_Comp_Date(p_mps_scheduled_comp_date IN DATE)RETURN BOOLEAN;
45 FUNCTION Organization(p_organization_id IN NUMBER)RETURN BOOLEAN;
46 FUNCTION Outside_Processing_Acct(p_outside_processing_acct IN NUMBER)RETURN BOOLEAN;
47 FUNCTION Outside_Proc_Var_Acct(p_outside_proc_var_acct IN NUMBER)RETURN BOOLEAN;
48 FUNCTION Overhead_Account(p_overhead_account IN NUMBER)RETURN BOOLEAN;
49 FUNCTION Overhead_Variance_Account(p_overhead_variance_account IN NUMBER)RETURN BOOLEAN;
50 FUNCTION Planned_Quantity(p_planned_quantity IN NUMBER)RETURN BOOLEAN;
51 FUNCTION Primary_Item(p_primary_item_id IN NUMBER)RETURN BOOLEAN;
52 FUNCTION Program_Application(p_program_application_id IN NUMBER)RETURN BOOLEAN;
53 FUNCTION Program(p_program_id IN NUMBER)RETURN BOOLEAN;
54 FUNCTION Program_Update_Date(p_program_update_date IN DATE)RETURN BOOLEAN;
55 FUNCTION Project(p_project_id IN NUMBER)RETURN BOOLEAN;
56 FUNCTION Quantity_Completed(p_quantity_completed IN NUMBER)RETURN BOOLEAN;
57 FUNCTION Request(p_request_id IN NUMBER)RETURN BOOLEAN;
58 FUNCTION Resource_Account(p_resource_account IN NUMBER)RETURN BOOLEAN;
59 FUNCTION Resource_Variance_Account(p_resource_variance_account IN NUMBER)RETURN BOOLEAN;
60 FUNCTION Routing_Revision(p_routing_revision IN VARCHAR2)RETURN BOOLEAN;
61 FUNCTION Routing_Revision_Date(p_routing_revision_date IN DATE)RETURN BOOLEAN;
62 FUNCTION Scheduled_Completion_Date(p_scheduled_completion_date IN DATE)RETURN BOOLEAN;
63 FUNCTION Scheduled(p_scheduled_flag IN NUMBER)RETURN BOOLEAN;
64 FUNCTION Scheduled_Start_Date(p_scheduled_start_date IN DATE)RETURN BOOLEAN;
65 FUNCTION Schedule_Group(p_schedule_group_id IN NUMBER)RETURN BOOLEAN;
66 FUNCTION Schedule_Number(p_schedule_number IN VARCHAR2)RETURN BOOLEAN;
67 FUNCTION Status(p_status IN NUMBER)RETURN BOOLEAN;
68 FUNCTION Std_Cost_Adjustment_Acct(p_std_cost_adjustment_acct IN NUMBER)RETURN BOOLEAN;
69 FUNCTION Task(p_task_id IN NUMBER)RETURN BOOLEAN;
70 FUNCTION Wip_Entity(p_wip_entity_id IN NUMBER)RETURN BOOLEAN;
71 FUNCTION End_Item_Unit_Number(p_end_item_unit_number IN VARCHAR2) RETURN BOOLEAN;
72 FUNCTION Quantity_Scrapped(p_quantity_scrapped IN NUMBER) RETURN BOOLEAN;
73
74 FUNCTION Assignment_Set
75 ( p_Assignment_Set_Id IN NUMBER
76 ) RETURN BOOLEAN;
77
78 FUNCTION Assignment
79 ( p_Assignment_Id IN NUMBER
80 ) RETURN BOOLEAN;
81
82 FUNCTION Sourcing_Rule
83 ( p_Sourcing_Rule_Id IN NUMBER
84 ) RETURN BOOLEAN;
85
86 FUNCTION Receiving_Org
87 ( p_Sr_Receipt_Id IN NUMBER
88 ) RETURN BOOLEAN;
89
90 FUNCTION Shipping_Org
91 ( p_Sr_Source_Id IN NUMBER
92 ) RETURN BOOLEAN;
93
94 -- END GEN validate
95
96 END MRP_Validate;