915: ,attribute12
916: ,attribute13
917: ,attribute14
918: ,attribute15
919: FROM wms_rule_consistencies
920: WHERE rule_id = p_orig_rule_id;
921:
922: l_consistency_rec l_orig_consistency_cur%ROWTYPE;
923:
1120: FETCH l_orig_consistency_cur INTO l_consistency_rec;
1121: EXIT WHEN l_orig_consistency_cur%NOTFOUND;
1122:
1123: l_consistency_rec.rule_id := l_rule_id;
1124: SELECT wms_rule_consistencies_s.NEXTVAL INTO l_consistency_id FROM dual;
1125: wms_rule_consistencies_pkg.insert_row
1126: (
1127: x_rowid => l_rowid
1128: ,x_consistency_id => l_consistency_id
1121: EXIT WHEN l_orig_consistency_cur%NOTFOUND;
1122:
1123: l_consistency_rec.rule_id := l_rule_id;
1124: SELECT wms_rule_consistencies_s.NEXTVAL INTO l_consistency_id FROM dual;
1125: wms_rule_consistencies_pkg.insert_row
1126: (
1127: x_rowid => l_rowid
1128: ,x_consistency_id => l_consistency_id
1129: ,x_rule_id => l_consistency_rec.rule_id