DBA Data[Home] [Help]

APPS.FLM_FILTER_CRITERIA_PROCESS dependencies on FLM_UTIL

Line 117: FLM_Util.add_bind(':filter_'|| l_counter,

113: l_debug_line := 30;
114: /*Getting the values for the current operation*/
115: IF criteria_list_rec.criteria_value_type = FLM_CONSTANTS.VALUE_STRING THEN
116: l_filter := l_filter || ':filter_'|| l_counter;
117: FLM_Util.add_bind(':filter_'|| l_counter,
118: criteria_list_rec.criteria_value_name);
119:
120: ELSIF criteria_list_rec.criteria_value_type = FLM_CONSTANTS.VALUE_NUM THEN
121: l_filter := l_filter || ':filter_'|| l_counter;

Line 122: FLM_Util.add_bind(':filter_'|| l_counter,

118: criteria_list_rec.criteria_value_name);
119:
120: ELSIF criteria_list_rec.criteria_value_type = FLM_CONSTANTS.VALUE_NUM THEN
121: l_filter := l_filter || ':filter_'|| l_counter;
122: FLM_Util.add_bind(':filter_'|| l_counter,
123: criteria_list_rec.criteria_value_num);
124:
125: ELSIF criteria_list_rec.criteria_value_type = FLM_CONSTANTS.VALUE_DATE THEN
126: l_filter := l_filter || 'TO_DATE(:filter_'|| l_counter ||

Line 128: FLM_Util.add_bind(':filter_'|| l_counter,

124:
125: ELSIF criteria_list_rec.criteria_value_type = FLM_CONSTANTS.VALUE_DATE THEN
126: l_filter := l_filter || 'TO_DATE(:filter_'|| l_counter ||
127: ',''DD-MON-RR HH24:MI:SS'')';
128: FLM_Util.add_bind(':filter_'|| l_counter,
129: to_char(criteria_list_rec.criteria_value_date, 'DD-MON-RR HH24:MI:SS'));
130:
131: ELSE
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;