[Home] [Help]
96: -- Get_RE_Data_Exists
97: -- Purpose
98: -- Determines whether the data was loaded for the given combination or not.
99: -- Arguments
100: -- p_hier_dataset_code The dataset code in FEM_BALANCES.
101: -- p_cal_period_id The current period's cal_period_id.
102: -- p_source_system_code GCS source system code.
103: -- p_from_ccy From currency code.
104: -- p_ledger_id The ledger in FEM_BALANCES.
100: -- p_hier_dataset_code The dataset code in FEM_BALANCES.
101: -- p_cal_period_id The current period's cal_period_id.
102: -- p_source_system_code GCS source system code.
103: -- p_from_ccy From currency code.
104: -- p_ledger_id The ledger in FEM_BALANCES.
105: -- p_entity_id Entity on which the translation is being performed.
106: -- p_line_item_id Line Item Id of retained earnings selected for the hierarchy.
107: -- Example
108: -- GCS_TRANSLATION_PKG.Get_RE_Data_Exists
127: p_ledger_id NUMBER,
128: p_entity_id NUMBER,
129: p_line_item_id NUMBER) IS
130: SELECT 'X'
131: FROM FEM_BALANCES fb
132: WHERE fb.dataset_code = p_hier_dataset_code
133: AND fb.cal_period_id = p_cal_period_id
134: AND fb.source_system_code = p_source_system_code
135: AND fb.currency_code = p_from_ccy