APPS.BOM_VALIDATE_RTG_HEADER dependencies on BOM_RTG_PUB

Line 53: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type

49: * error messsage and the tokens associated with the
50: * message.
51: *********************************************************************/
52: PROCEDURE Check_Existence
53: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
54: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
55: , x_old_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Rec_Type
56: , x_old_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
57: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 54: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type

50: * message.
51: *********************************************************************/
52: PROCEDURE Check_Existence
53: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
54: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
55: , x_old_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Rec_Type
56: , x_old_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_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_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Rec_Type

51: *********************************************************************/
52: PROCEDURE Check_Existence
53: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
54: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
55: , x_old_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Rec_Type
56: , x_old_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_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_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type

52: PROCEDURE Check_Existence
53: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
54: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
55: , x_old_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Rec_Type
56: , x_old_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_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 635: , p_rtg_header_Rec IN Bom_Rtg_Pub.rtg_header_Rec_Type

631: **********************************************************************/
632: PROCEDURE Check_Attributes
633: ( x_return_status IN OUT NOCOPY VARCHAR2
634: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
635: , p_rtg_header_Rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
636: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
637: , p_old_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
638: , p_old_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
639: )

Line 636: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type

632: PROCEDURE Check_Attributes
633: ( x_return_status IN OUT NOCOPY VARCHAR2
634: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
635: , p_rtg_header_Rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
636: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
637: , p_old_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
638: , p_old_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
639: )
640: IS

Line 637: , p_old_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type

633: ( x_return_status IN OUT NOCOPY VARCHAR2
634: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
635: , p_rtg_header_Rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
636: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
637: , p_old_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
638: , p_old_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
639: )
640: IS
641: l_err_text VARCHAR2(2000) := NULL;

Line 638: , p_old_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type

634: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
635: , p_rtg_header_Rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
636: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
637: , p_old_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
638: , p_old_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
639: )
640: IS
641: l_err_text VARCHAR2(2000) := NULL;
642: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 774: , p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type

770: **********************************************************************/
771: PROCEDURE Check_Required
772: ( x_return_status IN OUT NOCOPY VARCHAR2
773: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
774: , p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
775: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
776: )
777: IS
778: l_err_text VARCHAR2(2000);

Line 775: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type

771: PROCEDURE Check_Required
772: ( x_return_status IN OUT NOCOPY VARCHAR2
773: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
774: , p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
775: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
776: )
777: IS
778: l_err_text VARCHAR2(2000);
779: l_mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 1226: ( p_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Rec_Type

1222: * user is not entering values which may disturb the
1223: * integrity of the data.
1224: *********************************************************************/
1225: PROCEDURE Check_Entity
1226: ( p_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Rec_Type
1227: , p_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
1228: , p_old_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
1229: , p_old_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
1230: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1227: , p_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type

1223: * integrity of the data.
1224: *********************************************************************/
1225: PROCEDURE Check_Entity
1226: ( p_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Rec_Type
1227: , p_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
1228: , p_old_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
1229: , p_old_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
1230: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1231: , x_return_status IN OUT NOCOPY VARCHAR2

Line 1228: , p_old_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type

1224: *********************************************************************/
1225: PROCEDURE Check_Entity
1226: ( p_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Rec_Type
1227: , p_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
1228: , p_old_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
1229: , p_old_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
1230: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1231: , x_return_status IN OUT NOCOPY VARCHAR2
1232: )

Line 1229: , p_old_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type

1225: PROCEDURE Check_Entity
1226: ( p_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Rec_Type
1227: , p_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
1228: , p_old_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
1229: , p_old_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
1230: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1231: , x_return_status IN OUT NOCOPY VARCHAR2
1232: )
1233: IS

Line 2470: , p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type

2466:
2467: PROCEDURE Check_Entity_Delete
2468: ( x_return_status IN OUT NOCOPY VARCHAR2
2469: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2470: , p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
2471: , p_rtg_header_Unexp_Rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
2472: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
2473: )
2474: IS

Line 2471: , p_rtg_header_Unexp_Rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type

2467: PROCEDURE Check_Entity_Delete
2468: ( x_return_status IN OUT NOCOPY VARCHAR2
2469: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2470: , p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
2471: , p_rtg_header_Unexp_Rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
2472: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
2473: )
2474: IS
2475: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 2472: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type

2468: ( x_return_status IN OUT NOCOPY VARCHAR2
2469: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2470: , p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
2471: , p_rtg_header_Unexp_Rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
2472: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
2473: )
2474: IS
2475: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
2476: l_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type

Line 2476: l_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type

2472: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
2473: )
2474: IS
2475: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
2476: l_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
2477: := p_rtg_header_Unexp_Rec;
2478: l_err_text VARCHAR2(2000);
2479:
2480: Cursor CheckGroup is

Line 2572: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type

2568:
2569: END Check_Entity_Delete;
2570:
2571: PROCEDURE Check_SSOS -- Added for SSOS (bug 2689249)
2572: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
2573: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
2574: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2575: , x_return_status IN OUT NOCOPY VARCHAR2
2576: ) IS

Line 2573: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type

2569: END Check_Entity_Delete;
2570:
2571: PROCEDURE Check_SSOS -- Added for SSOS (bug 2689249)
2572: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
2573: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
2574: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2575: , x_return_status IN OUT NOCOPY VARCHAR2
2576: ) IS
2577: Cursor check_ssos_cur IS