DBA Data[Home] [Help]

APPS.GCS_RAISE_EVENT_PKG dependencies on GCS_UTILITY_PKG

Line 68: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;

64: p_analysis_cycle_id IN NUMBER)
65: IS
66: l_cal_period_end_date VARCHAR2(30);
67: l_end_date_attribute_id NUMBER :=
68: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;
69: l_end_date_version_id NUMBER :=
70: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
71: BEGIN
72:

Line 70: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;

66: l_cal_period_end_date VARCHAR2(30);
67: l_end_date_attribute_id NUMBER :=
68: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;
69: l_end_date_version_id NUMBER :=
70: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
71: BEGIN
72:
73: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
74: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_EXECUTE_ENG_EVENT.begin', '<>');

Line 152: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;

148: l_event_key VARCHAR2(200);
149: l_cal_period_end_date VARCHAR2(30);
150: l_threshold NUMBER;
151: l_end_date_attribute_id NUMBER :=
152: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;
153: l_end_date_version_id NUMBER :=
154: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
155: BEGIN
156:

Line 154: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;

150: l_threshold NUMBER;
151: l_end_date_attribute_id NUMBER :=
152: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;
153: l_end_date_version_id NUMBER :=
154: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
155: BEGIN
156:
157: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
158: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_EXECUTE_ENG_EVENT.begin', '<>');

Line 266: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;

262: l_event_key VARCHAR2(200);
263: l_cal_period_end_date VARCHAR2(30);
264: l_threshold NUMBER;
265: l_end_date_attribute_id NUMBER :=
266: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;
267: l_end_date_version_id NUMBER :=
268: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
269: l_source_dataset_code NUMBER;
270: l_hierarchy_dataset_code NUMBER;

Line 268: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;

264: l_threshold NUMBER;
265: l_end_date_attribute_id NUMBER :=
266: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;
267: l_end_date_version_id NUMBER :=
268: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
269: l_source_dataset_code NUMBER;
270: l_hierarchy_dataset_code NUMBER;
271:
272: --Bugfix 5505707: Add variables to store information required for default member setup

Line 273: l_dimension_info gcs_utility_pkg.t_hash_gcs_dimension_info;

269: l_source_dataset_code NUMBER;
270: l_hierarchy_dataset_code NUMBER;
271:
272: --Bugfix 5505707: Add variables to store information required for default member setup
273: l_dimension_info gcs_utility_pkg.t_hash_gcs_dimension_info;
274: l_column_name VARCHAR2(30);
275: l_value_set_tokens VARCHAR2(4000);
276: l_value_set_name VARCHAR2(150);
277: l_error_message VARCHAR2(32767);

Line 319: l_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;

315: fnd_file.put_line(fnd_file.log, '<>');
316:
317: --Bugfix 5505707: Validating Default Member Setup
318: fnd_file.put_line(fnd_file.log, '<>');
319: l_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
320: l_column_name := l_dimension_info.FIRST;
321:
322: WHILE (l_column_name <= l_dimension_info.LAST) LOOP
323: