[Home] [Help]
147: -- based on the conversion set rules defined
148: BEGIN
149: SELECT include_flag
150: INTO l_conversion_flag
151: FROM gl_je_inclusion_rules
152: WHERE je_rule_set_id = l_je_conv_set_id
153: AND je_source_name = p_je_source_name
154: AND je_category_name = p_je_category_name;
155:
157: WHEN OTHERS THEN
158: BEGIN
159: SELECT include_flag
160: INTO l_conversion_flag
161: FROM gl_je_inclusion_rules
162: WHERE je_rule_set_id = l_je_conv_set_id
163: AND je_source_name = p_je_source_name
164: AND je_category_name = 'Other';
165: EXCEPTION
166: WHEN OTHERS THEN
167: BEGIN
168: SELECT include_flag
169: INTO l_conversion_flag
170: FROM gl_je_inclusion_rules
171: WHERE je_rule_set_id = l_je_conv_set_id
172: AND je_source_name = 'Other'
173: AND je_category_name = p_je_category_name;
174: EXCEPTION
175: WHEN OTHERS THEN
176: BEGIN
177: SELECT include_flag
178: INTO l_conversion_flag
179: FROM gl_je_inclusion_rules
180: WHERE je_rule_set_id = l_je_conv_set_id
181: AND je_source_name = 'Other'
182: AND je_category_name = 'Other';
183: EXCEPTION