APPS.CHV_CUM_PERIODS_S2 dependencies on CHV_CUM_PERIOD_ITEMS

Line 264: -- If there are no records in chv_cum_period_items, then we must

260: x_cum_quantity_received);
261:
262: --dbms_output.put_line('Get Cum Info: cum qty'||x_cum_quantity_received);
263:
264: -- If there are no records in chv_cum_period_items, then we must
265: -- insert a record. The first time we build a schedule for an item
266: -- we must insert a record into chv_cum_period_items.
267: x_progress := '040';
268:

Line 266: -- we must insert a record into chv_cum_period_items.

262: --dbms_output.put_line('Get Cum Info: cum qty'||x_cum_quantity_received);
263:
264: -- If there are no records in chv_cum_period_items, then we must
265: -- insert a record. The first time we build a schedule for an item
266: -- we must insert a record into chv_cum_period_items.
267: x_progress := '040';
268:
269: SELECT count(*)
270: INTO x_number_records_cpi

Line 271: FROM chv_cum_period_items cpi

267: x_progress := '040';
268:
269: SELECT count(*)
270: INTO x_number_records_cpi
271: FROM chv_cum_period_items cpi
272: WHERE cpi.cum_period_id = x_cum_period_id
273: AND cpi.vendor_id = x_vendor_id
274: AND cpi.vendor_site_id = x_vendor_site_id
275: AND cpi.organization_id = x_organization_id

Line 293: INSERT INTO chv_cum_period_items (cum_period_item_id,

289: --dbms_output.put_line('Get Cum info: item'||x_item_id);
290: --dbms_output.put_line('Get Cum info: purchasing'||x_purchasing_unit_of_measure);
291: --dbms_output.put_line('Get Cum info: primary'||x_primary_unit_of_measure);
292:
293: INSERT INTO chv_cum_period_items (cum_period_item_id,
294: cum_period_id,
295: organization_id,
296: vendor_id,
297: vendor_site_id,

Line 304: VALUES (chv_cum_period_items_s.NEXTVAL,

300: last_updated_by,
301: creation_date,
302: created_by,
303: last_update_login)
304: VALUES (chv_cum_period_items_s.NEXTVAL,
305: x_cum_period_id,
306: x_organization_id,
307: x_vendor_id,
308: x_vendor_site_id,