APPS.WMS_SEARCH_ORDER_GLOBALS_PVT dependencies on DUAL

Line 577: SELECT wms_rule_trace_header_s.NEXTVAL INTO l_header_id FROM dual;

573: end if;
574:
575: IF (nvl(p_move_order_line_id,0) > 0) then
576:
577: SELECT wms_rule_trace_header_s.NEXTVAL INTO l_header_id FROM dual;
578:
579: /* get who column information */
580:
581: SELECT Sysdate INTO l_date FROM dual;

Line 581: SELECT Sysdate INTO l_date FROM dual;

577: SELECT wms_rule_trace_header_s.NEXTVAL INTO l_header_id FROM dual;
578:
579: /* get who column information */
580:
581: SELECT Sysdate INTO l_date FROM dual;
582:
583: l_user_id := fnd_global.user_id;
584: l_login_id := fnd_global.login_id;
585:

Line 586: -- select rawtohex(dbms_session.unique_session_id) into l_sid from dual;

582:
583: l_user_id := fnd_global.user_id;
584: l_login_id := fnd_global.login_id;
585:
586: -- select rawtohex(dbms_session.unique_session_id) into l_sid from dual;
587:
588:
589: if p_type_code = 2 then
590: l_engine_type := 'PICK';

Line 699: SELECT Sysdate INTO l_date FROM dual;

695:
696: if ( nvl(p_header_id ,0 ) > 0 and nvl(p_rule_id,0) > 0 ) then
697:
698: /* get who column information */
699: SELECT Sysdate INTO l_date FROM dual;
700: l_user_id := fnd_global.user_id;
701: l_login_id := fnd_global.login_id;
702:
703: -- l_pre_suggestions := p_pre_suggestions ;

Line 713: SELECT wms_rule_trace_lines_s.NEXTVAL INTO l_line_id FROM dual;

709: -- Bug #3107777
710: if l_index is null then
711: exit;
712: end if;
713: SELECT wms_rule_trace_lines_s.NEXTVAL INTO l_line_id FROM dual;
714:
715: /* call the table insert procedure to do the insert */
716: insert_lines_row
717: (