DBA Data[Home] [Help]

APPS.INV_SQL_BINDING_PVT dependencies on STANDARD

Line 213: -- standard Apps date format assumed

209: IF p_parent_data_type_code = 1 THEN -- number -> char
210: x_left_part_conv_fct := 'fnd_number.number_to_canonical(';
211: x_right_part_conv_fct := ')';
212: ELSIF p_parent_data_type_code = 3 THEN -- date -> char
213: -- standard Apps date format assumed
214: x_left_part_conv_fct := 'fnd_date.date_to_canonical(';
215: x_right_part_conv_fct := ')';
216: END IF;
217: ELSIF p_data_type_code = 3 THEN

Line 223: -- standard Apps date format assumed

219: -- Julian date assumed
220: x_left_part_conv_fct := 'to_date(to_char(';
221: x_right_part_conv_fct := '),''J'')';
222: ELSIF p_parent_data_type_code = 2 THEN -- char -> date
223: -- standard Apps date format assumed
224: x_left_part_conv_fct := 'fnd_date.canonical_to_date(';
225: x_right_part_conv_fct := ')';
226: END IF;
227: END IF;