DBA Data[Home] [Help]

APPS.GCS_FEM_HIER_SYNC_PKG dependencies on GCS_UTILITY_PKG

Line 246: x_retcode := gcs_utility_pkg.g_ret_sts_error;

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(

Line 260: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE').attribute_id;

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;

Line 262: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE').version_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;

Line 264: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_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;

Line 266: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_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;

Line 268: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_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);

Line 270: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').version_id;

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);