22: ****************************************************************************/
23:
24:
25: PROCEDURE Insert_Row
26: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
27: , p_bom_rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
28: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
29: , x_Return_Status IN OUT NOCOPY VARCHAR2
30: )
23:
24:
25: PROCEDURE Insert_Row
26: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
27: , p_bom_rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
28: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
29: , x_Return_Status IN OUT NOCOPY VARCHAR2
30: )
31: IS
154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
155: END Insert_Row;
156:
157: PROCEDURE Update_Row
158: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
159: , p_bom_rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
160: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
161: , x_Return_Status IN OUT NOCOPY VARCHAR2
162: )
155: END Insert_Row;
156:
157: PROCEDURE Update_Row
158: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
159: , p_bom_rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
160: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
161: , x_Return_Status IN OUT NOCOPY VARCHAR2
162: )
163: IS
226:
227: END Update_Row;
228:
229: PROCEDURE Perform_Writes
230: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
231: , p_bom_rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
232: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
233: , x_Return_Status IN OUT NOCOPY VARCHAR2
234: )
227: END Update_Row;
228:
229: PROCEDURE Perform_Writes
230: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
231: , p_bom_rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
232: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
233: , x_Return_Status IN OUT NOCOPY VARCHAR2
234: )
235: IS
265: PROCEDURE Query_Row
266: ( p_revision IN VARCHAR2
267: , p_assembly_item_id IN NUMBER
268: , p_organization_id IN NUMBER
269: , x_bom_revision_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Rec_Type
270: , x_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
271: , x_return_status IN OUT NOCOPY VARCHAR
272: )
273: IS
266: ( p_revision IN VARCHAR2
267: , p_assembly_item_id IN NUMBER
268: , p_organization_id IN NUMBER
269: , x_bom_revision_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Rec_Type
270: , x_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
271: , x_return_status IN OUT NOCOPY VARCHAR
272: )
273: IS
274: BEGIN