DBA Data[Home] [Help]

APPS.WIP_WS_SKILL_CHECK_PVT dependencies on WIP_CONSTANTS

Line 297: if l_from_step = WIP_CONSTANTS.TOMOVE then

293: l_to_step := p_to_step;
294: l_from_step := p_from_step;
295: end if;
296:
297: if l_from_step = WIP_CONSTANTS.TOMOVE then
298: l_add_where_clause := ' and operation_seq_num > :3 ';
299: else
300: l_add_where_clause := ' and operation_seq_num >= :3 ';
301: end if;

Line 303: if l_to_step = WIP_CONSTANTS.QUEUE then

299: else
300: l_add_where_clause := ' and operation_seq_num >= :3 ';
301: end if;
302:
303: if l_to_step = WIP_CONSTANTS.QUEUE then
304: l_add_where_clause := l_add_where_clause || ' and operation_seq_num < :4 ';
305: else
306: l_add_where_clause := l_add_where_clause || ' and operation_seq_num <= :4 ';
307: end if;