[Home] [Help]
PACKAGE: APPS.ENG_RIT_CONTROLLER
Source
1 PACKAGE ENG_RIT_Controller AUTHID CURRENT_USER AS
2 /* $Header: ENGCRICS.pls 120.0 2006/02/12 23:44:16 asjohal noship $ */
3
4 -- Global Record Type:
5 -- The ECO form declares a revised item controller record of this type to
6 -- send in user-entered information that requires processing.
7
8 TYPE Controller_RIT_Rec_Type IS RECORD
9 ( Eco_Name VARCHAR2(10) := NULL
10 , Organization_Code VARCHAR2(3) := NULL
11 , Revised_Item_Name VARCHAR2(700) := NULL
12 , New_Revised_Item_Revision VARCHAR2(3) := NULL
13 , New_Revised_Item_Rev_Desc VARCHAR2(240) := NULL
14 , Updated_Revised_Item_Revision VARCHAR2(3) := NULL
15 , Updated_Routing_Revision VARCHAR2(3) := NULL
16 , Start_Effective_Date DATE := NULL
17 , New_Effective_Date DATE := NULL
18 , Alternate_Bom_Code VARCHAR2(10) := NULL
19 , Status_Type NUMBER := NULL
20 , Mrp_Active NUMBER := NULL
21 , Earliest_Effective_Date DATE := NULL
22 , Use_Up_Item_Name VARCHAR2(700) := NULL
23 , Use_Up_Plan_Name VARCHAR2(10) := NULL
24 , Requestor VARCHAR2(30) := NULL
25 , Disposition_Type NUMBER := NULL
26 , Update_Wip NUMBER := NULL
27 , Cancel_Comments VARCHAR2(240) := NULL
28 , Change_Description VARCHAR2(240) := NULL
29 , Attribute_category VARCHAR2(30) := NULL
30 , Attribute1 VARCHAR2(150) := NULL
31 , Attribute2 VARCHAR2(150) := NULL
32 , Attribute3 VARCHAR2(150) := NULL
33 , Attribute4 VARCHAR2(150) := NULL
34 , Attribute5 VARCHAR2(150) := NULL
35 , Attribute6 VARCHAR2(150) := NULL
36 , Attribute7 VARCHAR2(150) := NULL
37 , Attribute8 VARCHAR2(150) := NULL
38 , Attribute9 VARCHAR2(150) := NULL
39 , Attribute10 VARCHAR2(150) := NULL
40 , Attribute11 VARCHAR2(150) := NULL
41 , Attribute12 VARCHAR2(150) := NULL
42 , Attribute13 VARCHAR2(150) := NULL
43 , Attribute14 VARCHAR2(150) := NULL
44 , Attribute15 VARCHAR2(150) := NULL
45 , Start_From_Unit_Number VARCHAR2(30) := NULL
46 , New_From_End_Item_Unit_Number VARCHAR2(30) := NULL
47 , Original_System_Reference VARCHAR2(50) := NULL
48 , Return_Status VARCHAR2(1) := NULL
49 , Transaction_Type VARCHAR2(30) := NULL
50 , From_Work_Order VARCHAR2(150) := NULL
51 , To_Work_Order VARCHAR2(150) := NULL
52 , From_Cumulative_Quantity NUMBER := NULL
53 , Lot_Number VARCHAR2(30) := NULL
54 , Completion_Subinventory VARCHAR2(10) := NULL
55 , Completion_Location_Name VARCHAR2(700) := NULL
56 , Priority NUMBER := NULL
57 , Ctp_Flag NUMBER := NULL
58 , New_Routing_Revision VARCHAR2(240) := NULL
59 , Routing_Comment VARCHAR2(240) := NULL
60 , Organization_Id NUMBER := NULL
61 , Revised_Item_Id NUMBER := NULL
62 , Implementation_Date DATE := NULL
63 , Auto_Implement_Date DATE := NULL
64 , Cancellation_Date DATE := NULL
65 , Bill_Sequence_Id NUMBER := NULL
66 , Use_Up_Item_Id NUMBER := NULL
67 , Use_Up NUMBER := NULL
68 , Requestor_id NUMBER := NULL
69 , Revised_Item_Sequence_Id NUMBER := NULL
70 , Routing_Sequence_Id NUMBER := NULL
71 , From_WIP_Entity_Id NUMBER := NULL
72 , To_WIP_Entity_Id NUMBER := NULL
73 , CFM_Routing_Flag NUMBER := NULL
74 , Completion_Locator_Id NUMBER := NULL
75 , Eco_For_Production NUMBER := NULL
76 -- added for Requirements :ECO form
77 , Change_Id NUMBER := NULL
78 , Reschedule_Comments VARCHAR2(240) := NULL -- Bug 3589974
79 );
80
81 -- Procedure Initialize_Record
82
83 PROCEDURE Initialize_Record
84 ( p_RIT_controller_rec IN ENG_RIT_Controller.Controller_Rit_Rec_Type
85 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
86 , x_RIT_controller_rec IN OUT NOCOPY ENG_RIT_Controller.Controller_Rit_Rec_Type
87 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
88 , x_return_status OUT NOCOPY VARCHAR2
89 );
90
91 PROCEDURE Validate_And_Write
92 ( p_RIT_controller_rec IN ENG_RIT_Controller.Controller_Rit_Rec_Type
93 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
94 , p_record_status IN VARCHAR2
95 , x_RIT_controller_rec IN OUT NOCOPY ENG_RIT_Controller.Controller_Rit_Rec_Type
96 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
97 , x_return_status OUT NOCOPY VARCHAR2
98 );
99
100 PROCEDURE Delete_Row
101 ( p_RIT_controller_rec IN ENG_RIT_Controller.Controller_Rit_Rec_Type
102 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
103 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
104 , x_return_status OUT NOCOPY VARCHAR2
105 );
106
107 PROCEDURE Change_Attribute
108 ( p_RIT_controller_rec IN ENG_RIT_Controller.Controller_Rit_Rec_Type
109 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
110 , p_record_status IN VARCHAR2
111 , x_RIT_controller_rec IN OUT NOCOPY ENG_RIT_Controller.Controller_Rit_Rec_Type
112 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
113 , x_return_status OUT NOCOPY VARCHAR2
114 , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
115 );
116
117 /*PROCEDURE Lock_Row
118 ( x_return_status OUT NOCOPY VARCHAR2
119 , x_err_text OUT NOCOPY VARCHAR2
120 , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
121 , x_ECO_rec OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
122 );
123 */
124
125 END ENG_RIT_Controller;