239: WHEN MATCHED THEN
240: UPDATE
241: SET gcds.status_code = src.status_code,
242: gcds.last_update_date = sysdate,
243: gcds.last_updated_by = fnd_global.user_id
244: WHEN NOT MATCHED THEN
245: INSERT
246: (gcds.hierarchy_id,
247: gcds.consolidation_entity_id,
257: p_entity_id,
258: p_cal_period_id,
259: p_balance_type_code,
260: src.status_code,
261: fnd_global.user_id,
262: sysdate,
263: fnd_global.user_id,
264: sysdate);
265: END load_entity;
259: p_balance_type_code,
260: src.status_code,
261: fnd_global.user_id,
262: sysdate,
263: fnd_global.user_id,
264: sysdate);
265: END load_entity;
266:
267: -- update the gcs_cons_data_statuses table for a newly added entity in the specified hierarchy
328: END IF;
329: UPDATE gcs_cons_data_statuses gcds
330: SET status_code = 'IN_PROGRESS',
331: last_update_date = sysdate,
332: last_updated_by = fnd_global.user_id
333: WHERE hierarchy_id = p_hierarchy_id
334: AND status_code in ('COMPLETED', 'WARNING', 'ERROR')
335: AND consolidation_entity_id in
336: (SELECT gcr.parent_entity_id