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