APPS.EDW_GL_ACCT_M_T dependencies on EDW_SEGMENT_CLASSES

Line 133: -- Description: This procedure reads in table "edw_segment_classes" and

129: end check_precedence;
130:
131: -- -----------------------------------------------------------------------
132: -- Procedure: load_type_table
133: -- Description: This procedure reads in table "edw_segment_classes" and
134: -- stores it to a pl/sql table "g_acct_type_root1".
135: -- -----------------------------------------------------------------------
136: procedure load_type_table is
137: l_table_counter integer :=0;

Line 146: from edw_segment_classes t1, edw_set_of_books t2

142: begin
143: open cur_edw_account_class for
144: select t1.value||'-'||t2.set_of_books_id||'-'||t2.instance,
145: t1.type
146: from edw_segment_classes t1, edw_set_of_books t2
147: where t1.edw_set_of_books_id = t2.edw_set_of_books_id
148: and (t1.segment_name,t2.chart_of_accounts_id,lower(t2.instance)) in
149: (select segment_name,structure_num,lower(instance_code)
150: FROM EDW_FLEX_SEG_MAPPINGS_V

Line 162: 'When reading in table edw_segment_classes for '

158: close cur_edw_account_class ;
159: exception
160: when others then
161: edw_log.put_line('Error:'||
162: 'When reading in table edw_segment_classes for '
163: ||g_dimension_name ||'. '||sqlcode||' : '||sqlerrm);
164: raise;
165: end load_type_table;
166:

Line 212: 'Error: When reordering edw_segment_classes table for '|| g_dimension_name||'. '||sqlcode||' : '||sqlerrm);

208:
209: exception
210: when others then
211: edw_log.put_line(
212: 'Error: When reordering edw_segment_classes table for '|| g_dimension_name||'. '||sqlcode||' : '||sqlerrm);
213: raise;
214: end reorder_type_table;
215:
216: