APPS.FLM_SEQ_UI dependencies on FLM_FILTER_CRITERIA

Line 41: DELETE FROM FLM_FILTER_CRITERIA

37: DELETE FROM FLM_SEQ_TASK_LINES
38: WHERE SEQ_TASK_ID = p_seq_task_id;
39:
40: l_debug_line := 50;
41: DELETE FROM FLM_FILTER_CRITERIA
42: WHERE CRITERIA_GROUP_ID = (SELECT DEMAND_CRITERIA_GROUP_ID FROM FLM_SEQ_TASKS WHERE SEQ_TASK_ID = p_seq_task_id);
43:
44: l_debug_line := 60;
45: DELETE FROM FLM_SEQ_TASKS

Line 429: flm_filter_criteria_process.get_filter_clause(l_criteria_group_id,'MUOV',NULL,l_filter,

425: '''DD-MON-RR HH24:MI:SS'')';
426: l_where := l_where || ' AND MUOV.ORDER_QUANTITY > 0';
427:
428: l_debug_line := 40;
429: flm_filter_criteria_process.get_filter_clause(l_criteria_group_id,'MUOV',NULL,l_filter,
430: l_return_status,l_msg_count,l_msg_data);
431: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
432: x_return_status := l_return_status;
433: x_msg_count := l_msg_count;

Line 595: * To delete criteria from FLM_FILTER_CRITERIA table. *

591:
592: END delete_demands;
593:
594: /*******************************************************
595: * To delete criteria from FLM_FILTER_CRITERIA table. *
596: *******************************************************/
597: PROCEDURE delete_criteria(p_seq_task_id IN NUMBER,
598: p_init_msg_list IN VARCHAR2,
599: x_return_status OUT NOCOPY VARCHAR2,

Line 622: DELETE FROM FLM_FILTER_CRITERIA WHERE CRITERIA_GROUP_ID = l_criteria_group_id;

618: FROM FLM_SEQ_TASKS
619: WHERE SEQ_TASK_ID = p_seq_task_id;
620:
621: l_debug_line := 30;
622: DELETE FROM FLM_FILTER_CRITERIA WHERE CRITERIA_GROUP_ID = l_criteria_group_id;
623:
624: l_debug_line := 40;
625:
626: EXCEPTION