[Home] [Help]
41: -- (Code copied from fnd_flex_apis.get_qualifier_segnum in
42: -- FND source control.)
43:
44: SELECT s.segment_num INTO this_segment_num
45: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
46: fnd_segment_attribute_types sat
47: WHERE s.application_id = 101
48: AND s.id_flex_code = 'GL#'
49: AND s.id_flex_num = structure_num
59: AND sat.unique_flag = 'Y'
60: AND sat.segment_attribute_type = 'GL_BALANCING';
61:
62: SELECT count(segment_num) INTO balancing_segnum
63: FROM fnd_id_flex_segments
64: WHERE application_id = 101
65: AND id_flex_code = 'GL#'
66: AND id_flex_num = structure_num
67: AND enabled_flag = 'Y'
69:
70: -- get Account segment
71:
72: SELECT s.segment_num INTO this_segment_num
73: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
74: fnd_segment_attribute_types sat
75: WHERE s.application_id = 101
76: AND s.id_flex_code = 'GL#'
77: AND s.id_flex_num = structure_num
87: AND sat.unique_flag = 'Y'
88: AND sat.segment_attribute_type = 'GL_ACCOUNT';
89:
90: SELECT count(segment_num) INTO account_segnum
91: FROM fnd_id_flex_segments
92: WHERE application_id = 101
93: AND id_flex_code = 'GL#'
94: AND id_flex_num = structure_num
95: AND enabled_flag = 'Y'
98:
99: -- Get Cost Center segment
100:
101: SELECT s.segment_num INTO this_segment_num
102: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
103: fnd_segment_attribute_types sat
104: WHERE s.application_id = 101
105: AND s.id_flex_code = 'GL#'
106: AND s.id_flex_num = structure_num
116: AND sat.unique_flag = 'Y'
117: AND sat.segment_attribute_type = 'FA_COST_CTR';
118:
119: SELECT count(segment_num) INTO cc_segnum
120: FROM fnd_id_flex_segments
121: WHERE application_id = 101
122: AND id_flex_code = 'GL#'
123: AND id_flex_num = structure_num
124: AND enabled_flag = 'Y'
165: -- (Code copied from fnd_flex_apis.get_qualifier_segnum in
166: -- FND source control.)
167:
168: SELECT to_number(substr(s.application_column_name,8,2)) INTO this_segment_num
169: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
170: fnd_segment_attribute_types sat
171: WHERE s.application_id = 101
172: AND s.id_flex_code = 'GL#'
173: AND s.id_flex_num = structure_num
185:
186: -- bug 1796224, changed where-clause below.
187:
188: SELECT count(segment_num) INTO balancing_segnum
189: FROM fnd_id_flex_segments
190: WHERE application_id = 101
191: AND id_flex_code = 'GL#'
192: AND id_flex_num = structure_num
193: AND enabled_flag = 'Y'
196:
197: -- get Account segment
198:
199: SELECT to_number(substr(s.application_column_name,8,2)) INTO this_segment_num
200: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
201: fnd_segment_attribute_types sat
202: WHERE s.application_id = 101
203: AND s.id_flex_code = 'GL#'
204: AND s.id_flex_num = structure_num
216:
217: -- bug 1796224, changed where-clause below.
218:
219: SELECT count(segment_num) INTO account_segnum
220: FROM fnd_id_flex_segments
221: WHERE application_id = 101
222: AND id_flex_code = 'GL#'
223: AND id_flex_num = structure_num
224: AND enabled_flag = 'Y'
226:
227: -- Get Cost Center segment
228:
229: SELECT to_number(substr(s.application_column_name,8,2)) INTO this_segment_num
230: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
231: fnd_segment_attribute_types sat
232: WHERE s.application_id = 101
233: AND s.id_flex_code = 'GL#'
234: AND s.id_flex_num = structure_num
246:
247: -- bug 1796224, changed where-clause below.
248:
249: SELECT count(segment_num) INTO cc_segnum
250: FROM fnd_id_flex_segments
251: WHERE application_id = 101
252: AND id_flex_code = 'GL#'
253: AND id_flex_num = structure_num
254: AND enabled_flag = 'Y'
571:
572: -- seg_table in fa_whatif_deprn2_pkg.seg_data_tbl
573: cursor segcolumns is
574: select g.application_column_name, g.segment_num
575: from fnd_columns c, fnd_id_flex_segments g
576: WHERE g.application_id = appl_id
577: AND g.id_flex_code = flex_code
578: AND g.id_flex_num = struct_id
579: AND g.enabled_flag = 'Y'