1 PACKAGE ENG_Val_To_Id AUTHID CURRENT_USER AS
2 /* $Header: ENGSVIDS.pls 120.2 2011/11/28 09:14:44 rambkond ship $ */
3
4 -- Generator will append new prototypes before end generate comment.
5 FUNCTION Key_Flex
6 ( p_key_flex_code IN VARCHAR2
7 , p_structure_number IN NUMBER
8 , p_appl_short_name IN VARCHAR2
9 , p_segment_array IN FND_FLEX_EXT.SegmentArray
10 ) RETURN NUMBER;
11
12 FUNCTION Approval_List(p_approval_list IN VARCHAR2, x_err_text OUT NOCOPY VARCHAR2)RETURN NUMBER;
13 -- changed the signature to get status id :enhancement:5414834
14 PROCEDURE Change_Order_VID
15 ( p_ECO_rec IN Eng_Eco_Pub.ECO_Rec_Type
16 , p_old_eco_unexp_rec IN Eng_Eco_Pub.ECO_Unexposed_Rec_Type
17 , P_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.ECO_Unexposed_Rec_Type
18 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
19 , x_return_status OUT NOCOPY VARCHAR2
20 );
21
22
23 FUNCTION Responsible_Org(p_responsible_org IN VARCHAR2
24 , p_current_org IN NUMBER
25 , x_err_text OUT NOCOPY VARCHAR2)
26 RETURN NUMBER;
27
28 FUNCTION Organization(p_organization IN VARCHAR2, x_err_text OUT NOCOPY VARCHAR2)RETURN NUMBER;
29
30 /*FUNCTION Requestor(p_requestor IN VARCHAR2, x_err_text OUT NOCOPY VARCHAR2)RETURN NUMBER;
31 FUNCTION Using_Assembly(p_using_assembly IN VARCHAR2, x_err_text OUT NOCOPY VARCHAR2)RETURN NUMBER;*/
32
33 FUNCTION Revised_Item( p_revised_item_num IN VARCHAR2,
34 p_organization_id IN NUMBER,
35 x_err_text OUT NOCOPY VARCHAR2 ) RETURN NUMBER;
36
37 FUNCTION Use_Up_Item( p_use_up_item_num IN VARCHAR2,
38 p_organization_id IN NUMBER,
39 x_err_text OUT NOCOPY VARCHAR2 ) RETURN NUMBER;
40
41 FUNCTION Bill_Sequence(p_assembly_item_id IN NUMBER,
42 p_alternate_bom_designator IN VARCHAR2,
43 p_organization_id IN NUMBER,
44 x_err_text OUT NOCOPY VARCHAR2)RETURN NUMBER;
45
46
47 FUNCTION BillandAssembly( p_revised_item_seq_id IN NUMBER,
48 x_bill_sequence_id OUT NOCOPY NUMBER,
49 x_assembly_item_id OUT NOCOPY NUMBER,
50 x_err_text OUT NOCOPY VARCHAR2) RETURN NUMBER;
51
52 FUNCTION AsmblyFromRevItem(p_revised_item_seq_id IN NUMBER,
53 x_err_text OUT NOCOPY VARCHAR2
54 ) RETURN NUMBER;
55
56 FUNCTION Revised_Item_Sequence( p_revised_item_id IN NUMBER
57 , p_change_notice IN VARCHAR2
58 , p_organization_id IN NUMBER
59 , p_new_item_revision IN VARCHAR2
60 ) RETURN NUMBER;
61
62 FUNCTION Revision ( p_rev IN VARCHAR2
63 , p_organization_id IN NUMBER
64 , p_change_notice IN VARCHAR2
65 , x_err_text OUT NOCOPY VARCHAR2
66 ) RETURN NUMBER;
67
68 FUNCTION Revised_Item_Code( p_revised_item_num IN NUMBER,
69 p_organization_id IN NUMBER,
70 p_revison_code IN VARCHAR2 )
71 RETURN number;
72
73
74 FUNCTION Lifecycle_id
75 ( p_lifecycle_name IN VARCHAR2
76 , p_inventory_item_id IN NUMBER
77 , p_org_id IN NUMBER
78 , x_err_text OUT NOCOPY VARCHAR2
79 )
80 RETURN NUMBER;
81
82
83
84 /* 11.5.10 Function to return parent_revised_item_sequence_id ,
85 given revised_item_id ,schedule_date and alternate_bom_designator
86 */
87
88 FUNCTION ParentRevSeqId
89 ( parent_item_name IN VARCHAR2
90 , p_organization_id IN NUMBER
91 , p_alternate_bom_code IN VARCHAR2
92 ,p_schedule_date DATE
93 ,p_change_id NUMBER
94 ) RETURN NUMBER;
95
96
97 -- Added by MK on 12/03/00
98
99 PROCEDURE BillAndRevitem_UUI_To_UI
100 ( p_revised_item_name IN VARCHAR2
101 , p_alternate_bom_code IN VARCHAR2 := NULL -- Bug 2429272
102 , p_revised_item_id IN NUMBER
103 , p_item_revision IN VARCHAR2
104 , p_effective_date IN DATE
105 , p_change_notice IN VARCHAR2
106 , p_organization_id IN NUMBER
107 , p_new_routing_revision IN VARCHAR2 := NULL
108 , p_from_end_item_number IN VARCHAR2 := NULL
109 , p_entity_processed IN VARCHAR2 := 'RC'
110 , p_component_item_name IN VARCHAR2 := NULL
111 , p_component_item_id IN NUMBER := NULL
112 , p_operation_sequence_number IN NUMBER := NULL
113 , p_rfd_sbc_name IN VARCHAR2 := NULL
114 , p_transaction_type IN VARCHAR2 := NULL
115 , x_revised_item_sequence_id OUT NOCOPY NUMBER
116 , x_bill_sequence_id OUT NOCOPY NUMBER
117 , x_component_sequence_id OUT NOCOPY NUMBER
118 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
119 , x_other_message OUT NOCOPY VARCHAR2
120 , x_other_token_tbl OUT NOCOPY Error_Handler.Token_Tbl_Type
121 , x_return_status OUT NOCOPY VARCHAR2
122 ) ;
123
124
125 -- Added by MK on 12/03/00
126 PROCEDURE RtgAndRevitem_UUI_To_UI
127 ( p_revised_item_name IN VARCHAR2
128 , p_revised_item_id IN NUMBER
129 , p_item_revision IN VARCHAR2
130 , p_effective_date IN DATE
131 , p_change_notice IN VARCHAR2
132 , p_organization_id IN NUMBER
133 , p_new_routing_revision IN VARCHAR2 := NULL
134 , p_from_end_item_number IN VARCHAR2 := NULL
135 , p_entity_processed IN VARCHAR2 := 'ROP'
136 , p_operation_sequence_number IN NUMBER := NULL
137 , p_operation_type IN NUMBER := NULL
138 , p_resource_sequence_number IN NUMBER := NULL
139 , p_sub_resource_code IN VARCHAR2 := NULL
140 , p_schedule_sequence_number IN NUMBER := NULL
141 , p_transaction_type IN VARCHAR2 := NULL
142 , p_alternate_routing_code IN VARCHAR2 := NULL -- Added for bug 13329115
143 , x_revised_item_sequence_id OUT NOCOPY NUMBER
144 , x_routing_sequence_id OUT NOCOPY NUMBER
145 , x_operation_sequence_id OUT NOCOPY NUMBER
146 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
147 , x_other_message OUT NOCOPY VARCHAR2
148 , x_other_token_tbl OUT NOCOPY Error_Handler.Token_Tbl_Type
149 , x_return_status OUT NOCOPY VARCHAR2
150 ) ;
151
152
153
154 PROCEDURE Revised_Item_VID
155 ( x_Return_Status OUT NOCOPY VARCHAR2
156 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
157 , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
158 , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
159 , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
160 );
161
162 PROCEDURE ECO_Header_VID
163 ( x_Return_Status OUT NOCOPY VARCHAR2
164 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
165 , p_ECO_Rec IN Eng_Eco_Pub.ECO_Rec_Type
166 , p_ECO_Unexp_Rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
167 , x_ECO_Unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
168 );
169
170 PROCEDURE ECO_Header_UUI_To_UI
171 ( p_eco_rec IN Eng_Eco_Pub.Eco_Rec_Type
172 , p_eco_unexp_rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
173 , x_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
174 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
175 , x_Return_Status OUT NOCOPY VARCHAR2
176 );
177
178 PROCEDURE ECO_Revision_UUI_To_UI
179 ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
180 , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
181 , x_eco_rev_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
182 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
183 , x_Return_Status OUT NOCOPY VARCHAR2
184 );
185
186 PROCEDURE Revised_Item_UUI_To_UI
187 ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
188 , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
189 , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
190 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
191 , x_Return_Status OUT NOCOPY VARCHAR2
192 );
193
194 PROCEDURE Change_Line_UUI_To_UI
195 ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
196 , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
197 , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
198 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
199 , x_Return_Status OUT NOCOPY VARCHAR2
200 );
201
202 PROCEDURE Change_Line_VID
203 ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
204 , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
205 , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
206 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
207 , x_Return_Status OUT NOCOPY VARCHAR2
208 );
209
210
211 END ENG_Val_To_Id;