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 GCS_CAL_PERIOD_MAPS

Line 165: -- which source period maps to which target information. If there is no information found in GCS_CAL_PERIOD_MAPS

161: -- Procedure
162: -- EXPLODE_CALENDAR_MAP
163: -- Purpose
164: -- This procedure takes the TARGET_CAL_PERIOD_ID, AND using the source entity information determines
165: -- which source period maps to which target information. If there is no information found in GCS_CAL_PERIOD_MAPS
166: -- between the source AND target a dummy record will be insert into GCS_TEMP_CAL_PERIOD_MAPS WHERE the
167: -- source_cal_period_id = target_cal_period_id.
168: -- Arguments
169: -- p_source_ledger_id Source ledger Identifier

Line 214: 'INSERT INTO gcs_cal_period_maps_gt (source_cal_period_id, target_cal_period_id)

210: IF (l_mapping_required = 'Y') THEN
211: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
212: fnd_log.STRING(fnd_log.level_statement,
213: g_pkg_name || '.' || l_api_name,
214: 'INSERT INTO gcs_cal_period_maps_gt (source_cal_period_id, target_cal_period_id)
215: SELECT fdl.cal_period_id, ' ||
216: p_target_cal_period_id || '
217: FROM fem_data_locations fdl, ' || '
218: fem_ledgers_attr fla, ' || '

Line 222: gcs_cal_period_maps gcpm, ' || '

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 ' || '
225: WHERE fdl.ledger_id = ' ||
226: p_source_ledger_id || '

Line 274: INSERT INTO gcs_cal_period_maps_gt

270: ''FOLLOWING'', ' ||
271: p_cal_period_record.cal_period_year || ' - 1 )');
272: END IF;
273:
274: INSERT INTO gcs_cal_period_maps_gt
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,

Line 282: gcs_cal_period_maps gcpm,

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
285: WHERE fdl.ledger_id = p_source_ledger_id
286: AND fdl.table_name = 'FEM_BALANCES'

Line 330: SELECT count(*) INTO l_cnt FROM gcs_cal_period_maps_gt;

326: p_cal_period_record.cal_period_year + 1,
327: 'FOLLOWING',
328: p_cal_period_record.cal_period_year - 1);
329:
330: SELECT count(*) INTO l_cnt FROM gcs_cal_period_maps_gt;
331: IF (l_cnt = 0) THEN
332: fnd_file.put_line(fnd_file.log,
333: 'Calendar Period Mapping does not exist');
334: p_prior_cal_period_id := p_cal_period_record.prev_cal_period_id;

Line 347: gcs_cal_period_maps_gt gcpmg,

343: g_pkg_name || '.' || l_api_name,
344: 'SELECT decode(COUNT (gcpmd.cal_period_map_id), 0, ''Y'', ''N'')
345: INTO p_year_end_values_match
346: FROM gcs_cal_period_map_dtls gcpmd,
347: gcs_cal_period_maps_gt gcpmg,
348: gcs_cal_period_maps gcpm,
349: fem_cal_periods_b fcpb_src,
350: fem_cal_periods_b fcpb_tgt
351: WHERE gcpmd.cal_period_map_id = gcpm.cal_period_map_id

Line 348: gcs_cal_period_maps gcpm,

344: 'SELECT decode(COUNT (gcpmd.cal_period_map_id), 0, ''Y'', ''N'')
345: INTO p_year_end_values_match
346: FROM gcs_cal_period_map_dtls gcpmd,
347: gcs_cal_period_maps_gt gcpmg,
348: gcs_cal_period_maps gcpm,
349: fem_cal_periods_b fcpb_src,
350: fem_cal_periods_b fcpb_tgt
351: WHERE gcpmd.cal_period_map_id = gcpm.cal_period_map_id
352: AND gcpmd.target_relative_year_code <> ''CURRENT''

Line 364: gcs_cal_period_maps_gt gcpmg,

360:
361: SELECT decode(COUNT(gcpmd.cal_period_map_id), 0, 'Y', 'N')
362: INTO p_year_end_values_match
363: FROM gcs_cal_period_map_dtls gcpmd,
364: gcs_cal_period_maps_gt gcpmg,
365: gcs_cal_period_maps gcpm,
366: fem_cal_periods_b fcpb_src,
367: fem_cal_periods_b fcpb_tgt
368: WHERE gcpmd.cal_period_map_id = gcpm.cal_period_map_id

Line 365: gcs_cal_period_maps gcpm,

361: SELECT decode(COUNT(gcpmd.cal_period_map_id), 0, 'Y', 'N')
362: INTO p_year_end_values_match
363: FROM gcs_cal_period_map_dtls gcpmd,
364: gcs_cal_period_maps_gt gcpmg,
365: gcs_cal_period_maps gcpm,
366: fem_cal_periods_b fcpb_src,
367: fem_cal_periods_b fcpb_tgt
368: WHERE gcpmd.cal_period_map_id = gcpm.cal_period_map_id
369: AND gcpmd.target_relative_year_code <> 'CURRENT'

Line 389: INSERT INTO gcs_cal_period_maps_gt

385: */
386: END IF; -- calendar map existence check
387: ELSE
388: -- no mapping required
389: INSERT INTO gcs_cal_period_maps_gt
390: (source_cal_period_id, target_cal_period_id)
391: VALUES
392: (p_target_cal_period_id, p_target_cal_period_id);
393: p_year_end_values_match := 'Y';

