eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GCS_DATA_PREP_PKG dependencies on FEM_CAL_PERIODS_ATTR

Line 219: fem_cal_periods_attr fcpa_number, ' || '

215: SELECT fdl.cal_period_id, ' ||
216: p_target_cal_period_id || '
217: FROM fem_data_locations fdl, ' || '
218: fem_ledgers_attr fla, ' || '
219: fem_cal_periods_attr fcpa_number, ' || '
220: fem_cal_periods_attr fcpa_year, ' || '
221: gcs_cal_period_map_dtls gcpmd, ' || '
222: gcs_cal_period_maps gcpm, ' || '
223: fem_cal_periods_b fcpb_src, ' || '

Line 220: fem_cal_periods_attr fcpa_year, ' || '

216: p_target_cal_period_id || '
217: FROM fem_data_locations fdl, ' || '
218: fem_ledgers_attr fla, ' || '
219: fem_cal_periods_attr fcpa_number, ' || '
220: fem_cal_periods_attr fcpa_year, ' || '
221: gcs_cal_period_map_dtls gcpmd, ' || '
222: gcs_cal_period_maps gcpm, ' || '
223: fem_cal_periods_b fcpb_src, ' || '
224: fem_cal_periods_b fcpb_tgt ' || '

Line 279: fem_cal_periods_attr fcpa_number,

275: (source_cal_period_id, target_cal_period_id)
276: SELECT fdl.cal_period_id, p_target_cal_period_id
277: FROM fem_data_locations fdl,
278: fem_ledgers_attr fla,
279: fem_cal_periods_attr fcpa_number,
280: fem_cal_periods_attr fcpa_year,
281: gcs_cal_period_map_dtls gcpmd,
282: gcs_cal_period_maps gcpm,
283: fem_cal_periods_b fcpb_src,

Line 280: fem_cal_periods_attr fcpa_year,

276: SELECT fdl.cal_period_id, p_target_cal_period_id
277: FROM fem_data_locations fdl,
278: fem_ledgers_attr fla,
279: fem_cal_periods_attr fcpa_number,
280: fem_cal_periods_attr fcpa_year,
281: gcs_cal_period_map_dtls gcpmd,
282: gcs_cal_period_maps gcpm,
283: fem_cal_periods_b fcpb_src,
284: fem_cal_periods_b fcpb_tgt

Line 504: fem_cal_periods_attr fcpa_number,

500: g_pkg_name || '.' || l_api_name,
501: 'INSERT INTO gcs_cal_period_maps_gt (source_cal_period_id, target_cal_period_id)
502: SELECT fcpb.cal_period_id, p_source_cal_period_id
503: FROM fem_cal_periods_b fcpb,
504: fem_cal_periods_attr fcpa_number,
505: fem_cal_periods_attr fcpa_year,
506: gcs_cal_period_map_dtls gcpmd
507: WHERE gcpmd.cal_period_map_id = ' ||
508: l_cal_period_map_id || '

Line 505: fem_cal_periods_attr fcpa_year,

501: 'INSERT INTO gcs_cal_period_maps_gt (source_cal_period_id, target_cal_period_id)
502: SELECT fcpb.cal_period_id, p_source_cal_period_id
503: FROM fem_cal_periods_b fcpb,
504: fem_cal_periods_attr fcpa_number,
505: fem_cal_periods_attr fcpa_year,
506: gcs_cal_period_map_dtls gcpmd
507: WHERE gcpmd.cal_period_map_id = ' ||
508: l_cal_period_map_id || '
509: AND fcpb.calendar_id = ' ||

Line 544: fem_cal_periods_attr fcpa_number,

540: INSERT INTO gcs_cal_period_maps_gt
541: (source_cal_period_id, target_cal_period_id)
542: SELECT p_source_cal_period_id, fcpb.cal_period_id
543: FROM fem_cal_periods_b fcpb,
544: fem_cal_periods_attr fcpa_number,
545: fem_cal_periods_attr fcpa_year,
546: gcs_cal_period_map_dtls gcpmd
547: WHERE gcpmd.cal_period_map_id = l_cal_period_map_id
548: AND fcpb.calendar_id = l_calendar_id

Line 545: fem_cal_periods_attr fcpa_year,

541: (source_cal_period_id, target_cal_period_id)
542: SELECT p_source_cal_period_id, fcpb.cal_period_id
543: FROM fem_cal_periods_b fcpb,
544: fem_cal_periods_attr fcpa_number,
545: fem_cal_periods_attr fcpa_year,
546: gcs_cal_period_map_dtls gcpmd
547: WHERE gcpmd.cal_period_map_id = l_cal_period_map_id
548: AND fcpb.calendar_id = l_calendar_id
549: AND fcpb.dimension_group_id = l_dimension_grp_id

Line 974: fem_cal_periods_attr fcpa

970: l_source_currency_type_code
971: FROM gcs_entity_cons_attrs geca,
972: fem_ledgers_attr fla,
973: gcs_entities_attr gea,
974: fem_cal_periods_attr fcpa
975: WHERE geca.entity_id = p_entity_id
976: AND geca.hierarchy_id = p_hierarchy_id
977: AND gea.entity_id = geca.entity_id
978: AND gea.data_type_code = p_balance_type_code

Line 1487: fem_cal_periods_attr fcpa

1483: SELECT fod.object_definition_id
1484: INTO l_hierarchy_obj_def_id
1485: FROM fem_xdim_dimensions fxd,
1486: fem_object_definition_b fod,
1487: fem_cal_periods_attr fcpa
1488: WHERE fxd.dimension_id = gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).dimension_id
1489: AND fxd.default_mvs_hierarchy_obj_id = fod.object_id
1490: AND fcpa.cal_period_id = p_cal_period_id
1491: AND fcpa.attribute_id = l_cal_attribute_id

Line 2046: fem_cal_periods_attr fcpa

2042: BEGIN
2043: SELECT gea.source_system_code
2044: INTO l_source_system_code
2045: FROM gcs_entities_attr gea,
2046: fem_cal_periods_attr fcpa
2047: WHERE gea.entity_id = p_entity_id
2048: AND gea.data_type_code = p_balance_type_code
2049: AND fcpa.cal_period_id = p_target_cal_period_id
2050: AND fcpa.attribute_id = l_period_end_date_attr