APPS.GCS_AGGREGATION_DYNAMIC_PKG dependencies on GCS_UTILITY_PKG

Line 55: gcs_utility_pkg.get_org_id(child_entity_id, hierarchy_id) org_id

51: l_sus_template GCS_TEMPLATES_PKG.TemplateRecord;
52:
53: CURSOR get_child_info IS
54: SELECT child_entity_id,
55: gcs_utility_pkg.get_org_id(child_entity_id, hierarchy_id) org_id
56: FROM gcs_cons_relationships
57: WHERE hierarchy_id = p_hierarchy_id
58: AND parent_entity_id = p_cons_entity_id
59: AND actual_ownership_flag = 'Y';

Line 65: GCS_UTILITY_PKG.g_module_enter || fn_name ||

61: BEGIN
62: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
63: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
64: g_api || '.' || fn_name,
65: GCS_UTILITY_PKG.g_module_enter || fn_name ||
66: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
67: END IF;
68: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
69: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 68: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||

64: g_api || '.' || fn_name,
65: GCS_UTILITY_PKG.g_module_enter || fn_name ||
66: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
67: END IF;
68: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
69: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
70:
71: -- Get information of the hierarchy
72: SELECT balance_by_org_flag

Line 123: AND fb.source_system_code = GCS_UTILITY_PKG.g_gcs_source_system_code

119: AND nvl(gt.consolidation_type_code, 'FULL') <> 'NONE'
120: AND fb.dataset_code = p_dataset_code
121: AND fb.ledger_id = ghb.fem_ledger_id
122: AND fb.cal_period_id = p_cal_period_id
123: AND fb.source_system_code = GCS_UTILITY_PKG.g_gcs_source_system_code
124: AND fb.currency_code IN (p_currency_code, 'STAT')
125: AND fb.entity_id = gcr.child_entity_id
126: GROUP BY
127: fb.currency_code,

Line 136: l_default_org_id := GCS_UTILITY_PKG.get_org_id(p_cons_entity_id,

132: ELSE -- Balancing by Entity: need special handling of RE/Suspense/CTA
133:
134: -- Values used for the special processing:
135: -- * default org id for the consolidation entity
136: l_default_org_id := GCS_UTILITY_PKG.get_org_id(p_cons_entity_id,
137: p_hierarchy_id);
138:
139: -- * For determining intercompany type
140: SELECT specific_intercompany_id

Line 216: AND fb.source_system_code = gcs_utility_pkg.g_gcs_source_system_code

212: AND NVL(gt.consolidation_type_code, 'FULL') <> 'NONE'
213: AND fb.dataset_code = p_dataset_code
214: AND fb.ledger_id = ghb.fem_ledger_id
215: AND fb.cal_period_id = p_cal_period_id
216: AND fb.source_system_code = gcs_utility_pkg.g_gcs_source_system_code
217: AND fb.currency_code IN (p_currency_code, 'STAT')
218: AND fb.entity_id = gcr.child_entity_id
219: GROUP BY
220: fb.currency_code,

Line 316: GCS_UTILITY_PKG.g_module_success || fn_name ||

312:
313: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
314: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
315: g_api || '.' || fn_name,
316: GCS_UTILITY_PKG.g_module_success || fn_name ||
317: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
318: END IF;
319: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
320: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 319: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||

315: g_api || '.' || fn_name,
316: GCS_UTILITY_PKG.g_module_success || fn_name ||
317: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
318: END IF;
319: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
320: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
321:
322: EXCEPTION
323: WHEN OTHERS THEN

Line 327: GCS_UTILITY_PKG.g_module_failure || fn_name ||

323: WHEN OTHERS THEN
324: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
325: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
326: g_api || '.' || fn_name,
327: GCS_UTILITY_PKG.g_module_failure || fn_name ||
328: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
329: END IF;
330: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
331: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 330: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

326: g_api || '.' || fn_name,
327: GCS_UTILITY_PKG.g_module_failure || fn_name ||
328: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
329: END IF;
330: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
331: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
332: RAISE;
333: END insert_full_entry_lines;
334: