APPS.WMS_RULE_PVT dependencies on INV_SQL_BINDING_PVT

Line 1142: inv_sql_binding_pvt.initbindtables;

1138: -- clean up the serial number detailing table
1139: -- Commenting out for Bug 5251221
1140: --inv_detail_util_pvt.init_output_serial_rows;
1141: -- clean up the bind variables table
1142: inv_sql_binding_pvt.initbindtables;
1143: END freeglobals;
1144:
1145: ----
1146: ----

Line 2256: inv_sql_binding_pvt.getconversionstring(l_data_type_code, l_parent_data_type_code, l_left_part_conv_fct, l_right_part_conv_fct);

2252: log_statement(l_api_name, 'parent_expression', 'parent_expression: ' || l_parent_expression);
2253: log_statement(l_api_name, 'parent_data_type_code', 'parent_data_type_code: ' || l_parent_data_type_code);
2254: log_statement(l_api_name, 'parent_table_alias', 'parent_table_alias: ' || l_parent_table_alias);
2255: -- find out, if data type conversion is needed
2256: inv_sql_binding_pvt.getconversionstring(l_data_type_code, l_parent_data_type_code, l_left_part_conv_fct, l_right_part_conv_fct);
2257:
2258: --
2259: -- find out, if outer join has to be used
2260: IF l_context_dependent_flag = 'Y' THEN

Line 2535: inv_sql_binding_pvt.getconversionstring(l_parent_data_type_code, l_data_type_code, l_left_part_conv_fct, l_right_part_conv_fct);

2531: END IF;
2532:
2533: --
2534: -- find out, if data type conversion is needed
2535: inv_sql_binding_pvt.getconversionstring(l_parent_data_type_code, l_data_type_code, l_left_part_conv_fct, l_right_part_conv_fct);
2536: log_statement(l_api_name, 'left_part', 'add left part of res');
2537:
2538: -- add left part of the restrictions
2539: IF l_parameter_type_code = 1 THEN -- parameter is table.column

Line 2631: --l_identifier := inv_sql_binding_pvt.InitBindVar(l_operand_constant_date);

2627: END IF;
2628:
2629: g_rule_where := g_rule_where || l_new_constant_character || l_bracket_close || g_line_feed;
2630: ELSIF l_operand_type_code = 3 THEN -- right side = const. date
2631: --l_identifier := inv_sql_binding_pvt.InitBindVar(l_operand_constant_date);
2632: --Bug #2611142 - Add quotes before and after l_operand_constant_date
2633: g_rule_where := g_rule_where
2634: || ''''
2635: || l_operand_constant_date

Line 2692: --l_identifier := inv_sql_binding_pvt.initbindvar

2688: || ')'
2689: || l_bracket_close
2690: || g_line_feed;
2691: ELSIF l_validation_type = 'I' THEN -- > validation type 'independent'
2692: --l_identifier := inv_sql_binding_pvt.initbindvar
2693: -- (l_operand_flex_value_set_id);
2694: g_rule_where := g_rule_where
2695: || '( select FLEX_VALUE from '
2696: || 'FND_FLEX_VALUES_VL where FLEX_VALUE_SET_ID = '

Line 2764: inv_sql_binding_pvt.getconversionstring(l_parent_data_type_code

2760: EXIT WHEN sortcrit%NOTFOUND;
2761: --
2762: log_statement(l_api_name, 'seq_number_sort', 'seq_number sort:' || l_sequence_number);
2763: -- find out, if data type conversion is needed
2764: inv_sql_binding_pvt.getconversionstring(l_parent_data_type_code
2765: , l_data_type_code
2766: , l_left_part_conv_fct
2767: , l_right_part_conv_fct);
2768:

Line 3209: --inv_sql_binding_pvt.SaveBindPointers;

3205: END IF;
3206:
3207: --
3208: -- Save the pointers, which mark the end of the rule sourced bind variables
3209: --inv_sql_binding_pvt.SaveBindPointers;
3210: --
3211: log_procedure(l_api_name, 'end', 'End BuildRuleSql');
3212: -- end of debugging section
3213: EXCEPTION