642: AND NVL(END_DATE_ACTIVE, SYSDATE+1);
643:
644: CURSOR pick_rule(x_rule_name IN VARCHAR2) IS
645: SELECT COUNT(*)
646: FROM SO_PICKING_RULES
647: WHERE PICKING_RULE = x_rule_name
648: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
649: AND NVL(END_DATE_ACTIVE, SYSDATE+1);
650:
650:
651: CURSOR get_default_psr(x_rule_name IN VARCHAR2) IS
652: SELECT par.pick_slip_rule_id
653: FROM WSH_PARAMETERS par,
654: SO_PICKING_RULES rules
655: WHERE rules.picking_rule = x_rule_name
656: AND rules.warehouse_id = par.organization_id;
657:
658: CURSOR get_default_rsr(x_rule_name IN VARCHAR2) IS
657:
658: CURSOR get_default_rsr(x_rule_name IN VARCHAR2) IS
659: SELECT par.release_seq_rule_id
660: FROM WSH_PARAMETERS par,
661: SO_PICKING_RULES rules
662: WHERE rules.picking_rule = x_rule_name
663: AND rules.warehouse_id = par.organization_id;
664:
665: x_batch_name VARCHAR2(30);
816: PARTIAL_ALLOWED_FLAG,
817: INCLUDE_PLANNED_LINES_FLAG,
818: AUTOCREATE_DELIVERY_FLAG,
819: operating_org -- Insert Operating Org
820: FROM SO_PICKING_RULES
821: WHERE PICKING_RULE = p_rule_name;
822:
823: WSH_UTIL.Write_Log('Inserted batch name ' || x_batch_name
824: || ' with batch_id ' ||