37: *
38: ********************************************************************/
39:
40: PROCEDURE Update_Row
41: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
42: , p_bom_comp_ops_unexp_Rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
43: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
44: , x_return_status IN OUT NOCOPY VARCHAR2
45: )
38: ********************************************************************/
39:
40: PROCEDURE Update_Row
41: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
42: , p_bom_comp_ops_unexp_Rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
43: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
44: , x_return_status IN OUT NOCOPY VARCHAR2
45: )
46: IS
43: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
44: , x_return_status IN OUT NOCOPY VARCHAR2
45: )
46: IS
47: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type :=
48: p_bom_comp_ops_rec;
49: l_return_status VARCHAR2(200);
50: l_err_text VARCHAR2(255);
51: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
161: * Bom_Component_Operations table.
162: *
163: ********************************************************************/
164: PROCEDURE Insert_Row
165: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
166: , p_bom_Comp_Ops_Unexp_Rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
167: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
168: , x_return_status IN OUT NOCOPY VARCHAR2
169: )
162: *
163: ********************************************************************/
164: PROCEDURE Insert_Row
165: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
166: , p_bom_Comp_Ops_Unexp_Rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
167: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
168: , x_return_status IN OUT NOCOPY VARCHAR2
169: )
170: IS
357: ********************************************************************/
358: PROCEDURE Query_Row
359: ( p_component_sequence_id IN NUMBER
360: , p_additional_operation_seq_num IN NUMBER
361: , x_bom_comp_ops_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
362: , x_bom_comp_ops_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
363: , x_return_status IN OUT NOCOPY VARCHAR2
364: )
365: IS
358: PROCEDURE Query_Row
359: ( p_component_sequence_id IN NUMBER
360: , p_additional_operation_seq_num IN NUMBER
361: , x_bom_comp_ops_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
362: , x_bom_comp_ops_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
363: , x_return_status IN OUT NOCOPY VARCHAR2
364: )
365: IS
366: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
362: , x_bom_comp_ops_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
363: , x_return_status IN OUT NOCOPY VARCHAR2
364: )
365: IS
366: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
367: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
368: BEGIN
369:
370: SELECT ROWID
363: , x_return_status IN OUT NOCOPY VARCHAR2
364: )
365: IS
366: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
367: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
368: BEGIN
369:
370: SELECT ROWID
371: , COMP_OPERATION_SEQ_ID
429:
430: END Query_Row;
431:
432: PROCEDURE Perform_Writes
433: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
434: , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
435: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
436: , x_Return_Status IN OUT NOCOPY VARCHAR2
437: )
430: END Query_Row;
431:
432: PROCEDURE Perform_Writes
433: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
434: , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
435: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
436: , x_Return_Status IN OUT NOCOPY VARCHAR2
437: )
438: IS
437: )
438: IS
439: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
440: l_return_status VARCHAR2(1);
441: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
442: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
443: BEGIN
444: l_bom_comp_ops_rec := p_bom_comp_ops_rec;
445: l_bom_comp_ops_unexp_rec := p_bom_comp_ops_unexp_rec;
438: IS
439: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
440: l_return_status VARCHAR2(1);
441: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
442: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
443: BEGIN
444: l_bom_comp_ops_rec := p_bom_comp_ops_rec;
445: l_bom_comp_ops_unexp_rec := p_bom_comp_ops_unexp_rec;
446: