[Home] [Help]
PACKAGE: APPS.ECO_CONTROLLER
Source
1 PACKAGE ECO_Controller AUTHID CURRENT_USER AS
2 /* $Header: ENGCECOS.pls 115.14 2003/09/22 18:40:14 akumar ship $ */
3
4 /*
5 -- Control record definition
6
7 TYPE Control_Rec_Type IS RECORD
8 ( controlled_operation BOOLEAN := FALSE
9 , check_existence BOOLEAN := FALSE
10 , attribute_defaulting BOOLEAN := FALSE
11 , entity_defaulting BOOLEAN := FALSE
12 , entity_validation BOOLEAN := FALSE
13 , process_entity VARCHAR2(30) := ENG_Globals.G_ENTITY_ECO
14 , write_to_db BOOLEAN := FALSE
15 );
16 */
17
18 -- Global Record Type:
19 -- The ECO form declares an ECO controller record of this type to send in
20 -- user-entered information that requires processing.
21
22 TYPE Controller_Eco_Rec_Type IS RECORD
23 ( change_notice VARCHAR2(10) := NULL
24 , organization_id NUMBER := NULL
25 , organization_code VARCHAR2(3) := NULL
26 , change_order_type VARCHAR2(10) := NULL
27 , change_order_type_id NUMBER := NULL
28 , description VARCHAR2(2000) := NULL
29 , initiation_date DATE := NULL
30 , implementation_date DATE := NULL
31 , cancellation_date DATE := NULL
32 , status_type NUMBER := NULL
33 , cancellation_comments VARCHAR2(240) := NULL
34 , priority_code VARCHAR2(10) := NULL
35 , reason_code VARCHAR2(10) := NULL
36 , estimated_eng_cost NUMBER := NULL
37 , estimated_mfg_cost NUMBER := NULL
38 , requestor_id NUMBER := NULL
39 , requestor_full_name VARCHAR2(240) := NULL
40 , approval_status_type NUMBER := NULL
41 , approval_list_id NUMBER := NULL
42 , approval_list_name VARCHAR2(10) := NULL
43 , approval_date DATE := NULL
44 , approval_request_date DATE := NULL
45 , responsible_organization_id NUMBER := NULL
46 , project_id NUMBER := NULL
47 , task_id NUMBER := NULL
48 , attribute_category VARCHAR2(30) := NULL
49 , attribute1 VARCHAR2(150) := NULL
50 , attribute2 VARCHAR2(150) := NULL
51 , attribute3 VARCHAR2(150) := NULL
52 , attribute4 VARCHAR2(150) := NULL
53 , attribute5 VARCHAR2(150) := NULL
54 , attribute6 VARCHAR2(150) := NULL
55 , attribute7 VARCHAR2(150) := NULL
56 , attribute8 VARCHAR2(150) := NULL
57 , attribute9 VARCHAR2(150) := NULL
58 , attribute10 VARCHAR2(150) := NULL
59 , attribute11 VARCHAR2(150) := NULL
60 , attribute12 VARCHAR2(150) := NULL
61 , attribute13 VARCHAR2(150) := NULL
62 , attribute14 VARCHAR2(150) := NULL
63 , attribute15 VARCHAR2(150) := NULL
64 --, hierarchy_flag NUMBER := NULL
65 , organization_hierarchy VARCHAR2(30) := NULL
66 -- Added for Requirements: ECO form
67 , change_mgmt_type_code VARCHAR2(30) := NULL
68 , hierarchy_id NUMBER := NULL
69 , change_id NUMBER := NULL
70 , PLM_OR_ERP_CHANGE VARCHAR2(3) :=NULL --11.5.10 to differentiate between ERP/PLM records
71 );
72
73
74 -- Procedure Initialize_Record
75
76 PROCEDURE Initialize_Record
77 ( p_ECO_controller_rec IN Controller_Eco_Rec_Type
78 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
79 , x_ECO_controller_rec IN OUT NOCOPY Controller_Eco_Rec_Type
80 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
81 , x_return_status OUT NOCOPY VARCHAR2
82 );
83
84 -- Procedure Validate_And_Write
85
86 PROCEDURE Validate_And_Write
87 ( p_ECO_controller_rec IN Controller_Eco_Rec_Type
88 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
89 , p_record_status IN VARCHAR2
90 , x_ECO_controller_rec IN OUT NOCOPY Controller_Eco_Rec_Type
91 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
92 , x_return_status OUT NOCOPY VARCHAR2
93 );
94
95 -- Procedure Delete_Row
96
97 PROCEDURE Delete_Row
98 ( p_ECO_controller_rec IN Controller_Eco_Rec_Type
99 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
100 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
101 , x_return_status OUT NOCOPY VARCHAR2
102 );
103
104 --Procedure Change_Attibute
105
106 PROCEDURE Change_Attribute
107 ( p_ECO_controller_rec IN Controller_Eco_Rec_Type
108 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
109 , p_record_status IN VARCHAR2
110 , x_ECO_controller_rec IN OUT NOCOPY Controller_Eco_Rec_Type
111 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
112 , x_return_status OUT NOCOPY VARCHAR2
113 );
114
115 /*PROCEDURE Lock_Row
116 ( x_return_status OUT NOCOPY VARCHAR2
117 , x_err_text OUT NOCOPY VARCHAR2
118 , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
119 , x_ECO_rec OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
120 );
121 */
122
123 END ECO_Controller;