APPS.FLM_SEQ_UI dependencies on FLM_SEQ_TASKS

Line 42: WHERE CRITERIA_GROUP_ID = (SELECT DEMAND_CRITERIA_GROUP_ID FROM FLM_SEQ_TASKS WHERE SEQ_TASK_ID = p_seq_task_id);

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
46: WHERE SEQ_TASK_ID = p_seq_task_id;

Line 45: DELETE FROM FLM_SEQ_TASKS

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
46: WHERE SEQ_TASK_ID = p_seq_task_id;
47:
48: l_debug_line := 70;
49:

Line 385: FROM FLM_SEQ_TASKS

381: TO_CHAR(DEMAND_START_DATE,'DD-MON-RR HH24:MI:SS'), TO_CHAR(DEMAND_END_DATE,'DD-MON-RR HH24:MI:SS'),
382: NVL(HONOR_PLANNING_FLAG,'N')
383: INTO l_criteria_group_id,l_alternate_routing_flag,l_seq_task_type,l_org_id,
384: l_demand_start_date,l_demand_end_date,l_planning_flag
385: FROM FLM_SEQ_TASKS
386: WHERE SEQ_TASK_ID = p_seq_task_id;
387:
388: l_debug_line := 20;
389: IF l_seq_task_type = FLM_CONSTANTS.SEQ_TASK_RESEQ THEN

Line 618: FROM FLM_SEQ_TASKS

614:
615: l_debug_line := 20;
616: SELECT NVL(DEMAND_CRITERIA_GROUP_ID,-1)
617: INTO 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;

Line 885: FROM FLM_SEQ_TASKS

881: x_msg_data OUT NOCOPY VARCHAR2)
882: IS
883: CURSOR l_task_cursor IS
884: SELECT seq_task_id
885: FROM FLM_SEQ_TASKS
886: WHERE seq_request_id = -1
887: AND creation_date < sysdate-2;
888:
889: l_debug_line NUMBER;