DBA Data[Home] [Help]

PACKAGE: APPS.ENG_VALIDATE_ECO

Source


1 PACKAGE ENG_Validate_Eco AS
2 /* $Header: ENGLECOS.pls 120.2 2007/06/01 09:13:10 pguharay ship $ */
3 
4 -- PROCEDURE Check_Delete
5 
6 PROCEDURE Check_Delete
7 ( p_eco_rec             IN  ENG_ECO_PUB.Eco_Rec_Type
8 , p_Unexp_ECO_rec       IN  ENG_Eco_PUB.Eco_Unexposed_Rec_Type
9 , x_return_status       OUT NOCOPY VARCHAR2
10 , x_Mesg_Token_Tbl      OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
11 );
12 
13 --  Procedure Entity
14 
15 PROCEDURE Check_Entity
16 (   x_return_status                 OUT NOCOPY VARCHAR2
17 ,   x_err_text			    OUT NOCOPY	VARCHAR2
18 ,   x_Mesg_Token_Tbl		    OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
19 ,   p_ECO_rec                       IN  ENG_Eco_PUB.Eco_Rec_Type
20 ,   p_Unexp_ECO_rec		    IN  ENG_Eco_PUB.Eco_Unexposed_Rec_Type
21 ,   p_old_ECO_rec                   IN  ENG_Eco_PUB.Eco_Rec_Type
22 ,   p_old_Unexp_ECO_rec		    IN  ENG_Eco_PUB.Eco_Unexposed_Rec_Type
23 ,   p_control_rec		    IN  BOM_BO_PUB.Control_Rec_Type :=
24 					BOM_BO_PUB.G_DEFAULT_CONTROL_REC
25 );
26 
27 --  Procedure Check_Attributes
28 
29 PROCEDURE Check_Attributes
30 (   x_return_status                 OUT NOCOPY VARCHAR2
31 ,   x_err_text			    OUT NOCOPY	VARCHAR2
32 ,   x_Mesg_Token_Tbl		    OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
33 ,   p_ECO_rec                       IN  ENG_Eco_PUB.Eco_Rec_Type
34 ,   p_Unexp_ECO_rec		    IN  ENG_Eco_PUB.Eco_Unexposed_Rec_Type
35 ,   p_old_ECO_rec                   IN  ENG_Eco_PUB.Eco_Rec_Type
36 ,   p_old_Unexp_ECO_rec		    IN  ENG_Eco_PUB.Eco_Unexposed_Rec_Type
37 ,   p_change_line_tbl               IN  ENG_Eco_PUB.Change_Line_Tbl_Type --Bug 2908248
38 ,   p_revised_item_tbl              IN  ENG_Eco_PUB.Revised_Item_Tbl_Type --Bug 2908248
39 
40 );
41 
42 -- Procedure Check_Required
43 
44 PROCEDURE Conditionally_Required
45 (   x_return_status		   OUT NOCOPY VARCHAR2
46 ,   x_Mesg_Token_Tbl		    OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
47 ,   p_ECO_rec			   IN  ENG_ECO_PUB.Eco_Rec_Type
48 ,   p_Unexp_ECO_rec		    IN  ENG_Eco_PUB.Eco_Unexposed_Rec_Type
49 ,   p_old_ECO_rec                   IN  ENG_Eco_PUB.Eco_Rec_Type
50 ,   p_old_Unexp_ECO_rec		    IN  ENG_Eco_PUB.Eco_Unexposed_Rec_Type
51 );
52 
53 PROCEDURE Check_Access
54 (  p_change_notice      IN  VARCHAR2
55  , p_organization_id    IN  NUMBER
56  , p_change_type_code	IN  VARCHAR2 := NULL
57  , p_change_order_type_id IN NUMBER := NULL
58  , p_Mesg_Token_Tbl     IN  Error_Handler.Mesg_Token_Tbl_Type :=
59                                 Error_Handler.G_MISS_MESG_TOKEN_TBL
60  , x_Mesg_Token_Tbl     IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
61  , x_Return_Status      OUT NOCOPY VARCHAR2
62  , p_check_scheduled_status IN BOOLEAN DEFAULT TRUE -- Added for Bug 5756870
63  , p_status_check_required IN BOOLEAN DEFAULT TRUE -- Added for enhancement 5414834
64 );
65 
66 PROCEDURE Check_Existence
67 (  p_change_notice      IN  VARCHAR2
68  , p_organization_id    IN  NUMBER
69  , p_organization_code  IN  VARCHAR2
70  , p_calling_entity     IN  VARCHAR2
71  , p_transaction_type   IN  VARCHAR2
72  , x_eco_rec            OUT NOCOPY Eng_Eco_Pub.Eco_Rec_Type
73  , x_eco_unexp_rec      OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
74  , x_Mesg_Token_Tbl     OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
75  , x_Return_Status      OUT NOCOPY VARCHAR2
76 );
77 
78 END ENG_Validate_Eco;