68: /*#
69: * Clear Dependent Attributes
70: * @param p_attr_id attribute id
71: * @param p_ref_designator_rec reference designator record
72: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
73: * @param p_old_ref_designator_rec old reference designator record. This is defaulted to
74: * Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
75: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
76: * @param x_ref_designator_rec returned reference designator record
70: * @param p_attr_id attribute id
71: * @param p_ref_designator_rec reference designator record
72: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
73: * @param p_old_ref_designator_rec old reference designator record. This is defaulted to
74: * Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
75: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
76: * @param x_ref_designator_rec returned reference designator record
77: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
78: * @rep:scope private
71: * @param p_ref_designator_rec reference designator record
72: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
73: * @param p_old_ref_designator_rec old reference designator record. This is defaulted to
74: * Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
75: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
76: * @param x_ref_designator_rec returned reference designator record
77: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
78: * @rep:scope private
79: * @rep:lifecycle active
73: * @param p_old_ref_designator_rec old reference designator record. This is defaulted to
74: * Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
75: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
76: * @param x_ref_designator_rec returned reference designator record
77: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
78: * @rep:scope private
79: * @rep:lifecycle active
80: * @rep:displayname Clear Dependent Attributes
81: */
82:
83:
84: PROCEDURE Clear_Dependent_Attr
85: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
86: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
87: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
88: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
89: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
90: );
83:
84: PROCEDURE Clear_Dependent_Attr
85: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
86: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
87: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
88: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
89: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
90: );
91:
84: PROCEDURE Clear_Dependent_Attr
85: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
86: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
87: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
88: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
89: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
90: );
91:
92: --added for bug 7713832
85: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
86: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
87: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
88: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
89: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
90: );
91:
92: --added for bug 7713832
93: FUNCTION Common_CompSeqIdRD( p_comp_seq_id NUMBER)
97:
98: /*#
99: * Apply Attribute Changes
100: * @param p_ref_designator_rec reference designator record
101: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
102: * @param p_old_ref_designator_rec old reference designator record. This is defaulted to
103: * Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
104: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
105: * @param x_ref_designator_rec returned reference designator record
99: * Apply Attribute Changes
100: * @param p_ref_designator_rec reference designator record
101: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
102: * @param p_old_ref_designator_rec old reference designator record. This is defaulted to
103: * Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
104: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
105: * @param x_ref_designator_rec returned reference designator record
106: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
107: * @rep:scope private
100: * @param p_ref_designator_rec reference designator record
101: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
102: * @param p_old_ref_designator_rec old reference designator record. This is defaulted to
103: * Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
104: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
105: * @param x_ref_designator_rec returned reference designator record
106: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
107: * @rep:scope private
108: * @rep:lifecycle active
102: * @param p_old_ref_designator_rec old reference designator record. This is defaulted to
103: * Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
104: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
105: * @param x_ref_designator_rec returned reference designator record
106: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
107: * @rep:scope private
108: * @rep:lifecycle active
109: * @rep:displayname Apply Attribute Changes
110: */
109: * @rep:displayname Apply Attribute Changes
110: */
111:
112: PROCEDURE Apply_Attribute_Changes
113: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
114: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
115: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
116: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
117: );
110: */
111:
112: PROCEDURE Apply_Attribute_Changes
113: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
114: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
115: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
116: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
117: );
118:
111:
112: PROCEDURE Apply_Attribute_Changes
113: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
114: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
115: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
116: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
117: );
118:
119: -- Function Convert_Miss_To_Null
112: PROCEDURE Apply_Attribute_Changes
113: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
114: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
115: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
116: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
117: );
118:
119: -- Function Convert_Miss_To_Null
120:
121: /*#
122: * This method will convert the missing values of some attributes that the user wishes to NULL
123: * This can be used with ECO
124: * @param p_ref_designator_rec the record that need to be converted
125: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
126: * @return the converted record
127: * @rep:scope private
128: * @rep:lifecycle active
129: * @rep:displayname Convert Miss To Null
130: */
131:
132:
133: FUNCTION Convert_Miss_To_Null
134: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
135: ) RETURN Bom_Bo_Pub.Ref_Designator_Rec_Type;
136:
137: -- Function Query_Row
138:
131:
132:
133: FUNCTION Convert_Miss_To_Null
134: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
135: ) RETURN Bom_Bo_Pub.Ref_Designator_Rec_Type;
136:
137: -- Function Query_Row
138:
139: /*#
142: * @param p_ref_designator This with the next two parameters form Reference Designator Key
143: * @param p_component_sequence_id component sequence id
144: * @param p_acd_type acd type
145: * @param x_Ref_Designator_Rec Reference Designator Record of exposed columns
146: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
147: * @param x_Ref_Desg_Unexp_Rec Reference Designator Record of Unexposed Columns
148: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type}
149: * @param x_Return_Status Indicating success or faliure
150: * @rep:scope private
144: * @param p_acd_type acd type
145: * @param x_Ref_Designator_Rec Reference Designator Record of exposed columns
146: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
147: * @param x_Ref_Desg_Unexp_Rec Reference Designator Record of Unexposed Columns
148: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type}
149: * @param x_Return_Status Indicating success or faliure
150: * @rep:scope private
151: * @rep:lifecycle active
152: * @rep:displayname Query Row
156: PROCEDURE Query_Row
157: ( p_ref_designator IN VARCHAR2
158: , p_component_sequence_id IN NUMBER
159: , p_acd_type IN NUMBER
160: , x_Ref_Designator_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
161: , x_Ref_Desg_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
162: , x_Return_Status IN OUT NOCOPY VARCHAR2
163: );
164:
157: ( p_ref_designator IN VARCHAR2
158: , p_component_sequence_id IN NUMBER
159: , p_acd_type IN NUMBER
160: , x_Ref_Designator_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
161: , x_Ref_Desg_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
162: , x_Return_Status IN OUT NOCOPY VARCHAR2
163: );
164:
165: /*#
165: /*#
166: * Perform Writes is the only exposed method that the user will have access, to perform
167: * any insert/update/deletes to corresponding database tables . This can be used with ECO
168: * @param p_ref_designator_rec Reference Designator exposed column record
169: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_rec_Type }
170: * @param p_ref_desg_unexp_rec Reference Designator unexposed column record
171: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
172: * @param p_control_rec control record.This is defaulted as BOM_BO_PUB.G_DEFAULT_CONTROL_REC
173: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Control_Rec_Type }
167: * any insert/update/deletes to corresponding database tables . This can be used with ECO
168: * @param p_ref_designator_rec Reference Designator exposed column record
169: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_rec_Type }
170: * @param p_ref_desg_unexp_rec Reference Designator unexposed column record
171: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
172: * @param p_control_rec control record.This is defaulted as BOM_BO_PUB.G_DEFAULT_CONTROL_REC
173: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Control_Rec_Type }
174: * @param x_Mesg_Token_Tbl Message token table
175: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
168: * @param p_ref_designator_rec Reference Designator exposed column record
169: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_rec_Type }
170: * @param p_ref_desg_unexp_rec Reference Designator unexposed column record
171: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
172: * @param p_control_rec control record.This is defaulted as BOM_BO_PUB.G_DEFAULT_CONTROL_REC
173: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Control_Rec_Type }
174: * @param x_Mesg_Token_Tbl Message token table
175: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
176: * @param x_Return_status Return Status
169: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_rec_Type }
170: * @param p_ref_desg_unexp_rec Reference Designator unexposed column record
171: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
172: * @param p_control_rec control record.This is defaulted as BOM_BO_PUB.G_DEFAULT_CONTROL_REC
173: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Control_Rec_Type }
174: * @param x_Mesg_Token_Tbl Message token table
175: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
176: * @param x_Return_status Return Status
177: * @rep:scope private
179: * @rep:displayname Perform Writes
180: */
181:
182: PROCEDURE Perform_Writes
183: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_rec_Type
184: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
185: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
186: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
187: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
180: */
181:
182: PROCEDURE Perform_Writes
183: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_rec_Type
184: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
185: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
186: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
187: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
188: , x_return_status IN OUT NOCOPY VARCHAR2
181:
182: PROCEDURE Perform_Writes
183: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_rec_Type
184: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
185: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
186: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
187: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
188: , x_return_status IN OUT NOCOPY VARCHAR2
189: );
182: PROCEDURE Perform_Writes
183: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_rec_Type
184: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
185: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
186: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
187: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
188: , x_return_status IN OUT NOCOPY VARCHAR2
189: );
190:
195:
196: /*#
197: * This method will convert the missing values of some attributes that the user wishes to NULL
198: * @param p_bom_ref_designator_rec the record that need to be converted
199: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }
200: * @return the converted record
201: * @rep:scope private
202: * @rep:lifecycle active
203: * @rep:displayname Convert Miss To Null
202: * @rep:lifecycle active
203: * @rep:displayname Convert Miss To Null
204: */
205: FUNCTION Convert_Miss_To_Null
206: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
207: ) RETURN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
208:
209: -- Function Query_Row
210:
203: * @rep:displayname Convert Miss To Null
204: */
205: FUNCTION Convert_Miss_To_Null
206: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
207: ) RETURN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
208:
209: -- Function Query_Row
210:
211:
215: * @param p_bom_ref_designator This with the next two parameters form Reference Designator Key
216: * @param p_component_sequence_id component sequence id
217: * @param p_acd_type acd type
218: * @param x_bom_Ref_Designator_Rec Reference Designator Record of exposed columns
219: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }
220: * @param x_bom_Ref_Desg_Unexp_Rec Reference Designator Record of Unexposed Columns
221: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type}
222: * @param x_Return_Status Indicating success or faliure
223: * @rep:scope private
217: * @param p_acd_type acd type
218: * @param x_bom_Ref_Designator_Rec Reference Designator Record of exposed columns
219: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }
220: * @param x_bom_Ref_Desg_Unexp_Rec Reference Designator Record of Unexposed Columns
221: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type}
222: * @param x_Return_Status Indicating success or faliure
223: * @rep:scope private
224: * @rep:lifecycle active
225: * @rep:displayname Query Row
228: PROCEDURE Query_Row
229: ( p_bom_ref_designator IN VARCHAR2
230: , p_component_sequence_id IN NUMBER
231: , p_acd_type IN NUMBER
232: , x_bom_Ref_Designator_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
233: , x_bom_Ref_Desg_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
234: , x_Return_Status IN OUT NOCOPY VARCHAR2
235: );
236:
229: ( p_bom_ref_designator IN VARCHAR2
230: , p_component_sequence_id IN NUMBER
231: , p_acd_type IN NUMBER
232: , x_bom_Ref_Designator_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
233: , x_bom_Ref_Desg_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
234: , x_Return_Status IN OUT NOCOPY VARCHAR2
235: );
236:
237: /*#
237: /*#
238: * Perform Writes is the only exposed method that the user will have access to perform any
239: * insert/update/deletes to corresponding database tables
240: * @param p_bom_ref_designator_rec BomReference Designator exposed column record
241: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_rec_Type }
242: * @param p_bom_ref_desg_unexp_rec Bom Reference Designator unexposed column record
243: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type }
244: * @param x_Mesg_Token_Tbl Message token table
245: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
239: * insert/update/deletes to corresponding database tables
240: * @param p_bom_ref_designator_rec BomReference Designator exposed column record
241: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_rec_Type }
242: * @param p_bom_ref_desg_unexp_rec Bom Reference Designator unexposed column record
243: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type }
244: * @param x_Mesg_Token_Tbl Message token table
245: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
246: * @param x_Return_status Return Status
247: * @rep:scope private
249: * @rep:displayname Perform Writes
250: */
251:
252: PROCEDURE Perform_Writes
253: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_rec_Type
254: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
255: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
256: , x_return_status IN OUT NOCOPY VARCHAR2
257: );
250: */
251:
252: PROCEDURE Perform_Writes
253: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_rec_Type
254: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
255: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
256: , x_return_status IN OUT NOCOPY VARCHAR2
257: );
258: