1 PACKAGE INV_TO_Form_Trohdr AUTHID CURRENT_USER AS
2 /* $Header: INVFTRHS.pls 120.1 2005/06/17 14:21:13 appldev $ */
3
4 -- Procedure : Default_Attributes
5 --
6
7 PROCEDURE Default_Attributes
8 ( x_return_status OUT NOCOPY VARCHAR2
9 , x_msg_count OUT NOCOPY NUMBER
10 , x_msg_data OUT NOCOPY VARCHAR2
11 , x_attribute1 OUT NOCOPY VARCHAR2
12 , x_attribute10 OUT NOCOPY VARCHAR2
13 , x_attribute11 OUT NOCOPY VARCHAR2
14 , x_attribute12 OUT NOCOPY VARCHAR2
15 , x_attribute13 OUT NOCOPY VARCHAR2
16 , x_attribute14 OUT NOCOPY VARCHAR2
17 , x_attribute15 OUT NOCOPY VARCHAR2
18 , x_attribute2 OUT NOCOPY VARCHAR2
19 , x_attribute3 OUT NOCOPY VARCHAR2
20 , x_attribute4 OUT NOCOPY VARCHAR2
21 , x_attribute5 OUT NOCOPY VARCHAR2
22 , x_attribute6 OUT NOCOPY VARCHAR2
23 , x_attribute7 OUT NOCOPY VARCHAR2
24 , x_attribute8 OUT NOCOPY VARCHAR2
25 , x_attribute9 OUT NOCOPY VARCHAR2
26 , x_attribute_category OUT NOCOPY VARCHAR2
27 , x_date_required OUT NOCOPY DATE
28 , x_description OUT NOCOPY VARCHAR2
29 , x_from_subinventory_code OUT NOCOPY VARCHAR2
30 , x_header_id OUT NOCOPY NUMBER
31 , x_header_status OUT NOCOPY NUMBER
32 , x_organization_id OUT NOCOPY NUMBER
33 , x_request_number OUT NOCOPY VARCHAR2
34 , x_status_date OUT NOCOPY DATE
35 , x_to_account_id OUT NOCOPY NUMBER
36 , x_to_subinventory_code OUT NOCOPY VARCHAR2
37 , x_move_order_type OUT NOCOPY NUMBER
38 , x_from_subinventory OUT NOCOPY VARCHAR2
39 , x_header OUT NOCOPY VARCHAR2
40 , x_organization OUT NOCOPY VARCHAR2
41 , x_to_account OUT NOCOPY VARCHAR2
42 , x_to_subinventory OUT NOCOPY VARCHAR2
43 , x_move_order_type_name OUT NOCOPY VARCHAR2
44 , x_transaction_type_id OUT NOCOPY NUMBER
45 , x_ship_to_location_id OUT NOCOPY NUMBER
46 );
47
48 -- Procedure : Change_Attribute
49 --
50
51 PROCEDURE Validate_Record
52 ( x_return_status OUT NOCOPY VARCHAR2
53 , x_msg_count OUT NOCOPY NUMBER
54 , x_msg_data OUT NOCOPY VARCHAR2
55 , p_attribute1 IN VARCHAR2
56 , p_attribute10 IN VARCHAR2
57 , p_attribute11 IN VARCHAR2
58 , p_attribute12 IN VARCHAR2
59 , p_attribute13 IN VARCHAR2
60 , p_attribute14 IN VARCHAR2
61 , p_attribute15 IN VARCHAR2
62 , p_attribute2 IN VARCHAR2
63 , p_attribute3 IN VARCHAR2
64 , p_attribute4 IN VARCHAR2
65 , p_attribute5 IN VARCHAR2
66 , p_attribute6 IN VARCHAR2
67 , p_attribute7 IN VARCHAR2
68 , p_attribute8 IN VARCHAR2
69 , p_attribute9 IN VARCHAR2
70 , p_attribute_category IN VARCHAR2
71 , p_date_required IN DATE
72 , p_description IN VARCHAR2
73 , p_from_subinventory_code IN VARCHAR2
74 , p_header_id IN NUMBER
75 , p_header_status IN NUMBER
76 , p_organization_id IN NUMBER
77 , p_request_number IN VARCHAR2
78 , p_status_date IN DATE
79 , p_to_account_id IN NUMBER
80 , p_to_subinventory_code IN VARCHAR2
81 , p_move_order_type IN NUMBER
82 , p_transaction_type_id IN NUMBER
83 , p_ship_to_location_id IN NUMBER
84 , p_db_flag IN VARCHAR2
85 );
86
87 -- Procedure Validate_And_Write
88 --
89
90 PROCEDURE Validate_And_Write
91 ( x_return_status OUT NOCOPY VARCHAR2
92 , x_msg_count OUT NOCOPY NUMBER
93 , x_msg_data OUT NOCOPY VARCHAR2
94 , p_attribute1 IN VARCHAR2
95 , p_attribute10 IN VARCHAR2
96 , p_attribute11 IN VARCHAR2
97 , p_attribute12 IN VARCHAR2
98 , p_attribute13 IN VARCHAR2
99 , p_attribute14 IN VARCHAR2
100 , p_attribute15 IN VARCHAR2
101 , p_attribute2 IN VARCHAR2
102 , p_attribute3 IN VARCHAR2
103 , p_attribute4 IN VARCHAR2
104 , p_attribute5 IN VARCHAR2
105 , p_attribute6 IN VARCHAR2
106 , p_attribute7 IN VARCHAR2
107 , p_attribute8 IN VARCHAR2
108 , p_attribute9 IN VARCHAR2
109 , p_attribute_category IN VARCHAR2
110 , p_date_required IN DATE
111 , p_description IN VARCHAR2
112 , p_from_subinventory_code IN VARCHAR2
113 , p_header_id IN NUMBER
114 , p_header_status IN NUMBER
115 , p_organization_id IN NUMBER
116 , p_request_number IN VARCHAR2
117 , p_status_date IN DATE
118 , p_to_account_id IN NUMBER
119 , p_to_subinventory_code IN VARCHAR2
120 , p_move_order_type IN NUMBER
121 , p_transaction_type_id IN NUMBER
122 , p_ship_to_location_id IN NUMBER
123 , p_db_flag IN VARCHAR2
124 , x_creation_date OUT NOCOPY DATE
125 , x_created_by OUT NOCOPY NUMBER
126 , x_last_update_date OUT NOCOPY DATE
127 , x_last_updated_by OUT NOCOPY NUMBER
128 , x_last_update_login OUT NOCOPY NUMBER
129 );
130
131 -- Procedure Delete_Row
132 --
133
134 PROCEDURE Delete_Row
135 ( x_return_status OUT NOCOPY VARCHAR2
136 , x_msg_count OUT NOCOPY NUMBER
137 , x_msg_data OUT NOCOPY VARCHAR2
138 , p_header_id IN NUMBER
139 );
140
141 -- Procedure Process_Entity
142 --
143
144 PROCEDURE Process_Entity
145 ( x_return_status OUT NOCOPY VARCHAR2
146 , x_msg_count OUT NOCOPY NUMBER
147 , x_msg_data OUT NOCOPY VARCHAR2
148 );
149
150 -- Procedure Process_Object
151 --
152
153 PROCEDURE Process_Object
154 ( x_return_status OUT NOCOPY VARCHAR2
155 , x_msg_count OUT NOCOPY NUMBER
156 , x_msg_data OUT NOCOPY VARCHAR2
157 );
158
159 -- Procedure lock_Row
160 --
161
162 PROCEDURE Lock_Row
163 ( x_return_status OUT NOCOPY VARCHAR2
164 , x_msg_count OUT NOCOPY NUMBER
165 , x_msg_data OUT NOCOPY VARCHAR2
166 , p_attribute1 IN VARCHAR2
167 , p_attribute10 IN VARCHAR2
168 , p_attribute11 IN VARCHAR2
169 , p_attribute12 IN VARCHAR2
170 , p_attribute13 IN VARCHAR2
171 , p_attribute14 IN VARCHAR2
172 , p_attribute15 IN VARCHAR2
173 , p_attribute2 IN VARCHAR2
174 , p_attribute3 IN VARCHAR2
175 , p_attribute4 IN VARCHAR2
176 , p_attribute5 IN VARCHAR2
177 , p_attribute6 IN VARCHAR2
178 , p_attribute7 IN VARCHAR2
179 , p_attribute8 IN VARCHAR2
180 , p_attribute9 IN VARCHAR2
181 , p_attribute_category IN VARCHAR2
182 , p_created_by IN NUMBER
183 , p_creation_date IN DATE
184 , p_date_required IN DATE
185 , p_description IN VARCHAR2
186 , p_from_subinventory_code IN VARCHAR2
187 , p_header_id IN NUMBER
188 , p_header_status IN NUMBER
189 , p_last_updated_by IN NUMBER
190 , p_last_update_date IN DATE
191 , p_last_update_login IN NUMBER
192 , p_organization_id IN NUMBER
193 , p_program_application_id IN NUMBER
194 , p_program_id IN NUMBER
195 , p_program_update_date IN DATE
196 , p_request_id IN NUMBER
197 , p_request_number IN VARCHAR2
198 , p_status_date IN DATE
199 , p_to_account_id IN NUMBER
200 , p_to_subinventory_code IN VARCHAR2
201 , p_move_order_type IN NUMBER
202 , p_transaction_type_id IN NUMBER
203 , p_ship_to_location_id IN NUMBER
204 );
205
206 END INV_TO_Form_Trohdr;