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.

[Home] [Help]

APPS.GCS_DATA_PREP_PKG dependencies on GCS_CAL_PERIOD_MAPS_GT

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 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 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 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 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 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