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_UTILITY_PKG dependencies on FEM_CAL_PERIODS_ATTR

Line 285: fem_cal_periods_attr fcpa_number,

281: INTO l_calendar_id, l_calendar_group_id,
282: l_curr_cal_period_number, l_curr_cal_period_year,
283: l_periods_per_year
284: FROM fem_cal_periods_b fcpb,
285: fem_cal_periods_attr fcpa_number,
286: fem_cal_periods_attr fcpa_year,
287: fem_dimension_grps_b fdgb,
288: fem_time_grp_types_attr ftgta,
289: fem_dim_attributes_b feab,

Line 286: fem_cal_periods_attr fcpa_year,

282: l_curr_cal_period_number, l_curr_cal_period_year,
283: l_periods_per_year
284: FROM fem_cal_periods_b fcpb,
285: fem_cal_periods_attr fcpa_number,
286: fem_cal_periods_attr fcpa_year,
287: fem_dimension_grps_b fdgb,
288: fem_time_grp_types_attr ftgta,
289: fem_dim_attributes_b feab,
290: fem_dim_attr_versions_b fdavb

Line 323: fem_cal_periods_attr fcpa_number,

319:
320: SELECT fcpb.cal_period_id
321: INTO l_prev_cal_period_id
322: FROM fem_cal_periods_b fcpb,
323: fem_cal_periods_attr fcpa_number,
324: fem_cal_periods_attr fcpa_year
325: WHERE fcpb.calendar_id = l_calendar_id
326: AND fcpb.dimension_group_id = l_calendar_group_id
327: AND fcpb.cal_period_id = fcpa_number.cal_period_id

Line 324: fem_cal_periods_attr fcpa_year

320: SELECT fcpb.cal_period_id
321: INTO l_prev_cal_period_id
322: FROM fem_cal_periods_b fcpb,
323: fem_cal_periods_attr fcpa_number,
324: fem_cal_periods_attr fcpa_year
325: WHERE fcpb.calendar_id = l_calendar_id
326: AND fcpb.dimension_group_id = l_calendar_group_id
327: AND fcpb.cal_period_id = fcpa_number.cal_period_id
328: AND fcpb.cal_period_id = fcpa_year.cal_period_id

Line 357: fem_cal_periods_attr fcpa_number,

353:
354: SELECT fcpb.cal_period_id
355: INTO l_next_cal_period_id
356: FROM fem_cal_periods_b fcpb,
357: fem_cal_periods_attr fcpa_number,
358: fem_cal_periods_attr fcpa_year
359: WHERE fcpb.calendar_id = l_calendar_id
360: AND fcpb.dimension_group_id = l_calendar_group_id
361: AND fcpb.cal_period_id = fcpa_number.cal_period_id

Line 358: fem_cal_periods_attr fcpa_year

354: SELECT fcpb.cal_period_id
355: INTO l_next_cal_period_id
356: FROM fem_cal_periods_b fcpb,
357: fem_cal_periods_attr fcpa_number,
358: fem_cal_periods_attr fcpa_year
359: WHERE fcpb.calendar_id = l_calendar_id
360: AND fcpb.dimension_group_id = l_calendar_group_id
361: AND fcpb.cal_period_id = fcpa_number.cal_period_id
362: AND fcpb.cal_period_id = fcpa_year.cal_period_id

Line 884: FROM fem_cal_periods_attr fcpa

880: END IF;
881:
882: SELECT DATE_ASSIGN_VALUE
883: INTO l_period_end_date
884: FROM fem_cal_periods_attr fcpa
885: WHERE fcpa.cal_period_id = p_cal_period_id
886: AND fcpa.attribute_id =
887: gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id
888: AND fcpa.version_id =

Line 1101: fem_cal_periods_attr fcpb_source_num,

1097: p_cal_period_id
1098: FROM fem_cal_periods_b fcpb_source,
1099: fem_cal_periods_b fcpb_target,
1100: gcs_cal_period_maps gcpm,
1101: fem_cal_periods_attr fcpb_source_num,
1102: fem_cal_periods_attr fcpb_source_year,
1103: gcs_cal_period_map_dtls gcpmd
1104: WHERE fcpb_target.cal_period_id = p_cal_period_id
1105: AND fcpb_target.calendar_id = gcpm.target_calendar_id

Line 1102: fem_cal_periods_attr fcpb_source_year,

1098: FROM fem_cal_periods_b fcpb_source,
1099: fem_cal_periods_b fcpb_target,
1100: gcs_cal_period_maps gcpm,
1101: fem_cal_periods_attr fcpb_source_num,
1102: fem_cal_periods_attr fcpb_source_year,
1103: gcs_cal_period_map_dtls gcpmd
1104: WHERE fcpb_target.cal_period_id = p_cal_period_id
1105: AND fcpb_target.calendar_id = gcpm.target_calendar_id
1106: AND fcpb_target.dimension_group_id = gcpm.target_dimension_group_id

Line 1133: fem_cal_periods_attr fcpb_source_num,

1129: fcpb_target.cal_period_id
1130: FROM fem_cal_periods_b fcpb_source,
1131: fem_cal_periods_b fcpb_target,
1132: gcs_cal_period_maps gcpm,
1133: fem_cal_periods_attr fcpb_source_num,
1134: fem_cal_periods_attr fcpb_source_year,
1135: gcs_cal_period_map_dtls gcpmd
1136: WHERE fcpb_target.cal_period_id >= p_cal_period_id
1137: AND fcpb_target.calendar_id = gcpm.target_calendar_id

Line 1134: fem_cal_periods_attr fcpb_source_year,

1130: FROM fem_cal_periods_b fcpb_source,
1131: fem_cal_periods_b fcpb_target,
1132: gcs_cal_period_maps gcpm,
1133: fem_cal_periods_attr fcpb_source_num,
1134: fem_cal_periods_attr fcpb_source_year,
1135: gcs_cal_period_map_dtls gcpmd
1136: WHERE fcpb_target.cal_period_id >= p_cal_period_id
1137: AND fcpb_target.calendar_id = gcpm.target_calendar_id
1138: AND fcpb_target.dimension_group_id = gcpm.target_dimension_group_id

Line 1174: fem_cal_periods_attr fcpb_target_num,

1170: fcpb_target.cal_period_id
1171: FROM fem_cal_periods_b fcpb_source,
1172: fem_cal_periods_b fcpb_target,
1173: gcs_cal_period_maps gcpm,
1174: fem_cal_periods_attr fcpb_target_num,
1175: fem_cal_periods_attr fcpb_target_year,
1176: gcs_cal_period_map_dtls gcpmd
1177: WHERE fcpb_source.cal_period_id = p_cal_period_id
1178: AND fcpb_source.calendar_id = gcpm.source_calendar_id

Line 1175: fem_cal_periods_attr fcpb_target_year,

1171: FROM fem_cal_periods_b fcpb_source,
1172: fem_cal_periods_b fcpb_target,
1173: gcs_cal_period_maps gcpm,
1174: fem_cal_periods_attr fcpb_target_num,
1175: fem_cal_periods_attr fcpb_target_year,
1176: gcs_cal_period_map_dtls gcpmd
1177: WHERE fcpb_source.cal_period_id = p_cal_period_id
1178: AND fcpb_source.calendar_id = gcpm.source_calendar_id
1179: AND fcpb_source.dimension_group_id = gcpm.source_dimension_group_id