Line 401: 'INSERT INTO gcs_cal_period_maps_gt (source_cal_period_id, target_cal_period_id )

397: WHEN NO_DATA_FOUND THEN
398: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
399: fnd_log.STRING(fnd_log.level_statement,
400: g_pkg_name || '.' || l_api_name,
401: 'INSERT INTO gcs_cal_period_maps_gt (source_cal_period_id, target_cal_period_id )
402: VALUES (' ||
403: p_target_cal_period_id || ', ' ||
404: p_target_cal_period_id || '
405: )');

Line 407: INSERT INTO gcs_cal_period_maps_gt

403: p_target_cal_period_id || ', ' ||
404: p_target_cal_period_id || '
405: )');
406: END IF;
407: INSERT INTO gcs_cal_period_maps_gt
408: (source_cal_period_id, target_cal_period_id)
409: VALUES
410: (p_target_cal_period_id, p_target_cal_period_id);
411: p_year_end_values_match := 'Y';

Line 426: -- which source period maps to which target information. If there is no information found in GCS_CAL_PERIOD_MAPS

422: -- Procedure
423: -- reverse_explode_calendar_map
424: -- Purpose
425: -- This procedure takes the TARGET_CAL_PERIOD_ID, AND using the source entity information determines
426: -- which source period maps to which target information. If there is no information found in GCS_CAL_PERIOD_MAPS
427: -- between the source AND target a dummy record will be insert into GCS_TEMP_CAL_PERIOD_MAPS WHERE the
428: -- source_cal_period_id = target_cal_period_id.
429: -- Arguments
430: -- p_source_ledger_id Source ledger Identifier

Line 474: FROM gcs_cal_period_maps gcpm,

470: fnd_log.STRING(fnd_log.level_statement,
471: g_pkg_name || '.' || l_api_name,
472: ' SELECT gcpm.cal_period_map_id
473: INTO l_cal_period_map_id
474: FROM gcs_cal_period_maps gcpm,
475: fem_cal_periods_b fcpb
476: WHERE gcpm.target_calendar_id = ' ||
477: l_calendar_id || '
478: AND gcpm.target_dimension_group_id = ' ||

Line 488: FROM gcs_cal_period_maps gcpm, fem_cal_periods_b fcpb

484: END IF;
485:
486: SELECT gcpm.cal_period_map_id
487: INTO l_cal_period_map_id
488: FROM gcs_cal_period_maps gcpm, fem_cal_periods_b fcpb
489: WHERE gcpm.target_calendar_id = l_calendar_id
490: AND gcpm.target_dimension_group_id = l_dimension_grp_id
491: AND fcpb.cal_period_id = p_source_cal_period_id
492: AND gcpm.source_calendar_id = fcpb.calendar_id

Line 501: 'INSERT INTO gcs_cal_period_maps_gt (source_cal_period_id, target_cal_period_id)

497: -- insert mapping data into temp table
498: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
499: fnd_log.STRING(fnd_log.level_statement,
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,

Line 540: INSERT INTO gcs_cal_period_maps_gt

536: l_cal_period_record.cal_period_year || '
537: + 1 )');
538: END IF;
539:
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,

Line 584: INSERT INTO gcs_cal_period_maps_gt

580: END IF;
581:
582: EXCEPTION
583: WHEN NO_DATA_FOUND THEN
584: INSERT INTO gcs_cal_period_maps_gt
585: (source_cal_period_id, target_cal_period_id)
586: VALUES
587: (p_source_cal_period_id, p_source_cal_period_id);
588: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

Line 1014: FROM gcs_cal_period_maps_gt');

1010: fnd_log.STRING(fnd_log.level_statement,
1011: g_pkg_name || '.' || l_api_name,
1012: ' SELECT MAX (source_cal_period_id)
1013: INTO l_max_period
1014: FROM gcs_cal_period_maps_gt');
1015: END IF;
1016:
1017: SELECT MAX(source_cal_period_id)
1018: INTO l_max_period

Line 1019: FROM gcs_cal_period_maps_gt;

1015: END IF;
1016:
1017: SELECT MAX(source_cal_period_id)
1018: INTO l_max_period
1019: FROM gcs_cal_period_maps_gt;
1020:
1021: BEGIN
1022: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1023: fnd_log.STRING(fnd_log.level_statement,

Line 2075: gcs_cal_period_maps_gt cpmgt

2071: g_pkg_name || ''.'' || l_api_name,
2072: ''SELECT cpmgt.source_cal_period_id cal_period_id
2073: BULK COLLECT INTO l_periods_list
2074: FROM fem_data_locations fdl,
2075: gcs_cal_period_maps_gt cpmgt
2076: WHERE fdl.ledger_id = '' ||p_source_ledger_id||''
2077: AND fdl.cal_period_id = cpmgt.source_cal_period_id
2078: AND fdl.source_system_code = ''||l_source_system_code||''
2079: AND fdl.dataset_code = '' ||p_source_dataset_code||''

Line 2086: gcs_cal_period_maps_gt cpmgt

2082:
2083: SELECT cpmgt.source_cal_period_id cal_period_id
2084: BULK COLLECT INTO l_periods_list
2085: FROM fem_data_locations fdl,
2086: gcs_cal_period_maps_gt cpmgt
2087: WHERE fdl.ledger_id = p_source_ledger_id
2088: AND fdl.cal_period_id = cpmgt.source_cal_period_id
2089: AND fdl.source_system_code = l_source_system_code
2090: AND fdl.dataset_code = p_source_dataset_code