[Home] [Help]
PACKAGE: APPS.ENG_RES_CONTROLLER
Source
1 PACKAGE ENG_RES_Controller AUTHID CURRENT_USER AS
2 /* $Header: ENGCRESS.pls 115.6 2004/02/12 22:55:34 sshrikha ship $ */
3
4 -- Global Record Type:
5 -- The ECO form declares a revised operation resource controller record of this type
6 -- to send in user-entered information that requires processing.
7
8 TYPE Controller_RES_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 , Op_Start_Effective_Date DATE := NULL
18 , Resource_Sequence_Number NUMBER := NULL
19 , Resource_Code VARCHAR2(10) := NULL
20 , Activity VARCHAR2(10) := NULL
21 , Standard_Rate_Flag NUMBER := NULL
22 , Assigned_Units NUMBER := NULL
23 , Usage_Rate_Or_amount NUMBER := NULL
24 , Usage_Rate_Or_Amount_Inverse NUMBER := NULL
25 , Basis_Type NUMBER := NULL
26 , Schedule_Flag NUMBER := NULL
27 , Resource_Offset_Percent NUMBER := NULL
28 , Autocharge_Type NUMBER := NULL
29 , Schedule_Sequence_Number NUMBER := NULL
30 , Principle_Flag NUMBER := NULL
31 , Attribute_category VARCHAR2(30) := NULL
32 , Attribute1 VARCHAR2(150) := NULL
33 , Attribute2 VARCHAR2(150) := NULL
34 , Attribute3 VARCHAR2(150) := NULL
35 , Attribute4 VARCHAR2(150) := NULL
36 , Attribute5 VARCHAR2(150) := NULL
37 , Attribute6 VARCHAR2(150) := NULL
38 , Attribute7 VARCHAR2(150) := NULL
39 , Attribute8 VARCHAR2(150) := NULL
40 , Attribute9 VARCHAR2(150) := NULL
41 , Attribute10 VARCHAR2(150) := NULL
42 , Attribute11 VARCHAR2(150) := NULL
43 , Attribute12 VARCHAR2(150) := NULL
44 , Attribute13 VARCHAR2(150) := NULL
45 , Attribute14 VARCHAR2(150) := NULL
46 , Attribute15 VARCHAR2(150) := NULL
47 , Original_System_Reference VARCHAR2(50) := NULL
48 , Transaction_Type VARCHAR2(30) := NULL
49 , Setup_Code VARCHAR2(30) := NULL
50 , Return_Status VARCHAR2(1) := NULL
51 , Revised_Item_Sequence_Id NUMBER := NULL
52 , Operation_Sequence_Id NUMBER := NULL
53 , Routing_Sequence_Id NUMBER := NULL
54 , Revised_Item_Id NUMBER := NULL
55 , Organization_Id NUMBER := NULL
56 , Substitute_Group_Number NUMBER := NULL
57 , Resource_Id NUMBER := NULL
58 , Activity_Id NUMBER := NULL
59 , Setup_Id NUMBER := NULL
60 );
61
62 -- Procedure Initialize_Record
63
64 PROCEDURE Initialize_Record
65 ( p_RES_controller_rec IN Controller_RES_Rec_Type
66 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
67 , x_RES_controller_rec IN OUT NOCOPY Controller_RES_Rec_Type
68 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
69 , x_return_status OUT NOCOPY VARCHAR2
70 );
71
72 PROCEDURE Validate_And_Write
73 ( p_RES_controller_rec IN Controller_RES_Rec_Type
74 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
75 , p_record_status IN VARCHAR2
76 , x_RES_controller_rec IN OUT NOCOPY Controller_RES_Rec_Type
77 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
78 , x_return_status OUT NOCOPY VARCHAR2
79 );
80
81 PROCEDURE Delete_Row
82 ( p_RES_controller_rec IN Controller_RES_Rec_Type
83 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
84 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
85 , x_return_status OUT NOCOPY VARCHAR2
86 );
87
88 PROCEDURE Change_Attribute
89 ( p_RES_controller_rec IN Controller_RES_Rec_Type
90 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
91 , p_record_status IN VARCHAR2
92 , x_RES_controller_rec IN OUT NOCOPY Controller_RES_Rec_Type
93 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
94 , x_return_status OUT NOCOPY VARCHAR2
95 );
96
97 /*PROCEDURE Lock_Row
98 ( x_return_status OUT NOCOPY VARCHAR2
99 , x_err_text OUT NOCOPY VARCHAR2
100 , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
101 , x_ECO_rec OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
102 );
103 */
104
105 END ENG_RES_Controller;