1 PACKAGE ENG_Validate_Revised_Item AUTHID CURRENT_USER AS
2 /* $Header: ENGLRITS.pls 120.2.12010000.1 2008/07/28 06:24:01 appldev ship $ */
3
4 -- Procedure Entity
5 PROCEDURE Check_Entity
6 ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
7 , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
8 , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
9 , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
10 , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
11 := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
12 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
13 , x_Return_Status OUT NOCOPY VARCHAR2
14 );
15
16 -- Procedure Attributes
17 PROCEDURE Check_Attributes
18 ( x_return_status OUT NOCOPY VARCHAR2
19 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
20 , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
21 , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
22 , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
23 , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
24 );
25
26
27 -- Procedure Entity_Delete
28 PROCEDURE Check_Entity_Delete
29 ( x_return_status OUT NOCOPY VARCHAR2
30 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
31 , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
32 , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
33 );
34
35 PROCEDURE Check_Required
36 ( x_return_status OUT NOCOPY VARCHAR2
37 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
38 , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
39 );
40
41 PROCEDURE Check_Existence
42 ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
43 , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
44 , x_old_revised_item_rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
45 , x_old_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
46 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
47 , x_Return_Status OUT NOCOPY VARCHAR2
48 , x_disable_revision OUT NOCOPY NUMBER -- Bug no:3034642
49 );
50
51 -- Added for bug 5756870
52 PROCEDURE Check_Access_Scheduled
53 ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
54 , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
55
56 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
57 , x_Return_Status OUT NOCOPY VARCHAR2
58 );
59
60
61 PROCEDURE Check_Access
62 ( p_change_notice IN VARCHAR2
63 , p_organization_id IN NUMBER
64 , p_revised_item_id IN NUMBER
65 , p_new_item_revision IN VARCHAR2
66 , p_effectivity_date IN DATE
67 , p_new_routing_revsion IN VARCHAR2 -- Added by MK on 11/02/00
68 , p_from_end_item_number IN VARCHAR2 -- Added by MK on 11/02/00
69 , p_revised_item_name IN VARCHAR2
70 , p_entity_processed IN VARCHAR2 := NULL
71 , p_operation_seq_num IN NUMBER := NULL
72 , p_routing_sequence_id IN NUMBER := NULL
73 , p_operation_type IN NUMBER := NULL
74 , p_alternate_bom_code IN VARCHAR2 := NULL -- Bug 4210718
75 , p_Mesg_Token_Tbl IN Error_Handler.Mesg_Token_Tbl_Type :=
76 Error_Handler.G_MISS_MESG_TOKEN_TBL
77 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
78 , x_Return_Status OUT NOCOPY VARCHAR2
79 , p_check_scheduled_status IN BOOLEAN DEFAULT TRUE -- Added for bug 5756870
80 );
81
82 -- Fix for bug 3577967
83 PROCEDURE Get_Where_Clause_For_Subjects
84 ( p_change_notice IN VARCHAR2
85 ,x_item_lifecycle_Phase IN OUT NOCOPY VARCHAR2
86 ,x_item_catalogue_Group IN OUT NOCOPY VARCHAR2
87 ,x_item_type IN OUT NOCOPY VARCHAR2
88 );
89
90 -- Fix for bug 3577967
91 PROCEDURE validate_rev_items_for_sub
92 ( p_change_notice IN VARCHAR2
93 ,p_inventory_item_id IN NUMBER
94 ,p_org_id IN NUMBER
95 ,x_ret_Value OUT NOCOPY BOOLEAN
96 );
97
98 -- Fix for bug 3311749
99 FUNCTION Exp_Validate_New_Item_Revision
100 ( p_revised_item_id IN NUMBER
101 , p_organization_id IN NUMBER
102 , p_new_item_revision IN VARCHAR2
103 , p_revised_item_sequence_id IN NUMBER
104 , x_change_notice OUT NOCOPY VARCHAR2
105 ) RETURN NUMBER ;
106
107 -- Bug 4210718
108 /*****************************************************************************
109 * Procedure : Check_Structure_Type_Policy
110 * Parameters IN : p_inventory_item_id => Revised item
111 * p_organization_id => Organization Id
112 * p_alternate_bom_code => Alternate_Bom_Designator
113 * Parameters OUT : x_structure_type_id => Structure Type Id of the bill/alternate
114 * x_strc_cp_not_allowed => 1 if change policy is not allowed
115 * , 2 otherwise
116 * Purpose : To check if the a bill for given revised item with the given
117 * alternate designator has structure policy NOT_ALLOWED
118 * associated with its structure type.
119 *******************************************************************************/
120 PROCEDURE Check_Structure_Type_Policy
121 ( p_inventory_item_id IN NUMBER
122 , p_organization_id IN NUMBER
123 , p_alternate_bom_code IN VARCHAR2
124 , x_structure_type_id OUT NOCOPY NUMBER
125 , x_strc_cp_not_allowed OUT NOCOPY NUMBER
126 ) ;
127
128 PROCEDURE Validate_Revised_Item (
129 p_api_version IN NUMBER := 1.0 --
130 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
131 , p_commit IN VARCHAR2 := FND_API.G_FALSE --
132 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL --
133 , p_debug IN VARCHAR2 := 'N' --
134 , p_output_dir IN VARCHAR2 := NULL --
135 , p_debug_filename IN VARCHAR2 := 'VALREVITEMS.log' --
136 , x_return_status OUT NOCOPY VARCHAR2 --
137 , x_msg_count OUT NOCOPY NUMBER --
138 , x_msg_data OUT NOCOPY VARCHAR2 --
139 -- Initialization
140 , p_bo_identifier IN VARCHAR2 := 'ECO'
141 , p_transaction_type IN VARCHAR2
142 -- Change context
143 , p_organization_id IN NUMBER
144 , p_change_id IN NUMBER
145 , p_change_notice IN VARCHAR2
146 , p_assembly_type IN NUMBER
147 -- revised item
148 , p_revised_item_sequence_id IN NUMBER
149 , p_revised_item_id IN NUMBER
150 , p_status_type IN NUMBER
151 , p_status_code IN NUMBER
152 -- new revision
153 , p_new_revised_item_revision IN VARCHAR2
154 , p_new_revised_item_rev_desc IN VARCHAR2
155 , p_from_item_revision_id IN NUMBER
156 , p_new_revision_reason_code IN VARCHAR2
157 , p_new_revision_label IN VARCHAR2
158 , p_updated_revision IN VARCHAR2
159 , p_new_item_revision_id IN NUMBER
160 , p_current_item_revision_id IN NUMBER
161 -- effectivity
162 , p_start_effective_date IN DATE
163 , p_new_effective_date IN DATE
164 , p_earliest_effective_date IN DATE
165 -- bill and routing
166 , p_alternate_bom_code IN VARCHAR2
167 , p_bill_sequence_id IN NUMBER
168 , p_from_unit_number IN VARCHAR2
169 , p_new_from_unit_number IN VARCHAR2
170 , p_from_end_item_id IN NUMBER
171 , p_from_end_item_revision_id IN NUMBER
172 , p_routing_sequence_id IN NUMBER
173 , p_completion_subinventory IN VARCHAR2
174 , p_completion_locator_id IN NUMBER
175 , p_priority IN NUMBER
176 , p_ctp_flag IN NUMBER
177 , p_new_routing_revision IN VARCHAR2
178 , p_updated_routing_revision IN VARCHAR2
179 , p_eco_for_production IN NUMBER
180 , p_cfm_routing_flag IN NUMBER
181 -- useup
182 , p_use_up_plan_name IN VARCHAR2
183 , p_use_up_item_id IN NUMBER
184 , p_use_up IN NUMBER
185 -- wip
186 , p_disposition_type IN NUMBER
187 , p_update_wip IN NUMBER
188 , p_mrp_active IN NUMBER
189 , p_from_wip_entity_id IN NUMBER
190 , p_to_wip_entity_id IN NUMBER
191 , p_from_cumulative_quantity IN NUMBER
192 , p_lot_number IN VARCHAR2
193 );
194
195 END ENG_Validate_Revised_Item;