[Home] [Help]
4033: ids(i) := NULL;
4034: end if;
4035: end loop;
4036:
4037: -- Next save the debugging info to the standard server debug string.
4038: -- Note this is different from the client which will save it to a
4039: -- file fdfplv.log. Use errmsg as temporary string to store debug info.
4040: --
4041: errmsg := ' Calling FND_FLEX_PLSQL.validate(';
4592: END IF;
4593: /************************************************************************************************************
4594: Date, DateTime and Time value sets are not supported in vset Security Logic
4595: At this time it is not feasible to make the code work using Decodes
4596: ELSIF (p_format_type in ('X', 'Y')) THEN -- Standard Date and Time
4597: IF (p_apply_nvl) THEN
4598: RETURN(' fnd_date.canonical_to_date(' || p_column || ') ' ||
4599: ' BETWEEN fnd_date.canonical_to_date(DECODE(RTRIM(TRANSLATE(Nvl(' ||
4600: p_min_column || ', ' || p_column || '),''0123456789'',''0''),''0''), NULL, ' ||
4655: RETURN(' AND r.parent_flex_value_low = ' ||
4656: 'fnd_number.canonical_to_number(DECODE(RTRIM(TRANSLATE(' || p_parent_column ||
4657: ', ''0123456789'',''0''),''0''), NULL, ' || p_parent_column || ', -99999))' );
4658: /*
4659: ELSIF (p_format_type in ('X', 'Y')) THEN -- Standard Date and Time
4660: RETURN(' AND r.parent_flex_value_low = ' ||
4661: 'fnd_date.canonical_to_date(DECODE(RTRIM(TRANSLATE(' || p_parent_column ||
4662: ', ''0123456789'',''0''),''0''), NULL, ' || p_parent_column || ', -99999))' );
4663: ELSIF (p_format_type = 'I') THEN -- Time