PACKAGE: APPS.REV_CONTROLLER

Source

1 PACKAGE REV_Controller AUTHID CURRENT_USER AS
2 /* $Header: ENGCREVS.pls 115.6 2003/01/06 12:47:07 akumar ship $ */
3 
4 -- Global Record Type:
5 -- The ECO form declares a revised item controller record of this type to send in
6 -- user-entered information that requires processing.
7 
8 TYPE Controller_REV_Rec_Type IS RECORD
9 (   Change_Notice                 VARCHAR2(10)   := NULL
10 ,   Organization_code             VARCHAR2(3)    := NULL
11 ,   Revision                      VARCHAR2(10)   := NULL
12 ,   New_Revision                  VARCHAR2(10)   := NULL
13 ,   Comments                      VARCHAR2(240)  := NULL
14 ,   Attribute_category            VARCHAR2(30)   := NULL
15 ,   Attribute1                    VARCHAR2(150)  := NULL
16 ,   Attribute2                    VARCHAR2(150)  := NULL
17 ,   Attribute3                    VARCHAR2(150)  := NULL
18 ,   Attribute4                    VARCHAR2(150)  := NULL
19 ,   Attribute5                    VARCHAR2(150)  := NULL
20 ,   Attribute6                    VARCHAR2(150)  := NULL
21 ,   Attribute7                    VARCHAR2(150)  := NULL
22 ,   Attribute8                    VARCHAR2(150)  := NULL
23 ,   Attribute9                    VARCHAR2(150)  := NULL
24 ,   Attribute10                   VARCHAR2(150)  := NULL
25 ,   Attribute11                   VARCHAR2(150)  := NULL
26 ,   Attribute12                   VARCHAR2(150)  := NULL
27 ,   Attribute13                   VARCHAR2(150)  := NULL
28 ,   Attribute14                   VARCHAR2(150)  := NULL
29 ,   Attribute15                   VARCHAR2(150)  := NULL
30 ,   Return_Status                 VARCHAR2(1)    := NULL
31 ,   Transaction_Type              VARCHAR2(30)   := NULL
32 ,   Organization_Id               NUMBER         := NULL
33 ,   Revision_Id                   NUMBER         := NULL
34 ,   Change_Id                     NUMBER         := NULL   --added on 6.1.2003
35 );
36 
37 PROCEDURE Validate_And_Write
38 (   p_REV_controller_rec        IN  REV_Controller.Controller_REV_Rec_Type
39 ,   p_control_rec		IN  BOM_BO_PUB.Control_Rec_Type
40 ,   p_record_status             IN  VARCHAR2
41 ,   x_REV_controller_rec        IN OUT NOCOPY REV_Controller.Controller_REV_Rec_Type
42 ,   x_Mesg_Token_Tbl            OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
43 ,   x_return_status             OUT NOCOPY VARCHAR2
44 );
45 
46 PROCEDURE Delete_Row
47 (   p_REV_controller_rec        IN  REV_Controller.Controller_REV_Rec_Type
48 ,   p_control_rec               IN  BOM_BO_PUB.Control_Rec_Type
49 ,   x_Mesg_Token_Tbl            OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
50 ,   x_return_status             OUT NOCOPY VARCHAR2
51 );
52 
53 /*
54 PROCEDURE Change_Attribute
55 (   p_REV_controller_rec        IN  ENG_ECO_PUB.Controller_REV_Rec_Type
56 ,   p_control_rec               IN  BOM_BO_PUB.Control_Rec_Type
57 ,   p_record_status             IN  VARCHAR2
58 ,   x_REV_controller_rec        IN OUT NOCOPY ENG_ECO_PUB.Controller_REV_Rec_Type
59 ,   x_Mesg_Token_Tbl            OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
60 ,   x_return_status             OUT NOCOPY VARCHAR2
61 );
62 
63 PROCEDURE Lock_Row
64 (   x_return_status                 OUT NOCOPY VARCHAR2
65 ,   x_err_text			    OUT NOCOPY VARCHAR2
66 ,   p_ECO_rec                       IN  ENG_Eco_PUB.Eco_Rec_Type
67 ,   x_ECO_rec                       OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
68 );
69 */
70 
71 END REV_Controller;