[Home] [Help]
PACKAGE: APPS.ENG_OPS_CONTROLLER
Source
1 PACKAGE ENG_OPS_Controller AUTHID CURRENT_USER AS
2 /* $Header: ENGCOPSS.pls 115.7 2004/02/12 22:56:50 sshrikha ship $ */
3
4 -- Global Record Type:
5 -- The ECO form declares a revised operation sequence controller record of this type
6 -- to send in user-entered information that requires processing.
7
8 TYPE Controller_OPS_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 , ACD_Type NUMBER := NULL
14 , Alternate_Routing_Code VARCHAR2(10) := NULL
15 , Operation_Sequence_Number NUMBER := NULL
16 , Operation_Type NUMBER := NULL
17 , Start_Effective_Date DATE := NULL
18 , New_Operation_Sequence_Number NUMBER := NULL
19 , Old_Operation_Sequence_Number NUMBER := NULL
20 , Old_Start_Effective_Date DATE := NULL
21 , Standard_Operation_Code VARCHAR2(4) := NULL
22 , Department_Code VARCHAR2(10) := NULL
23 , Op_Lead_Time_Percent NUMBER := NULL
24 , Minimum_Transfer_Quantity NUMBER := NULL
25 , Count_Point_Type NUMBER := NULL
26 , Operation_Description VARCHAR2(240) := NULL
27 , Disable_Date DATE := NULL
28 , Backflush_Flag NUMBER := NULL
29 , Option_Dependent_Flag NUMBER := NULL
30 , Reference_Flag NUMBER := NULL
31 , Yield NUMBER := NULL
32 , Cumulative_Yield NUMBER := NULL
33 , Cancel_Comments VARCHAR2(240) := NULL
34 , Attribute_category VARCHAR2(30) := NULL
35 , Attribute1 VARCHAR2(150) := NULL
36 , Attribute2 VARCHAR2(150) := NULL
37 , Attribute3 VARCHAR2(150) := NULL
38 , Attribute4 VARCHAR2(150) := NULL
39 , Attribute5 VARCHAR2(150) := NULL
40 , Attribute6 VARCHAR2(150) := NULL
41 , Attribute7 VARCHAR2(150) := NULL
42 , Attribute8 VARCHAR2(150) := NULL
43 , Attribute9 VARCHAR2(150) := NULL
44 , Attribute10 VARCHAR2(150) := NULL
45 , Attribute11 VARCHAR2(150) := NULL
46 , Attribute12 VARCHAR2(150) := NULL
47 , Attribute13 VARCHAR2(150) := NULL
48 , Attribute14 VARCHAR2(150) := NULL
49 , Attribute15 VARCHAR2(150) := NULL
50 , Original_System_Reference VARCHAR2(50) := NULL
51 , Transaction_Type VARCHAR2(30) := NULL
52 , Return_Status VARCHAR2(1) := NULL
53 , Revised_Item_Sequence_Id NUMBER := NULL
54 , Operation_Sequence_Id NUMBER := NULL
55 , Old_Operation_Sequence_Id NUMBER := NULL
56 , Routing_Sequence_Id NUMBER := NULL
57 , Revised_Item_Id NUMBER := NULL
58 , Organization_Id NUMBER := NULL
59 , Standard_Operation_Id NUMBER := NULL
60 , Department_Id NUMBER := NULL
61 );
62
63 -- Procedure Initialize_Record
64
65 PROCEDURE Initialize_Record
66 ( p_OPS_controller_rec IN Controller_OPS_Rec_Type
67 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
68 , x_OPS_controller_rec IN OUT NOCOPY Controller_OPS_Rec_Type
69 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
70 , x_return_status OUT NOCOPY VARCHAR2
71 );
72
73 PROCEDURE Validate_And_Write
74 ( p_OPS_controller_rec IN Controller_OPS_Rec_Type
75 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
76 , p_record_status IN VARCHAR2
77 , x_OPS_controller_rec IN OUT NOCOPY Controller_OPS_Rec_Type
78 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
79 , x_return_status OUT NOCOPY VARCHAR2
80 );
81
82 PROCEDURE Delete_Row
83 ( p_OPS_controller_rec IN Controller_OPS_Rec_Type
84 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
85 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
86 , x_return_status OUT NOCOPY VARCHAR2
87 );
88
89 PROCEDURE Change_Attribute
90 ( p_OPS_controller_rec IN Controller_OPS_Rec_Type
91 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
92 , p_record_status IN VARCHAR2
93 , x_OPS_controller_rec IN OUT NOCOPY Controller_OPS_Rec_Type
94 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
95 , x_return_status OUT NOCOPY VARCHAR2
96 );
97
98 /*PROCEDURE Lock_Row
99 ( x_return_status OUT NOCOPY VARCHAR2
100 , x_err_text OUT NOCOPY VARCHAR2
101 , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
102 , x_ECO_rec OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
103 );
104 */
105
106 END ENG_OPS_Controller;