[Home] [Help]
1: PACKAGE BODY flm_filter_criteria_process AS
2: /* $Header: FLMFLCRB.pls 115.3 2003/05/02 00:31:51 hwenas noship $ */
3:
4: /* Function to return the column name for the criteria. */
5: FUNCTION get_filter_column (p_criteria_group_type NUMBER, p_criteria_type NUMBER) RETURN VARCHAR2 IS
36: END IF;
37: END IF;
38: END get_filter_column;
39:
40: /* Procedure to construct the where clause of the FLM filter criteria.
41: The data is obtained from FLM_FILTER_CRITERIA table. */
42: PROCEDURE get_filter_clause (p_criteria_group_id IN NUMBER,
43: p_table_alias IN VARCHAR2,
44: p_init_msg_list IN VARCHAR2,
37: END IF;
38: END get_filter_column;
39:
40: /* Procedure to construct the where clause of the FLM filter criteria.
41: The data is obtained from FLM_FILTER_CRITERIA table. */
42: PROCEDURE get_filter_clause (p_criteria_group_id IN NUMBER,
43: p_table_alias IN VARCHAR2,
44: p_init_msg_list IN VARCHAR2,
45: x_filter OUT NOCOPY VARCHAR2,
55:
56: CURSOR criteria_list (p_criteria_group_id NUMBER) IS
57: SELECT CRITERIA_GROUP_TYPE,CRITERIA_NUM,CRITERIA_TYPE,CRITERIA_OPERATION,CRITERIA_VALUE_TYPE,
58: CRITERIA_VALUE_NAME,CRITERIA_VALUE_NUM,CRITERIA_VALUE_DATE
59: FROM flm_filter_criteria
60: WHERE CRITERIA_GROUP_ID = p_criteria_group_id
61: ORDER BY CRITERIA_NUM, CRITERIA_OPERATION;
62:
63: BEGIN
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: ROLLBACK TO flm_get_filter_clause;
149:
150: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
151: FND_MSG_PUB.Add_Exc_Msg ('flm_filter_criteria_process' ,'get_filter_clause('||l_debug_line||')');
152: END IF;
153:
154: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
155:
155:
156: END get_filter_clause;
157:
158:
159: END flm_filter_criteria_process;