49: * error messsage and the tokens associated with the
50: * message.
51: *********************************************************************/
52: PROCEDURE Check_Existence
53: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
54: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
55: , x_old_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
56: , x_old_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
57: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
50: * message.
51: *********************************************************************/
52: PROCEDURE Check_Existence
53: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
54: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
55: , x_old_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
56: , x_old_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
57: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
58: , x_return_status IN OUT NOCOPY VARCHAR2
51: *********************************************************************/
52: PROCEDURE Check_Existence
53: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
54: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
55: , x_old_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
56: , x_old_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
57: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
58: , x_return_status IN OUT NOCOPY VARCHAR2
59: )
52: PROCEDURE Check_Existence
53: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
54: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
55: , x_old_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
56: , x_old_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
57: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
58: , x_return_status IN OUT NOCOPY VARCHAR2
59: )
60: IS
349: **********************************************************************/
350: PROCEDURE Check_Attributes
351: ( x_return_status IN OUT NOCOPY VARCHAR2
352: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
353: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
354: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
355: , p_old_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
356: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
357: )
350: PROCEDURE Check_Attributes
351: ( x_return_status IN OUT NOCOPY VARCHAR2
352: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
353: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
354: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
355: , p_old_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
356: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
357: )
358: IS
351: ( x_return_status IN OUT NOCOPY VARCHAR2
352: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
353: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
354: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
355: , p_old_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
356: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
357: )
358: IS
359: l_err_text VARCHAR2(2000) := NULL;
352: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
353: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
354: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
355: , p_old_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
356: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
357: )
358: IS
359: l_err_text VARCHAR2(2000) := NULL;
360: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
428: **********************************************************************/
429: PROCEDURE Check_Required
430: ( x_return_status IN OUT NOCOPY VARCHAR2
431: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
432: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
433: )
434: IS
435: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
436: l_Token_Tbl Error_Handler.Token_Tbl_Type;
483: * user is not entering values which may disturb the
484: * integrity of the data.
485: *********************************************************************/
486: PROCEDURE Check_Entity
487: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
488: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
489: , p_old_bom_head_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
490: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
491: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
484: * integrity of the data.
485: *********************************************************************/
486: PROCEDURE Check_Entity
487: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
488: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
489: , p_old_bom_head_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
490: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
491: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
492: , x_return_status IN OUT NOCOPY VARCHAR2
485: *********************************************************************/
486: PROCEDURE Check_Entity
487: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
488: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
489: , p_old_bom_head_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
490: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
491: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
492: , x_return_status IN OUT NOCOPY VARCHAR2
493: )
486: PROCEDURE Check_Entity
487: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
488: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
489: , p_old_bom_head_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
490: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
491: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
492: , x_return_status IN OUT NOCOPY VARCHAR2
493: )
494: IS
1301:
1302: PROCEDURE Check_Entity_Delete
1303: ( x_return_status IN OUT NOCOPY VARCHAR2
1304: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1305: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
1306: , p_bom_head_Unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1307: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1308: )
1309: IS
1302: PROCEDURE Check_Entity_Delete
1303: ( x_return_status IN OUT NOCOPY VARCHAR2
1304: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1305: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
1306: , p_bom_head_Unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1307: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1308: )
1309: IS
1310: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
1303: ( x_return_status IN OUT NOCOPY VARCHAR2
1304: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1305: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
1306: , p_bom_head_Unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1307: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1308: )
1309: IS
1310: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
1311: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1307: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1308: )
1309: IS
1310: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
1311: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1312: := p_bom_head_Unexp_Rec;
1313: Cursor CheckGroup is
1314: SELECT description,
1315: delete_group_sequence_id,