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
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: );
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:
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:
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
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
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:
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
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
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
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: );
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:
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
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: );
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:
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
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: );
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:
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
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: );
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:
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
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: );
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: