DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_HEADER dependencies on BOM_BO_PUB

Line 53: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type

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

Line 54: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_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

Line 55: , x_old_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type

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: )

Line 56: , x_old_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

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

Line 353: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type

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: )

Line 354: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

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

Line 355: , p_old_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type

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;

Line 356: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

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;

Line 432: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_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;

Line 487: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_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

Line 488: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_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

Line 489: , p_old_bom_head_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type

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: )

Line 490: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

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

Line 1547: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type

1543:
1544: PROCEDURE Check_Entity_Delete
1545: ( x_return_status IN OUT NOCOPY VARCHAR2
1546: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1547: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
1548: , p_bom_head_Unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1549: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1550: )
1551: IS

Line 1548: , p_bom_head_Unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

1544: PROCEDURE Check_Entity_Delete
1545: ( x_return_status IN OUT NOCOPY VARCHAR2
1546: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1547: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
1548: , p_bom_head_Unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1549: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1550: )
1551: IS
1552: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 1549: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

1545: ( x_return_status IN OUT NOCOPY VARCHAR2
1546: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1547: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
1548: , p_bom_head_Unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1549: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1550: )
1551: IS
1552: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
1553: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

Line 1553: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

1549: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1550: )
1551: IS
1552: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
1553: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1554: := p_bom_head_Unexp_Rec;
1555: Cursor CheckGroup is
1556: SELECT description,
1557: delete_group_sequence_id,