DBA Data[Home] [Help]

APPS.FND_FLEX_VAL_API dependencies on STANDARD

Line 3896: are replaced by Standard Date(X) and Standard DateTime(Y) format types.

3892: /*
3893: For KFF and DFF and SRS
3894: This rule is to make sure Date and DateTime value sets
3895: format types are not used since they are now obsolete and
3896: are replaced by Standard Date(X) and Standard DateTime(Y) format types.
3897: */
3898: IF(l_format_type='D' or l_format_type='T')
3899: THEN
3900: fnd_message.set_name('FND','FLEX-VSET TYPE OBSOLETE');

Line 3991: Date(D), then only VS Format Types T=DateTime, I=Time, X=StandardDate,

3987: Table ID Type. If it is not null then we can use that Type to compare
3988: to the underlying column and they must match. If the VS Table ID
3989: Type is null, then we use the VS Format Type to compare to the
3990: underlying column. If the underlying column is of type
3991: Date(D), then only VS Format Types T=DateTime, I=Time, X=StandardDate,
3992: Y=StandardDateTime, Z=StandardTime can be used.
3993: */
3994: IF(NOT((l_application_column_type = 'C' OR l_application_column_type = 'V')
3995: OR l_validation_type = 'U' OR

Line 3992: Y=StandardDateTime, Z=StandardTime can be used.

3988: to the underlying column and they must match. If the VS Table ID
3989: Type is null, then we use the VS Format Type to compare to the
3990: underlying column. If the underlying column is of type
3991: Date(D), then only VS Format Types T=DateTime, I=Time, X=StandardDate,
3992: Y=StandardDateTime, Z=StandardTime can be used.
3993: */
3994: IF(NOT((l_application_column_type = 'C' OR l_application_column_type = 'V')
3995: OR l_validation_type = 'U' OR
3996: ((l_application_column_type = l_id_column_type and

Line 4223: Date(D), then only VS Format Types T=DateTime, I=Time, X=StandardDate,

4219: Table ID Type. If it is not null then we can use that Type to compare
4220: to the underlying column and they must match. If the VS Table ID
4221: Type is null, then we use the VS Format Type to compare to the
4222: underlying column. If the underlying column is of type
4223: Date(D), then only VS Format Types T=DateTime, I=Time, X=StandardDate,
4224: Y=StandardDateTime, Z=StandardTime can be used.
4225: */
4226: IF(NOT((p_application_column_type = 'C' OR p_application_column_type = 'V')
4227: OR p_validation_type = 'U' OR

Line 4224: Y=StandardDateTime, Z=StandardTime can be used.

4220: to the underlying column and they must match. If the VS Table ID
4221: Type is null, then we use the VS Format Type to compare to the
4222: underlying column. If the underlying column is of type
4223: Date(D), then only VS Format Types T=DateTime, I=Time, X=StandardDate,
4224: Y=StandardDateTime, Z=StandardTime can be used.
4225: */
4226: IF(NOT((p_application_column_type = 'C' OR p_application_column_type = 'V')
4227: OR p_validation_type = 'U' OR
4228: ((p_application_column_type = p_id_column_type and

Line 4309: are replaced by Standard Date(X) and Standard DateTime(Y) format types.

4305:
4306: /*
4307: This rule is to make sure Date and DateTime value sets
4308: format types are not used since they are now obsolete and
4309: are replaced by Standard Date(X) and Standard DateTime(Y) format types.
4310: */
4311: IF(p_format_type='D' or p_format_type='T')
4312: THEN
4313: fnd_message.set_name('FND','FLEX-VSET TYPE OBSOLETE');