39: PROCEDURE Query_Row
40: ( p_assembly_item_id IN NUMBER
41: , p_organization_id IN NUMBER
42: , p_revision IN VARCHAR2
43: , x_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_revision_Rec_Type
44: , x_rtg_rev_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_rev_unexposed_Rec_Type
45: , x_Return_status IN OUT NOCOPY VARCHAR2
46: )
47: IS
40: ( p_assembly_item_id IN NUMBER
41: , p_organization_id IN NUMBER
42: , p_revision IN VARCHAR2
43: , x_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_revision_Rec_Type
44: , x_rtg_rev_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_rev_unexposed_Rec_Type
45: , x_Return_status IN OUT NOCOPY VARCHAR2
46: )
47: IS
48: l_rtg_revision_rec Bom_Rtg_Pub.Rtg_revision_Rec_Type;
44: , x_rtg_rev_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_rev_unexposed_Rec_Type
45: , x_Return_status IN OUT NOCOPY VARCHAR2
46: )
47: IS
48: l_rtg_revision_rec Bom_Rtg_Pub.Rtg_revision_Rec_Type;
49: l_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_rev_Unexposed_Rec_Type;
50: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
51: l_dummy varchar2(10);
52: BEGIN
45: , x_Return_status IN OUT NOCOPY VARCHAR2
46: )
47: IS
48: l_rtg_revision_rec Bom_Rtg_Pub.Rtg_revision_Rec_Type;
49: l_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_rev_Unexposed_Rec_Type;
50: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
51: l_dummy varchar2(10);
52: BEGIN
53: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
126: * Purpose : Procedure will perfrom an insert into the
127: * rtg_Bill_Of_Materials table thus creating a new bill
128: *********************************************************************/
129: PROCEDURE Insert_Row
130: ( p_rtg_revision_rec IN Bom_Rtg_Pub.rtg_revision_Rec_Type
131: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.rtg_rev_Unexposed_Rec_Type
132: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
133: , x_return_Status IN OUT NOCOPY VARCHAR2
134: )
127: * rtg_Bill_Of_Materials table thus creating a new bill
128: *********************************************************************/
129: PROCEDURE Insert_Row
130: ( p_rtg_revision_rec IN Bom_Rtg_Pub.rtg_revision_Rec_Type
131: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.rtg_rev_Unexposed_Rec_Type
132: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
133: , x_return_Status IN OUT NOCOPY VARCHAR2
134: )
135: IS
253: * Purpose : Procedure will perfrom an Update into the
254: * rtg_Bill_Of_Materials table.
255: ********************************************************************/
256: PROCEDURE Update_Row
257: ( p_RTG_revision_rec IN Bom_Rtg_Pub.RTG_Revision_Rec_Type
258: , p_RTG_rev_unexp_rec IN Bom_Rtg_Pub.RTG_Rev_Unexposed_Rec_Type
259: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
260: , x_return_Status IN OUT NOCOPY VARCHAR2
261: )
254: * rtg_Bill_Of_Materials table.
255: ********************************************************************/
256: PROCEDURE Update_Row
257: ( p_RTG_revision_rec IN Bom_Rtg_Pub.RTG_Revision_Rec_Type
258: , p_RTG_rev_unexp_rec IN Bom_Rtg_Pub.RTG_Rev_Unexposed_Rec_Type
259: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
260: , x_return_Status IN OUT NOCOPY VARCHAR2
261: )
262: IS
317: * Purpose : Procedure will perfrom an Delete from the
318: * rtg_Bill_Of_Materials by creating a delete Group.
319: *********************************************************************/
320: PROCEDURE Delete_Row
321: ( p_rtg_revision_rec IN Bom_Rtg_Pub.rtg_revision_Rec_Type
322: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.rtg_rev_Unexposed_Rec_Type
323: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
324: , x_return_Status IN OUT NOCOPY VARCHAR2
325: )
318: * rtg_Bill_Of_Materials by creating a delete Group.
319: *********************************************************************/
320: PROCEDURE Delete_Row
321: ( p_rtg_revision_rec IN Bom_Rtg_Pub.rtg_revision_Rec_Type
322: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.rtg_rev_Unexposed_Rec_Type
323: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
324: , x_return_Status IN OUT NOCOPY VARCHAR2
325: )
326: IS
323: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
324: , x_return_Status IN OUT NOCOPY VARCHAR2
325: )
326: IS
327: l_rtg_rev_unexp_rec Bom_Rtg_Pub.rtg_rev_Unexposed_Rec_Type
328: := p_rtg_rev_unexp_rec;
329:
330: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
331:
367: * access to when he/she needs to perform any kind of
368: * writes to the bom_operational_routings.
369: *********************************************************************/
370: PROCEDURE Perform_Writes
371: ( p_rtg_revision_rec IN Bom_Rtg_Pub.rtg_revision_Rec_Type
372: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.rtg_rev_Unexposed_Rec_Type
373: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
374: , x_return_status IN OUT NOCOPY VARCHAR2
375: )
368: * writes to the bom_operational_routings.
369: *********************************************************************/
370: PROCEDURE Perform_Writes
371: ( p_rtg_revision_rec IN Bom_Rtg_Pub.rtg_revision_Rec_Type
372: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.rtg_rev_Unexposed_Rec_Type
373: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
374: , x_return_status IN OUT NOCOPY VARCHAR2
375: )
376: IS