APPS.GCS_UTILITY_PKG dependencies on GCS_CAL_PERIOD_MAPS_GT

Line 1074: delete from gcs_cal_period_maps_gt;

1070: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1071: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.gcs_utility_pkg.populate_calendar_map_details.begin', '<>');
1072: END IF;
1073:
1074: delete from gcs_cal_period_maps_gt;
1075:
1076: gcs_utility_pkg.get_cal_period_details( p_cal_period_id,
1077: l_cal_period_record);
1078:

Line 1080: INSERT INTO gcs_cal_period_maps_gt

1076: gcs_utility_pkg.get_cal_period_details( p_cal_period_id,
1077: l_cal_period_record);
1078:
1079: --Insert one row where source and target are the same
1080: INSERT INTO gcs_cal_period_maps_gt
1081: ( source_cal_period_id,
1082: target_cal_period_id)
1083: VALUES
1084: ( p_cal_period_id,

Line 1093: INSERT INTO gcs_cal_period_maps_gt

1089:
1090: IF (p_greater_than_flag = 'N') THEN
1091:
1092: --Insert all mapping options
1093: INSERT INTO gcs_cal_period_maps_gt
1094: ( source_cal_period_id,
1095: target_cal_period_id)
1096: SELECT fcpb_source.cal_period_id,
1097: p_cal_period_id

Line 1125: INSERT INTO gcs_cal_period_maps_gt

1121: 'FOLLOWING', l_cal_period_record.cal_period_year - 1);
1122: ELSE
1123:
1124: --Insert all mapping options
1125: INSERT INTO gcs_cal_period_maps_gt
1126: ( source_cal_period_id,
1127: target_cal_period_id)
1128: SELECT fcpb_source.cal_period_id,
1129: fcpb_target.cal_period_id

Line 1154: INSERT INTO gcs_cal_period_maps_gt

1150: AND fcpb_source_year.number_assign_value = DECODE(gcpmd.target_relative_year_code,
1151: 'CURRENT', l_cal_period_record.cal_period_year,
1152: 'PRIOR', l_cal_period_record.cal_period_year + 1,
1153: 'FOLLOWING', l_cal_period_record.cal_period_year - 1);
1154: INSERT INTO gcs_cal_period_maps_gt
1155: ( source_cal_period_id,
1156: target_cal_period_id)
1157: SELECT distinct target_cal_period_id,
1158: target_cal_period_id

Line 1159: FROM gcs_cal_period_maps_gt

1155: ( source_cal_period_id,
1156: target_cal_period_id)
1157: SELECT distinct target_cal_period_id,
1158: target_cal_period_id
1159: FROM gcs_cal_period_maps_gt
1160: WHERE target_cal_period_id <> p_cal_period_id;
1161:
1162: END IF;
1163:

Line 1166: INSERT INTO gcs_cal_period_maps_gt

1162: END IF;
1163:
1164: ELSE
1165: --Insert all mapping options
1166: INSERT INTO gcs_cal_period_maps_gt
1167: ( source_cal_period_id,
1168: target_cal_period_id)
1169: SELECT p_cal_period_id,
1170: fcpb_target.cal_period_id