APPS.EDW_GL_ACCT_M_C dependencies on GL_CONSOLIDATION

Line 1156: l_coa_mapping_id gl_consolidation.coa_mapping_id%TYPE;

1152: l_set_of_books edw_local_set_of_books%ROWTYPE;
1153: l_parent_set_of_books edw_local_set_of_books%ROWTYPE;
1154: l_edw_equi_sob edw_local_set_of_books%ROWTYPE;
1155: l_consolidation_id edw_local_cons_set_of_books.consolidation_id%TYPE;
1156: l_coa_mapping_id gl_consolidation.coa_mapping_id%TYPE;
1157: l_resurn_msg varchar2(150);
1158: l_rows_inserted Number:=0;
1159: l_dups_removed Number:=0;
1160: l_rows_replicated Number:=0;

Line 1382: From gl_consolidation

1378:
1379: --get the coa_mapping_id for the consolidation_id :Bug#4583057
1380: OPEN cur_coa_mapping_id FOR
1381: SELECT coa_mapping_id
1382: From gl_consolidation
1383: WHERE consolidation_id=l_consolidation_id;
1384:
1385: FETCH cur_coa_mapping_id INTO l_coa_mapping_id;
1386: CLOSE cur_coa_mapping_id;

Line 1405: -- lookup the l_flex_value_desc and call EDW_GL_CONSOLIDATION

1401: l_parent_set_of_books:=l_edw_equi_sob;
1402: END IF;
1403: CLOSE cur_edw_equi_sob ;
1404:
1405: -- lookup the l_flex_value_desc and call EDW_GL_CONSOLIDATION
1406: OPEN cur_flex_value_desc FOR
1407: 'SELECT flex_value,description,summary_flag
1408: FROM '|| g_value_temp_table||'
1409: WHERE flex_value_set_id=:s1'

Line 1415: EDW_GL_CONSOLIDATION.edw_get_cons_flex_value(

1411: LOOP
1412: FETCH cur_flex_value_desc INTO l_flex_value_desc;
1413: EXIT WHEN cur_flex_value_desc%NOTFOUND;
1414: l_parent_value:=null;
1415: EDW_GL_CONSOLIDATION.edw_get_cons_flex_value(
1416: l_coa_mapping_id,l_value_set_id,
1417: l_parent_value_set_id,l_flex_value_desc.value, l_flex_value_desc.parent_flag,
1418: l_parent_value,l_resurn_msg, l_cons_status);
1419: