[Home] [Help]
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:
152:
153: PROCEDURE Revised_Item_VID
154: ( x_Return_Status OUT NOCOPY VARCHAR2
155: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
156: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
157: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
158: , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
159: );
160:
153: PROCEDURE Revised_Item_VID
154: ( x_Return_Status OUT NOCOPY VARCHAR2
155: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
156: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
157: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
158: , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
159: );
160:
161: PROCEDURE ECO_Header_VID
154: ( x_Return_Status OUT NOCOPY VARCHAR2
155: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
156: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
157: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
158: , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
159: );
160:
161: PROCEDURE ECO_Header_VID
162: ( x_Return_Status OUT NOCOPY VARCHAR2
160:
161: PROCEDURE ECO_Header_VID
162: ( x_Return_Status OUT NOCOPY VARCHAR2
163: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
164: , p_ECO_Rec IN Eng_Eco_Pub.ECO_Rec_Type
165: , p_ECO_Unexp_Rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
166: , x_ECO_Unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
167: );
168:
161: PROCEDURE ECO_Header_VID
162: ( x_Return_Status OUT NOCOPY VARCHAR2
163: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
164: , p_ECO_Rec IN Eng_Eco_Pub.ECO_Rec_Type
165: , p_ECO_Unexp_Rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
166: , x_ECO_Unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
167: );
168:
169: PROCEDURE ECO_Header_UUI_To_UI
162: ( x_Return_Status OUT NOCOPY VARCHAR2
163: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
164: , p_ECO_Rec IN Eng_Eco_Pub.ECO_Rec_Type
165: , p_ECO_Unexp_Rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
166: , x_ECO_Unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
167: );
168:
169: PROCEDURE ECO_Header_UUI_To_UI
170: ( p_eco_rec IN Eng_Eco_Pub.Eco_Rec_Type
166: , x_ECO_Unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
167: );
168:
169: PROCEDURE ECO_Header_UUI_To_UI
170: ( p_eco_rec IN Eng_Eco_Pub.Eco_Rec_Type
171: , p_eco_unexp_rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
172: , x_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
173: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
174: , x_Return_Status OUT NOCOPY VARCHAR2
167: );
168:
169: PROCEDURE ECO_Header_UUI_To_UI
170: ( p_eco_rec IN Eng_Eco_Pub.Eco_Rec_Type
171: , p_eco_unexp_rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
172: , x_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
173: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
174: , x_Return_Status OUT NOCOPY VARCHAR2
175: );
168:
169: PROCEDURE ECO_Header_UUI_To_UI
170: ( p_eco_rec IN Eng_Eco_Pub.Eco_Rec_Type
171: , p_eco_unexp_rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
172: , x_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
173: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
174: , x_Return_Status OUT NOCOPY VARCHAR2
175: );
176:
174: , x_Return_Status OUT NOCOPY VARCHAR2
175: );
176:
177: PROCEDURE ECO_Revision_UUI_To_UI
178: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
179: , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
180: , x_eco_rev_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
181: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
182: , x_Return_Status OUT NOCOPY VARCHAR2
175: );
176:
177: PROCEDURE ECO_Revision_UUI_To_UI
178: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
179: , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
180: , x_eco_rev_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
181: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
182: , x_Return_Status OUT NOCOPY VARCHAR2
183: );
176:
177: PROCEDURE ECO_Revision_UUI_To_UI
178: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
179: , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
180: , x_eco_rev_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
181: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
182: , x_Return_Status OUT NOCOPY VARCHAR2
183: );
184:
182: , x_Return_Status OUT NOCOPY VARCHAR2
183: );
184:
185: PROCEDURE Revised_Item_UUI_To_UI
186: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
187: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
188: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
189: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
190: , x_Return_Status OUT NOCOPY VARCHAR2
183: );
184:
185: PROCEDURE Revised_Item_UUI_To_UI
186: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
187: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
188: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
189: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
190: , x_Return_Status OUT NOCOPY VARCHAR2
191: );
184:
185: PROCEDURE Revised_Item_UUI_To_UI
186: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
187: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
188: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
189: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
190: , x_Return_Status OUT NOCOPY VARCHAR2
191: );
192:
190: , x_Return_Status OUT NOCOPY VARCHAR2
191: );
192:
193: PROCEDURE Change_Line_UUI_To_UI
194: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
195: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
196: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
197: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
198: , x_Return_Status OUT NOCOPY VARCHAR2
191: );
192:
193: PROCEDURE Change_Line_UUI_To_UI
194: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
195: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
196: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
197: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
198: , x_Return_Status OUT NOCOPY VARCHAR2
199: );
192:
193: PROCEDURE Change_Line_UUI_To_UI
194: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
195: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
196: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
197: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
198: , x_Return_Status OUT NOCOPY VARCHAR2
199: );
200:
198: , x_Return_Status OUT NOCOPY VARCHAR2
199: );
200:
201: PROCEDURE Change_Line_VID
202: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
203: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
204: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
205: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
206: , x_Return_Status OUT NOCOPY VARCHAR2
199: );
200:
201: PROCEDURE Change_Line_VID
202: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
203: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
204: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
205: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
206: , x_Return_Status OUT NOCOPY VARCHAR2
207: );
200:
201: PROCEDURE Change_Line_VID
202: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
203: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
204: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
205: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
206: , x_Return_Status OUT NOCOPY VARCHAR2
207: );
208: