242: fnd_file.put_line(fnd_file.log, 'End of Integration with EPF');
243:
244: EXCEPTION
245: WHEN OTHERS THEN
246: x_retcode := gcs_utility_pkg.g_ret_sts_error;
247: fnd_file.put_line(fnd_file.log, 'Error occurring during integration with EPF');
248: END synchronize_hierarchy;
249:
250: PROCEDURE entity_added(
256: l_child_entity_id NUMBER;
257: l_entity_type VARCHAR2(1);
258: l_parent_depth_num NUMBER(15);
259: l_entity_type_attr NUMBER :=
260: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE').attribute_id;
261: l_entity_type_version NUMBER :=
262: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE').version_id;
263: l_elim_entity_attr NUMBER :=
264: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id;
258: l_parent_depth_num NUMBER(15);
259: l_entity_type_attr NUMBER :=
260: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE').attribute_id;
261: l_entity_type_version NUMBER :=
262: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE').version_id;
263: l_elim_entity_attr NUMBER :=
264: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id;
265: l_elim_entity_version NUMBER :=
266: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
260: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE').attribute_id;
261: l_entity_type_version NUMBER :=
262: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE').version_id;
263: l_elim_entity_attr NUMBER :=
264: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id;
265: l_elim_entity_version NUMBER :=
266: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
267: l_oper_entity_attr NUMBER :=
268: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id;
262: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE').version_id;
263: l_elim_entity_attr NUMBER :=
264: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id;
265: l_elim_entity_version NUMBER :=
266: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
267: l_oper_entity_attr NUMBER :=
268: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id;
269: l_oper_entity_version NUMBER :=
270: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').version_id;
264: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id;
265: l_elim_entity_version NUMBER :=
266: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
267: l_oper_entity_attr NUMBER :=
268: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id;
269: l_oper_entity_version NUMBER :=
270: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').version_id;
271: l_prior_relation_exists BOOLEAN := FALSE;
272: l_object_definition_id NUMBER(9);
266: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
267: l_oper_entity_attr NUMBER :=
268: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id;
269: l_oper_entity_version NUMBER :=
270: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').version_id;
271: l_prior_relation_exists BOOLEAN := FALSE;
272: l_object_definition_id NUMBER(9);
273: l_object_id NUMBER(9);
274: l_hierarchy_name VARCHAR2(150);