APPS.EDW_GL_CONSOLIDATION dependencies on GL_CONS_SEGMENT_MAP

Line 5: p_coa_mapping_id IN gl_cons_segment_map.coa_mapping_id%TYPE,

1: Package Body EDW_GL_CONSOLIDATION AS
2: /* $Header: FIIECONB.pls 120.2 2005/08/30 15:05:22 sgautam noship $ */
3:
4: procedure edw_get_cons_flex_value (
5: p_coa_mapping_id IN gl_cons_segment_map.coa_mapping_id%TYPE,
6: p_cons_from_flex_set_id IN fnd_flex_values.FLEX_VALUE_SET_ID%TYPE ,
7: p_cons_to_flex_set_id IN fnd_flex_values.FLEX_VALUE_SET_ID%TYPE ,
8: p_cons_from_flex_value IN fnd_flex_values.FLEX_VALUE%TYPE ,
9: p_parent_flag IN varchar2,

Line 15: l_map_type gl_cons_segment_map.segment_map_type%TYPE;

11: p_return_msg OUT NOCOPY /* file.sql.39 change */ varchar2,
12: p_status OUT NOCOPY /* file.sql.39 change */ boolean
13: ) IS
14:
15: l_map_type gl_cons_segment_map.segment_map_type%TYPE;
16: l_proc_name varchar2(30) :='EDW_GET_CONS_FLEX_VALUE';
17:
18: diamond_problem exception;
19: no_return_value exception;

Line 29: FROM gl_cons_segment_map csm,

25: p_from_value in varchar2
26: ) IS
27: SELECT cfh.parent_flex_value parent,
28: csm.segment_map_type segment_map_type
29: FROM gl_cons_segment_map csm,
30: gl_cons_flex_hierarchies cfh
31: WHERE cfh.segment_map_id = csm.segment_map_id
32: AND csm.segment_map_type = 'R'
33: AND csm.from_value_set_id = p_from_value_set_id

Line 41: FROM gl_cons_segment_map csm

37: and cfh.child_flex_value_high
38: UNION ALL
39: SELECT csm.single_value parent,
40: csm.segment_map_type segment_map_type
41: FROM gl_cons_segment_map csm
42: WHERE csm.segment_map_type = 'P'
43: AND csm.from_value_set_id = p_from_value_set_id
44: AND csm.to_value_set_id = p_to_value_set_id
45: AND csm.coa_mapping_id = p_coa_mapping_id

Line 50: FROM gl_cons_segment_map csm

46: AND p_from_value = csm.parent_rollup_value
47: UNION ALL
48: SELECT csm.single_value parent,
49: csm.segment_map_type segment_map_type
50: FROM gl_cons_segment_map csm
51: WHERE csm.segment_map_type = 'C'
52: AND csm.from_value_set_id = p_from_value_set_id
53: AND csm.to_value_set_id = p_to_value_set_id
54: AND csm.coa_mapping_id = p_coa_mapping_id

Line 58: FROM gl_cons_segment_map csm

54: AND csm.coa_mapping_id = p_coa_mapping_id
55: UNION ALL
56: SELECT csm.single_value parent,
57: csm.segment_map_type segment_map_type
58: FROM gl_cons_segment_map csm
59: WHERE csm.segment_map_type = 'S'
60: AND csm.to_value_set_id = p_to_value_set_id
61: AND csm.coa_mapping_id = p_coa_mapping_id;
62: