[Home] [Help]
199: app_exception.raise_exception;
200: END Get_Domain_Name;
201: --+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
202: --+ this function is called in the GLXCORUN.fmb to get the remote instance
203: --+ data for a specific mapping rule from gl_consolidation_history table
204: --+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
205: procedure Remote_Data_Map(
206: p_name IN varchar2,
207: p_resp_name IN OUT NOCOPY varchar2,
210: ) IS
211: -- We get the information for the last consolidation run only
212: CURSOR C IS
213: SELECT h.*
214: FROM gl_consolidation_history h,
215: gl_consolidation c
216: WHERE h.consolidation_id = c.consolidation_id
217: AND c.name = p_name
218: ORDER BY h.last_update_date DESC;
211: -- We get the information for the last consolidation run only
212: CURSOR C IS
213: SELECT h.*
214: FROM gl_consolidation_history h,
215: gl_consolidation c
216: WHERE h.consolidation_id = c.consolidation_id
217: AND c.name = p_name
218: ORDER BY h.last_update_date DESC;
219: v_Cons gl_consolidation_history%ROWTYPE;
215: gl_consolidation c
216: WHERE h.consolidation_id = c.consolidation_id
217: AND c.name = p_name
218: ORDER BY h.last_update_date DESC;
219: v_Cons gl_consolidation_history%ROWTYPE;
220: begin
221: OPEN C;
222: FETCH C INTO v_Cons;
223: if (C%FOUND) then
232: CLOSE C;
233: end Remote_Data_Map;
234: --+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
235: --+ this function is called in GLXCORST.fmb to get the remote instance data
236: --+ for a specific mapping set from gl_consolidation_history table
237: --+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
238: procedure Remote_Data_Map_Set(
239: p_name IN varchar2,
240: p_resp_name IN OUT NOCOPY varchar2,
243: ) IS
244: -- We get the information for the last consolidation set run only
245: CURSOR C IS
246: SELECT h.*
247: FROM gl_consolidation_history h,
248: gl_consolidation_sets c
249: WHERE h.consolidation_set_id = c.consolidation_set_id
250: AND c.name = p_name
251: ORDER BY h.last_update_date DESC;
244: -- We get the information for the last consolidation set run only
245: CURSOR C IS
246: SELECT h.*
247: FROM gl_consolidation_history h,
248: gl_consolidation_sets c
249: WHERE h.consolidation_set_id = c.consolidation_set_id
250: AND c.name = p_name
251: ORDER BY h.last_update_date DESC;
252: v_Cons gl_consolidation_history%ROWTYPE;
248: gl_consolidation_sets c
249: WHERE h.consolidation_set_id = c.consolidation_set_id
250: AND c.name = p_name
251: ORDER BY h.last_update_date DESC;
252: v_Cons gl_consolidation_history%ROWTYPE;
253: begin
254: OPEN C;
255: FETCH C INTO v_Cons;
256: if (C%FOUND) then
982: IS
983: v_SQL varchar2(500);
984: l_group_id number;
985: BEGIN
986: v_SQL := 'select group_id from gl_consolidation_history ' ||
987: 'where consolidation_id = :cons_id ' ||
988: 'and consolidation_run_id = :cons_run_id';
989: EXECUTE IMMEDIATE v_SQL INTO l_group_id USING cons_id, cons_run_id;
990: l_group_id := l_group_id;
1095:
1096: l_tgt_ld_name varchar2(30);
1097:
1098:
1099: CURSOR c_remote_ledger_name (cp_source_group_id gl_consolidation_history.group_id%TYPE) IS
1100: SELECT gc.to_ledger_name
1101: FROM gl_consolidation_v gc, gl_consolidation_history gch
1102: WHERE gc.consolidation_id = gch.consolidation_id
1103: AND gch.group_id = cp_source_group_id;
1097:
1098:
1099: CURSOR c_remote_ledger_name (cp_source_group_id gl_consolidation_history.group_id%TYPE) IS
1100: SELECT gc.to_ledger_name
1101: FROM gl_consolidation_v gc, gl_consolidation_history gch
1102: WHERE gc.consolidation_id = gch.consolidation_id
1103: AND gch.group_id = cp_source_group_id;
1104:
1105: begin