DBA Data[Home] [Help]

APPS.FLM_SEQ_UI dependencies on FLM_CONSTANTS

Line 389: IF l_seq_task_type = FLM_CONSTANTS.SEQ_TASK_RESEQ THEN

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
390: x_return_status := FND_API.G_RET_STS_SUCCESS;
391: return;
392: END IF;
393:

Line 404: IF (l_seq_task_type = FLM_CONSTANTS.SEQ_TASK_SO AND l_alternate_routing_flag = 'N') THEN

400: l_cursor_cnt := NULL;
401:
402: FLM_Util.init_bind;
403:
404: IF (l_seq_task_type = FLM_CONSTANTS.SEQ_TASK_SO AND l_alternate_routing_flag = 'N') THEN
405: l_where := 'FROM FLM_SEQ_DEMAND_SALES_ORDERS_V MUOV WHERE '||
406: 'MUOV.ALTERNATE_ROUTING_DESIGNATOR IS NULL AND ';
407: ELSIF (l_seq_task_type = FLM_CONSTANTS.SEQ_TASK_SO AND l_alternate_routing_flag = 'Y') THEN
408: l_where := 'FROM FLM_SEQ_DEMAND_SALES_ORDERS_V MUOV WHERE ';

Line 407: ELSIF (l_seq_task_type = FLM_CONSTANTS.SEQ_TASK_SO AND l_alternate_routing_flag = 'Y') THEN

403:
404: IF (l_seq_task_type = FLM_CONSTANTS.SEQ_TASK_SO AND l_alternate_routing_flag = 'N') THEN
405: l_where := 'FROM FLM_SEQ_DEMAND_SALES_ORDERS_V MUOV WHERE '||
406: 'MUOV.ALTERNATE_ROUTING_DESIGNATOR IS NULL AND ';
407: ELSIF (l_seq_task_type = FLM_CONSTANTS.SEQ_TASK_SO AND l_alternate_routing_flag = 'Y') THEN
408: l_where := 'FROM FLM_SEQ_DEMAND_SALES_ORDERS_V MUOV WHERE ';
409: ELSE
410: l_where := 'FROM FLM_SEQ_DEMAND_PLAN_ORDERS_V MUOV WHERE ';
411: --Added for bugfix:7305721