[Home] [Help]
PACKAGE BODY: APPS.PO_ASL_ATTRIBUTES_THS
Source
1 PACKAGE BODY PO_ASL_ATTRIBUTES_THS as
2 /* $Header: POXA5LSB.pls 115.8 2003/08/21 09:39:01 tmanda ship $ */
3
4 /*=============================================================================
5
6 PROCEDURE NAME: insert_row()
7
8 ===============================================================================*/
9 procedure insert_row(
10 x_row_id IN OUT NOCOPY VARCHAR2,
11 x_asl_id NUMBER,
12 x_using_organization_id NUMBER,
13 x_last_update_date DATE,
14 x_last_updated_by NUMBER,
15 x_creation_date DATE,
16 x_created_by NUMBER,
17 x_document_sourcing_method VARCHAR2,
18 x_release_generation_method VARCHAR2,
19 x_purchasing_unit_of_measure VARCHAR2,
20 x_enable_plan_schedule_flag VARCHAR2,
21 x_enable_ship_schedule_flag VARCHAR2,
22 x_plan_schedule_type VARCHAR2,
23 x_ship_schedule_type VARCHAR2,
24 x_plan_bucket_pattern_id NUMBER,
25 x_ship_bucket_pattern_id NUMBER,
26 x_enable_autoschedule_flag VARCHAR2,
27 x_scheduler_id NUMBER,
28 x_enable_authorizations_flag VARCHAR2,
29 x_vendor_id NUMBER,
30 x_vendor_site_id NUMBER,
31 x_item_id NUMBER,
32 x_category_id NUMBER,
33 x_attribute_category VARCHAR2,
34 x_attribute1 VARCHAR2,
35 x_attribute2 VARCHAR2,
36 x_attribute3 VARCHAR2,
37 x_attribute4 VARCHAR2,
38 x_attribute5 VARCHAR2,
39 x_attribute6 VARCHAR2,
40 x_attribute7 VARCHAR2,
41 x_attribute8 VARCHAR2,
42 x_attribute9 VARCHAR2,
43 x_attribute10 VARCHAR2,
44 x_attribute11 VARCHAR2,
45 x_attribute12 VARCHAR2,
46 x_attribute13 VARCHAR2,
47 x_attribute14 VARCHAR2,
48 x_attribute15 VARCHAR2,
49 x_last_update_login NUMBER,
50 x_price_update_tolerance NUMBER,
51 x_processing_lead_time NUMBER,
52 x_delivery_calendar VARCHAR2,
53 x_min_order_qty NUMBER,
54 x_fixed_lot_multiple NUMBER,
55 x_country_of_origin_code VARCHAR2,
56 /* VMI FPH START */
57 x_enable_vmi_flag VARCHAR2,
58 x_vmi_min_qty NUMBER,
59 x_vmi_max_qty NUMBER,
60 x_enable_vmi_auto_repl_flag VARCHAR2,
61 x_vmi_replenishment_approval VARCHAR2,
62 /* VMI FPH END */
63 /* CONSSUP FPI START */
64 x_consigned_from_supplier_flag VARCHAR2,
65 x_consigned_billing_cycle NUMBER ,
66 x_last_billing_date DATE,
67 /* CONSSUP FPI END */
68 /*FPJ START*/
69 x_replenishment_method NUMBER,
70 x_vmi_min_days NUMBER,
71 x_vmi_max_days NUMBER,
72 x_fixed_order_quantity NUMBER,
73 x_forecast_horizon NUMBER,
74 x_consume_on_aging_flag VARCHAR2,
75 x_aging_period NUMBER
76 /*FPJ END*/
77 ) is
78
79
80
81 cursor row_id is SELECT rowid
82 FROM PO_ASL_ATTRIBUTES
83 WHERE x_asl_id = asl_id
84 AND x_using_organization_id = using_organization_id;
85
86 begin
87
88 INSERT INTO PO_ASL_ATTRIBUTES(
89 asl_id ,
90 using_organization_id ,
91 last_update_date ,
92 last_updated_by ,
93 creation_date ,
94 created_by ,
95 document_sourcing_method ,
96 release_generation_method ,
97 purchasing_unit_of_measure ,
98 enable_plan_schedule_flag ,
99 enable_ship_schedule_flag ,
100 plan_schedule_type ,
101 ship_schedule_type ,
102 plan_bucket_pattern_id ,
103 ship_bucket_pattern_id ,
104 enable_autoschedule_flag ,
105 scheduler_id ,
106 enable_authorizations_flag ,
107 vendor_id ,
108 vendor_site_id ,
109 item_id ,
110 category_id ,
111 attribute_category ,
112 attribute1 ,
113 attribute2 ,
114 attribute3 ,
115 attribute4 ,
116 attribute5 ,
117 attribute6 ,
118 attribute7 ,
119 attribute8 ,
120 attribute9 ,
121 attribute10 ,
122 attribute11 ,
123 attribute12 ,
124 attribute13 ,
125 attribute14 ,
126 attribute15 ,
127 last_update_login ,
128 price_update_tolerance ,
129 processing_lead_time ,
130 delivery_calendar ,
131 min_order_qty ,
132 fixed_lot_multiple ,
133 country_of_origin_code ,
134 /* VMI FPH START */
135 enable_vmi_flag ,
136 vmi_min_qty ,
137 vmi_max_qty ,
138 enable_vmi_auto_replenish_flag ,
139 vmi_replenishment_approval ,
140 /* VMI FPH END */
141 /* CONSSUP FPI START */
142 consigned_from_supplier_flag ,
143 consigned_billing_cycle ,
144 last_billing_date ,
145 /* CONSSUP FPI END */
146 /*FPJ START */
147 replenishment_method ,
148 vmi_min_days ,
149 vmi_max_days ,
150 fixed_order_quantity ,
151 forecast_horizon ,
152 consume_on_aging_flag ,
153 aging_period
154 /*FPJ END*/
155 ) VALUES (
156 x_asl_id ,
157 x_using_organization_id ,
158 x_last_update_date ,
159 x_last_updated_by ,
160 x_creation_date ,
161 x_created_by ,
162 x_document_sourcing_method ,
163 x_release_generation_method ,
164 x_purchasing_unit_of_measure ,
165 x_enable_plan_schedule_flag ,
166 x_enable_ship_schedule_flag ,
167 x_plan_schedule_type ,
168 x_ship_schedule_type ,
169 x_plan_bucket_pattern_id ,
170 x_ship_bucket_pattern_id ,
171 x_enable_autoschedule_flag ,
172 x_scheduler_id ,
173 x_enable_authorizations_flag ,
174 x_vendor_id ,
175 x_vendor_site_id ,
176 x_item_id ,
177 x_category_id ,
178 x_attribute_category ,
179 x_attribute1 ,
180 x_attribute2 ,
181 x_attribute3 ,
182 x_attribute4 ,
183 x_attribute5 ,
184 x_attribute6 ,
185 x_attribute7 ,
186 x_attribute8 ,
187 x_attribute9 ,
188 x_attribute10 ,
189 x_attribute11 ,
190 x_attribute12 ,
191 x_attribute13 ,
192 x_attribute14 ,
193 x_attribute15 ,
194 x_last_update_login ,
195 x_price_update_tolerance ,
196 x_processing_lead_time ,
197 x_delivery_calendar ,
198 x_min_order_qty ,
199 x_fixed_lot_multiple ,
200 x_country_of_origin_code ,
201 /* VMI FPH START */
202 x_enable_vmi_flag ,
203 x_vmi_min_qty ,
204 x_vmi_max_qty ,
205 x_enable_vmi_auto_repl_flag ,
206 x_vmi_replenishment_approval ,
207 /* VMI FPH END */
208 /* CONSSUP FPI START */
209 x_consigned_from_supplier_flag ,
210 x_consigned_billing_cycle ,
211 x_last_billing_date ,
212 /* CONSSUP FPI END */
213 /*FPJ START*/
214 x_replenishment_method ,
215 x_vmi_min_days ,
216 x_vmi_max_days ,
217 x_fixed_order_quantity ,
218 x_forecast_horizon ,
219 x_consume_on_aging_flag ,
220 x_aging_period
221 /*FPJ END*/
222 );
223
224
225 OPEN row_id;
226 FETCH row_id INTO x_row_id;
227 if (row_id%notfound) then
228 CLOSE row_id;
229 raise no_data_found;
230 end if;
231 CLOSE row_id;
232
233 end insert_row;
234
235 END PO_ASL_ATTRIBUTES_THS;