PACKAGE: APPS.RFD_CONTROLLER

Source

1 PACKAGE RFD_Controller AUTHID CURRENT_USER AS
2 /* $Header: ENGCRFDS.pls 115.5 2004/02/12 22:57:23 sshrikha ship $ */
3 
4 -- Global Record Type:
5 -- The ECO form declares a revised component controller record of this type to send in
6 -- user-entered information that requires processing.
7 
8 TYPE Controller_RFD_Rec_Type IS RECORD
9 (   Change_Notice                   VARCHAR2(10) := NULL
10 ,   Organization_Code               VARCHAR2(3)  := NULL
11 ,   Revised_Item_Name               VARCHAR2(700) := NULL
12 ,   Start_Effective_Date            DATE         := NULL
13 ,   New_Revised_Item_Revision       VARCHAR2(3)  := NULL
14 ,   Operation_Sequence_Number       NUMBER       := NULL
15 ,   Component_Item_Name             VARCHAR2(700) := NULL
16 ,   Alternate_BOM_Code              VARCHAR2(10) := NULL
17 ,   Reference_Designator_Name       VARCHAR2(700) := NULL
18 ,   Acd_Type                      NUMBER         := NULL
19 ,   Ref_Designator_Comment	  VARCHAR2(240)  := NULL
20 ,   Attribute_category            VARCHAR2(30)   := NULL
21 ,   Attribute1                    VARCHAR2(150)  := NULL
22 ,   Attribute2                    VARCHAR2(150)  := NULL
23 ,   Attribute4                    VARCHAR2(150)  := NULL
24 ,   Attribute5                    VARCHAR2(150)  := NULL
25 ,   Attribute6                    VARCHAR2(150)  := NULL
26 ,   Attribute8                    VARCHAR2(150)  := NULL
27 ,   Attribute9                    VARCHAR2(150)  := NULL
28 ,   Attribute10                   VARCHAR2(150)  := NULL
29 ,   Attribute12                   VARCHAR2(150)  := NULL
30 ,   Attribute13                   VARCHAR2(150)  := NULL
31 ,   Attribute14                   VARCHAR2(150)  := NULL
32 ,   Attribute15                   VARCHAR2(150)  := NULL
33 ,   program_id                    NUMBER         := NULL
34 ,   Attribute3                    VARCHAR2(150)  := NULL
35 ,   Attribute7                    VARCHAR2(150)  := NULL
36 ,   Attribute11                   VARCHAR2(150)  := NULL
37 ,   Return_Status                 VARCHAR2(1)    := NULL
38 ,   Transaction_Type                VARCHAR2(30) := NULL
39 ,   Organization_Id                NUMBER        := NULL
40 ,   Component_Item_Id              NUMBER        := NULL
41 ,   Component_Sequence_Id          NUMBER        := NULL
42 ,   Revised_Item_Id                NUMBER        := NULL
43 ,   Substitute_Component_Id        NUMBER        := NULL
44 ,   Bill_Sequence_Id               NUMBER        := NULL
45 ,   Revised_Item_Sequence_Id       NUMBER        := NULL
46 );
47 
48 PROCEDURE Validate_And_Write
49 (   p_RFD_controller_rec        IN  Controller_RFD_Rec_Type
50 ,   p_control_rec		IN  BOM_BO_PUB.Control_Rec_Type
51 ,   p_record_status             IN  VARCHAR2
52 ,   x_RFD_controller_rec        IN OUT NOCOPY Controller_RFD_Rec_Type
53 ,   x_Mesg_Token_Tbl            OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
54 ,   x_return_status             OUT NOCOPY VARCHAR2
55 );
56 
57 PROCEDURE Delete_Row
58 (   p_RFD_controller_rec        IN  Controller_RFD_Rec_Type
59 ,   p_control_rec               IN  BOM_BO_PUB.Control_Rec_Type
60 ,   x_Mesg_Token_Tbl            OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
61 ,   x_return_status             OUT NOCOPY VARCHAR2
62 );
63 
64 
65 /*PROCEDURE Lock_Row
66 (   x_return_status                 OUT NOCOPY VARCHAR2
67 ,   x_err_text			    OUT NOCOPY VARCHAR2
68 ,   p_ECO_rec                       IN  ENG_Eco_PUB.Eco_Rec_Type
69 ,   x_ECO_rec                       OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
70 );
71 */
72 
73 END RFD_Controller;