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 1305: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type

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

Line 1306: , p_bom_head_Unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

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;

Line 1307: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_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

Line 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,