APPS.CHV_CUM_PERIODS_S2 dependencies on CHV_CUM_PERIOD_ITEMS

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

266: x_cum_quantity_received);
267:
268: --dbms_output.put_line('Get Cum Info: cum qty'||x_cum_quantity_received);
269:
270: -- If there are no records in chv_cum_period_items, then we must
271: -- insert a record. The first time we build a schedule for an item
272: -- we must insert a record into chv_cum_period_items.
273: x_progress := '040';
274:

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

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

Line 277: FROM chv_cum_period_items cpi

273: x_progress := '040';
274:
275: SELECT count(*)
276: INTO x_number_records_cpi
277: FROM chv_cum_period_items cpi
278: WHERE cpi.cum_period_id = x_cum_period_id
279: AND cpi.vendor_id = x_vendor_id
280: AND cpi.vendor_site_id = x_vendor_site_id
281: AND cpi.organization_id = x_organization_id

Line 299: INSERT INTO chv_cum_period_items (cum_period_item_id,

295: --dbms_output.put_line('Get Cum info: item'||x_item_id);
296: --dbms_output.put_line('Get Cum info: purchasing'||x_purchasing_unit_of_measure);
297: --dbms_output.put_line('Get Cum info: primary'||x_primary_unit_of_measure);
298:
299: INSERT INTO chv_cum_period_items (cum_period_item_id,
300: cum_period_id,
301: organization_id,
302: vendor_id,
303: vendor_site_id,

Line 310: VALUES (chv_cum_period_items_s.NEXTVAL,

306: last_updated_by,
307: creation_date,
308: created_by,
309: last_update_login)
310: VALUES (chv_cum_period_items_s.NEXTVAL,
311: x_cum_period_id,
312: x_organization_id,
313: x_vendor_id,
314: x_vendor_site_id,