[Home] [Help]
1055: -- clean up the serial number detailing table
1056: -- Commenting out for Bug 5251221
1057: --inv_detail_util_pvt.init_output_serial_rows;
1058: -- clean up the bind variables table
1059: inv_sql_binding_pvt.initbindtables;
1060: END freeglobals;
1061:
1062: ----
1063: ----
2162: log_statement(l_api_name, 'parent_expression', 'parent_expression: ' || l_parent_expression);
2163: log_statement(l_api_name, 'parent_data_type_code', 'parent_data_type_code: ' || l_parent_data_type_code);
2164: log_statement(l_api_name, 'parent_table_alias', 'parent_table_alias: ' || l_parent_table_alias);
2165: -- find out, if data type conversion is needed
2166: inv_sql_binding_pvt.getconversionstring(l_data_type_code, l_parent_data_type_code, l_left_part_conv_fct, l_right_part_conv_fct);
2167:
2168: --
2169: -- find out, if outer join has to be used
2170: IF l_context_dependent_flag = 'Y' THEN
2383: END IF;
2384:
2385: --
2386: -- find out, if data type conversion is needed
2387: inv_sql_binding_pvt.getconversionstring(l_parent_data_type_code, l_data_type_code, l_left_part_conv_fct, l_right_part_conv_fct);
2388: log_statement(l_api_name, 'left_part', 'add left part of res');
2389:
2390: -- add left part of the restrictions
2391: IF l_parameter_type_code = 1 THEN -- parameter is table.column
2479: END IF;
2480:
2481: g_rule_where := g_rule_where || l_new_constant_character || l_bracket_close || g_line_feed;
2482: ELSIF l_operand_type_code = 3 THEN -- right side = const. date
2483: --l_identifier := inv_sql_binding_pvt.InitBindVar(l_operand_constant_date);
2484: --Bug #2611142 - Add quotes before and after l_operand_constant_date
2485: g_rule_where := g_rule_where
2486: || ''''
2487: || l_operand_constant_date
2540: || ')'
2541: || l_bracket_close
2542: || g_line_feed;
2543: ELSIF l_validation_type = 'I' THEN -- > validation type 'independent'
2544: --l_identifier := inv_sql_binding_pvt.initbindvar
2545: -- (l_operand_flex_value_set_id);
2546: g_rule_where := g_rule_where
2547: || '( select FLEX_VALUE from '
2548: || 'FND_FLEX_VALUES_VL where FLEX_VALUE_SET_ID = '
2607: EXIT WHEN sortcrit%NOTFOUND;
2608: --
2609: log_statement(l_api_name, 'seq_number_sort', 'seq_number sort:' || l_sequence_number);
2610: -- find out, if data type conversion is needed
2611: inv_sql_binding_pvt.getconversionstring(l_parent_data_type_code
2612: , l_data_type_code
2613: , l_left_part_conv_fct
2614: , l_right_part_conv_fct);
2615:
2876: END IF;
2877:
2878: --
2879: -- Save the pointers, which mark the end of the rule sourced bind variables
2880: --inv_sql_binding_pvt.SaveBindPointers;
2881: --
2882: log_procedure(l_api_name, 'end', 'End BuildRuleSql');
2883: -- end of debugging section
2884: EXCEPTION