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.GL_CI_DATA_TRANSFER_PKG dependencies on GL_CONSOLIDATION

Line 202: --+ data for a specific mapping rule from gl_consolidation_history table

198: app_exception.raise_exception;
199: END Get_Domain_Name;
200: --+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
201: --+ this function is called in the GLXCORUN.fmb to get the remote instance
202: --+ data for a specific mapping rule from gl_consolidation_history table
203: --+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
204: procedure Remote_Data_Map(
205: p_name IN varchar2,
206: p_resp_name IN OUT NOCOPY varchar2,

Line 213: FROM gl_consolidation_history h,

209: ) IS
210: -- We get the information for the last consolidation run only
211: CURSOR C IS
212: SELECT h.*
213: FROM gl_consolidation_history h,
214: gl_consolidation c
215: WHERE h.consolidation_id = c.consolidation_id
216: AND c.name = p_name
217: ORDER BY h.last_update_date DESC;

Line 214: gl_consolidation c

210: -- We get the information for the last consolidation run only
211: CURSOR C IS
212: SELECT h.*
213: FROM gl_consolidation_history h,
214: gl_consolidation c
215: WHERE h.consolidation_id = c.consolidation_id
216: AND c.name = p_name
217: ORDER BY h.last_update_date DESC;
218: v_Cons gl_consolidation_history%ROWTYPE;

Line 218: v_Cons gl_consolidation_history%ROWTYPE;

214: gl_consolidation c
215: WHERE h.consolidation_id = c.consolidation_id
216: AND c.name = p_name
217: ORDER BY h.last_update_date DESC;
218: v_Cons gl_consolidation_history%ROWTYPE;
219: begin
220: OPEN C;
221: FETCH C INTO v_Cons;
222: if (C%FOUND) then

Line 235: --+ for a specific mapping set from gl_consolidation_history table

231: CLOSE C;
232: end Remote_Data_Map;
233: --+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
234: --+ this function is called in GLXCORST.fmb to get the remote instance data
235: --+ for a specific mapping set from gl_consolidation_history table
236: --+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
237: procedure Remote_Data_Map_Set(
238: p_name IN varchar2,
239: p_resp_name IN OUT NOCOPY varchar2,

Line 246: FROM gl_consolidation_history h,

242: ) IS
243: -- We get the information for the last consolidation set run only
244: CURSOR C IS
245: SELECT h.*
246: FROM gl_consolidation_history h,
247: gl_consolidation_sets c
248: WHERE h.consolidation_set_id = c.consolidation_set_id
249: AND c.name = p_name
250: ORDER BY h.last_update_date DESC;

Line 247: gl_consolidation_sets c

243: -- We get the information for the last consolidation set run only
244: CURSOR C IS
245: SELECT h.*
246: FROM gl_consolidation_history h,
247: gl_consolidation_sets c
248: WHERE h.consolidation_set_id = c.consolidation_set_id
249: AND c.name = p_name
250: ORDER BY h.last_update_date DESC;
251: v_Cons gl_consolidation_history%ROWTYPE;

Line 251: v_Cons gl_consolidation_history%ROWTYPE;

247: gl_consolidation_sets c
248: WHERE h.consolidation_set_id = c.consolidation_set_id
249: AND c.name = p_name
250: ORDER BY h.last_update_date DESC;
251: v_Cons gl_consolidation_history%ROWTYPE;
252: begin
253: OPEN C;
254: FETCH C INTO v_Cons;
255: if (C%FOUND) then

Line 968: v_SQL := 'select group_id from gl_consolidation_history ' ||

964: IS
965: v_SQL varchar2(500);
966: l_group_id number;
967: BEGIN
968: v_SQL := 'select group_id from gl_consolidation_history ' ||
969: 'where consolidation_id = :cons_id ' ||
970: 'and consolidation_run_id = :cons_run_id';
971: EXECUTE IMMEDIATE v_SQL INTO l_group_id USING cons_id, cons_run_id;
972: l_group_id := l_group_id;