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
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: END Insert_Row;
171:
172: PROCEDURE Update_Row
173: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
174: , p_bom_rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
175: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
176: , x_Return_Status IN OUT NOCOPY VARCHAR2
177: )
170: END Insert_Row;
171:
172: PROCEDURE Update_Row
173: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
174: , p_bom_rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
175: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
176: , x_Return_Status IN OUT NOCOPY VARCHAR2
177: )
178: IS
256:
257: END Update_Row;
258:
259: PROCEDURE Perform_Writes
260: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
261: , p_bom_rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
262: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
263: , x_Return_Status IN OUT NOCOPY VARCHAR2
264: )
257: END Update_Row;
258:
259: PROCEDURE Perform_Writes
260: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
261: , p_bom_rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
262: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
263: , x_Return_Status IN OUT NOCOPY VARCHAR2
264: )
265: IS
295: PROCEDURE Query_Row
296: ( p_revision IN VARCHAR2
297: , p_assembly_item_id IN NUMBER
298: , p_organization_id IN NUMBER
299: , x_bom_revision_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Rec_Type
300: , x_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
301: , x_return_status IN OUT NOCOPY VARCHAR
302: )
303: IS
296: ( p_revision IN VARCHAR2
297: , p_assembly_item_id IN NUMBER
298: , p_organization_id IN NUMBER
299: , x_bom_revision_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Rec_Type
300: , x_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
301: , x_return_status IN OUT NOCOPY VARCHAR
302: )
303: IS
304: BEGIN