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;
187: * Bom_Component_Operations table.
188: *
189: ********************************************************************/
190: PROCEDURE Insert_Row
191: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
192: , p_bom_Comp_Ops_Unexp_Rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
193: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
194: , x_return_status IN OUT NOCOPY VARCHAR2
195: )
188: *
189: ********************************************************************/
190: PROCEDURE Insert_Row
191: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
192: , p_bom_Comp_Ops_Unexp_Rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
193: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
194: , x_return_status IN OUT NOCOPY VARCHAR2
195: )
196: IS
393: ********************************************************************/
394: PROCEDURE Query_Row
395: ( p_component_sequence_id IN NUMBER
396: , p_additional_operation_seq_num IN NUMBER
397: , x_bom_comp_ops_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
398: , x_bom_comp_ops_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
399: , x_return_status IN OUT NOCOPY VARCHAR2
400: )
401: IS
394: PROCEDURE Query_Row
395: ( p_component_sequence_id IN NUMBER
396: , p_additional_operation_seq_num IN NUMBER
397: , x_bom_comp_ops_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
398: , x_bom_comp_ops_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
399: , x_return_status IN OUT NOCOPY VARCHAR2
400: )
401: IS
402: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
398: , x_bom_comp_ops_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
399: , x_return_status IN OUT NOCOPY VARCHAR2
400: )
401: IS
402: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
403: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
404: BEGIN
405:
406: SELECT ROWID
399: , x_return_status IN OUT NOCOPY VARCHAR2
400: )
401: IS
402: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
403: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
404: BEGIN
405:
406: SELECT ROWID
407: , COMP_OPERATION_SEQ_ID
465:
466: END Query_Row;
467:
468: PROCEDURE Perform_Writes
469: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
470: , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
471: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
472: , x_Return_Status IN OUT NOCOPY VARCHAR2
473: )
466: END Query_Row;
467:
468: PROCEDURE Perform_Writes
469: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
470: , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
471: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
472: , x_Return_Status IN OUT NOCOPY VARCHAR2
473: )
474: IS
473: )
474: IS
475: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
476: l_return_status VARCHAR2(1);
477: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
478: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
479: BEGIN
480: l_bom_comp_ops_rec := p_bom_comp_ops_rec;
481: l_bom_comp_ops_unexp_rec := p_bom_comp_ops_unexp_rec;
474: IS
475: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
476: l_return_status VARCHAR2(1);
477: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
478: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
479: BEGIN
480: l_bom_comp_ops_rec := p_bom_comp_ops_rec;
481: l_bom_comp_ops_unexp_rec := p_bom_comp_ops_unexp_rec;
482: